While most restaurant owners focus on their menu prices including VAT, accurate food cost calculations require the opposite approach. Converting to prices excluding VAT forms the foundation of every profitable calculation. Many operators skip this step, causing their food cost percentages to paint a dangerously misleading picture.
Why calculate excluding VAT?
Food cost calculations always use the price excluding VAT. The logic's straightforward: VAT isn't your revenue. You're simply collecting it for the government and passing it along.
⚠️ Important:
Calculate food cost with VAT-inclusive prices, and your percentages will look artificially low. You'll think you're profitable when you're actually bleeding money.
The formula for excluding VAT
Here's the basic formula to convert from inclusive to exclusive VAT:
Price excl. VAT = Price incl. VAT ÷ (1 + VAT percentage)
Hospitality VAT rates break down like this:
- Food and non-alcoholic beverages: 9% VAT
- Alcoholic beverages: 21% VAT
- Takeaway and delivery: 9% VAT
💡 Example at 9% VAT:
Pasta carbonara menu price: €24.50
Calculation: €24.50 ÷ 1.09 = €22.48 excl. VAT
Use €22.48 for food cost calculations, not €24.50
💡 Example at 21% VAT:
Wine bottle menu price: €32.00
Calculation: €32.00 ÷ 1.21 = €26.45 excl. VAT
Pour cost calculations use €26.45
Practical calculation tips
Speed up your calculations with these conversion factors:
- At 9% VAT: divide by 1.09 (or multiply by 0.917)
- At 21% VAT: divide by 1.21 (or multiply by 0.826)
Quick verification trick: 9% VAT means the exclusive price sits roughly 8% below the inclusive price. For 21% VAT, expect around 17% lower.
💡 Example full menu:
Appetizer €12.50 → €11.47 excl. VAT
Main course €28.00 → €25.69 excl. VAT
Wine €6.50 → €5.37 excl. VAT
These converted amounts drive your food cost calculations
Common mistakes
The most frequent error involves misapplying the VAT percentage:
- Wrong approach: €25.00 - (€25.00 × 0.09) = €22.75
- Correct method: €25.00 ÷ 1.09 = €22.94
That difference might seem trivial, but something most kitchen managers discover too late is how these small errors compound across hundreds of menu items, completely distorting their cost analysis.
⚠️ Watch out for mixed menus:
Selling both food and alcohol means tracking different VAT rates per item. That beer with lunch carries 21% VAT while the meal itself gets 9%.
Digital tools
Manual conversion eats time and breeds errors. Apps automatically handle these conversions and feed the correct figures into your food cost calculations. You'll dodge calculation mistakes and keep accurate numbers within reach.
How do you calculate excluding VAT prices? (step by step)
Determine the correct VAT rate
Check per product whether it's 9% (food, non-alcoholic) or 21% VAT (alcohol). This is shown on your receipt or in your POS system. Unsure? Food and soft drinks are almost always 9%.
Apply the formula
Divide the including VAT price by (1 + VAT percentage). At 9%: divide by 1.09. At 21%: divide by 1.21. Round to 2 decimal places for practical use.
Check your result
Quick check: at 9% VAT your result should be roughly 8% lower than your starting amount. At 21% VAT roughly 17% lower. Doesn't match? Then you probably made a calculation error.
✨ Pro tip
Convert your top 20 menu items to VAT-exclusive prices within the next 48 hours and save them in a reference sheet. You'll eliminate repeated calculations and catch pricing errors before they damage your margins.
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 subtract 9% from my menu price?
No, that's mathematically incorrect. You must divide by 1.09, not subtract 9%. This seemingly small difference creates significant errors when applied across your entire menu.
What if I sell mixed products like a lunch with a beer?
Calculate each component separately. The lunch carries 9% VAT, the beer 21% VAT. Convert both to excluding VAT before combining your food costs.
How do I know for sure which VAT rate applies?
Check your POS system or printed receipts for confirmation. Food and non-alcoholic drinks get 9%, alcoholic beverages get 21%. Your accountant can clarify any edge cases.
📚 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.
Set selling prices based on facts
Guessing at prices? KitchenNmbrs calculates the ideal selling price based on your actual food cost and desired margin. Test it free for 14 days.
Start free trial →