Categories

Latest Posts

Restaurant Chart of Accounts in QuickBooks: The Setup That Actually Works

Your Chart of Accounts is the skeleton of your QuickBooks. If it’s built wrong, every report you pull—P&L, balance sheet, cash flow—will give you information that looks right but means nothing.

Most restaurant owners inherit their Chart of Accounts from their bookkeeper, their accountant, or QuickBooks’ default template. Almost none of these are built for how restaurants actually operate. Here’s what needs to change.

Why the Default QuickBooks Chart of Accounts Fails Restaurants

QuickBooks ships with a generic chart of accounts designed for small businesses. It has categories like “Cost of Goods Sold,” “Payroll Expenses,” and “Rent.” For a service business or retail store, that might be enough.

For a restaurant, it’s not even close. Here’s why:

You have multiple revenue streams — dine-in, takeout, delivery, catering, bar sales, gift cards. Each has different margins. Lumping them into “Sales” hides whether your delivery channel is actually profitable or quietly losing money after platform commissions.

You have multiple cost categories that behave differently — food, liquor, beer, wine, paper goods. Each has its own benchmark percentage. A 2% increase in liquor cost requires a completely different response than a 2% increase in food cost.

You have labor that splits across functions — FOH hourly, BOH hourly, management salaries, overtime, payroll taxes. A well-structured restaurant P&L shows these separately because the levers you pull for each are different.

The Restaurant Chart of Accounts That Actually Works

Below is the account structure we set up in QuickBooks for every restaurant client. It’s organized by the way restaurant operators actually think about their business.

Revenue Accounts (4000 series)

4100 – Food Sales
4110 – Dine-In Food Revenue
4120 – Takeout Food Revenue
4200 – Beverage Sales
4210 – Bar / Liquor Revenue
4220 – Beer Revenue
4230 – Wine Revenue
4240 – Non-Alcoholic Beverage Revenue
4300 – Catering Revenue
4400 – Delivery Revenue
4410 – DoorDash / UberEats / Grubhub Revenue
4420 – Direct Delivery Revenue
4500 – Gift Card Sales
4600 – Merchandise Revenue
4900 – Other Revenue

Why this level of detail matters: if your overall revenue is growing 8% but your dine-in is flat and delivery is up 30%, you need to know that—because delivery comes with 15-30% commission costs that dine-in doesn’t. Growth that looks healthy on a single “Sales” line might actually be margin-negative.

Cost of Goods Sold (5000 series)

5100 – Food Cost
5110 – Protein / Meat
5120 – Produce
5130 – Dairy
5140 – Dry Goods & Grains
5150 – Oils, Spices & Condiments
5200 – Liquor Cost
5300 – Beer Cost
5400 – Wine Cost
5500 – Non-Alcoholic Beverage Cost
5600 – Paper Goods & Disposables
5700 – Delivery Platform Commissions
5800 – Smallwares & Kitchen Supplies

Benchmark ranges: food cost 28-35% of food revenue, liquor 18-22%, beer 24-28%, wine 30-35%. If you’re tracking all of these under one “COGS” line, you can’t tell which category is out of line when your overall number drifts.

Labor Costs (6000 series)

6100 – Management Salaries
6200 – FOH Hourly Wages
6210 – Servers
6220 – Hosts / Hostesses
6230 – Bartenders
6300 – BOH Hourly Wages
6310 – Line Cooks
6320 – Prep Cooks
6330 – Dishwashers
6400 – Overtime
6500 – Payroll Taxes
6510 – Health Insurance & Benefits
6520 – Workers Compensation
6600 – Contract / Temp Labor

Total labor should run 25-35% of revenue depending on your concept. But the actionable insight is in the split. If BOH is at 19% and climbing, you’re either overstaffed on prep or your cooks are hitting overtime. You can’t see that from one “Payroll” line.

Operating Expenses (7000 series)

7100 – Rent / Lease
7110 – CAM Charges
7200 – Utilities
7210 – Gas
7220 – Electric
7230 – Water / Sewer
7240 – Trash / Recycling
7300 – Insurance
7310 – General Liability
7320 – Property Insurance
7330 – Liquor Liability
7400 – Marketing & Advertising
7500 – Repairs & Maintenance
7510 – Equipment Repair
7520 – Building Maintenance
7600 – Technology
7610 – POS System Fees
7620 – Online Ordering Platform
7630 – Reservation System
7640 – Accounting Software
7700 – Professional Services
7710 – Accounting & Bookkeeping
7720 – Legal
7800 – Licenses & Permits
7810 – Liquor License
7820 – Health Permits
7900 – Linen & Laundry
7950 – Music & Entertainment

How to Restructure Without Starting Over

You don’t need to nuke your existing QuickBooks and start from scratch. Here’s the practical approach:

Step 1: Map your current accounts. Export your current Chart of Accounts from QuickBooks (Reports → Account List). Identify which accounts map to the structure above and which ones are missing or too broad.

Step 2: Add missing sub-accounts. In QuickBooks, you can add sub-accounts under existing parent accounts without losing any historical data. If you currently have “Cost of Goods Sold” as one account, create sub-accounts for Food Cost, Liquor Cost, Beer Cost, etc. under it.

Step 3: Reclassify historical transactions. For the current period, go back and reclassify transactions into the new sub-accounts. This gives you a clean baseline to compare against going forward. For prior periods, leave them as-is—comparing new structure against old structure month-over-month would be misleading anyway.

Step 4: Update your POS mapping. If your POS (Toast, Square, Clover, Revel) syncs with QuickBooks, update the category mappings so new sales and cost data flows into the correct sub-accounts automatically.

This is exactly the kind of restructuring that FinAcct360 handles in the first week of every restaurant engagement. We rebuild your Chart of Accounts to match how restaurants actually operate, remap your POS integration, and reclassify the current period so your very first weekly P&L is structured and actionable.

The Three Mistakes That Wreck Restaurant Reporting

Mistake 1: Too few accounts. “COGS” as one line item means you can’t diagnose which cost category is drifting. The fix takes 30 minutes—add sub-accounts for food, liquor, beer, wine, and paper goods.

Mistake 2: Too many accounts. Some accountants create 200+ accounts “for detail.” The result is a P&L that’s 8 pages long and impossible to read. Keep it to the level of detail that drives a decision. You need to separate food cost from liquor cost. You probably don’t need a separate account for each spice vendor.

Mistake 3: Accounts that don’t match your POS categories. If your POS tracks “Food,” “Beer,” “Wine,” and “Liquor” but your QuickBooks only has “Sales,” you’re manually reconciling every week or losing data. Align the two systems.

The Bottom Line

Your Chart of Accounts isn’t an accounting formality. It’s the structure that determines whether your QuickBooks reports tell you something useful or just confirm that you spent money. Build it for how restaurants work—revenue by source, COGS by category, labor by function, expenses by type—and every report you pull going forward actually means something.

If your current Chart of Accounts has fewer than 30 accounts, it’s almost certainly too generic to tell you what’s driving your margins. If it has more than 100, it’s probably cluttered with legacy accounts nobody uses. The sweet spot for most single-location restaurants is 50-70 accounts, structured the way we’ve outlined above.

FinAcct360 builds this structure from day one for every restaurant client—Chart of Accounts, POS mapping, and weekly P&L reviews that catch drift before it compounds.

Want your QuickBooks Chart of Accounts rebuilt for restaurant operations? Book a discovery call and we’ll map your current setup against the structure that actually works.

    Leave a Reply

    Your email address will not be published. Required fields are marked*