Financial Statements
Restaurant P&L Template: Excel Layout, Formulas, and Review
Use a restaurant P&L template with sales channels, food and beverage cost, labor, occupancy, operating expenses, margins, controls, and review.
Put the answer to work
Want a clearer, more dependable financial process?
A restaurant P&L template organizes revenue and expenses for a defined period so an owner can see gross profit, operating performance, and net profit or loss. A useful template separates food and beverage sales, direct costs, labor, occupancy, and other operating expenses while preserving a clear link to the accounting records.
The template is a reporting structure, not a substitute for reconciled books. The SEC describes an income statement as a report of revenue and the related costs and expenses over a period. Restaurant management should be able to trace every subtotal to the general ledger, payroll reports, inventory records, point-of-sale data, processor settlements, invoices, and approved adjustments.
Recommended workbook layout
Use one input or import area, one account-mapping table, one monthly P&L, one comparison report, and one control sheet. Keep raw point-of-sale and accounting exports separate from formulas. The final P&L should use mapped totals, not amounts manually typed into summary cells.
| Section | Illustrative lines | Management question |
|---|---|---|
| Revenue | Food, alcoholic beverage, nonalcoholic beverage, catering, delivery | What was sold, through which channel? |
| Cost of sales | Food, beverage, packaging, direct delivery inputs | What attributable product cost was recognized? |
| Labor | Kitchen, service, management, payroll taxes, benefits | What did staffing cost for the period? |
| Occupancy | Rent, common-area charges, utilities, repairs | What did the location cost? |
| Operating expenses | Marketing, software, insurance, professional fees, supplies | What other costs supported operations? |
Build the revenue section
Separate revenue at the level management can reconcile and use. Common categories include dine-in food, bar, takeout, catering, delivery, event, merchandise, and service charges. Distinguish gross sales, discounts, refunds, taxes collected, tips, and processor activity according to the applicable accounting policy.
Do not treat every point-of-sale deposit as revenue. Settlement timing, processor fees, chargebacks, gift-card activity, marketplace commissions, withheld amounts, and transfers can make cash differ from sales. Reconcile transaction reports to processor settlements, bank deposits, and the ledger.
The restaurant profit and loss guide explains how the major lines fit together.
Map food and beverage cost
Cost of sales may include beginning inventory plus purchases and attributable costs less ending inventory, subject to the business’s accounting policy. Separate food, beer, wine, liquor, nonalcoholic beverage, packaging, and other categories when the detail supports purchasing and pricing decisions.
Use consistent inventory count dates, units, locations, and valuation methods. Review waste, spoilage, transfers, complimentary items, employee meals, and unrecorded invoices. A favorable food-cost percentage caused by a missing purchase or late inventory count is not an improvement.
Present labor clearly
Restaurant labor can be shown by kitchen, service, bar, management, catering, or location. Include wages and a consistently defined payroll burden, which may include employer payroll taxes, benefits, workers’ compensation, bonuses, and other documented costs. Reconcile hours and pay to payroll reports and the ledger.
State whether owner compensation, contract labor, recruiting, training, and temporary staff are included in labor or operating expenses. Comparisons are misleading when classification changes between periods. Use the same approved mapping and disclose material reclassifications.
Formula structure
| Subtotal | Illustrative formula | Review |
|---|---|---|
| Net revenue | Recognized sales less returns and discounts | Agree to ledger revenue |
| Gross profit | Net revenue less cost of sales | Review amount and percentage |
| Restaurant operating result | Gross profit less labor, occupancy, and operating expenses | Use a consistently defined subtotal |
| Net profit or loss | Revenue and gains less all included expenses and losses | Agree to formal statement |
Use the complete P&L template Excel guide for workbook design and formula controls. Avoid hard-coded subtotals. Use named tables or controlled ranges, separate input cells from formulas, and make exception checks visible.
Compare dollars, percentages, and operational drivers
For each month, show current actual, prior period, budget, and variance where useful. Percentage-of-sales views can help compare food cost, beverage cost, labor, and occupancy, but a percentage can improve while profit dollars fall. Review dollars, percentages, guest counts, average check, channel mix, hours, and capacity together.
Document the denominator for every percentage. Food cost divided by food revenue answers a different question from total product cost divided by total restaurant revenue. Do not combine categories merely to make a result look favorable.
Account mapping and restaurant-specific exceptions
Create a mapping table with ledger account, location, department, P&L line, cost category, effective date, and reviewer. Prevent duplicate mappings and identify unmapped accounts. Review new accounts every month before closing the report.
Restaurant exceptions may include gift cards, loyalty rewards, service charges, tips, delivery marketplace activity, franchise fees, sales tax, liquor inventory, prepaid events, deposits, catering contracts, and shared commissary costs. Their accounting and legal treatment depends on facts and jurisdiction. The template should expose these items for review, not assume one treatment.
Monthly preparation process
- Close the point-of-sale day and reconcile sales, taxes, tips, discounts, and cash activity.
- Reconcile processor settlements and deposits, including fees, holds, and chargebacks.
- Record bills, inventory, payroll, accruals, prepaid items, and approved adjustments.
- Complete bank, card, receivable, payable, payroll, and inventory reconciliations.
- Refresh the mapped P&L and resolve unmapped accounts or formula exceptions.
- Compare actual results with budget and prior periods using operational evidence.
- Record reviewer approval, open items, and the final reporting version.
Controls for an editable Excel template
Keep the chart-of-accounts mapping and formulas company controlled. Restrict editing, protect formula cells, retain version history, and store backups. Use a review check that total mapped activity equals the source-ledger total. Confirm every period column uses the same start and end dates.
Spreadsheet protection reduces accidental edits but is not a complete security system. Protect payroll, employee, customer, payment, and vendor information with appropriate access and secure storage. Do not share an editable workbook broadly simply because the summary report appears harmless.
How to interpret the result
A P&L should support questions, not produce an automatic diagnosis. A margin decline may result from price, menu mix, purchasing, yield, waste, labor scheduling, channel commissions, occupancy, seasonality, or missing entries. Investigate the source records before choosing an action.
Profit is also not cash. Inventory purchases, debt principal, equipment, tax payments, customer deposits, gift-card timing, and working capital can affect cash differently. Review the balance sheet and cash flow with the profit and loss statement.
Template completion checklist
Before relying on the report, confirm that the entity, location population, accounting basis, period, currency, and mapping version are stated. Ensure the income statement agrees to the ledger, retained source data is complete, formulas have no errors, manual adjustments are approved, and unusual balances are explained. Preserve the report issued to management rather than overwriting it with later data.
Frequently asked questions
What should a restaurant P&L template include?
Include revenue by useful channel, food and beverage cost, labor, occupancy, operating expenses, defined profit subtotals, comparisons, and reconciliation controls.
How is restaurant food cost calculated?
A common structure uses beginning inventory plus purchases and attributable costs less ending inventory, applied consistently under the business's accounting policy.
Should labor include payroll taxes and benefits?
Include a consistently defined payroll burden when useful, and disclose which wages, taxes, benefits, contractors, and owner amounts are included.
Are tips and sales tax restaurant revenue?
The treatment depends on facts and applicable requirements. Track them separately and have a qualified professional confirm the accounting and legal treatment.
Why does P&L profit differ from bank cash?
Revenue, expenses, deposits, payments, inventory, equipment, debt, taxes, gift cards, and working-capital changes can occur in different periods.
Can one restaurant template be used for multiple locations?
Yes if each location uses consistent mappings and controls, interlocation activity is handled correctly, and consolidated totals reconcile to the ledger.
Turn this guide into action