How to Track Batch Inventory & Expiry Dates in Excel
Learn a manual lot inventory workflow, reconcile on-hand stock and prioritize expiry dates. Includes a worked example and a free CSV starter.
Read guideExcel Inventory, Pricing & Purchase Order Templates
A maker needs three different records: what is on hand, what each finished unit costs, and what a supplier still owes. These Microsoft Excel workbooks handle those tasks separately, so you can start with the record that is missing from your current process.
Compare the actual files
Current prices are in USD for a one-time digital download. Check the limited preview and software requirements for each tool.
| Product and preview | Price | Formats | Software requirements |
|---|---|---|---|
| Batch Inventory & Expiry Tracker Limited preview | $19.00 USD | XLSX · CSV · PDF | XLSX workbooks designed for Microsoft Excel with automatic calculation enabled. No macros. CSV companions are sample records and do not contain the XLSX calculations. The PDF guide needs a reader; other spreadsheet apps have not been tested. |
| Maker Cost & Pricing Calculator Limited preview | $15.00 USD | XLSX · CSV · PDF | XLSX workbooks designed for Microsoft Excel with automatic calculation enabled. No macros. Use consistent material units and one currency. CSV companions are sample records and the PDF guide needs a reader; other spreadsheet apps have not been tested. |
| Supplier & Purchase Order Tracker Limited preview | $15.00 USD | XLSX · CSV · PDF | XLSX workbooks designed for Microsoft Excel with automatic calculation enabled. No macros. Receipts are entered as cumulative totals. CSV companions are sample records and the PDF guide needs a reader; other spreadsheet apps have not been tested. |
Use a consistent workflow
Choose one task, replace the sample inputs and keep records you can reconcile.
Browse all 14 toolsReconcile stock by lot
Record an item and a unique lot before recording movements. Keep quantities in a consistent unit and compare calculated balances with a physical count. The inventory workbook is a manual ledger; it does not deduct recipe ingredients automatically or sync stock with a store.
Cost the usable finished unit
Separate material quantity, usable yield, packaging, labor, overhead and selling fees. A material purchase is not the same as the cost of one sellable unit. Use the pricing guide and small free CSV to inspect margin versus markup before working with a complete recipe.
Follow up outstanding purchases
Enter ordered quantities and cumulative receipts, then review open and overdue lines. The supplier tracker organizes your own purchase records and renewal dates; it does not issue purchase orders, send supplier emails or verify legal compliance.
Read the method first
Worked examples and free resources explain the assumptions before you buy a complete tool.
How to Price Handmade Products: Cost, Margin & Markup
Calculate handmade unit costs, labor and overhead, then compare target margin with markup. Worked example and a free pricing CSV starter.
Read guide