Two inventories, not one
Ingredients are bought by weight; finished goods are sold by unit. Mixing them in one list hides both waste and shortages. Keep an ingredient list (with unit cost) and a daily finished-goods list (made, sold, unsold, rejected).
A weekly routine that takes under an hour
| When | Task |
|---|---|
| On delivery | Check quantity, dates and temperature; update stock |
| Daily | Record finished goods made, sold and wasted |
| Weekly | Count the top 15 ingredients by value; compare with par level |
| Monthly | Full count; update unit costs and recipe costs |
Par levels and reorder points
Par level = average use per day × days until the next delivery + safety stock. See bakery par levels explained.
When to move from spreadsheets to software
Software helps once you have recipes, several staff and custom orders. Look for recipe-based ingredient deduction, finished-stock posting after the bake and stock shown at checkout. POS Bakery does this in bakery inventory management; compare tools with the bakery POS buying guide.
