Free XLSX template

Ingredient Inventory Sheet

Track opening stock, receipts, usage, adjustments, reorder points, package rounding, and estimated purchase cost.

Preview of the Ingredient Inventory Sheet workbook

What is included

  • 15 ingredient rows
  • Movement-based on-hand formula
  • Reorder shortage
  • Whole-package purchase estimate

How to use it

  1. Enter one consistent stock unit for each ingredient, then record opening stock, receipts, usage, and signed adjustments.
  2. Set a reorder point and package size in that same unit.
  3. 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