Running a restaurant is one of the most exciting — and most demanding — businesses in the world. You’re managing inventory, staff, customers, and creativity all at once, often with wafer-thin margins and no room for guesswork. The difference between a restaurant that thrives and one that closes isn’t just great food. It’s knowing your numbers.
If you’ve ever ended a busy month and still wondered where the money went, you’re not alone. Most restaurant owners are incredible operators but don’t always have a clear, structured way to track the KPIs — key performance indicators — that actually predict profit. That’s exactly what this guide and the free restaurant_kpi_template are designed to fix.
Download it, open it up, and let’s walk through how to use it to run a smarter, more profitable operation.
What Is a Restaurant KPI — and Why Does Excel Still Work Beautifully?
A KPI (key performance indicator) is simply a number that tells you whether your business is moving in the right direction. For restaurants, that means things like your food cost percentage, your net profit margin, how often your tables turn over, and what your online review score is trending toward.
You don’t need expensive software to start tracking these. A well-structured Excel spreadsheet — or Google Sheets equivalent — is one of the most powerful tools a restaurant owner can use. It’s flexible, accessible, doesn’t require training, and gives you a living record of your performance month by month.
The template above is built around five core KPI categories. Let’s break each one down.
The 5 KPI Categories Every Restaurant Should Track
1. Revenue & Sales KPIs
Before you can manage costs, you need to understand where your money comes from. Revenue KPIs tell you not just how much you’re making, but how efficiently you’re earning it.
Key metrics:
- Total Revenue — your top-line number; track it monthly and compare year-over-year
- Revenue per Cover — total revenue divided by total guests served; reveals pricing effectiveness
- Average Check Size — how much the average table spends per visit
- Catering and Events Revenue — a high-margin income stream worth tracking separately
- Takeaway and Delivery Revenue — increasingly important post-pandemic
A healthy restaurant should see month-over-month revenue growth of 2–10%. More importantly, watch the composition of revenue — a business that’s growing takeaway while dine-in drops may be shifting its entire model without realising it.
2. Cost Control KPIs
This is where restaurants live or die. The hospitality industry benchmarks for cost ratios are well established, and exceeding them consistently is a warning sign that deserves immediate attention.
Key metrics:
- Food Cost % — cost of goods sold (food) divided by food revenue. Target: 25–32%.
- Beverage Cost % — cost of goods sold (beverage) divided by beverage revenue. Target: 18–28%.
- Labour Cost % — total labour spend divided by total revenue. Target: 25–35%.
- Prime Cost % — the single most important ratio in this list. It’s your food COGS + beverage COGS + labour, divided by total revenue. A prime cost above 65% is a serious red flag. Top-performing restaurants keep it below 60%.
- Waste and Spoilage % — often undertracked but can easily represent 2–5% of revenue walking out the door.
What’s Prime Cost and why does it matter so much? Prime cost captures the two biggest controllable expenses in your business. If you only ever track one KPI, make it this one. A prime cost above 65% means you are almost certainly losing money after overhead — even if your sales look strong.
3. Profitability KPIs
Revenue minus costs equals profit — but the ratios reveal the story behind the number.
Key metrics:
- Gross Profit Margin — revenue minus food and beverage COGS, expressed as a percentage. Most restaurants should target 65–75%.
- Net Profit Margin — the percentage left after all costs: COGS, labour, overhead, and fixed costs. Industry average is 3–9%; excellent operators reach 12–15%.
- EBITDA — earnings before interest, tax, depreciation, and amortisation. Useful if you’re thinking about investment, expansion, or sale.
- Revenue per Labour Hour — a powerful efficiency ratio that connects your revenue to your staffing decisions.
If your net profit margin is consistently below 5%, the problem is almost always food cost, labour cost, or both. The template’s Calculated KPIs sheet will show you exactly where the gap is.
4. Guest Experience KPIs
Happy guests come back. They bring friends. They leave reviews. And reviews drive bookings. Guest experience KPIs bridge the gap between your operation and your reputation.
Key metrics:
- Online Review Score — your average across Google, Tripadvisor, or your primary platform. Below 4.0 is a serious commercial risk; below 3.5 is an emergency.
- Number of New Reviews per Month — volume matters alongside score for local SEO.
- Repeat Guest Rate — the percentage of guests who have visited before. A rate above 40% signals strong loyalty.
- Average Wait Time — over 20 minutes consistently starts to erode satisfaction.
- Table Turnover Rate — how many times your tables “turn” in a service. Higher turnover drives more revenue from the same seat count.
5. Operations KPIs
Operational metrics reveal the engine under the hood. They tell you whether your capacity is being used efficiently and where process problems are hiding.
Key metrics:
- Seat Occupancy Rate — covers served as a percentage of total available seat-sittings per month. Target 65–80% for financial sustainability.
- No-Show Rate — the percentage of reservations that don’t show up. Above 8% suggests you need a reminder policy or deposit system.
- Inventory Turnover — how often you turn over your full inventory in a month. Higher = less spoilage and better cash flow.
- Covers Served — absolute volume; track alongside occupancy to understand demand trends.
How to Use the Restaurant KPI Excel Template
The template you’ve downloaded is built across five sheets:
How To Use — start here. It explains the colour-coding system and gives you five steps to get started in under 10 minutes.
Monthly Data Entry — enter your actual figures here, in the yellow cells. You’ll input raw numbers: revenue lines, COGS, labour costs, covers served, bookings, no-shows, and guest metrics. One row per KPI, one column per month.
Calculated KPIs — this sheet does all the maths for you. Food cost %, prime cost %, net profit margin, revenue per cover, repeat guest rate — all auto-calculated from your data entry sheet using live formulas. You never need to calculate manually.
Dashboard — a colour-coded 6-month snapshot of your most important KPIs. Green means you’re on track. Amber means you’re within 5% of your target — watch it. Red means you’re off track and need action. The sample data pre-loaded shows you how the dashboard looks in use.
Targets & Benchmarks — set your own annual targets in the blue cells. Industry benchmark ranges are pre-filled for every KPI so you have a reference point, whether you’re in quick-service, casual dining, or fine dining.
Ready to go beyond a spreadsheet? generatekpi.com helps you define and build the exact KPI framework for your specific restaurant — so you’re always measuring what actually matters for your business model.
A Real-World Example: How One Restaurant Fixed Its Prime Cost Problem
Imagine a busy neighbourhood bistro with strong Friday and Saturday nights — consistently turning $50,000+ per month in revenue. The owner is satisfied, but something feels off: the bank balance never seems to reflect the sales figures.
When they finally start tracking KPIs monthly, the picture becomes clear immediately. Food cost is running at 34% (above their 28% target). Labour is at 33%. Prime cost? 67% — solidly in the danger zone.
The fixes aren’t glamorous: tighter portion control on three high-waste dishes, a revised staff schedule that reduces the overlap between prep and service shifts, and a menu engineering review that quietly removes the two lowest-margin items. Six weeks later, food cost is at 29%, labour at 31%, prime cost at 60%. On the same revenue, they’ve freed up over $3,500 a month in cash.
None of this is possible without tracking. The numbers create the visibility. The visibility creates the opportunity to act.
Setting Targets That Actually Motivate Your Team
One of the most underrated uses of a KPI tracker is as a team communication tool. When your front-of-house team understands that each upsell genuinely improves average check size — and that average check size is a tracked metric with a target — it becomes a shared goal, not just a manager’s request.
The same applies to your kitchen team and food cost. When the numbers are visible, the behaviours that drive them become visible too.
Use the Targets & Benchmarks sheet to set your quarterly goals, then share the relevant metrics with your team leaders. You don’t need to share the entire P&L — just the KPIs that each team can actually influence.
How Often Should You Update Your Restaurant KPIs?
The honest answer: it depends on the metric.
Weekly tracking makes sense for food cost %, waste, covers served, and online review score. These are fast-moving numbers where a one-week trend can tell you something important before it becomes a problem.
Monthly tracking is appropriate for revenue totals, profit margins, EBITDA, labour cost %, inventory turnover, and repeat guest rate. These metrics need a full period to be meaningful.
Quarterly reviews are the right cadence for target-setting, benchmark comparison, and strategic conversations about menu engineering, staffing models, or marketing investment.
The template is designed for monthly data entry, but the most successful operators open it weekly to check on the numbers that matter most to them right now.
Conclusion
Your restaurant’s financial health isn’t a mystery — it’s a set of numbers that, once visible, give you the confidence and clarity to make better decisions every single day. A restaurant KPI Excel template doesn’t replace your instincts as an operator. It sharpens them.
Download the template, start with your last full month of data, and watch what becomes clear almost immediately. The first time you see your prime cost in a cell next to your target, something changes. You stop wondering where the money went — and you start knowing exactly what to do next.
Template includes: Monthly Data Entry sheet, auto-calculated KPI formulas, colour-coded dashboard, and industry benchmark reference for 25+ restaurant KPIs. Download here restaurant_kpi_template