Recipe history reveals which dishes have stayed profitable while others slowly bled money over months or years. Most restaurants lose this valuable data because recipes live only in chefs' heads. Start tracking systematically and you'll spot the patterns that separate winners from losers.
Why recipe history matters so much
Your menu shifts constantly. Supplier prices creep up. Dishes get tweaked. But without historical data, you're flying blind on which changes actually worked.
💡 Example:
Your beef tenderloin ran for 3 years:
- 2021: €28.50 selling price, 32% food cost
- 2022: €32.00 selling price, 35% food cost
- 2023: €36.00 selling price, 38% food cost
Result: despite higher prices, the dish became less profitable each year.
Essential data to capture
For dishes that stick around longer than 6 months, you need:
- Ingredient costs per portion - don't forget garnishes and sauces
- Selling price excl. VAT - exactly as listed on your menu
- Food cost percentage - calculated from actual numbers
- Monthly sales volume - track popularity shifts
- Change dates - when prices or recipes got adjusted
⚠️ Note:
Always use selling prices excluding VAT. Including VAT makes your food cost look artificially low.
Reading the patterns
After collecting 12 months of data, trends become clear. I've seen this mistake cost restaurants EUR 200-400 per month - they keep dishes that look popular but steadily lose profitability.
- Rising food cost - expensive ingredients eating into margins
- Declining popularity - guests ordering less frequently
- Seasonal swings - dishes that only work certain months
- Price sensitivity - how sales drop when you raise prices
💡 Example analysis:
Your salmon dish over 12 months:
- Food cost jumped from 28% to 34% (salmon prices rose)
- Sales fell from 120 to 85 portions monthly
- Selling price stayed €24.50
Decision: Raise price to €26.50 or swap for another fish option.
Comparing dishes side by side
Real insights emerge from comparing multiple dishes. Which ones stayed consistently profitable? Those recipes are your foundation.
- Stable winners - food cost under 32%, steady sales
- Seasonal champions - highly profitable 4-6 months yearly
- Money drains - food cost above 35% and dropping sales
- Wild cards - huge food cost swings month to month
✨ Pro tip:
Analyze your top 8 sellers from the past 18 months - if those maintained healthy margins throughout, you've got a solid menu backbone.
Digital tracking vs. spreadsheets
Excel seems tempting but becomes a nightmare of outdated versions and missed updates. Digital systems automatically track how food costs evolve over time. You get clear visuals of which dishes truly delivered profits across multiple years, without manual calculations or spreadsheet maintenance.
How do you analyze recipe history? (step by step)
Gather historical data
Go back to old menus, supplier invoices and cash register summaries from at least 12 months. Note for each dish the selling price, ingredient costs and number sold per month.
Calculate food cost per period
For each period you calculate: food cost % = (ingredient costs / selling price excl. VAT) × 100. Make sure you calculate consistently with prices excluding VAT.
Find patterns and trends
Put the figures side by side and look for trends. Is food cost rising? Is sales declining? Which seasons does the dish perform best in? These patterns help you decide which dishes to keep or adjust.
✨ Pro tip
Pull data on your top 8 dishes from the past 18 months and calculate their average food cost percentage. Any dish above 35% needs immediate price adjustment or recipe changes.
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 far back should I look for meaningful recipe history?
At least 12 months for seasonal patterns, but 24 months gives much more reliable data. You'll see if trends are real or just random fluctuations.
What if I don't have historical data on my dishes?
Start tracking immediately. After 6 months you'll spot early trends, after 12 months you can make solid decisions. Don't let perfect be the enemy of good.
Should I track every dish or focus on popular ones?
Focus on your top 10-15 sellers first. They generate 70-80% of your revenue. Track the rest more casually until you have systems in place.
How often should I recalculate food costs?
Every time supplier prices change, plus quarterly reviews as a safety check. Suppliers often raise prices without clear notification.
What's a normal food cost increase per year?
Ingredient costs typically rise 3-5% annually due to inflation. If your food costs climb faster, your dishes are losing profitability structurally.
Can I track recipe profitability without expensive software?
Yes, but it requires discipline. Start with a simple spreadsheet tracking monthly food cost and sales for your top dishes. The key is consistency, not complexity.
📚 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 recipes in one place, forever
Recipes in heads, on notes, in folders — that doesn't work. KitchenNmbrs centralizes all your recipes with costs, allergens, and portions. Try it free for 14 days.
Start free trial →