Warehouse Inventory Template
Stock control by bin location with opening stock, received, shipped and a running balance.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Bin | Unit | Opening | Received | Shipped | Balanceƒ | Reorder Point | Statusƒ | Unit Cost | Valueƒ |
|---|---|---|---|---|---|---|---|---|---|---|---|
| WH-5001 | Pallet wrap 500mm | A-01-02 | roll | 40 | 24 | 30 | auto | 20 | auto | 9.9 | auto |
| WH-5002 | Carton 40x30x20 | B-03-01 | pcs | 600 | 0 | 420 | auto | 250 | auto | 0.62 | auto |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Bin
- Unit
- Opening
- Received
- Shipped
- Balance — calculated automatically
- Reorder Point
- Status — calculated automatically
- Unit Cost
- Value — calculated automatically
Tips for using this template
- Use a consistent bin code format like A-01-03 (aisle-rack-shelf).
- Reconcile Received against supplier packing slips.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.