Bank Statement to QuickBooks for Catering Companies: Convert PDF Statements to QBO

Convert PDF bank and credit card statements to QBO for QuickBooks Online and Desktop so catering event deposits, service charges, and gratuity post cleanly.

Totals reconcile to the original QuickBooks Online and Desktop
Loved by bookkeepers and accountants 50K+ pages converted

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Caterers and their bookkeepers can upload a PDF bank or credit card statement to the converter at the top of this page and download a .qbo Web Connect file for QuickBooks Online or Desktop, plus Excel and CSV copies to review first. The tool reads a PDF or an image, so a scanned or photographed statement works too. Because you import the .qbo by hand, there is no 90-day live-feed cutoff, which suits seasonal catering: you can reconcile a busy wedding or holiday stretch all at once instead of chasing a feed that already dropped off the older weeks. A catering statement mixes a lot of things together: event deposits collected weeks ahead, final event payments, card batches that land net of fees, rental pass-throughs rebilled to clients, food and beverage purchases, and payments to 1099 event staff. Sorting those into the right accounts is where the real work is.

Last updated July 2026.

A real .qbo file QuickBooks accepts

Built for the statements US banks actually send, checked before it exports.

Reconciliation

Every total checked against the statement

The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.

Web Connect

A genuine .qbo, not a renamed CSV

Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.

OCR

Scans and phone photos read line by line

OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.

Volume

A year of statements in one batch

Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.

Locked files

Password-protected PDFs handled

Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.

Exports

Excel and CSV in the same download

One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.

How to convert your statement to QuickBooks

Three steps. No column-mapping wizard.

1

Upload the PDF statement

Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.

2

Review the reconciled rows

Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.

3

Import into QuickBooks

Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.

Questions worth answering

The specifics that decide whether the import is clean. If your case is not here, email [email protected].

Event deposits are customer deposits, not revenue yet

When a client pays a deposit weeks or months before their event, that money is a liability, not income. It is a customer deposit (unearned or deferred revenue) that you owe back as a service, and you recognize it as revenue only when the event is actually performed, not on the day the deposit clears your bank. Booking deposits as sales the moment they hit the account inflates this month's income and understates next quarter's, which distorts every profit report in between.

On a large event with a payment schedule, the progress deposits stack up. A 25 percent booking deposit, a second payment at menu tasting, and a balance due before the date all sit in the customer-deposit liability account until the event happens. On the event date you move the full contracted amount to revenue in one step and clear the deposits against it. Revenue recognition timing can get nuanced, so confirm your approach with a CPA if you run long lead times or multi-day events.

Service charge versus gratuity: get this one right

This is the distinction caterers get wrong most often, and it changes both your taxable revenue and your payroll. A mandatory or automatic service charge (the fixed percentage a contract adds to every event) is the caterer's revenue, not a tip. When you later pay that money out to staff, it is treated as wages subject to normal payroll withholding, not as a tip. That treatment follows IRS Revenue Ruling 2012-18, which holds that an automatic or mandatory charge is a service charge because the client had no choice in it. A voluntary tip that the client freely decides to leave is the employees' money: it is a pass-through liability you hold and distribute, never your revenue.

Booking a mandatory service charge as a tip understates your taxable revenue and mishandles payroll, because that money should run through wages. Getting it backward the other way (treating a genuine voluntary tip as revenue) overstates income and can create sales tax problems. The line between the two turns on whether the client was free to decide, and payroll handling of service charges has real tax consequences, so confirm the treatment with your CPA or payroll provider before you lock in how the accounts are mapped.

Card batches deposit net of merchant fees

Credit card settlements almost never land as a clean round number. A batch deposits net of the processor's fee, and it can bundle several different things at once. Split each batch into its parts: gross sales go to income, the processor fee goes to a merchant fees expense account, any sales tax you collected goes to a sales tax payable liability, and any voluntary tips go to a tips payable liability. If you post only the net deposit as income, your sales look smaller than they are and your fee spend disappears from view.

Catering sales tax is genuinely state-specific. Many states tax prepared food, and a number of them also tax the service or labor portion of a catered event, sometimes at a different rate or with local add-ons. Because the rules vary widely by state and even by locality, treat sales tax as state-specific and confirm what is taxable on your invoices with a CPA before you set up the tax accounts.

Rentals and pass-throughs

Tables, linens, china, glassware, and tents that you rent for a client and then rebill can be recorded two ways. You can record them gross (the rebilled amount as revenue and the rental cost as a matching expense) or handle them as a pure pass-through that nets to zero. Either method can be defensible, but pick one and stay consistent, and make it match how the charge shows up on your client invoice.

If your contract lists rentals as a marked-up line item, gross recording usually mirrors reality better and captures the margin you earn on the markup. If you simply pass the vendor's cost straight through with no markup, the pass-through method keeps your revenue from being padded by money that was never really yours to keep.

Food and beverage cost: COGS or inventory

For most caterers, perishable food bought for a near-term event is expensed straight to cost of goods sold as it is purchased. The food is consumed within days, so there is little value in carrying it as an asset on the balance sheet. That keeps your COGS tied closely to the events you are actually serving in a given period.

The picture changes if you hold significant non-perishable stock or a real beverage inventory (cases of wine, liquor, or bulk dry goods you draw down over many events). Those items behave like inventory: you record them as an asset when purchased and move them to COGS as they are used. Tracking beverage as inventory also helps you spot shrinkage. Which method fits depends on how much you hold and for how long, so confirm the approach with a CPA if your storage is substantial.

