Multiple versions of the same recipe file create a nightmare for restaurant owners trying to control costs. Your chef works from one Excel sheet, you've got another saved on your desktop, and there's probably a third version floating around on someone's USB drive. Before you know it, nobody has any clue what your dishes actually cost.
Why copies of files are dangerous
Each time someone saves a new version of your cost spreadsheet, you're creating another potential disaster. Your head chef calculates portions using last month's prices, while you're working with numbers from three weeks ago. Meanwhile, your kitchen manager found an old version in his email and thinks that's the current one.
💡 Example:
You have 3 versions of your recipe file:
- Desktop: steak €24.50
- Dropbox: steak €26.80
- USB stick: steak €22.30
Which one reflects reality? Good luck figuring that out.
The problem of outdated prices
Food suppliers don't send you a memo every time they bump up prices. That beef you think costs €8.50 per kilo? It's been €9.20 for two months now. But since you updated only one spreadsheet and forgot about the copies, you're still calculating margins based on fantasy numbers.
⚠️ Watch out:
A difference of €0.70 per steak costs you €1,820 per year in lost profit at 50 portions per week.
Who works with which version?
After managing kitchen operations for nearly a decade, I've seen this chaos play out countless times. Everyone develops their own system, and none of them talk to each other. Your chef scribbles notes on recipe cards, you've got an Excel file from last season, and your purchasing manager keeps supplier emails in a folder marked "important stuff."
- Chef: Relies on muscle memory and handwritten notes
- Owner: Excel sheet with prices from half a year ago
- Buyer: Random supplier emails buried in inbox
- Sous-chef: Laminated recipe cards covered in sauce stains
The hidden costs of chaos
Every minute spent hunting down the "correct" version eats into your profit margins. But that's nothing compared to making menu decisions based on wrong information. You might axe a dish that's actually making money, or keep pushing a special that's bleeding cash.
💡 Example:
You think your pasta carbonara runs at 28% food cost (solid profit), but outdated ingredient prices mean it's actually hitting 36% (disaster zone). So you feature it as a special and lose money on every plate.
What you miss without one system
All those scattered files hide the big picture from you. Which dishes actually turn a profit? Has your produce supplier been gradually hiking prices? Could you swap ingredients to boost margins? These insights get lost in the mess of conflicting data.
- No real-time food cost tracking per dish
- No warnings about supplier price increases
- No way to compare different recipe variations
- No historical trends to spot patterns
The solution: one source of truth
Tools like KitchenNmbrs solve this by centralizing everything in one place. Update an ingredient cost once, and you instantly see how it affects every single dish that uses it. No more guessing, no more outdated spreadsheets.
💡 Example:
Your meat supplier jumps beef from €18 to €21 per kilo. Update it once and immediately see:
- Steak: food cost jumps from 31% to 35%
- Beef stew: food cost rises from 26% to 29%
- Carpaccio: food cost climbs from 24% to 27%
Now you can decide: adjust menu prices or find a cheaper supplier.
Regain control of your prices
Stop playing guessing games with your food costs. One centralized system gives you real numbers in real time. You'll spot price changes the moment they happen and can react before they eat into your profits.
How do you regain control of your prices?
Gather all versions
Find all recipe files, cost price lists and notes. Lay them side by side and identify the differences. Which prices are still correct? Which are outdated?
Check current supplier prices
Call your suppliers or check your latest invoices. What do your main ingredients actually cost today? Update these prices in one master file.
Calculate new food cost
With the correct prices, calculate the actual food cost of your main dishes. Use the formula: (ingredient costs / selling price excl. VAT) × 100.
Choose one system
Stop using multiple files. Choose one system - digital or paper - that everyone works with. Make agreements about who updates what and when.
Check monthly
Schedule 30 minutes each month to check prices. Have any suppliers raised their prices? Update these immediately in your system.
✨ Pro tip
Pick your top 3 highest-volume dishes and track their exact ingredient costs weekly for the next 30 days. You'll quickly see how much money slips through the cracks with outdated pricing.
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
Can't I just use one Excel file for everyone?
Sure, but that means everyone needs access to the same file and nobody can make backup copies. In reality, someone always saves their own version "just in case" and you're back to square one.
How often should I actually check my ingredient prices?
Monthly at minimum, but ideally right after each supplier delivery. Food costs change constantly, and every week you delay updating costs you real money.
What if I have multiple restaurant locations?
Then centralized pricing becomes absolutely critical. Otherwise each location operates with different costs and recipes, and you lose any hope of controlling margins across your business.
📚 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.
Discover what KitchenNmbrs can do for you
From recipe calculation to allergen registration, from inventory management to menu engineering. One platform for complete control of your kitchen. Try it free for 14 days.
Start free trial →