Most restaurants guess at their ingredient costs while successful operators extract exact prices from every invoice. The difference between estimating and tracking real purchase prices can make or break your profit margins. Here's how to pull accurate ingredient costs from supplier invoices.
Why use invoice prices?
Your supplier's quoted price rarely matches what you actually pay. Seasonal adjustments, volume discounts, and fuel surcharges create a gap between expectations and reality.
⚠️ Note:
Catalog prices and estimates will mislead your cost calculations. Only invoice prices reflect what you actually spent per ingredient.
What's on an invoice?
Supplier invoices contain multiple price components, but you only need specific data for cost calculations:
- Base price per kg/unit: Your target number
- Discounts: Volume rebates, seasonal reductions
- Surcharges: Delivery fees, minimum order penalties
- VAT: Exclude this from cost calculations
? Example invoice:
Beef tenderloin, 3 kg ordered:
- Listed price: €32.00/kg
- Volume discount: -€3.00/kg
- Fuel surcharge: +€0.75/kg
- Net cost: €29.75/kg
Use €29.75/kg for recipe calculations, not €32.00
Different units on invoices
Suppliers invoice using various units that don't always match your recipe measurements. Convert everything to your kitchen's standard unit:
- Per piece to per kg: Divide unit price by individual weight
- Per case to per kg: Divide case price by total case weight
- Per liter to per kg: Generally equivalent, but verify density
? Example conversion:
Whole duck on invoice:
- Invoice price: €38.50 per duck
- Average weight: 2.2 kg per duck
- Calculation: €38.50 ÷ 2.2 kg = €17.50/kg
Recipe cost: €17.50/kg
Handle VAT correctly
Cost calculations require VAT-exclusive prices. Food suppliers typically charge 9% VAT, which inflates your ingredient costs if included:
? VAT calculation:
Invoice shows: €27.25 including 9% VAT
- Formula: VAT-inclusive price ÷ 1.09
- Math: €27.25 ÷ 1.09 = €25.00
Cost calculation price: €25.00 excluding VAT
Track price changes
From analyzing actual purchasing data across different restaurant types, ingredient prices shift every 4-6 weeks on average. Update your costs monthly minimum, or immediately after major supplier deliveries.
⚠️ Note:
A 12% increase on core ingredients can push food costs up by 4-5 percentage points. Monitor this after every delivery from primary suppliers.
Digital vs. manual tracking
Updating ingredient prices in spreadsheets works initially, but becomes tedious and error-prone as your operation grows. Digital systems automatically recalculate dish costs across your entire menu after price updates.
How do you get ingredient prices from invoices? (step by step)
Gather your latest invoices
Get the invoices from your 3 main suppliers from the past month. Focus on products you use most: meat, fish, vegetables, dairy.
Find the net price per unit
Look at the price after all discounts and surcharges, but before VAT. Convert to the unit you use in your kitchen (usually per kg).
Remove VAT
Divide the price by 1.09 to go from incl. to excl. VAT. This is the price you use in your cost calculation.
Update your price list
Update your Excel or app with the new prices. Immediately check the impact on your food cost for your main dishes.
Schedule monthly updates
Put it in your calendar to check your prices every month. Suppliers raise prices regularly without explicitly mentioning it.
✨ Pro tip
Cross-reference invoice prices against your POS system's top 3 selling dishes within 48 hours of price updates. If any dish exceeds 32% food cost, adjust portions or menu prices immediately.
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
Should I include VAT in my purchase price?
How often should I update my ingredient prices?
What if my supplier invoices per unit instead of weight?
Should delivery fees be included in ingredient costs?
How do I handle bulk order discounts?
What about ingredients with extreme seasonal price swings?
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
Calculate it yourself with KitchenNmbrs
All the formulas you learn here — KitchenNmbrs calculates them automatically. Enter your ingredients and instantly see your food cost, margin, and selling price. Try it free for 14 days.
Start free trial →