All templates
Business
Inventory Tracker
Know what is in stock, what is running low and what it is worth.
Stock3 rows
| # | AItem | BSKU | CIn stock | DReorder at | EUnit cost | FValue | GStatus |
|---|---|---|---|---|---|---|---|
| 1 | Copper elbow 15mm | CU-15E | 84 | 40 | 1.20 | 100.80 | OK |
| 2 | Boiler filter | BF-200 | 6 | 10 | 18.50 | 111.00 | Reorder |
| 3 | PTFE tape | PT-01 | 52 | 20 | 0.85 | 44.20 | OK |
What it tracks
- Stock levels
- Reorder points
- Stock value
Included sheets
StockMovementsSummary
Key calculations
- Value
- =InStock*UnitCost
- Status
- =IF(C2<=D2,"Reorder","OK")