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 do architects track billable hours vs project costs?

Most architecture firms use phase-based billing that maps to standard project phases. Tracking hours against each phase and comparing them to the agreed fee is what reveals whether a project is actually profitable.

Read answer

How do small law firms handle cost advances vs expenses?

Client cost advances like filing fees and expert witness payments are not firm expenses. They are client receivables that sit on the balance sheet until the client reimburses the firm.

Read answer

How do restaurants track COGS for food and beverage separately?

Restaurants use separate cost of goods sold accounts in their chart of accounts for food and beverage. This matters because target food cost runs 28-35% of food sales while beverage cost runs 18-25%, and combining them hides margin problems in both categories.

Read answer

How do I handle holdbacks or retainage in a facility services contract?

Track retainage in a separate receivable account so it doesn't distort your AR aging. Recognize the revenue when you earn it, but don't expect to collect the held-back portion until the contract terms trigger its release.

Read answer

What are the best bookkeeping practices for a photography business?

Use a dedicated business bank account and credit card, track camera gear as depreciable fixed assets, log mileage for every shoot, and record client deposits as deferred revenue until the work is complete.

Read answer

How long do Wisconsin law firms need to keep trust account records?

Wisconsin Supreme Court Rule 20:1.15(f)(5) requires at least six years. Covered records include bank statements, cancelled checks, deposit slips, client ledgers, and three-way reconciliation reports.

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