Skip to content

Restaurant Profit and Loss Template: Five Totals

A free restaurant profit and loss template: sales, cost of goods, labor, operating costs and what's left, each as a share of sales, with a worked month.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

A restaurant's profit and loss statement is a month in five totals. Sales, split into food and drink. Cost of goods sold: the food and drink you used. Labor: wages and what goes with them. Operating expenses: rent, utilities, fees and the rest. And what's left. Two subtotals on the way down are worth as much as the bottom line. Gross profit is sales less cost of goods. Prime cost is cost of goods plus labor, the two costs a manager controls week to week. Every line is also shown as a share of sales, because that's what makes one month comparable with another. In the made-up month below, sales are $82,000, cost of goods 30%, labor 33%, operating expenses 29%, and $6,560 is left: 8%. Below are the lines, how to get each number, how to read it, and a template that does the percentages.

The short version

  • Five totals: sales, cost of goods, labor, operating, what's left.
  • Every line as a share of sales.
  • Cost of goods is what you used: opening stock + purchases − closing stock.
  • Prime cost (cost of goods + labor) is the number to watch.
  • Compare with last month and the same month last year, not with an industry average.
  • TaroStack gives the stock figures the cost of goods line needs. More below.

A month

Line Amount Share of sales
Food sales $61,500 75.0%
Drink sales $20,500 25.0%
Sales $82,000 100%
Food cost $19,680 24.0%
Drink cost $4,920 6.0%
Cost of goods sold $24,600 30.0%
Gross profit $57,400 70.0%
Kitchen wages $12,300 15.0%
Front of house wages $9,840 12.0%
Payroll taxes and benefits $4,920 6.0%
Labor $27,060 33.0%
Prime cost $51,660 63.0%
Rent, utilities, fees, repairs, supplies, marketing, insurance, other $23,780 29.0%
Left, before the owner's pay and tax $6,560 8.0%

The template has the operating expenses on nine lines of their own.

Where each number comes from

Sales come from the point of sale's monthly report, before sales tax and before tips. Tax and tips pass through you; they aren't income. Split food from drink, because they have different costs.

Cost of goods sold is the line most restaurants get wrong, by typing in what they bought.

Food
Stock at the start of the month $7,900
Purchases in the month $20,180
Stock at the end of the month −$8,400
Food used $19,680

Purchases were $20,180, and $500 of that is still on the shelf, so the month's food cost is $19,680. Without a count at each month end, a big delivery on the 30th makes the month look terrible and the next one look brilliant. How to count is in how to count inventory.

Food cost here is 32% of food sales and drink cost 24% of drink sales. Those two percentages, each against its own sales, say more than the blended 30%.

Labor is gross wages plus the employer's payroll taxes and benefits, for the pay periods in the month. A working owner's own pay is a choice: this example leaves it out and says so on the last line.

Operating expenses come from the bank and card statements: everything that isn't food, drink or wages.

Reading it

Down the percentage column. Dollar figures move with sales. Percentages show whether the restaurant is running the same way. Food cost at 32% of food sales this month and 34% next is a question, whatever the dollars did.

Across to last month. The template has a column for it. A change is a prompt, not a verdict: repairs went from $420 to $1,640 because the walk-in's compressor failed.

Prime cost. At 63%, 37 cents of each dollar is left for rent, everything else and profit. If prime cost creeps to 66%, the 8% at the bottom becomes 5% with nothing else changing. It's the two lines you can do something about this week: portions, waste, prices, the rota.

The bottom. $6,560 on $82,000. It's before the owner's pay, loan payments and income tax, so it isn't spending money. It's what the restaurant produced.

What moves the bottom line, and the margin on each plate, is worked through in restaurant profit margin. Targets for food cost are in what is a good food cost percentage, and how much stock to hold in how much inventory should a restaurant carry.

Weekly, not just monthly

A monthly statement arrives two weeks after the month ends, which is too late to fix anything in it. Most of the value is in a weekly version of the top half: sales, food and drink used (from a weekly count of the expensive items), and wages. That's prime cost, every Monday.

This is general information, not accounting advice. Your accountant decides how your books are set up, and a bank or a tax return may want the statement in a particular form.

Get the template

Download the restaurant profit and loss template. A P&L sheet with a line for each item, its share of sales, last month and the change, and a Summary sheet that works out gross profit, prime cost and what's left. Add or delete lines; keep the Kind column filled in. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

The statement says food cost was 32%. It can't say why it wasn't 30%. Was it prices, portions, waste, or stock that left by the back door? Those are four different problems, and the P&L shows only their sum. And the figure itself rests on two counts, usually done late at night by whoever was closing.

How TaroStack does it

TaroStack isn't an accounting system and doesn't post journal entries. It gives the P&L's hardest line a proper footing.

Stock value by site and month. The opening and closing figures for the cost of goods sum, from the records, checked by counts.

Counting on a phone, in walk order, with no signal in the walk-in. The count shows what a difference is worth before it's posted.

Actual against standard. What the recipes say the kitchen should have used against what it did use: the gap is portions and waste.

Every adjustment carries a reason: expired, spoiled, damaged, staff meals. Waste is reported by reason and item.

A price-creep report for each supplier, so a rise in food cost can be traced to the invoice.

The P&L line From a spreadsheet With TaroStack
Opening and closing stock Two late-night counts, summed by hand Stock value by month
Why food cost rose Unknown Prices, usage against recipes, waste by reason
Purchases Add up invoices Receiving records, by supplier
The books themselves Your accounting software Still your accounting software

Every list exports to CSV for your accountant, and your QuickBooks or Xero lists import when you set up. Stock, counting and costing are on every plan, from $9.99 a month. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

What goes on a restaurant profit and loss statement?

Sales, split into food and drink; cost of goods sold; labor; operating expenses such as rent, utilities and fees; and what's left. Each line is usually shown as a share of sales too.

How do you calculate cost of goods sold for a restaurant?

Stock at the start of the period, plus purchases, less stock at the end. It needs a count at the start and the end.

What is prime cost in a restaurant?

Cost of goods sold plus labor. In this example it's 63% of sales. It's watched closely because it's most of what a manager can change week to week.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.