Restaurant P&L Template
This free restaurant P&L template lays out a profit and loss statement the standard way: sales, cost of goods sold, labor, prime cost, operating expenses, occupancy and net income. Type your figures and it totals each section and shows every line as a percent of sales. Download a CSV, copy it into a spreadsheet, or print it.
| Line | Amount ($) | % of sales |
|---|---|---|
| Sales | ||
| Food sales | ||
| Non-alcoholic beverage sales | ||
| Alcohol sales | ||
| Catering and other sales | ||
| Total sales | $0.00 | |
| Cost of goods sold | ||
| Food cost | ||
| Non-alcoholic beverage cost | ||
| Alcohol cost | ||
| Paper and packaging | ||
| Total cost of goods sold | $0.00 | |
| Gross profit | $0.00 | |
| Labor | ||
| Management salaries | ||
| Hourly wages | ||
| Payroll taxes and benefits | ||
| Total labor | $0.00 | |
| Prime cost (cost of goods sold + labor) | $0.00 | |
| Operating expenses | ||
| Supplies and smallwares | ||
| Marketing | ||
| Card processing fees | ||
| Delivery app commissions and fees | ||
| Software and technology | ||
| Utilities | ||
| Repairs and maintenance | ||
| General and administrative | ||
| Total operating expenses | $0.00 | |
| Occupancy | ||
| Rent | ||
| Property taxes and common area charges | ||
| Property and liability insurance | ||
| Total occupancy | $0.00 | |
| Operating income (before depreciation and interest) | $0.00 | |
| Other expenses | ||
| Depreciation and amortization | ||
| Interest | ||
| Total other expenses | $0.00 | |
| Net income before income taxes | $0.00 | |
Save your P&L
No signup. The figures stay in this browser tab and are not sent to RestauNax, so download or copy them before you close the page. Percent of sales is each line divided by total sales.
General information for management reporting, not accounting or tax advice. Ask your accountant how to classify items for your books.
How to use the restaurant P&L template
- Enter the period the statement covers: a month, a four-week period or a week.
- Type sales first, then each cost for the same period. Totals, gross profit, prime cost and net income update as you type.
- Download the CSV, copy the table into Excel or Google Sheets, or print it. Repeat for the next period and compare.
Use figures for one period only, and use the same period for every line. Sales come from your point of sale reports, net of discounts, comps and refunds, and without sales tax or tips, which are not your revenue. Cost of goods sold is what you used, not what you bought: opening inventory plus purchases minus closing inventory. Labor includes wages, salaries, payroll taxes and benefits.
The method is simple arithmetic. Gross profit is total sales minus cost of goods sold. Prime cost is cost of goods sold plus labor, the two costs a manager controls from week to week. Operating income is gross profit minus labor, operating expenses and occupancy. Net income before income taxes subtracts depreciation and interest. Percent of sales is each line divided by total sales.
The template shows no target percentages. Healthy numbers depend on your concept, service style and rent, so the useful comparison is your own restaurant against its last period and against your budget. To work on a single line, use the prime cost calculator, the food cost calculator or the labor cost calculator, and read restaurant profit margins for how the lines fit together.
What is a restaurant P&L?
A restaurant P&L, or profit and loss statement, is a report that subtracts a period's costs from its sales to show whether the restaurant made or lost money. It is also called an income statement. It groups costs so you can see where the money went: ingredients, staff, running expenses and the building.
Restaurants put cost of goods sold and labor near the top because they are the largest costs and the ones that change with each shift. Rent and insurance sit lower, in occupancy, because they do not change with sales.
What is prime cost on a restaurant P&L?
Prime cost is cost of goods sold plus total labor. On this template it appears as its own highlighted row under the labor section, in dollars and as a percent of sales. Owners watch it closely because food and labor can be adjusted within days through portioning, purchasing, scheduling and menu prices.
To track it weekly without filling in the whole statement, use the prime cost calculator.
How do you read a restaurant P&L?
Read a restaurant P&L from the top down, and read the percent column before the dollar column. Start with total sales against the last period. Then check cost of goods sold and labor as percentages of sales: if sales rose and those percentages rose too, the extra sales cost more to produce than they should.
Next look for any operating expense that moved sharply, such as repairs or delivery app commissions. Finish at operating income, which shows what the restaurant itself earned before financing and depreciation.
How often should a restaurant prepare a P&L?
Prepare a full P&L for every accounting period, usually a month or a four-week period, and review prime cost weekly in between. A monthly statement that arrives weeks later is too late to fix a food cost problem, so it helps to count inventory weekly and check sales, cost of goods and labor on that rhythm.
Frequently asked questions
Is the restaurant P&L template free?
Yes. It is free to fill in, download as a CSV, copy into a spreadsheet and print. There is no signup, and your figures are not sent to RestauNax.
Can I open the P&L template in Excel or Google Sheets?
Yes. Download the CSV and open it in Excel or Google Sheets, or use the copy button and paste: the table pastes as columns.
Should sales tax and tips be included in sales?
No. Sales tax is collected for the government and tips belong to staff, so neither is restaurant revenue. Enter sales net of discounts, comps and refunds.
Why does the template not show target percentages?
Targets differ by concept, service style and location, and we do not publish benchmark figures we cannot source. Compare each period with your own previous period and your budget.
Is this accounting or tax advice?
No. It is a general template for management reporting. Your accountant decides how items are classified for your books and tax return.