Restaurant Profit & Loss Template

A profit and loss (P&L) statementalso called an income statementshows whether a restaurant is making money or losing it over a specific period. While many restaurant owners use accounting software, a simple, wellstructured template can give quick insights, help control costs, and support strategic decisions.

Why Every Restaurant Needs a P&L Template

• Track performance: Compare actual results with budgets or previous months.
• Identify problem areas: Spot high food cost percentages, labor overruns, or waste.
• Make informed decisions: Know where to cut expenses, raise prices, or invest in new equipment.
• Communicate with stakeholders: Investors, lenders and partners expect clear financial reporting.

Key Sections of the Template

How to Build the Template in Excel or Google Sheets

1. Set up a time column. Most restaurants use monthly periods; create columns for each month of the fiscal year and a YTD column.
2. Create a Revenue block. List every sales channel, then use =SUM() to total them.
3. Add the COGS section. Include a line for Opening Inventory, Purchases, and Closing Inventory. Use the formula shown above.
4. Calculate Gross Profit. Simple subtraction formula; format the cell with bold text or a different colour for easy reference.
5. Enter Operating Expenses. Break them into meaningful categories (Labor, Rent, Utilities, Marketing, etc.). Keep a running total.
6. Derive Operating Income. Link it directly to Gross Profit and total expenses.
7. Include Other Income/Expense. Add rows for interest expense, tax, or any extraordinary items.
8. Result: Net Profit. This cell should be the final figure; you can also calculate profit margin: =Net Profit / Revenue.
9. Chart the trends. Insert line or bar charts for Revenue, Gross Profit, and Net Profit to visualize performance over time.

Sample Layout (Simplified)

Interpreting the Results

Once the numbers are in, focus on three core ratios:

• Gross Profit Margin: Gross Profit Revenue. A healthy restaurant typically targets 6070% for foodcentric concepts and 7080% for fastcasual or beverageheavy venues.
• Labor Cost Percentage: Labor Expenses Revenue. Keep this under 3035%; higher percentages usually erode profitability.
• Net Profit Margin: Net Profit Revenue. Aim for 510% overall, though highvolume quickservice models can achieve 1215%.

Tips for Maintaining Accuracy

1. Update the template weekly, not just monthend. Small variances compound.
2. Reconcile inventory counts with purchases every two weeks to prevent phantom costs.
3. Separate cash sales from card sales; reconcile against POS reports.
4. Enter labor hours daily; use scheduling software data to avoid manual errors.
5. Review the P&L with key staff (chef, manager) to gain insight into operational drivers.

Download a ReadyMade Template

For convenience, a preformatted Excel workbook can be downloaded here. The file contains:

• Colorcoded sections for quick visual reference.
• Builtin charts that autoupdate as you enter data.
• Conditional formatting warnings when labor or COGS exceed target thresholds.
• Separate tabs for monthly, quarterly, and yearly views.

Common Mistakes to Avoid

• Mixing personal expenses with business costs. Keep a strict boundaryuse separate credit cards.
• Ignoring small waste. Even a 1% shrinkage on $200,000 food cost equals $2,000 lost.
• Failing to account for seasonal variations. Adjust budgets for holidays, tourism peaks, and offseason lulls.
• Not tracking delivery platform fees. Thirdparty apps can eat 1530% of sales; record them under Other Expense.

Next Steps for Restaurant Owners

1. Implement the template. Populate it with historical data for the first three months, then compare against future periods.

2. Set realistic targets. Use industry benchmarks as a starting point, then adjust to your concepts unique cost structure.

3. Review monthly. Hold a brief meeting with your management team to discuss variances and corrective actions.

4. Iterate. As you gather more data, refine categories, add new revenue streams (e.g., loyalty programs), and update assumptions.

With a disciplined approach to profit and loss tracking, youll gain the clarity needed to keep your restaurant profitable, sustainable, and ready for growth.