How should bars separate liquor sales, food sales, tips and merchant fees?
The structure starts at the POS. Configure categories that match how you want to see the business. At minimum, separate liquor, beer, wine, food, and non-alcoholic beverages. If you sell merchandise or charge cover, those need their own buckets too. Whatever categories exist at the POS flow into your books, so getting this right upfront saves hours of cleanup later.
Each POS category should map to its own revenue account in QuickBooks. Liquor sales, beer sales, wine sales, food sales, NA beverage sales. This lets you see what’s actually driving revenue and calculate margins by category. Lumping everything into a single sales account makes your P&L useless for managing the business and harder to defend if you ever get audited.
Sales tax is the next layer. North Carolina applies general sales tax to most prepared food and beverages, but mixed beverages carry an additional excise tax that gets reported separately. Your POS should tag each sale with the correct tax treatment, and your books should reflect sales tax as a liability rather than revenue. The gross ticket includes tax, but only the net amount hits your revenue account. The tax portion sits in a sales tax payable account until you file and remit. Our restaurant and bar bookkeeping work usually starts here because most owners we meet have these mixed together.
Tips work the same way. When a customer leaves a $20 tip on a credit card, that’s not your money. Record it as a tip liability when collected, then clear it when paid out to the bartender through payroll or a tip pool. Cash tips that don’t run through the bar’s deposit only show up in your books for payroll tax reporting, but any tips you’re holding for any reason belong on the liability side of the balance sheet, not in revenue. The IRS expects reported tip income to reconcile with payroll, so this needs to be clean.
Merchant fees should be booked gross. Run all card sales through revenue at full ticket value, then book the processor’s fees as a separate expense account. Don’t net fees against sales just because the deposits arrive net. You want to see your true sales number and you want merchant fees as a visible line item, because at 2% to 4% of card volume, they add up to real money over a year. A daily sales journal entry should show total sales by category, sales tax collected, tips owed, and the processor fee taken out before deposit.
COGS gets the same category treatment. Set up separate accounts for liquor cost, beer cost, wine cost, and food cost. Every invoice from your distributor or food vendor gets coded to the right category. This is what lets you calculate pour cost and food cost percentages that actually mean something. Pour cost typically runs 18% to 22% on liquor, around 25% on beer, and 28% to 32% on wine. Food cost usually lands between 28% and 32% for bars with a kitchen. If your numbers are off, the categorized COGS tells you whether it’s the kitchen, the bar, or both.
Inventory ties into COGS. Take counts at month-end by category and adjust COGS based on actual usage rather than purchases. Buying $8,000 in liquor in March doesn’t mean you used $8,000 in March. The adjusting entry brings COGS in line with consumption so your margins by category aren’t fiction.
The daily reconciliation routine ties it together. POS reports show sales by category, sales tax collected, tips collected, and merchant batch totals. Bank deposits match net of fees. Tips paid out clear the liability. Sales tax accrues until remitted. That’s the structure that makes month-end financials useful instead of a guess, and it’s the structure our bookkeeping, tax and consulting services are built around for bar and restaurant clients across the Carolinas.
Trusted Accounting for Small Businesses
First Step:
Start With a Call
Tell us about your business and what you need help with. We'll ask a few questions, evaluate your current situation, and let you know how GMJ can support your books, taxes, and day-to-day operations.
More Questions
How should a nonprofit prepare for an annual review or audit?
Audit prep starts months before the auditor arrives, not the week of fieldwork. Reconcile every account, organize supporting documents, build complete grant files, and have all schedules ready before they're requested. The cleaner the records, the lower the audit fees and the fewer management letter comments.
Read answerWhat should a QuickBooks Online setup include before transactions are imported?
A proper QuickBooks Online setup includes configuring the chart of accounts, connecting bank and credit card feeds, setting up products and services, sales tax, user permissions, and any third-party integrations. Getting these right before transactions come in saves hours of cleanup later.
Read answerHow can TaxJar help with ecommerce sales tax reporting?
TaxJar connects to your sales channels, calculates sales tax by state and jurisdiction, tracks economic nexus thresholds, and files returns automatically. It handles the compliance work, but it only works correctly when your underlying bookkeeping is reconciled to each sales channel.
Read answerWhat bookkeeping records should medical and dental practices review monthly?
Medical and dental practices should review daily deposits, insurance payments, patient AR aging, payroll and benefits, merchant fees, supply spending, and equipment loan activity each month. Catching issues monthly keeps practice management software in sync with the books and prevents small problems from becoming costly cleanups.
Read answerWhat is the best way to reconcile merchant deposits for a medical practice?
Reconcile by batch using the payment processor report, not by individual patient charge. Match the gross deposit total, post fees as a separate expense, and use a clearing account to bridge the timing gap between date of service and the day the money hits the bank.
Read answerWhat restaurant reports should owners review weekly?
Restaurant owners should review sales by category, labor cost, food cost, prime cost, comps and voids, cash over/short, delivery app fees, and cash position every week. Monthly is too slow to catch problems while you can still fix them.
Read answer