Small Business Inventory Template
A simple stock list for shops and small businesses: track quantity on hand, stock value and when to reorder — formulas included.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Category | Location | Unit | Qty on Hand | Reorder Point | Unit Cost | Stock Valueƒ | Statusƒ | Supplier | Last Received |
|---|---|---|---|---|---|---|---|---|---|---|---|
| SKU-1001 | Black T-shirt (M) | Apparel | Shelf A1 | pcs | 24 | 10 | 6.5 | auto | auto | Acme Wholesale | 2026-10-02 |
| SKU-1002 | Canvas tote bag | Accessories | Shelf A2 | pcs | 8 | 12 | 3.2 | auto | auto | BagCo | 2026-09-18 |
| SKU-1003 | Gift box (small) | Packaging | Back room | pcs | 150 | 50 | 0.45 | auto | auto | PackRight | 2026-10-11 |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Category
- Location
- Unit
- Qty on Hand
- Reorder Point
- Unit Cost
- Stock Value — calculated automatically
- Status — calculated automatically
- Supplier
- Last Received
Tips for using this template
- Set a reorder point for every item; the Status column turns to REORDER automatically.
- Update quantities when stock arrives by pasting rows from our invoice to inventory converter.
- Sort by Stock Value to see where your cash is tied up.
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.