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 small retailers handle returns and refunds in bookkeeping?

Returns reverse the original sale. Revenue and sales tax get reduced, and inventory increases back if the item is resellable. Using a contra-revenue account to track returns separately gives you visibility into return patterns.

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

How should a roofing contractor handle storm/insurance jobs vs retail jobs?

Track insurance and retail jobs as separate revenue streams using distinct income accounts or classes. Insurance work has a unique payment structure with ACV and RCV supplements that requires careful accounts receivable tracking to see true profitability.

Read answer

How much does it cost to start a Wisconsin LLC?

The mandatory state filing fee is $130 for Articles of Organization. Add a $25 annual report and a few optional items, and most Wisconsin business owners launch an LLC for under $200.

Read answer

What inventory method should a small retailer use — FIFO or average cost?

Most small retailers should use average cost. It's simpler, it's what QuickBooks Online calculates automatically, and the difference in accuracy compared to FIFO is minimal for typical retail operations. Consistency over time matters more than the method you pick.

Read answer

How do I track employee mileage for a mobile cleaning business?

It depends on whether employees drive personal vehicles or company vehicles. For personal vehicles, use a mileage tracking app and reimburse at the IRS standard rate. For company vehicles, track actual expenses per vehicle using fuel cards and maintenance logs.

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