How to Record Daily Sales in QuickBooks for a Restaurant

Short answer: The right way to record daily sales in QuickBooks for a restaurant is one sales receipt or journal entry per day that mirrors your POS Z-report, not an invoice for every ticket. Debit where the money went (a card clearing account for card sales, Undeposited Funds for cash), credit each sales category, credit sales tax payable, credit tips as a liability owed to staff, and debit merchant fees and any cash over or short. When the processor batch and the cash drop hit the bank, you match them against the clearing account so it nets to zero. This keeps revenue, tax, and tips separated and makes the bank reconciliation tie out.

Why you record a daily summary, not individual sales

A restaurant rings up hundreds of tickets a day, and entering them as individual customer invoices would bury QuickBooks and never reconcile against the bank. Instead you record a single daily sales entry that matches the totals on your point-of-sale Z-report or daily sales summary. That one entry captures the whole day: gross food and beverage sales, the sales tax you collected, the tips guests added, the fees your processor took, and the split between cash and card. Most operators build it once as a recurring template and update the numbers each day, or let a POS integration push it in.

What goes into a restaurant daily sales entry

A daily sales entry has a debit side for where the money landed and a credit side for what the money represents. The two sides have to balance. Here is the structure most restaurants use.

The card clearing account is the key to a clean reconciliation. You debit it for the day's card sales, then when the processor batch lands in the bank a day or two later you record the deposit against that clearing account so it empties out. If the batch came in net of fees, the difference is your merchant fee line.

How do I set up daily sales in QuickBooks Online?

In QuickBooks Online, create a Sales Receipt with a single customer named Daily Sales and add a product or service item for each line that maps to the right account, or use a recurring Journal Entry. Turn on the tips setting under Account and settings so QuickBooks posts gratuities to an Undistributed Tips liability instead of income. Set the receipt or journal to recurring so you reuse the same template each day and only change the amounts. Save the day's Z-report as the supporting document so anyone can trace the entry back to the register.

How do I record credit card tips for a restaurant?

Record credit card tips as a liability, not as sales income, because that money belongs to your staff. On the daily entry, credit a Tips Payable or Undistributed Tips account for the gratuities guests added to their cards. When you pay those tips out to servers, whether in cash from the drawer or through payroll, you debit the same liability account to clear it. Booking tips this way keeps them out of revenue, so you are not overstating income or paying tax on money that was never the restaurant's.

How do I handle merchant fees and the deposit that does not match?

Your processor settles each card batch net of interchange and processing fees, so the deposit that reaches the bank is smaller than the card sales you rang up. Record the gross card sales into the card clearing account on the daily entry, then when the net batch deposit posts, split it: the deposit amount to the bank and the fee to a Merchant Fees expense, together clearing the gross amount out of the clearing account. That way your revenue stays at gross, your fees are visible on the profit and loss, and the clearing account returns to zero.

How does cash over/short work?

Cash over or short is the small gap between the cash your POS says you should have and the cash you actually counted and deposited. Book the difference to a Cash Over/Short account: a shortage is a debit (an expense), an overage is a credit. Keeping a dedicated account for it means the discrepancy does not distort sales, and a running total flags a drawer or a shift that needs attention.

Reconcile the entry against the bank

The daily entry is only half the job. At month end you reconcile the bank statement against these entries so every cash drop and card batch is accounted for. The fastest way to do that is to work from the statement itself: convert the restaurant's bank statement to a spreadsheet so each deposit sits on its own row, then match each card batch and cash deposit to the daily entry that created it. If you keep your books in QuickBooks, you can also convert the statement straight into QuickBooks and reconcile inside the software. For a step-by-step on tying the two sides together, see our guide to reconciling bank statements.

Weekly instead of daily

A small restaurant does not have to post every single day. If your volume is low or you close the books weekly, record one summary entry per week built from the daily Z-reports, using the same structure. The tradeoff is less day-level detail if you need to chase a discrepancy, so busy operations usually stay daily and quieter ones move to weekly. Either way the entry mirrors the POS and runs through the clearing account so the bank still reconciles cleanly.