How to Build a Restaurant P&L That Supports Location-Level Decisions
A useful restaurant P&L needs consistent definitions before it needs more columns. If one location includes manager salaries in labor and another puts them in overhead, their percentages do not mean the same thing.
Start with a common chart of accounts and agree on the reporting basis with your accountant. Then build a view that supports both financial close and operating decisions.
1. Set the reporting basis and map accounts
Ask accounting to approve the period, account mapping and handling of sales tax, service charges, shared costs and inventory adjustments. Preserve a mapping from each source account to one statement line. Use the same categories at every location.
2. Copy this location worksheet
Fill the Actual and Budget columns with positive expense amounts. Enter net sales after its agreed adjustments. Add rows when your approved chart of accounts requires them.
| Row | Statement line | Actual | Budget | Formula or source |
|---|---|---|---|---|
| A | Net sales | Enter amount | Enter amount | Reconciled revenue accounts |
| B | Beginning inventory | Enter amount | Enter amount | Approved opening inventory |
| C | Purchases and net inventory adjustments | Enter amount | Enter amount | Receipts, credits and documented transfers |
| D | Ending inventory | Enter amount | Enter amount | Approved ending inventory |
| E | Cost of goods sold | Calculate | Calculate | B + C − D |
| F | Gross profit | Calculate | Calculate | A − E |
| G | Labor | Enter amount | Enter amount | Agreed wages, taxes and benefits |
| H | Other operating expense, before shared costs | Enter amount | Enter amount | Mapped operating accounts |
| I | Shared-cost allocation | Enter amount | Enter amount | Documented allocation schedule |
| J | Depreciation/amortization | Enter amount | Enter amount | Accounting schedule |
| K | Operating income | Calculate | Calculate | F − G − H − I − J |
| L | Interest and other net nonoperating expense | Enter amount | Enter amount | Accounting records; show material items separately |
| M | Income tax expense | Enter amount | Enter amount | Accounting provision |
| N | Net income | Calculate | Calculate | K − L − M |
For each line, add Actual % = Actual / actual net sales × 100, Budget % = Budget / budget net sales × 100, and Dollar variance = Actual − Budget. A positive expense variance means more expense, while a positive income variance means more income. Mark percentages unavailable when the sales denominator is zero. Inventory-based COGS follows the underlying calculation explained in IRS Publication 334; confirm applicable accounting treatment with your accountant.
Use the labor cost calculator to check a location’s labor-to-sales ratio with your own target; do not treat the target gap as realized savings.
3. Allocate and consolidate without double-counting
Hypothetical monthly example: Location A has $100,000 net sales and $20,000 operating income before shared overhead; Location B has $150,000 and $30,000. Assume a documented sales-based allocation of $10,000 central overhead, with all other accounting items already included in these operating subtotals.
| Location | Sales share | Allocated overhead | Operating income after allocation |
|---|---|---|---|
| A | $100,000 / $250,000 = 40% | $4,000 | $16,000 |
| B | $150,000 / $250,000 = 60% | $6,000 | $24,000 |
| Group | 100% | $10,000 | $40,000 |
The group result is $20,000 + $30,000 − $10,000 = $40,000. Do not deduct central overhead again after adding the allocated location results. Sales-based allocation is only this example's assumption; use the basis accounting approves and eliminate applicable intercompany entries.
4. Tie the worksheet to the ledger
Check that location totals plus unallocated central entries and consolidation adjustments equal the group ledger. Retain the reconciliation difference and owner until it is explained. A spreadsheet that balances internally can still omit an account or location.
For the separate POS-to-bank evidence trail, see restaurant cash reconciliation. A deposit timing difference should not be inserted as a new P&L expense.
5. Keep supporting detail out of the wrong place
Voids, comps, overtime and delivery commissions deserve visibility. That does not always mean adding each as another expense line. If an adjustment is already reflected in net sales, deducting it again misstates the result. Use a supporting schedule that ties back to the ledger.
For each important variance, link the source records and note whether the explanation is confirmed or still open.
6. Reconcile the flash to the closed statement
A weekly flash can help managers act sooner. Label estimated inventory use, payroll accruals and missing invoices. Include the last refreshed time and locations with incomplete data. Reconcile the flash to the closed monthly statement rather than silently overwriting it.
The management question is simple: what changed, what evidence explains it, and who follows up? A fast report with hidden gaps cannot answer that reliably.
A hypothetical flash shows $12,000 operating income. At close, a previously missing $1,200 utility invoice reduces it, while a $500 overestimated payroll accrual is reversed: $12,000 − $1,200 + $500 = $11,300. Retain both versions and those explanations. Neither adjustment alone proves an operating change.
Put the findings to work
Use consistent location statements to establish which controls deserve attention first. Marty is a managed profit-control layer using Find → Assign → Follow up → Verify. Its paid Cash Recovery Plan establishes the baseline; optional Managed Profit Control monitors agreed controls, alerts managers, follows up, escalates missed actions and verifies results.