Multi-Location Restaurant P&L Template

A consolidated restaurant P&L answers whether the group made money. It may not answer which locations produced that result, why one store missed plan, or whether shared overhead is obscuring store operations. A multi-location reporting package needs both views: consistent individual location P&Ls and a consolidated company report.

Accounting Forward is a CPA-led accounting and fractional CFO firm working exclusively with restaurants. We provide restaurant bookkeeping, financial reporting, cash-flow forecasting, and CFO advisory to single-location and multi-location restaurant operators nationwide.

What the template shows

The workbook contains three illustrative location input tabs, a formula-driven consolidated tab, and instructions. Each location accepts actual, budget, and prior-period amounts. The consolidated view reports sales by location, COGS, fully burdened labor, prime cost, controllable operating expenses, occupancy, store-level operating profit, shared or corporate overhead, and profit after allocations. Dollar and percentage variances show how actual results differ from budget and prior period.

Expense variances require context. A positive dollar variance calculated as actual minus budget means higher expense, which is unfavorable unless the additional cost supported a larger profitable sales increase. For revenue and profit, a positive variance is generally favorable. The workbook presents the arithmetic; management must interpret the operating cause.

Why every location needs a consistent chart of accounts

Location comparison fails when one restaurant records linen under supplies, another under occupancy, and a third under miscellaneous expense. The account numbers do not have to be identical across separate systems, but each location must map into the same reporting categories with the same definitions.

Create a group chart of accounts and a short mapping guide. Define food sales, beverage sales, discounts, delivery commissions, food cost, beverage cost, restaurant management labor, payroll burden, controllable costs, occupancy, and corporate overhead. Lock the definitions before building scorecards. When a new account is added, decide its group mapping once rather than letting each bookkeeper improvise.

Which expenses should remain at the location level

Keep revenue and costs that arise directly from operating a restaurant at that restaurant. These normally include food and beverage sales, COGS, hourly labor, restaurant management salaries, employer payroll taxes and benefits, supplies, repairs, local marketing, utilities, rent, occupancy costs, and other expenses a location manager influences or that are required to operate the store.

Direct identification is better than allocation. If one invoice clearly belongs to Location 2, record it there. Avoid sending direct costs to a corporate bucket simply because the invoice was paid centrally. Otherwise store-level margin looks artificially strong and corporate overhead looks too high.

How to handle shared corporate expenses

Shared accounting, executive, software, insurance, recruiting, and administrative costs may benefit the group rather than one restaurant. Show them in a distinct corporate column or below store-level operating profit. That preserves a clean view of restaurant economics before overhead.

If management needs location profit after allocations, select a rational allocation method and document it. Revenue may be suitable for some shared costs; headcount, invoice count, square footage, or equal allocation may be better for others. Do not use an allocation merely to force locations toward a preferred result. Review store-level operating profit before allocation and location profit after allocation side by side.

Illustrative three-location example

These sample numbers are illustrative and simplified. Assume a group has $600,000 in consolidated sales and $45,000 of shared overhead.

The group is profitable, but Location 2 contributes only $4,000 before corporate overhead. The consolidated $20,000 result hides the operating gap. A location review can separate volume, COGS, labor, occupancy, and controllable expense variances and give Location 2 an accountable plan. It may also show that Location 3's strong performance is supporting a location whose economics need attention.

How to use the workbook

1. Choose one reporting period. Use the same dates and accounting basis for actual, budget, and prior-period data.
2. Map every location. Enter each restaurant's accounts into the standard lines. Replace all illustrative values.
3. Review completeness. Confirm POS sales, inventory and AP, payroll accruals, card fees, rent, utilities, repairs, and location-specific invoices are posted.
4. Review location economics. Compare actual dollars and percentages with budget and prior period. Investigate meaningful changes in sales, COGS, labor, prime cost, and store-level profit.
5. Review corporate overhead separately. Confirm direct costs are not parked at corporate and that shared costs are complete.
6. Document allocations. If used, apply the same approved method each period.
7. Close the loop. Assign owners and deadlines to operating actions, then review results in the next period.

How restaurant systems may fit

Toast may provide sales, discounts, tenders, labor, and deposit information from restaurant operations. MarginEdge may support invoice capture, food-cost workflows, and integrations. Restaurant365 combines restaurant accounting and operational reporting capabilities. QuickBooks Online may serve as the general ledger, particularly when class, location, entity, and account structures are designed carefully.

The right stack depends on the number of entities and locations, reporting needs, internal team, transaction volume, and existing processes. Data still needs controls: reconcile POS sales to the general ledger, deposits to the bank, AP to vendor statements, payroll to payroll reports, and intercompany activity across entities. Accounting Forward is not presented here as an official partner of these platforms.

Why consolidated results can hide a problem

Aggregation lets favorable and unfavorable performance offset. A high-volume store can conceal another location's weak traffic, overtime, waste, or excessive occupancy. Shared overhead can also make every store appear weak if it is allocated without a clear store-level subtotal. Always review absolute dollars, percentages of sales, budget variance, and prior-period change by location.

Common multi-location reporting mistakes

• Different account definitions, week calendars, or accounting methods across restaurants.
• Recording direct location costs in a corporate entity or miscellaneous account.
• Comparing percentages without considering sales volume, format, menu, or market.
• Allocating corporate overhead before reviewing store-level operating profit.
• Leaving intercompany revenue, expenses, receivables, or payables in consolidated totals.
• Using POS sales without reconciling deposits, discounts, refunds, gift cards, and sales tax.
• Distributing reports without an owner, explanation, or action for material variances.

FAQ

Continue with our guide to location-level restaurant profitability, the weekly prime-cost tracker, or our multi-location restaurant accounting services.

This resource provides general educational information and does not replace accounting, tax, legal, systems, or financial advice based on your restaurant group's individual financial situation.