Staffing: 1099 contractors and temporary W-2

Servers, bartenders, and event captains are frequently paid as 1099 contractors or as temporary W-2 staff, and the classification is not yours to choose freely: it depends on the control and independence tests, so confirm worker status with a CPA. For contractors, the 1099-NEC reporting threshold is $2,000 for payments made on or after January 1, 2026 (and indexed for inflation after that), a change from the old $600 threshold. Track total payments to each contractor across the year so you know who crosses the line.

If you run event staff as W-2 employees instead, you have payroll withholding, the employer share of FICA, and usually workers' compensation coverage in the mix, and each payroll run splits into wages, taxes, and withholdings rather than a single contractor payment. Keep those posting to your labor and payroll liability accounts, not lumped into a generic expense.

Equipment financing splits principal and interest

A delivery van, a stack of convection ovens, or a financed mobile kitchen shows up on the statement as one flat monthly payment, but it is not a single expense. Each payment splits into principal, which reduces the loan liability on your balance sheet, and interest, which is the actual expense. Post the whole payment to the expense account and you overstate costs while the loan balance never moves. Use the lender's amortization schedule to split each payment correctly.

Chargebacks and refunded deposits

When an event cancels and you return a deposit, that refund reduces the customer-deposit liability you were holding, not your revenue, because you never recognized the deposit as income in the first place. If you booked deposits correctly as a liability, a refund simply unwinds the liability and the cash leaves the bank, with no hit to sales. The same logic covers a card chargeback on a deposit that was never earned.

How catering statement lines map to QuickBooks
What appears on the bank statementWhat it actually isWhere it belongs in QuickBooks
Event deposit receivedCustomer deposit collected before the eventCustomer deposits / deferred revenue (liability)
Final event paymentBalance earned when the event is performedCatering income (recognized on event date)
Card batch net of feesGross sales minus processor fee and any tax or tipsSplit: sales income, merchant fees, sales tax payable, tips payable
Merchant processing feeCost the processor deducts from each batchMerchant fees expense
Mandatory service chargeCaterer's revenue, wages when paid to staffService charge income (payout runs through payroll)
Voluntary gratuity paid outEmployees' money you were holdingTips payable (liability), cleared at payout
Rental rebilled to clientPass-through or grossed-up rebillRental income with matching rental expense, consistent with your invoice
Food or beverage purchaseIngredients or drinks for eventsCost of goods sold (or inventory if held in quantity)
Sales tax remittanceTax collected, paid to the stateSales tax payable (liability), reduced on payment
1099 event-staff paymentContractor pay for servers or bartendersContract labor expense (track toward the $2,000 threshold)
Delivery van or equipment loan paymentSplit of principal and interestLoan liability (principal) plus interest expense
Refunded deposit on a cancelled eventReturn of money you were holdingReduces customer deposits (liability), not revenue
Frequently asked questions

How do I record catering deposits in QuickBooks?

Record a catering deposit as a liability, not income. Post it to a customer deposits or deferred revenue account when the money clears, because you have not earned it yet. On the event date, recognize the full contracted amount as revenue and clear the deposits against it. Long lead times can get nuanced, so confirm timing with a CPA.

Is a service charge taxable income for a catering company?

Yes. A mandatory or automatic service charge is the caterer's revenue and taxable income, per IRS Revenue Ruling 2012-18, unlike a voluntary tip. When you pay that service charge out to staff, it is treated as wages subject to payroll withholding, not as a tip. Payroll handling has real tax effects, so confirm the setup with your CPA or payroll provider.

What is the difference between a service charge and a gratuity in QuickBooks?

A service charge is a mandatory fee the client cannot decline, so it is your revenue and runs through wages when paid to staff. A gratuity is a voluntary tip the client freely chooses, so it is the employees' money, held as a tips payable liability, never revenue. The dividing line is whether the client had a choice.

How do I record event staff paid as 1099 contractors?

Post payments to servers, bartenders, and captains to a contract labor expense account and track each contractor's yearly total. The 1099-NEC threshold is $2,000 for payments made on or after January 1, 2026, indexed after that, replacing the old $600 figure. Worker classification depends on control tests, so confirm each person's status with a CPA.

Is catering subject to sales tax?

Usually, but it is state-specific. Most states tax prepared food, and many also tax the service or labor portion of a catered event, sometimes at a different rate or with local add-ons. Because the rules vary by state and locality, confirm what is taxable on your invoices with a CPA and set up your sales tax payable account accordingly.

How do I import a bank statement into QuickBooks?

QuickBooks cannot read a PDF, so convert your PDF or image statement to a .qbo file with the tool above first. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file. Then categorize each line once it lands.

Convert your first statement free.

Upload a PDF, get a QuickBooks-ready .qbo back in seconds. No card to try it.

Related guides

Ready to convert a statement? Start with the PDF to QBO converter or the general QBO converter at the top of this page, then follow the steps to import a bank statement into QuickBooks Online. Catching up a full season? A bulk bank statement to QuickBooks conversion turns a stack of months into .qbo files at once, and firms handling several clients can work from the workflow for accountants. For related food-service bookkeeping, see the guides for restaurants and breweries and taprooms, and for a deeper walkthrough read how to record deposits, service charges, and gratuity.

More bank statements we convert to QuickBooks

Same converter, tuned for the layout each bank uses. Find yours: