Picture this: your sous chef updates menu prices on their old laptop while you're calculating costs on your new desktop. Different Excel versions create silent discrepancies in formulas, rounding, and VAT calculations. Your margins start bleeding without anyone noticing.
Why different Excel versions cause problems
Excel versions follow different calculation standards, particularly for VAT and rounding operations. A price that shows €29.36 excl. VAT in Excel 2019 might display €29.35 in Excel 2016 due to varying rounding protocols.
💡 Example:
Steak on menu: €32.00 incl. 9% VAT
- Excel 2019: €32.00 / 1.09 = €29.358 → rounded €29.36
- Excel 2016: €32.00 / 1.09 = €29.358 → rounded €29.35
- Difference per plate: €0.01
At 5,000 plates per year: €50 difference in calculation
Formula incompatibility between versions
Legacy Excel versions can't recognize newer functions or interpret them differently. The ROUNDUP and ROUND functions behave inconsistently, directly affecting your cost price calculations.
- Newer versions: automatic VAT recognition in templates
- Older versions: manual entry required
- Inconsistent handling of empty cells
- Varying results in percentage calculations
The real problem: nobody checks the results
Technology isn't the biggest threat—it's the absence of verification. Your chef works on an outdated laptop while you use a modern desktop, creating two separate pricing ecosystems without anyone realizing.
⚠️ Watch out:
Most kitchens have multiple Excel files floating around with nobody tracking which version is authoritative. This creates random pricing across your menu.
Concrete impact on your margin
The damage extends beyond minor rounding errors. Different versions can systematically corrupt pricing across your entire menu—the kind of thing you only learn after closing your first month at a loss.
💡 Example margin impact:
Restaurant with 10 main courses, averaging 100 portions per week:
- Difference per dish due to Excel version: €0.15
- 10 dishes × €0.15 × 100 portions = €150/week
- Annual difference: €7,800
That's almost a month's salary in 'lost' margin
Why one system is the solution
Standardizing Excel versions won't fix this. The core issue is multiple files and multiple people entering data without coordination.
- One central database eliminates version conflicts
- Automated calculations remove human error
- Real-time updates ensure everyone sees identical figures
- No more Excel files that disappear or get accidentally overwritten
Tools like KitchenNmbrs operate from one central database. Every team member sees identical prices, food cost percentages, and margins. No more Excel version surprises.
💡 Practical example:
Bistro with 3 employees calculating prices:
- Owner: Excel 2019 on new laptop
- Chef: Excel 2016 on old computer
- Sous-chef: Google Sheets on tablet
Result: 3 different prices for the same dish. With one app, all three see identical figures.
How do you prevent Excel version problems?
Check all active Excel files
Gather all files used for price calculations. Check which Excel versions are running and whether the formulas produce the same results.
Test a standard calculation on all systems
Take one dish and calculate the food cost on all computers. Note the differences and determine which version you'll use as your standard.
Choose one central solution
Stop using Excel and switch to one system that gives everyone the same result. This prevents version conflicts and ensures consistent pricing.
✨ Pro tip
Always verify your Excel calculations on your chef's computer before implementing new prices. Results often differ from what you see on your own device within the same 24-hour period.
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 big can the differences between Excel versions be?
With basic rounding, usually a few cents per dish. But complex calculations involving multiple VAT rates can create differences of €1-2 per dish. Over thousands of servings, this adds up fast.
What if we use Google Sheets instead of Excel?
Google Sheets follows different rounding rules than Excel, so you'll still get inconsistent results. The problem persists—just with different software creating the discrepancies.
How do I check if our Excel calculations are correct?
Manually calculate the food cost of your top-selling dish with a basic calculator. Compare this result with your Excel output to spot any deviations. Test this on each team member's device.
📚 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 →