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.
Related articles
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?
What if I don't have historical data on my dishes?
Should I track every dish or focus on popular ones?
How often should I recalculate food costs?
What's a normal food cost increase per year?
Can I track recipe profitability without expensive software?
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
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.
More in this category
Related questions
Explore more topics
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 →