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.
