Free XLSX template
Ingredient Inventory Sheet
Track opening stock, receipts, usage, adjustments, reorder points, package rounding, and estimated purchase cost.

What is included
- 15 ingredient rows
- Movement-based on-hand formula
- Reorder shortage
- Whole-package purchase estimate
How to use it
- Enter one consistent stock unit for each ingredient, then record opening stock, receipts, usage, and signed adjustments.
- Set a reorder point and package size in that same unit.
- Review suggested whole packages and estimated purchase cost before buying.
Example calculation
Reorder: 3.8 kg shortage ÷ 2 kg pack → 2 whole packs. Illustrative only; replace every example row before real use.
Formula assumptions and limits
- On-hand = opening + received − used + adjustment; shortage is max(0, reorder point − on-hand).
- Package count rounds shortage up to whole packs; no unit conversion, expiry check, or supplier price feed is built in.
File and compatibility
Format: Microsoft Excel workbook (.xlsx). Microsoft Excel, LibreOffice Calc, or import into Google Sheets.
License
Free for your bakery's internal business use. Do not resell or redistribute the unchanged file.
Data note
The downloaded file stays on your device and is separate from your online workspace; edits do not sync between them. Bake Pricing does not receive values entered into the file. Financial results depend on your inputs. Keep backups and remove example rows before real use.
Download Ingredient Inventory Sheet← All templates