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 answerShould 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 answerHow 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 answerHow 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 answerWhat 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 answerHow 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