Inventory and stock sheet
A spreadsheet to keep track of stock. List each item with its quantity, unit cost and reorder level, and the value of every line, the total value, the items to reorder and the items out of stock are worked out for you. Download it as Excel, OpenDocument, PDF or CSV.
Stock
Inventory and stock sheet
Count what you have, then enter the quantity. Value and the Reorder flag are worked out for every item.
Business or location Hillside Hardware, back store
Counted on 2027-03-31
| SKU | Item | Quantity | Unit cost | Reorder level | Stock value | Status |
|---|---|---|---|---|---|---|
| HW-1001 | Claw hammer 450 g | 24 | 8.90 | 10 | 213.60 | OK |
| HW-1002 | Cordless drill 18 V | 6 | 74.50 | 5 | 447.00 | OK |
| HW-1010 | Wood screws 4 x 40 mm, box of 200 | 58 | 3.20 | 20 | 185.60 | OK |
| HW-1017 | Paint roller set | 4 | 6.75 | 8 | 27.00 | Reorder |
| HW-1022 | Work gloves, pair | 0 | 2.40 | 15 | 0.00 | Reorder |
| HW-1030 | Spirit level 60 cm | 12 | 11.30 | 6 | 135.60 | OK |
| Total | 6 | 104 | 1,008.80 | |||
| Items to reorder | 2 | |||||
| Items out of stock | 1 | |||||
| Most valuable item | Cordless drill 18 V |
