Business template
Inventory tracker
Keep stock levels, values and reorder points in one place. Items at or below their reorder point are highlighted and collected on a ready to send reorder list.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
3 sheets
- Inventory
- Reorder list
- Suppliers
80 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 285 filled cells in all.
Built in
- Conditional formatting
- Dropdowns
- Tables
- Dynamic arrays
- Frozen headers
- 3 conditional format rules
A look at the Inventory sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Inventory tracker | |||||||
| 2 | Lumen and Loom Home Goods. Update On hand after each delivery or stock count. | |||||||
| 3 | STOCK VALUE | ITEMS TO REORDER | OUT OF STOCK | REORDER COST | ||||
| 4 | $4,708 | 5 | 2 | $2,261 | ||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | SKU | Item | Category | Supplier | On hand | Reorder at | Reorder qty | Unit cost |
| 8 | LL-TH-01 | Linen throw, oat | Textiles | Fernway Textiles | 24 | 10 | 20 | $38.00 |
| 9 | LL-TH-02 | Linen throw, sage | Textiles | Fernway Textiles | 8 | 10 | 20 | $38.00 |
| 10 | LL-CU-01 | Wool cushion cover | Textiles | Fernway Textiles | 31 | 12 | 24 | $17.50 |
| 11 | LL-TT-01 | Waffle tea towel, 2 pack | Textiles | Fernway Textiles | 0 | 15 | 40 | $6.20 |
| 12 | LL-MG-01 | Stoneware mug, speckled | Ceramics | Clayborne Ceramics | 46 | 24 | 48 | $7.80 |
- inventory
- stock
- reorder
- suppliers
More business templates
BusinessInvoiceA clean, printable invoice with line items, discount, tax and a due date worked out from your payment terms. The balance due updates as you type.
BusinessExpense reportLog business expenses and mileage for a period and see exactly what is owed back. Company card spending is tracked but not reimbursed.
BusinessPurchase orderCreate a purchase order by picking a vendor from your list; their contact details and payment terms fill in automatically. Track received and open quantities per line.
BusinessRecipe cost calculatorCost out a recipe from your ingredient price list, including trim and cooking loss. See the cost per serving, food cost percentage and a suggested menu price.
Start your inventory tracker now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.