Toast to QuickBooks Online Mapping: The Complete Fix-It Guide for Restaurant Operators
When Toast and QuickBooks Online (QBO) are mapped correctly, your restaurant gains clean financials, accurate daily sales summaries, and rock-solid reporting.
When they’re mapped incorrectly, everything breaks:
Food cost looks wrong
Discount lines inflate COGS
Tips don’t reconcile
Deposits don’t match bank activity
Third-party delivery fees land in random accounts
Owner dashboards become meaningless
Prime cost becomes fiction
Most restaurants are operating with messy, fragmented, or outdated Toast to QBO mapping - and they don’t even know it.
This post breaks down exactly how to fix it, prevent it from breaking again, and create an automated, audit-proof sales workflow.
Why Toast → QBO Mapping Breaks So Easily
Toast pushes dozens of data points daily into QBO. If even one category is mapped incorrectly, your P&L and COGS metrics get thrown off.
Mapping breaks because:
Menus change
Discounts change
New payment types get added
Delivery platforms update fee structures
Managers create new service charges
Tip handling changes
Cash handling policies evolve
Toast roles permissions allow accidental edits
Restaurants evolve quickly - but their mapping doesn’t.
1. Understand What Toast Sends to QuickBooks
Toast sends a daily journal entry containing:
Revenue
Food, Beverage, and Alcohol sales
Catering sales
Delivery sales
Service charges
Discounts
Payments
Credit card payments
Cash payments
Gift card redemptions
House accounts
Online ordering payments
3rd-party delivery remittances
Liabilities
Tips payable
Gift card liability
Sales tax payable
Service charge liability
If you don’t map these correctly, your financial statements are unreliable.
Resource:
Toast Support — Accounting Exports
2. Set Up a Standard Restaurant Chart of Accounts
Before fixing mapping, your chart of accounts must be structured for restaurant operations.
A strong restaurant COA includes:
Revenue
Food Sales
Beverage Sales
Alcohol Sales
Catering
Delivery/Online Sales
Cost of Goods Sold
COGS — Food
COGS — Beverage
COGS — Alcohol
COGS — Packaging/Supplies
Labor
FOH Labor
BOH Labor
Management Salaries
Payroll Taxes
Employee Benefits
Liabilities
Tips Payable
Gift Cards Outstanding
Sales Tax Payable
Service Charges Payable
Operating Expenses
Standardized by category (utilities, repairs, marketing, etc.)
A clean COA prevents Toast entries from scattering across the P&L.
Resource:
3. Map Toast Sales Categories to QBO Correctly
Every Toast sales category must point to the correct revenue or liability account.
Example Mapping
Toast Category -> Proper QBO Mapping
Food Sales -> Food Revenue
Alcohol Sales -> Alcohol Revenue
Catering -> Catering Revenue
Delivery -> Delivery Revenue
Sales Discounts/Promos -> Discounts Given (contra-revenue)
Sales Tax -> Sales Tax Payable
Tips -> Tips Payable
Service Charges -> Service Charge Liability
Critical Rule:
Discounts ALWAYS map to a contra-revenue account, NEVER to COGS. This is the #1 mistake restaurants make.
4. Fix Tips, Service Charges, and Payable Liabilities
This is the most confusing part for restaurants.
Tips
Tips are NOT revenue.
Tips are a pass-through liability.
They must be paid out to employees.
Correct mapping:
Toast → Tips Payable → Payroll System
Service Charges
Service charges ARE revenue
But they create a liability until paid out
They must map to “Service Charge Liability”
If you map service charges as tips, your payroll becomes a compliance risk.
Gift Cards
Gift card purchases are NOT revenue - They are liabilities until redeemed.
5. Clean Up Payment Type Mapping
Improper payment mapping creates bank reconciliation nightmares.
Correct Structure
Toast Payment Type QBO Account
Credit Cards - Undeposited Funds (or Toast Depository)
Cash - Cash on Hand
3rd-Party Delivery Payments - Delivery Clearing Account
Gift Card Redemption - Gift Card Liability
House Accounts - AR — House Accounts
If your deposits don’t match your bank, the payment mapping is wrong.
6. Match Toast Deposits to the Bank Correctly
Toast batches credit card deposits into your bank account.
You must match:
Toast daily sales → Toast daily deposit → Bank feed
If you’re seeing:
Duplicate deposits
Missing deposits
Overstated revenue
Negative clearing accounts
…your mapping is incorrect.
7. Automate the Entire Workflow (Best Practice)
The best restaurants eliminate manual entry entirely.
Automation Tools:
xtraCHEF by Toast (invoice automation + recipe costing)
MarginEdge (imports Toast + vendor invoices into QBO)
Shogo (3rd-party POS-to-QBO automation tool)
Automation ensures:
No manual errors
Faster closes
Audit-ready books
Accurate COGS
Accurate revenue by channel
Resource:
Toast + QuickBooks Sync Overview
8. Weekly Toast to QBO Reconciliation Checklist
A tight checklist keeps everything clean and consistent.
WEEKLY CHECKLIST
Revenue Accuracy
Confirm daily sales entries posted
Review revenue by category (food, bev, alcohol)
Verify discounts map to contra-revenue
Liabilities
Tips payable matches payroll tip payouts
Service charge liability reconciles
Gift card liability increases/decreases correctly
Payments & Deposits
Match Toast deposits to bank feed
Reconcile 3rd-party delivery deposits
Clear out old unmatched deposits
Troubleshooting
Review negative clearing accounts
Check for duplicate sales entries
Review mismatched dates (common with late-night businesses)
This 10-minute weekly routine prevents 10 months of headaches.
Final Thoughts
Clean Toast to QBO mapping is one of the highest ROI improvements a restaurant can make. It:
Fixes inaccurate food cost
Eliminates messy financials
Improves weekly reporting
Speeds up month-end close
Supports multi-unit scaling
Reduces audit and lender risk
Helps owners see real prime cost
If your Toast mapping is off even slightly, Lumiere can rebuild it cleanly — and automate everything from daily sales to invoice processing and COGS tracking.
Running a restaurant is hard enough — your financials shouldn’t be. Lumiere builds clarity, control, and calm into every shift.