Restaurant P&L Template

Download the .xlsx file and open it in Excel or Google Sheets — no macros, no plugins, no setup beyond entering your numbers. Start with the Monthly P&L sheet. Review the pre-loaded revenue and expense categories: most restaurants can go live with 80–90% of them unchanged. Rename any categories that don't match your setup (for example, if you don't serve alcohol, remove that revenue line and replace it with something relevant). The whole first-time setup typically takes 15–20 minutes.

Once the structure is set, enter your monthly revenue and expense figures. Pull numbers from your POS system's monthly sales report and your accounting software or bank statements for expenses. The food cost analysis sheet is worth filling out separately: enter your purchases by category each month and it will calculate your food cost percentage automatically, broken down by protein, produce, dairy, dry goods, and beverage. This is where most operators find the most actionable insight in the first few months.

Come back to the template at the close of each month — it usually takes 20–30 minutes once you're in the habit. Over time, the Annual P&L sheet becomes your most useful view: you can scan 12 months of cost percentages in a single glance and spot the months where food costs or labor drifted above target. Restaurant operators who review their P&L monthly tend to catch margin problems weeks earlier than those who only look at numbers when something feels wrong.

Restaurants operate on some of the thinnest margins in any industry — typically 3–9% net profit on every dollar of revenue. At those margins, a 2-point rise in food cost percentage or an unbudgeted repair bill can turn a profitable month into a loss. Most restaurant owners know this intellectually, but without a structured P&L to review each month, the numbers stay abstract until it's too late to do anything about them. A P&L template turns financial data from a quarterly surprise into a monthly management tool.

A restaurant P&L has a specific structure that generic templates don't reflect. Revenue needs to be broken out by channel — dine-in, takeout, delivery, catering, and alcohol behave differently and have different margin profiles. COGS should separate food from beverage, not lump them together as 'cost of goods.' Labor needs to distinguish front-of-house from back-of-house because they scale differently: FOH labor rises and falls with covers, while BOH labor is relatively fixed. When these categories are set up correctly, the P&L shows you not just whether the restaurant is profitable, but which parts of the business are pulling their weight.

The real operational value of a P&L comes from comparing it month over month and against targets. Food cost percentage should typically sit between 28–35%; labor between 25–35%. When either number starts creeping, the P&L shows you exactly where — whether it's protein costs rising, delivery channel commissions eating into margin, or a staffing model that doesn't scale down during slow periods. This template is structured to surface those patterns quickly, so you're making adjustments in real time rather than reconciling surprises at year-end.