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
What's the role of budgeting and variance analysis for a growing business?
A budget gives you a financial target for the year. Variance analysis is the monthly practice of comparing what actually happened to what you planned, then asking why the gaps exist and what to do about them.
Read answerHow do I track employee mileage and tolls for a mobile cleaning business in NYC?
Use a mileage tracking app to log every business trip and reimburse employees at the IRS standard rate. For NYC tolls and congestion pricing, pull E-ZPass statements monthly and allocate costs to specific jobs so you know your true margins per client.
Read answerWhat's per diem for truck drivers and how is it tracked?
Per diem is a daily allowance for meals and incidental expenses when a driver is away from home overnight. For 2024, transportation workers can use $69 per full travel day, and they get a higher deduction rate of 80% compared to most other industries.
Read answerWhat expenses can a NYC trucking company deduct?
Nearly every cost of running a trucking operation is deductible. Fuel, tolls, truck payments, insurance, repairs, permits, per diem meals, and more. The challenge for most NYC trucking companies isn't having deductions but tracking and categorizing them properly.
Read answerHow should a Bronx salon owner separate personal and business finances?
Open a dedicated business checking account and credit card, and run every salon expense through those accounts only. Pay yourself through owner draws or a W-2 salary depending on your entity type. This is the single most important thing you can do to protect yourself from IRS problems.
Read answerWhat accounting software works best for a small trucking company?
QuickBooks Online is the best accounting foundation, but it needs a trucking-specific layer on top for IFTA reporting, per-load profitability, and driver settlements. QBO alone leaves too many gaps for a trucking operation.
Read answer