Managing a restaurant means juggling the floor, the kitchen, and the books, often all at once. From tracking daily sales to managing payroll and inventory, the right restaurant accounting software makes all the difference.
QuickBooks Online is one of the most widely used tools in the restaurant industry for a reason. This cloud-based solution lets you access your financial data anytime and anywhere. When you set it up correctly, it shows a clear, real-time view of your income statements, cash flow statements, and overall financial performance. With that visibility, you can focus on guests, not spreadsheets.
Here’s how to set up QuickBooks for restaurants the right way, step by step.
1. Chart of Accounts (Simplest Setup)
Your Chart of Accounts is the foundation of your restaurant bookkeeping. It organizes every transaction into the buckets that matter when you are trying to improve your business.
Below is a simple, restaurant-specific setup built for clarity and efficiency — no unnecessary clutter, just what matters.
Revenue
Understanding your revenue streams helps pinpoint which parts of your restaurant are most profitable.
- General Revenue: Your total restaurant sales.
- Revenue from Each Sales Channel: Break out dine-in, takeout, and delivery app sales (DoorDash, Uber Eats, etc.) to see where your margins sit.
- Revenue from Beverages (Non-Alcoholic): For cafés or juice bars where beverage sales make up a large portion.
- Revenue from Alcohol: Must be tracked separately due to unique tax and regulatory reporting rules.
Pro Tip: Use the Uniform System of Accounts for Restaurants (USAR) as a guideline. It’s an industry standard that ensures your financial reporting aligns with best practices.
Expenses
The best restaurant owners know that managing labor costs, overhead, and operational efficiency is key to making a profit.
- Wages (FOH / BOH): Separate Front of House and Back of House wages to better analyze staffing efficiency.
- Payroll Taxes & Benefits: Include CPP, EI, vacation pay, and any benefits.
- Merchant & Processing Fees: Include QuickBooks Payments, Stripe, or Square fees.
- Rent & Utilities: Core fixed costs; vital for cost-per-cover analysis.
- Cleaning & Laundry: Keep this separate — it’s easy to overlook and adds up.
- Marketing & Promotions: Campaigns, loyalty programs, or event sponsorships.
- Repairs & Maintenance: HVAC, kitchen equipment, or POS terminal upkeep.
- Software Subscriptions: Restaurant management software, POS systems, CRM software, and payroll tools.
Pro Tip: Simplify first. Add sub-accounts only when you regularly need detailed breakdowns (for example, “Delivery App Fees” under Merchant Fees).
2. Integrate Your POS & Payroll Tools
Once your QuickBooks account is structured, the next step is integration. Connecting your Point of Sale (POS) and payroll systems ensures that your data flows automatically between platforms for seamless, real-time reporting.
What to Integrate
- POS System (e.g., Lightspeed, TouchBistro, Square): Syncs sales receipts, daily totals, and sales reports directly into QuickBooks Online.
- Payroll Software (e.g., Wagepoint, QuickBooks Payroll): Syncs labor costs, deductions, and payroll tax transactions.
- Inventory Management or CRM Software: Optional but valuable for automating customer data and item-level insights as part of your broader inventory process.
Common Issues with POS Integrations
- Duplicate Journal Entries: Check that your POS posts only summaries, not detailed transactions and daily totals.
- Tax Mapping Errors: Ensure GST/HST and provincial sales tax match your QuickBooks setup.
- Uncategorized Transactions: Always map new income or expense accounts properly.
- Timing Differences: POS may record same-day sales, while deposits hit your bank later. Use your Profit and Loss (P&L) Statement and cash flow statements to reconcile weekly.
Pro Tip: Test your integration using a small batch of sales first. It’s easier to fix transaction mapping early than to clean up months of misclassified data later.
3. Tracking Tips
Tips are a major part of restaurant payroll — and a common compliance trap. In QuickBooks Online, treat tips as liabilities, not income.
Here’s how to track them properly:
- Create a Tips Payable (Liability) account.
- Record daily tip totals from your POS into this account.
- When you pay out tips (via payroll or cash), reduce that same liability.
This keeps your income statement accurate and ensures tip payouts aren’t mistaken for revenue or wages.
Pro Tip: If using QuickBooks Desktop for Mac, the same principle applies — but you’ll need to create manual journal entries. Always verify your balance sheet shows a $0 tip liability after each pay cycle.
4. Tracking Inventory
Inventory can make or break your profitability, but that doesn’t mean you need to overcomplicate it.
The simplest approach? Track your inventory at regular intervals.
- Record all purchases under Cost of Goods Sold – Food & Beverage.
- At month-end, do a quick physical count and adjust for usage.
- Create inventory adjustments in QuickBooks to reflect what’s left on hand.
Pro Tip: For better insight, maintain an Item List for your most expensive ingredients (like meat, coffee beans, or liquor). You can link these to Inventory Tracking accounts to see shrinkage and waste patterns.
Advanced restaurants often use software like MarketMan or MarginEdge to manage their operations. These programs sync real-time stock levels and update QuickBooks automatically.
5. Key Reports We Recommend Restaurants to Look At
Reports help managers make decisions about finances. These are the ones every restaurant owner should review regularly.
Profit & Loss Statement (P&L)
Run monthly to understand:
- Sales trends by channel
- Labor costs as a % of revenue
- Cost of Goods Sold vs menu pricing
Balance Sheet
Review quarterly to:
- Track tip liabilities and prepaid expenses
- Confirm asset values for equipment
- Monitor debt and lease obligations
Accounts Payable (A/P) Aging Report
Run weekly to:
- Check unpaid supplier invoices (produce, meat, wine)
- Prevent duplicate vendor payments
- Identify recurring cash flow bottlenecks
Cash Flow Statement
Run monthly to:
- Identify seasonal trends (e.g., patio months vs winter)
- Forecast upcoming expenses
- Ensure liquidity for payroll and rent
Pro Tip: If you want advanced analytics, QuickBooks works with restaurant management dashboards and tools. These pull sales reports and real-time data from your POS for a complete view.
Final Thoughts
Setting up QuickBooks Online for your restaurant isn’t just an accounting task, it’s a restaurant management strategy. With the right setup, your Profit and Loss Statement, Balance Sheet, and Cash Flow Statement actually tell a story — what’s working, where margins are slipping, and how your restaurant can grow sustainably.
If you’re not sure whether your QuickBooks setup aligns with your restaurant’s structure, Mesa CPA can help. We specialize in helping restaurant owners simplify their financial reports, from POS integration to payroll setup, so your books always stay as clean as your kitchen.