Beauty Supply Store Inventory Template
For beauty supply shops carrying hair care, color, extensions, tools and nail products in many shades. Track shade-level SKUs and distributors so popular colors stay on the wall.
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| BS-COL-6N-PERM | Permanent Hair Color, 6N Dark Blonde | Hair Color | Color Wall Row 3 | each | 9 | 4 | 4.1 | auto | auto | Glow Beauty Distributors |
| BS-EXT-1B-18 | Synthetic Braiding Hair, 1B, 18 in. | Extensions | Wall B / Hooks | pack | 40 | 20 | 1.75 | auto | auto | Crown Hair Wholesale |
| BS-TOL-FLT-1 | Ceramic Flat Iron, 1 in. | Tools | Locked Case | each | 6 | 2 | 22 | auto | auto | Glow Beauty Distributors |
ƒ = 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
- Give each shade its own SKU; customers rarely accept a substitute shade, so a single gap costs the sale.
- Spot-check high-theft items like lashes and edge controls weekly and keep them near the register.
- Note batch or expiry on hair color and relaxers during counts and sell the oldest stock first.
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 SpreadsheetClothing Boutique Inventory TemplateConvenience Store Inventory SpreadsheetGift Shop Inventory TemplateBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory Template