How should a NYC restaurant handle daily sales entry in QuickBooks?
The right approach is one summary entry per day based on your POS system’s Z-report. Not individual transactions, and not a POS integration that dumps hundreds of line items into QuickBooks and creates a mess you can’t reconcile. One clean entry per business day that captures everything your register reported.
Pull the Z-report at close. The numbers you need are gross taxable sales, non-taxable sales (if any), comps and discounts, sales tax collected, and the tender breakdown showing how much came in as cash, how much as credit and debit cards, and how much in charged tips. These are the building blocks of your daily sales summary.
In QuickBooks, create a daily sales receipt or journal entry. On the income side, record your food sales, beverage sales, and any other revenue categories you want to track separately. Sales tax collected at 8.875% goes to a Sales Tax Payable liability account. Comps can either reduce gross sales directly or go into a separate contra-revenue account so you can see how much you’re comping over time. On the payment side, cash tender hits your Cash on Hand account and credit card tender goes into an Undeposited Funds or merchant clearing account.
Tips need careful handling. Credit card tips that your POS collected show up in the card tender total, but that money belongs to your staff. Record the tip amount as a credit to a Tips Payable liability account. When you pay tips out to employees, either through payroll or a cash payout, you reduce that liability. Cash tips kept by servers at the end of the night don’t flow through your books as income or expense since that money went straight from customer to employee. You still need to track reported cash tips for payroll tax purposes, but that happens on the payroll side.
When your merchant processor deposits funds into your bank account a day or two later, match that deposit against the card tender amount sitting in your clearing account. The deposit will be smaller than the card total because the processor took their cut. Book the difference as a credit card processing fee expense. This is where a lot of restaurants get confused. The bank deposit doesn’t match any single number on the Z-report because it’s the card sales plus charged tips minus processing fees, sometimes batched across days. The clearing account is what makes this reconcilable.
If your cash register is over or short at the end of the night, record the difference in a Cash Over/Short account. Small overages and shortages happen. If they’re consistently large, that’s a different problem, but the bookkeeping should reflect what actually happened.
Do this every day or at minimum every few days while the reports are still fresh. Restaurants that let Z-reports pile up for weeks end up guessing, and guessing leads to books that don’t tie to the bank and sales tax filings that are off. Working with Bronx bookkeepers who understand restaurant operations can take this completely off your plate so the entries stay current and accurate.
The daily sales summary method gives you clean revenue numbers, accurate sales tax liability tracking for your NYC filings, and a clear trail from POS to bank deposit. It also makes your restaurant bookkeeping something your accountant can actually work with at tax time instead of spending hours trying to untangle a year of messy data. Keep your Z-reports filed by date as backup documentation. If you ever get audited or questioned on a sales tax filing, those reports are your proof.
Your NYC Small Business Bookkeeper
The Next Step:
A Short Conversation
Tell us about your business and what you need help with. We'll ask a few questions, walk you through how we work, and give you an exact quote.
More Questions
How do NYC restaurants track COGS for food and beverage separately?
Set up separate cost of goods sold accounts in your chart of accounts for food and beverage, then use regular inventory counts and purchase tracking to calculate the true cost in each category. Beverage COGS should be broken down further into beer, wine, and liquor.
Read answerHow does an external controller review the work of an in-house bookkeeper?
An external controller performs a structured monthly review of reconciliations, journal entries, aged receivables and payables, and financial statements. They sample-test transactions and produce a signed checklist that gives the business owner audit-ready documentation.
Read answerHow do NYC restaurants handle credit card tips vs cash tips in bookkeeping?
Credit card tips flow through your merchant deposit and get paid out via payroll. Cash tips are reported by employees on a daily tip log. Both types must appear on W-2s and have payroll taxes calculated.
Read answerHow should a NYC residential cleaning business calculate gross margin on a contract?
Subtract your direct costs from contract revenue, then divide by revenue. Direct costs include labor, supplies, travel and tolls, and equipment. NYC operators should target 30-40% gross margin to cover overhead and leave room for profit.
Read answerWhen does a small business need a fractional CFO?
Most small businesses need a fractional CFO when financial decisions become forward-looking rather than historical. Common triggers include crossing $1M in revenue, seeking financing, planning major investments, or needing cash flow forecasting that goes beyond what a bookkeeper provides.
Read answerHow do I migrate from spreadsheets or Excel to QuickBooks Online?
Start by building a chart of accounts in QuickBooks Online that matches how you've been tracking things in Excel. Pick a clean cutoff date, enter opening balances, then import historical transactions or connect bank feeds going forward.
Read answer