Bank Statement to QuickBooks for Restaurants: Convert PDF Statements to QBO

A restaurant almost never runs on a single account. You have an operating checking account, a merchant or card-settlement account where POS batches land, one or more vendor cards for food, produce, and paper goods, and often a separate payroll account. Each one carries a slice of the numbers you need, and bank feeds usually reach back only about 90 days. Feeds also tend to skip closed cards and loan accounts, which is a problem when you are backfilling last year for taxes or catching up a set of books.

QuickBooks will not read a PDF directly, so when your bank or lender only gives you PDF statements you have to convert them into a format QuickBooks accepts. Manual .qbo upload carries no date limit, so you can bring in a full prior year or an account the feed never touched. You can convert a bank statement to QuickBooks with the tool above, then categorize each transaction once it lands.

Most POS batches (Toast, Square, Clover) settle to your bank net of processing fees, which run roughly 2 to 4 percent of card sales for a typical restaurant. If you book the deposit as revenue, your sales look smaller than they really are and your sales tax math drifts. The cleaner method is to gross up: record the full sales figure from the POS as income, then post the processing fees to a separate merchant fees expense account. The net deposit on your bank statement should equal gross sales minus fees, which is how you check the entry ties out.

Credit card tips are not your money, so do not treat them as sales. When a card batch includes tips, credit a Tips Payable liability account (QuickBooks Online creates an Undistributed Tips account when you turn on tips) for the gross tip amount, and clear that liability when you pay the tips out to staff, usually through payroll. Holding tips as a liability until payout keeps them off your income statement and keeps your payroll and withholding numbers honest.

Here is how the lines on a restaurant's bank and card statements typically map to QuickBooks accounts, with a class or tag for the location or revenue center so multi-unit reporting stays clean.

Delivery app payouts need the same gross-up as your POS batches. DoorDash and Uber Eats deposit the sale after commission, marketing, and refunds are taken out, so record the full menu sales as income and post commission and marketing to their own expense accounts. If you only book the deposit, you understate sales and hide what the platforms are really costing you.

If you run more than one location, class or location tracking is what keeps each unit's profit and loss separate inside one company file. Turn on classes (or locations) in QuickBooks Online Plus and Advanced, name one class per restaurant, and tag every imported transaction to its unit. Now you can run a profit and loss by class and see which location is carrying the group and which is dragging it. On QuickBooks Desktop, the class list does the same job.

Getting there is faster when the statements come in together rather than one account at a time. When you are stacking a merchant account, two or three vendor cards, and a checking account across a full year, a bulk bank statement to QuickBooks conversion turns the whole pile into .qbo files at once, so you can import account by account and reconcile each month against the closing balance on the statement.

Prime cost is the number most operators watch: it is Cost of Goods Sold (food and beverage) plus total labor (wages, taxes, and benefits). Together those two lines are the biggest controllable costs in the building, and many full-service restaurants aim to keep prime cost around 60 percent of sales. Food cost on its own, food used divided by food sales, tells you whether portioning, pricing, and waste are under control.

These metrics only mean something if they are tracked often, ideally weekly, because a bad week is easier to fix than a bad quarter you find out about in April. Clean data feeds clean metrics: when your card and vendor statements import with accurate dates, descriptions, and amounts, your CoGS and labor accounts stay current, and a weekly prime cost number stops being a guess.

1. Upload your PDF bank and credit card statements to the converter at the top of this page. You can drop in several accounts at once, including merchant and vendor cards. It accepts PDF and image files.
2. The tool OCRs and parses each statement, then reconciles the running balance, keeping the date, description, and amount for every line.
3. Download a .qbo file per statement, plus Excel and CSV copies for prime cost and food cost sheets.
4. Import into QuickBooks. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect.

QuickBooks Online manual upload accepts .csv, .txt, .qbo, .qfx, and .ofx files, up to 1,000 lines and 350 KB per file, so split a long statement if it runs past those limits. For a step-by-step walkthrough, see how to import into QuickBooks Online, then assign classes and categories once the transactions land.

How do I do bookkeeping for a restaurant in QuickBooks?

Set up a chart of accounts built for restaurants: separate CoGS for food and beverage, a labor group, a merchant fees account, and a Tips Payable liability. Import POS deposits grossed up against processing fees, tag each transaction to its location with classes, and reconcile every account monthly against the statement balance.

How do I record credit card tips in QuickBooks?

Record credit card tips as a liability, not as sales, because the money belongs to your staff. Credit a Tips Payable account (QuickBooks Online calls it Undistributed Tips) for the gross tip amount when the card batch settles, then clear that liability when you pay the tips out, usually through payroll so withholding applies.

How do I record restaurant sales in QuickBooks?

Record the full gross sales from your POS as income, then post processing fees, tips, and refunds separately so the net matches your bank deposit. Many operators enter a daily or weekly sales receipt or journal entry from the POS summary, split by revenue center, rather than booking the net deposit as revenue.

How do I categorize food purchases in QuickBooks?

Categorize food and ingredient purchases as Cost of Goods Sold, keeping food and beverage or liquor in separate CoGS accounts so you can measure each cost percentage. Post paper goods and cleaning supplies to their own expense lines instead of CoGS, and tag each purchase to the location that used it for multi-unit reporting.

Can I import old bank statements into QuickBooks for taxes?

Yes. Convert your older PDF bank and card statements to .qbo files and upload them manually, which has no date limit, unlike bank feeds that reach back only about 90 days. This is how most restaurants backfill a prior tax year or a merchant account the feed never connected to. Import account by account and reconcile each month.

How do I record merchant fees in QuickBooks?

Record merchant processing fees in their own expense account rather than netting them against sales. Book gross card sales as income, then post the fees (about 2 to 4 percent of card volume) to a merchant fees account. The deposit on your statement equals gross sales minus fees, which is how you confirm the entry ties out.