Hair Salon Inventory Spreadsheet
For salons tracking professional color tubes, developer, lightener, backbar shampoo and foils. Know which shades are low before a full day of color appointments.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Item | Category | Lot # | Location | Unit | Qty | Min Qty | Statusƒ | Expiry | Days to Expiryƒ | Unit Cost | Valueƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Permanent Color Tube, 7N, 2 oz | Color | HC25-7N-0618 | Color Bar Drawer 7 | tube | 8 | 4 | auto | 2027-06-30 | auto | 8.25 | auto | Mane Street Salon Supply |
| Cream Developer 20 Vol, 32 oz | Developer | DV25-20-1102 | Color Bar Shelf | bottle | 5 | 3 | auto | 2027-12-31 | auto | 9.5 | auto | Mane Street Salon Supply |
| Pre-Cut Foil Sheets 5x11, 500-ct | Tools & Disposables | FL25-0077 | Color Bar Shelf | box | 6 | 3 | auto | auto | 14 | auto | Studio Beauty Distributors |
ƒ = calculated automatically by formula.
What's included
- Item
- Category
- Lot #
- Location
- Unit
- Qty
- Min Qty
- Status — calculated automatically
- Expiry
- Days to Expiry — calculated automatically
- Unit Cost
- Value — calculated automatically
- Supplier
Tips for using this template
- Count color tubes by shade weekly and reorder against booked color services for the next two weeks.
- Track developer by volume (10, 20, 30, 40) and keep the sizes your stylists actually mix with.
- Weigh backbar products to measure usage per service and spot heavy-handed pours.
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 TemplateMedical Office Supply Inventory TemplateDental Office Inventory SpreadsheetVeterinary Clinic Inventory TemplateLab Chemical Inventory SpreadsheetFirst Aid Kit Inventory TemplateSpa Inventory TemplateTattoo Shop Inventory SpreadsheetPPE Inventory Template