Retail Store Inventory Template
Track every product with cost and retail price side by side so you can see margin and stock value at a glance.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Category | Location | Unit | Qty on Hand | Reorder Point | Unit Cost | Retail Price | Margin %ƒ | Stock Valueƒ | Statusƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RT-200 | Ceramic mug 12oz | Kitchen | Aisle 2 | pcs | 36 | 12 | 3.1 | 12 | auto | auto | auto | HomeGoods Dist. |
| RT-201 | Scented candle | Decor | Aisle 4 | pcs | 9 | 15 | 4.2 | 18 | auto | auto | auto | Glow Supply |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Category
- Location
- Unit
- Qty on Hand
- Reorder Point
- Unit Cost
- Retail Price
- Margin % — calculated automatically
- Stock Value — calculated automatically
- Status — calculated automatically
- Supplier
Tips for using this template
- Margin % = (retail − cost) ÷ retail.
- Run a full count monthly and a spot check weekly on fast movers.
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.