Clothing Boutique Inventory Template
Made for small apparel boutiques that buy in size runs and need to know which sizes and colors are actually selling. Track every style-color-size as its own SKU with cost and vendor.
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| DR104-NVY-M | Wrap Midi Dress, Navy, M | Dresses | Floor Rack 2 | each | 4 | 2 | 28 | auto | auto | Coastline Apparel Group |
| TP220-IVR-S | Linen Button Top, Ivory, S | Tops | Stockroom Shelf A | each | 7 | 3 | 16.5 | auto | auto | Sunday Thread Wholesale |
| JN310-BLK-28 | High-Rise Skinny Jean, Black, 28 | Denim | Floor Wall 1 | each | 5 | 2 | 31 | auto | auto | Indigo Row Clothing |
ƒ = 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
Tips for using this template
- Build SKUs as style-color-size (e.g. DR104-NVY-M) so you can sort and see which sizes sell out first in each buy.
- Review sell-through at six weeks; anything under about 40% is a markdown candidate before the next season lands.
- Count the back stockroom and the floor separately so you know when to replenish racks, not just when to reorder.
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.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateAuto Parts Inventory TemplateHardware Store Inventory SpreadsheetConvenience Store Inventory SpreadsheetGift Shop Inventory TemplateBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory TemplateJewelry Store Inventory Spreadsheet