Extract accurate ingredient prices from supplier invoices to calculate true food costs. Stop estimating purchases and start using real invoice data for profitable menu pricing.
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?
No, exclude VAT from cost calculations. Divide invoice prices by 1.09 to convert from VAT-inclusive to VAT-exclusive amounts.
How often should I update my ingredient prices?
Monthly at minimum, or immediately after receiving invoices from your top three suppliers. Price volatility can dramatically impact food costs within weeks.
What if my supplier invoices per unit instead of weight?
Convert to per-kilogram pricing by dividing the unit price by the item's weight. This creates consistent pricing across all ingredients.
Should delivery fees be included in ingredient costs?
No, treat delivery as an operational expense separate from ingredient costs. Include delivery in your overall cost structure but not in food cost percentages.
How do I handle bulk order discounts?
Use your actual discounted price for cost calculations. If you consistently order in discount quantities, that discounted rate is your true ingredient cost.
What about ingredients with extreme seasonal price swings?
Update prices with each new invoice during volatile periods. For planning purposes, calculate quarterly averages to smooth out extreme fluctuations.
📚 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.
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 →