Convert PDF bank and credit card statements to QBO for QuickBooks Online and Desktop so catering event deposits, service charges, and gratuity post cleanly.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF
Uploading...
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.
Built for the statements US banks actually send, checked before it exports.
The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.
Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.
One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
Three steps. No column-mapping wizard.
Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.
Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
The specifics that decide whether the import is clean. If your case is not here, email [email protected].
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.
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.
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.
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.
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.
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.
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.
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.
| What appears on the bank statement | What it actually is | Where it belongs in QuickBooks |
|---|---|---|
| Event deposit received | Customer deposit collected before the event | Customer deposits / deferred revenue (liability) |
| Final event payment | Balance earned when the event is performed | Catering income (recognized on event date) |
| Card batch net of fees | Gross sales minus processor fee and any tax or tips | Split: sales income, merchant fees, sales tax payable, tips payable |
| Merchant processing fee | Cost the processor deducts from each batch | Merchant fees expense |
| Mandatory service charge | Caterer's revenue, wages when paid to staff | Service charge income (payout runs through payroll) |
| Voluntary gratuity paid out | Employees' money you were holding | Tips payable (liability), cleared at payout |
| Rental rebilled to client | Pass-through or grossed-up rebill | Rental income with matching rental expense, consistent with your invoice |
| Food or beverage purchase | Ingredients or drinks for events | Cost of goods sold (or inventory if held in quantity) |
| Sales tax remittance | Tax collected, paid to the state | Sales tax payable (liability), reduced on payment |
| 1099 event-staff payment | Contractor pay for servers or bartenders | Contract labor expense (track toward the $2,000 threshold) |
| Delivery van or equipment loan payment | Split of principal and interest | Loan liability (principal) plus interest expense |
| Refunded deposit on a cancelled event | Return of money you were holding | Reduces customer deposits (liability), not revenue |
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.
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.
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.
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.
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.
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.
Upload a PDF, get a QuickBooks-ready .qbo back in seconds. No card to try it.
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.
Same converter, tuned for the layout each bank uses. Find yours:
For one bookkeeper running monthly close.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
For an accounting firm or finance team with steady volume. Adds QuickBooks .qbo export and bulk conversion.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
For lenders, audit firms and analysts running thousands of statements a month.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |