Bookkeeping and financial strategy for small businesses in Beaver Dam and throughout Wisconsin.

Call or Text: (608) 318-3094

How should a restaurant handle daily sales entry in QuickBooks?

Don’t enter every individual ticket or transaction into QuickBooks. You’d spend hours on data entry and still end up with a mess. Instead, enter one daily sales summary per day pulled from your POS system’s Z-report. This gives you the detail you need without burying your books in thousands of line items every month.

Your POS Z-report (the end-of-day report) breaks down everything that happened that day. Pull these numbers from it for your daily entry: total taxable sales, total non-taxable sales, comps and discounts, sales tax collected, cash payments received, credit card payments received, and tips. Each of these goes to a specific account in QuickBooks.

In QuickBooks, create a sales receipt or journal entry for each day. Taxable food and beverage sales hit your revenue accounts. Non-taxable sales (catering deposits, gift card sales, or whatever applies to your operation) go to their own line. Sales tax collected goes to a sales tax liability account because that money isn’t yours. It’s owed to the Wisconsin Department of Revenue. Comps reduce your revenue or go to a separate comps account so you can see how much you’re giving away.

The payment side of the entry needs to split between cash and cards. Cash goes to a cash on hand account until you make your bank deposit. Credit and debit card payments go to a clearing account (sometimes called “undeposited funds”) because the money won’t hit your bank for a day or two, and it will arrive minus processing fees. Tips collected on cards go to a tips payable liability account since that money belongs to your employees, not the business.

When the card processor deposits funds into your bank account, match that deposit against what’s sitting in your clearing account. The difference between what you recorded from the Z-report and what actually hits the bank is your credit card processing fee. Record that fee as an expense. This is how you keep your books clean and catch any discrepancies between what your POS says happened and what actually landed in your account.

For cash deposits, match the physical deposit you bring to the bank against the cash totals from your daily summaries. If there’s a difference, investigate it. Cash shortages happen in restaurants, but you want to know about them promptly rather than discovering a pattern months later.

The most common mistake is recording just the bank deposit amount and calling it “sales.” This lumps everything together and hides critical information. You lose visibility into sales tax owed, tip liabilities, comps, and processing fees. Your profit and loss statement becomes unreliable because revenue is overstated by the amount of sales tax and tips mixed in. When it’s time to file your sales tax return, you’re scrambling to figure out what you actually owe.

Do your daily sales entries consistently, ideally the next morning or within a day or two. Letting them pile up for weeks means you’re reconciling from memory, which leads to errors. If you run a restaurant and find yourself three weeks behind on sales entries, you’re already losing track of your cash position.

This process takes five to ten minutes a day once you have a template set up in QuickBooks. A bookkeeper who works with restaurants can build this template for you and show you exactly which Z-report numbers go where. If you’d rather not touch it at all, Wisconsin small business bookkeeping services like Rock Steady can handle the daily sales recording as part of your monthly bookkeeping so your books always reflect what’s actually happening in your restaurant.

Wisconsin's Small Business Bookkeeper

The Next Step:
A Quick Conversation

Tell us about your business. We'll talk through what you need, answer your questions, and give you a clear quote.

More Questions

How should an architecture firm handle subcontractor/consultant costs?

It depends on whether you pass consultant costs through at cost, mark them up, or absorb them in your fee. Each method hits your P&L differently, and the bookkeeping has to match the contract structure or your margins won't mean anything.

Read answer

Do I need to issue 1099s to cleaning subcontractors?

Yes, if you paid a subcontractor $600 or more during the year via check, cash, or ACH and they aren't incorporated. Collect a W-9 from every subcontractor before you pay them the first time.

Read answer

How do retailers handle shrinkage and inventory adjustments?

Compare a physical count to what your books say you should have. The difference is shrinkage, recorded as a loss expense with a matching reduction to your inventory asset. Industry average runs 1-2% of sales.

Read answer

How do boutiques account for inventory markdowns and sales?

When you sell marked-down inventory, the sale records at the reduced price while cost of goods sold reflects what you originally paid. Your gross margin compresses naturally. For clearance items sold below cost, you may need to write inventory value down.

Read answer

How do you do weekly inventory counts for restaurant COGS?

Count everything on hand Sunday night after close, apply standard costs, then compare your actual usage to theoretical usage based on recipes and POS sales. The gap between those two numbers tells you where food cost is leaking.

Read answer

What's tip pooling and how is it recorded?

Tip pooling collects a portion of tips from tipped employees and redistributes them among eligible staff like bussers, food runners, and bartenders. It must be tracked through your POS and processed through payroll so each worker's share shows up on their paystub.

Read answer

Small business bookkeeping firm based in Beaver Dam, Wisconsin. Bookkeeping, financial strategy, and fractional CFO services built around helping owners understand their numbers and plan ahead. Founded by Laura Prater, a QuickBooks Certified ProAdvisor with over a decade of accounting experience.

  • QuickBooks ProAdvisor Gold badge
  • Intuit Certified QuickBooks ProAdvisor Level 1 badge
  • Gusto Payroll Certification badge
  • Gusto People Advisory Certification badge
  • Float Certified badge
  • Highly Recommended on Alignable badge

© 2026 Rock Steady Bookkeeping LLC