Building a restaurant dashboard is like assembling a car's instrument panel - you need both the speedometer and the fuel gauge to drive safely. Most owners obsess over daily sales but ignore the operational warning lights flashing in their kitchen. Smart dashboards blend profit numbers with service metrics so you spot trouble before it hits your bank account.
The 5 most important financial KPIs
These numbers reveal if you're actually making money:
- Food cost percentage: How much of your revenue goes to ingredients
- Gross margin per dish: What you earn per plate after ingredient costs
- Labor cost percentage: How much of your revenue goes to staff
- Average check value: How much a guest spends on average
- Break-even point: How much revenue you need at minimum
💡 Example financial KPIs:
Restaurant with €25,000 monthly revenue:
- Food cost: 32% = €8,000
- Labor cost: 28% = €7,000
- Gross margin: €25,000 - €8,000 = €17,000
- Break-even: €18,500/month
This restaurant runs a profit of €6,500/month
The 4 most important operational KPIs
These metrics show how efficiently your kitchen and service run:
- Number of covers per day: How many guests you serve
- Revenue per square meter: How productive your space is
- Inventory turnover: How often you cycle through stock
- Waste percentage: How many ingredients end up in the bin
💡 Example operational KPIs:
Restaurant of 80m² with 40 seats:
- Covers: 120 per day on average
- Revenue per m²: €25,000 / 80m² = €312/m²/month
- Inventory turnover: 2x per week = 8x per month
- Waste: 8% of purchases
Occupancy rate: 120 / 40 = 3 times full per day
How you connect financial and operational data
The real magic happens by linking both data types. Here's what the patterns tell you:
- More covers, lower check value: Your food cost looks fine, but you're earning less per guest
- High inventory value, low revenue: You're buying too much for actual sales
- High waste, climbing food cost: Kitchen inefficiency becomes a profit killer
⚠️ Watch out:
Don't focus on single metrics. Growing revenue can fool you if food cost jumps from 30% to 38% at the same time. You're actually earning less per euro of sales. This mistake costs the average restaurant EUR 200-400 per month in missed profit opportunities.
Dashboard structure: daily, weekly, monthly
Organize your KPIs by review frequency:
Daily (5 minutes):
- Yesterday's revenue vs. same day last week
- Number of covers
- Average check value
- Waste (what went in the bin)
Weekly (15 minutes):
- Food cost percentage of your top dishes
- Inventory value (count what's there)
- Labor cost (hours × rates)
Monthly (30 minutes):
- Break-even analysis
- Revenue per m² vs. last month
- Calculate inventory turnover
Tools for your dashboard
You've got several options to track KPIs:
Excel/Google Sheets: Free, but requires manual data entry. You'll input all numbers yourself and build formulas.
POS system reports: Provides revenue and cover data automatically, but can't track food costs or inventory.
Specialized restaurant software: Food cost calculators can automatically calculate ingredient costs and track supplier price changes.
💡 Example dashboard setup:
Combination approach:
- POS: revenue and covers (automatic)
- Food cost app: ingredient costs and recipes (automatic)
- Excel: labor cost and break-even (fill in weekly)
- Manual count: inventory and waste (weekly)
Total time per week: 45 minutes
Warning signals to monitor
Your dashboard should flag problems before they spiral out of control:
- Food cost suddenly spikes: Supplier increased prices, or chef's giving bigger portions
- Covers drop, revenue holds steady: You've raised prices - check if customers are leaving
- Inventory value climbs weekly: You're over-ordering, tying up cash
- Waste exceeds 10%: Poor planning or overly generous portions
⚠️ Watch out:
A dashboard only works if you act on what it shows. Block 15 minutes weekly to review numbers and decide what you'll change.
How do you set up a KPI dashboard? (step by step)
Choose your 5 most important KPIs
Start small. Choose 2-3 financial KPIs (like food cost and gross margin) and 2-3 operational KPIs (like covers and waste). More than 5 becomes confusing.
Determine your data sources
Inventory where your data comes from: POS system for revenue, manual count for inventory, invoices for purchase prices. Note how much time each source takes.
Create your dashboard format
Use Excel, Google Sheets, or an app like KitchenNmbrs. Put your KPIs in an overview with this week vs. last week. Add colors: green for good, red for bad.
Schedule your update times
Set fixed times in your calendar: Monday 9:00 for weekly figures, every day 5:00 PM for daily figures. Without a fixed routine, your dashboard gets neglected.
Test and improve
Use your dashboard for 4 weeks. Which figures do you look at most? Which are useless? Adjust until you have a dashboard that really helps you make decisions.
✨ Pro tip
Check your 8 highest-volume dishes every Wednesday morning for food cost drift above 35%. This 10-minute routine catches 80% of profit leaks before they compound.
Calculate this yourself?
In the KitchenNmbrs app you can do this in just a few clicks. 7 days free, no credit card.
Was this article helpful?
Frequently asked questions
How many KPIs should I track in my dashboard?
Start with 5-7 KPIs maximum. More creates confusion. Focus on 2-3 financial metrics (food cost, gross margin) and 2-3 operational ones (covers, waste).
How often should I update my dashboard?
Daily numbers (revenue, covers) take 5 minutes each morning. Weekly metrics (food cost, inventory) need 15 minutes once per week. Monthly analysis requires 30 minutes at month-end.
Can I connect my POS system to my KPI dashboard?
Most POS systems export data to Excel easily. This works great for revenue and cover tracking. But you'll need separate tools for food costs since your POS doesn't know ingredient prices.
What if my KPIs give conflicting signals?
That's exactly why dashboards are powerful. Rising revenue with falling gross margin means food costs are climbing too fast. Without both metrics, you'd only see the good revenue news and miss the profit leak.
📚 Sources consulted
- EU Verordening 852/2004 — Levensmiddelenhygiëne (2004) — Official source
- EU Verordening 853/2004 — Hygiënevoorschriften voor levensmiddelen van dierlijke oorsprong (2004) — Official source
- EU Verordening 1169/2011 — Voedselinformatie aan consumenten (2011) — Official source
- NVWA — Hygiënecode voor de horeca (2024) — Official source
- NVWA — Allergenen in voedsel (2024) — Official source
- Codex Alimentarius — International Food Standards (2024) — Official source
- FSA — Safer food, better business (HACCP) (2024) — Official source
- BVL — Lebensmittelhygiene (HACCP) (2024) — Official source
- Warenwetbesluit Bereiding en behandeling van levensmiddelen (2024) — Official source
- WHO — Foodborne diseases estimates (2024) — Official source
Food Standards Agency (FSA) — https://www.food.gov.uk
The HACCP standards shown in this application are for informational purposes only. KitchenNmbrs does not guarantee that displayed values are current or complete. Always consult the FSA or your local authority for the latest regulations.
Written by
Jeffrey Smit
Founder & CEO of KitchenNmbrs
Jeffrey Smit built KitchenNmbrs from 8 years of hands-on experience as kitchen manager at 1NUL8 Group in Rotterdam. His mission: give every restaurant owner control over food cost.
All your financial KPIs in one dashboard
Food cost percentage, gross margin, revenue per cover — KitchenNmbrs calculates it all automatically based on your recipes and purchases. Start your free trial.
Start free trial →