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

What's the best chart of accounts for a residential cleaning business?

Split revenue by service type, separate direct costs like labor and supplies from overhead, and keep your operating expenses specific enough to spot trends. This structure lets you see true margins by service line.

Read answer

Should I pay my cleaners as W-2 employees or 1099 contractors?

For most cleaning businesses, your cleaners should be classified as W-2 employees. If you set schedules, provide supplies, and direct how the work gets done, the IRS considers them employees regardless of what you call them on paper.

Read answer

What's Wisconsin's Economic Development Surcharge?

The Economic Development Surcharge is a Wisconsin tax on C-corporations and certain partnerships with gross receipts of $4 million or more. Most small businesses fall well below the threshold, but LLCs that elected corporate taxation should verify whether they're subject to it.

Read answer

What are common bookkeeping mistakes for roofing contractors?

Roofing contractors commonly mix storm and retail revenue together, pay subcontractors without collecting W-9s, miss dump fees in job costing, and fail to reconcile merchant deposits correctly. These mistakes distort job profitability, create tax compliance issues, and make it harder to understand where your money is actually going.

Read answer

Should I use QuickBooks Online Simple Start, Essentials, Plus, or Advanced?

Most small businesses land on Essentials or Plus. The right plan depends on how many users you need, whether you track inventory, and whether you need job or project-level reporting.

Read answer

How do I form an LLC in Wisconsin?

File Articles of Organization with the Wisconsin Department of Financial Institutions (DFI) online for $130. Your LLC name must be unique and include 'LLC' or a variation. Online filings are typically processed within 1-2 business days.

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