Cafe and restaurant P&L: a template and key metrics
A P&L template for cafes and restaurants: food cost, prime cost, theoretical vs actual COGS, delivery app commissions, with a line-by-line worked example.
By The DataxLand team· · 6 min read
Cafe and restaurant owners usually know exactly whether today was busy or quiet, but can rarely say with confidence "how much did we make this month". Revenue sits in the point-of-sale (POS) system, ingredient spend in the purchase log, wages in the timesheet, rent in the lease, delivery commissions in each app's report. Everything lives in a different place, and by the time it is pieced together at month end, you are already in the second week of the next month.
This post gives a profit and loss (P&L) template for a food and beverage business, explains the most important metrics (food cost, prime cost, the gap between recipe-based and inventory-based cost of goods), and shows how to collect the data so the report is ready at the start of the month.
Every number in this post is an illustrative example for a hypothetical cafe, not an industry average or any specific business's figures. Replace them with your own.
Monthly P&L template
| Line | Amount | % of net revenue |
|---|---|---|
| Net revenue (dine-in + takeaway + delivery apps, after discounts) | 294,000,000 ₫ | 100% |
| − Ingredient cost (drinks, food) | 88,200,000 ₫ | 30.0% |
| = Gross profit | 205,800,000 ₫ | 70.0% |
| − Delivery app commissions | 15,000,000 ₫ | 5.1% |
| − Takeaway packaging | 4,500,000 ₫ | 1.5% |
| − Labour (salaried staff, part-time shifts) | 70,000,000 ₫ | 23.8% |
| − Rent | 45,000,000 ₫ | 15.3% |
| − Electricity, water, gas | 12,000,000 ₫ | 4.1% |
| − Marketing | 6,000,000 ₫ | 2.0% |
| − Equipment depreciation, repairs | 8,000,000 ₫ | 2.7% |
| − Other costs | 5,000,000 ₫ | 1.7% |
| = Operating profit | 40,300,000 ₫ | 13.7% |
Three things worth noting in this structure:
- Delivery app commissions are a separate line, not deducted directly from revenue. That way you can compare dine-in with delivery: in the example, delivery revenue is assumed to be 60,000,000 ₫ at a 25% commission (your real rate depends on your contract with each app).
- Takeaway packaging is a channel cost, not an overhead. Paper cups, lids and bags only occur when customers take the order away.
- Depreciation belongs in the management report. The espresso machine is not free just because you paid for it last year.
Food cost: the first metric to watch
Food cost (the ingredient cost ratio) is ingredient cost divided by net revenue. In the example it is 30.0%.
The month's ingredient cost is not what you spent on purchases that month. It is calculated from a stock count:
Ingredient cost = Opening stock + Purchases in the period − Closing stock
= 18,000,000 + 92,000,000 − 21,800,000
= 88,200,000 ₫If you only use purchases (92,000,000 ₫), any month in which you stock up will look like a loss, and the following month will look unusually profitable.
Recipe-based vs inventory-based cost
The figure above is the actual cost. If you have standard recipes (portion specs), you can also calculate a theoretical cost: the ingredients that should have been used for the items sold.
Example recipe for one iced milk coffee (ingredient prices assumed):
| Ingredient | Quantity | Unit price | Cost |
|---|---|---|---|
| Ground roasted coffee | 20 g | 300 ₫/g | 6,000 ₫ |
| Condensed milk | 30 g | 80 ₫/g | 2,400 ₫ |
| Ice, cup, straw | 1 set | — | 1,600 ₫ |
| Cost per cup | 10,000 ₫ |
At a selling price of 35,000 ₫, this item's food cost is 10,000 ÷ 35,000 ≈ 28.6%.
Add up the theoretical cost of every item sold in the month (quantity sold from the POS × recipe cost per item); say it comes to 80,500,000 ₫. Compared with the actual cost of 88,200,000 ₫:
Variance = 88,200,000 − 80,500,000 = 7,700,000 ₫ (≈ 2.6% of net revenue)This variance is money that "disappears" between the storeroom and the cup: over-portioning, spoiled ingredients, remade items, staff drinks, receiving errors. Tracking this variance month by month is far more useful than looking only at total food cost.
Prime cost: ingredients plus labour
Prime cost is ingredient cost plus labour cost — the two largest costs of a food business and the ones you can adjust most.
Prime cost = 88,200,000 + 70,000,000 = 158,200,000 ₫ (≈ 53.8% of net revenue)Rent is usually fixed by the lease; ingredients and labour change with how you operate day to day (portioning, shift schedules, staff per time slot). That is why prime cost is a metric owners should check weekly, not just monthly. A reasonable threshold depends on the format (a takeaway kiosk differs from a table-service restaurant), so set yours from your own numbers over a few stable months.
Operating metrics to keep next to the P&L
| Metric | How it is calculated | Used to |
|---|---|---|
| Average ticket | Net revenue ÷ number of receipts | Judge upselling and combos |
| Revenue by time slot | Totals by hour of the day | Plan shifts and happy hours |
| Revenue by channel | Dine-in, takeaway, each delivery app | See which channel is profitable after commission and packaging |
| Gross profit by item | (Price − recipe cost) × quantity | Decide which items to keep, push or drop |
| Cost variance | Actual − theoretical | Detect shrinkage and waste |
In the example, if the cafe issued 6,300 receipts in the month, the average ticket is 294,000,000 ÷ 6,300 ≈ 46,667 ₫.
How to collect the data so the report is ready at the start of the month
- Revenue and items sold: export from your POS software by day (an Excel file), or pull it through an API if the software has one.
- Delivery app orders: download each app's settlement report, keeping the commission and promotion columns separate.
- Stock count: one spreadsheet of month-end stock by ingredient, counted by the same person on the same day each month.
- Recipes and ingredient prices: one recipe table, updated when purchase prices change (with an effective date).
- Fixed costs: a small monthly table: rent, wages, utilities, depreciation.
These five sources are enough for the report above. The hard part is not having the data but combining it the same way every month.
How DataxLand does this
DataxLand takes Excel files exported from your POS (Excel file), stock and cost spreadsheets in Google Sheets, or data from any software with a REST API that returns JSON (Custom REST API). Si reads the structure and a sample of the data with personal information masked, and proposes how to interpret each column (which is the receipt, the item, the channel, the ingredient) for you to approve before anything is built.
Metrics specific to your business, such as food cost, prime cost or cost variance, are defined as workspace metrics: checked against a sample period before they are switched on, then the dashboard, Telegram reports and Si's answers all use the same definition. Set an alert for when weekly food cost crosses a threshold you choose. See also automated management reports and DataxLand for operations.
FAQ
What is a good food cost?
There is no single right number for every business: specialty drinks, cooked food and table service have very different cost structures. The practical approach is to track your own food cost over many months and look closely at any month that drifts from the usual level.
Do I need a stock count every month?
Yes, if you want an accurate actual cost. Without a stock count you only have purchases, and purchases do not reflect the ingredients actually used. A small cafe can count its most expensive ingredients weekly and do a full count at month end.
Should delivery app commissions be deducted from revenue or recorded as a cost?
In the management report, a separate cost line lets you compare the profit of delivery with dine-in. For how to record it in your statutory accounts, ask your accountant.
What about a business with several branches?
Add a "branch" dimension to every source (POS, stock counts, costs). Shared costs such as marketing or management are allocated by a fixed rule, for example by revenue, and that rule is stated in the report.
Read next: Profit and loss dashboard: 8 metrics to track · Cost of goods sold: weighted average, by batch, by date · Your business's own metrics