Free template
Restaurant P&L template. Every total fills in by itself.
Twelve months on one sheet, with the lines Mise uses. Type your sales and your costs. The totals, the result and the margin fill in by themselves.
- Excel file, 14 KB
- No sign up
- Any currency
Last updated .
Line by line
The P&L, read from the top.
What you sold, minus what it cost, is what you made. Each line, in plain words.
Sales
Everything the restaurant sold in the month, before tax. In Mise, the service charge stays in sales.
Food and drink costs
What you bought to cook and to pour. Packaging goes with the running costs.
- Food
- Drinks
Gross profit
Sales minus food and drink costs.
What is left after food and drink costs, to pay the team, the building and the rest.
Wages
Every cost of the team in the month. In Mise, the service charge paid to the team is here.
- Salaries
- Service charge to staff
- Tips to staff
- Social security
- Allowances
- Visas and work permits
- Other staff costs
Prime cost
Food and drink costs plus wages.
The two costs read together, as one figure. The template works it out under the wages.
Building
The cost of the place itself.
- Rent
- Electricity, water and gas
- Repairs
- Insurance
Running costs
Everything else it takes to open each night.
- Bank and card fees
- Marketing
- Accounting and advice
- Laundry
- Supplies
- Packaging
- Software
- Equipment rental
- Transport
- Licences and tax
- Cleaning
- Delivery app fees
- Staff meals
- Other
Operating result
Sales minus every cost above.
What the restaurant made in the month.
Margin
Operating result divided by sales.
The operating result as a percent of sales. For every 100 in sales, what is left after every cost.
In the file
Ready to fill in.
- 12months side by side, and the year.
- 27lines, the ones Mise uses, in its order.
- 16totals and percents a month, worked out for you.
- 2sheets: the P&L, and how to use it.
How to fill it in
Three steps a month.
Sales, each month.
What the restaurant sold, before tax. In Mise, the service charge stays in sales.
Each invoice on its line.
Food on Food, rent on Rent. In the month it belongs to.
The wages, once a month.
Salaries, the service charge paid to the team, social security. Then read the result and the margin.
Questions
About the template.
What is a restaurant P&L?
A page that shows, month by month, what the restaurant sold, what it cost, and what was left. P&L means profit and loss.
Is the template free?
Yes. Download it and it is yours. No sign up and no email address needed.
Which currency does it use?
Yours. Type every amount in your own currency, as a whole amount. Write the currency at the top of the sheet.
Where do the service charge and tax go?
In Mise, sales are counted before tax, with the service charge in. The part of the service charge paid to the team goes in wages. Your accountant knows how the tax of your country reads these lines.
Can I add my own lines?
Yes. Insert a row inside a group, between two of its lines, and the total of the group takes it in.
What is prime cost?
Food and drink costs plus wages, read as one figure. The template works it out under the wages, in money and as a percent of sales.