Purchase prices change constantly. Your supplier raises the price of beef by 15%, but your recipes still calculate with the old prices. This way you lose money on every dish without noticing. You can update this manually, but there are smarter ways to let your recipes automatically adjust to price changes.
Why automatic updates are crucial
Many entrepreneurs think they'll remember their prices. But suppliers adjust their rates 3-4 times a year. With 50 ingredients and 30 recipes, you'll spend hours updating everything manually.
⚠️ Watch out:
A 10% price increase on your main ingredients can bring your food cost from 30% to 33%. That costs you €15,000 per year at €500,000 in revenue.
Three ways to automatically update recipes
1. Central ingredient database
Instead of keeping prices per recipe, you work with one central list of all ingredients with their current prices. If you adjust the price of beef from €18 to €20 per kilo, all recipes with beef are automatically recalculated.
💡 Example:
You have 8 dishes with beef. The price rises from €18 to €21 per kilo (+17%).
Manually: 8 recipes × 5 minutes = 40 minutes of work
Automatically: 1 price adjustment = 30 seconds, all recipes updated instantly
2. Supplier link per ingredient
Register which supplier each ingredient comes from and what the last purchase price was. When you receive a new invoice, you only update the ingredients from that supplier.
- Greengrocer: lettuce, tomato, onion, bell pepper
- Meat supplier: beef, pork, chicken, lamb
- Fish merchant: salmon, tuna, sea bass
3. Percentage adjustments
If a supplier raises all prices by 8%, you adjust all ingredients from that supplier at once. Many digital systems can do this automatically.
💡 Example:
Your meat supplier raises all prices by 12% due to inflation.
- Beef: €18.00 → €20.16
- Pork: €14.50 → €16.24
- Chicken fillet: €12.00 → €13.44
With percentage adjustment: 1 action for all meat ingredients
How often should you check prices?
Check at least monthly whether your purchase prices are still correct. With large suppliers, you often get advance notice of price changes. Then schedule time right away to update your system.
- Weekly: Fresh products (vegetables, fish) - prices fluctuate significantly
- Monthly: Meat, dairy, dry goods - prices more stable
- Immediately: When you receive a price list from your supplier
Digital tools vs. Excel
In Excel you have to manually adjust every price in all recipes where the ingredient appears. With an app like KitchenNmbrs you adjust the price once in the ingredient database, and all recipes are automatically recalculated.
💡 Example comparison:
50 ingredients used in 30 recipes, price update costs:
- Excel: 2-3 hours searching and adjusting
- Digital system: 15 minutes central update
Time saved: 2.5 hours per update
The benefit of automatic updates goes beyond time. You also prevent errors: no forgotten recipes, no incorrectly typed prices, and your food cost always stays current.
How do you set up automatic recipe updates? (step by step)
Create a central ingredient database
List all ingredients you use with their current purchase price per unit (kilo, liter, piece). Also add which supplier each ingredient comes from and when you last checked the price.
Link recipes to the database
Make sure your recipes don't have their own prices, but reference the central ingredient database. If you adjust the price of flour in the database, all bread and pizza recipes are automatically recalculated.
Schedule monthly price check
Set a recurring appointment in your calendar to check prices. Review supplier invoices and update prices that have changed. With digital systems this takes 15-30 minutes per month.
✨ Pro tip
Check with every supplier invoice whether the prices match what you have in your system. This way you catch price changes immediately instead of months later at month-end closing.
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 often do purchase prices change on average?
Fresh products (vegetables, fish) can fluctuate weekly. Meat and dairy usually change 3-4 times per year. Dry goods are most stable with 1-2 adjustments per year.
What if I forget to update a price?
Then you calculate with a cost price that's too low and lose money on every dish sold. If you miss a 15% price increase for 3 months, you easily lose hundreds of euros.
Can I do percentage adjustments in Excel?
Yes, but you have to manually select each cell and adjust the formula. In digital systems you select all ingredients from one supplier and apply the percentage adjustment at once.
How do I know if my supplier has raised prices?
Many suppliers send a new price list in advance. Also check your invoices: if you suddenly pay more for the same quantity, prices have gone up.
Do I also need to automatically adjust my menu prices?
No, you do that deliberately. If your ingredient costs rise, you immediately see the impact on your food cost. Then you can decide whether to adjust your menu price or temporarily accept a lower margin.
📚 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.
All your recipes in one place, forever
Recipes in heads, on notes, in folders — that doesn't work. KitchenNmbrs centralizes all your recipes with costs, allergens, and portions. Try it free for 14 days.
Start free trial →