
Salon operations
Salon Inventory Management: Stock Counts and Reordering
Separate backbar from retail, record stock movements and use actual consumption to plan your next order.
Published: · 11 min read
By NeonO · Updated:
How do you manage salon inventory?
Track retail products separately from backbar products consumed during services. Record deliveries, sales, service use and adjustments in consistent units, reconcile those records with physical counts, and set reorder points from usage, supplier lead time and a safety buffer. Start with high-turnover, high-cost or expiry-sensitive items.
A spreadsheet can support this process if stock movements are recorded consistently; a shelf count alone cannot show what was used between counts. The checklist below covers the fields to record and the differences to investigate before adjusting stock.
A weekly salon stock-count checklist
Choose a count time and one person responsible for adjustments. Separate retail, backbar consumables and durable tools. For each item record SKU, location, unit, physical quantity, recorded quantity, unit cost and expiry where relevant. Use the same unit for receiving, service usage and counts.
Record deliveries, retail sales, service use, re-dos, samples, spills and returns separately. Investigate differences before adjusting stock. Start cycle counts with high-turnover, high-cost or expiry-sensitive items, then schedule a full physical count. The weekly/monthly cadence here is a suggested starting point, not a rule for every shop.
The four numbers worth tracking
Before you touch a tool, decide what you're actually trying to learn. Four numbers cover almost everything a salon owner needs to make a decision.
| Number | What it answers | Illustrative planning range |
|---|---|---|
| Backbar cost % | Is product cost eating my service margin? | 8–12% of service revenue |
| Retail margin % | Is the shelf earning its floor space? | 45–55% gross |
| Weeks of cover | Am I holding too much cash on a shelf? | 4–6 weeks on fast movers |
| Shrinkage % | How much product never became revenue? | Under 2% of purchases |
These ranges are illustrative planning assumptions, not independently verified salon benchmarks. Set targets from your own service mix, costs and usage records.
Why the spreadsheet breaks
Picture a Thursday. Three colour clients back to back, a walk-in blow-dry, and a retail sale at 6:40pm. Here is what actually gets recorded in each system.
Spreadsheet
- Count happens once a month, if the month is calm
- Colour mixed mid-service is never written down
- Corrective re-dos draw product with no ticket attached
- Reorder decided by looking at the shelf
- Cost per service is an estimate, revisited yearly
Deducted at checkout
- Every service carries its own product recipe
- On-hand falls as the ticket closes
- Re-dos are logged as a zero-revenue draw
- Reorder list is generated from actual usage
- Cost per service is a live number, per stylist
Set it up in one afternoon
The reason most inventory projects die is scope. Salons try to enter 400 SKUs at once. Don't. Start with the twenty percent of products that account for most of your spend, and let the tail wait.
1.Pull your last three distributor invoices
Sort by dollars spent, not by line count. The top twenty percent of items usually accounts for seventy to eighty percent of your product spend. That list is your entire starting scope.
2.Record the true unit cost
Use consistent units, such as grams or millilitres, and separate recoverable tax from cost only when you are eligible to claim it. GST/HST registration and input-tax-credit conditions matter; ask your accountant whether tax belongs in your recorded product cost.
3.Write a recipe for your ten most-booked services
Root retouch, full head of foils, gloss, blow-dry, beard trim. Grams of colour, millilitres of developer, one pump or two. Approximate is fine on day one; precision comes from use.
4.Deduct at checkout, not at count time
This is the part a spreadsheet cannot do. When the ticket closes, the recipe comes off the shelf. Counting becomes a verification step instead of the source of truth.
5.Count weekly on fast movers, monthly on the rest
A ten-minute Monday count of thirty items keeps the system honest. A two-hour count of every SKU gets skipped, and a skipped count is how the whole thing unravels.

Where the money actually is
Consider a hypothetical four-stylist salon with C$42,000 monthly service revenue and backbar at 14%, or C$5,880. The chart is an invented allocation for a worked example, not observed salon data or a promised result.
- Colour and lightener$2,650 · 45%
- Developer$940 · 16%
- Treatments and bond builders$810 · 14%
- Shampoo, conditioner, styling$720 · 12%
- Unrecorded draws and over-mixing$760 · 13%
The C$760 band is an assumed allocation in this example. In a real count, an unexplained variance needs investigation; it could reflect units, delivery errors, unlogged use or other causes. Do not label it all as avoidable waste.
Backbar at 14% of $42,000 = $5,880 / month
Backbar at 10% of $42,000 = $4,200 / month
Difference = $1,680 / month
Annualised = $20,160 / yearFigures above are a worked illustration on a four-stylist salon, not a promise. Run the same arithmetic on your own distributor invoices — the shape of the answer tends to hold even when the numbers don't.
What tightening it up looks like month by month
Backbar percentage doesn't fall because you bought software. It falls because measurement changes behaviour: weighed mixing, logged re-dos, and prices that finally move with product cost.
Reordering without guessing
Most salons reorder by eye: the shelf looks thin, so they call the distributor. That produces two failure modes at once — a stockout on the colour everyone books, and eleven tubes of a shade you use twice a year.
Set a par level per item, not per order
Par level is simply the quantity that covers your lead time plus a buffer. If your distributor delivers in five business days and you use six tubes a week, your reorder point is around eight tubes, not “when it looks low”.
Weekly usage = 6 tubes
Lead time = 1 week
Safety buffer (30%) = 1.8 tubes
Reorder point ≈ 8 tubes
Order quantity (4 wks) = 24 tubesWatch weeks of cover, not dollars on the shelf
A $9,000 stockroom is fine if it turns every four weeks and alarming if it turns every four months. Weeks of cover is the number that tells you which one you have, and it's the fastest way to release cash without changing a single price.
Retail is a different business
Backbar is consumed and belongs in cost of service. Retail is sold and belongs in gross margin. Tracking them in one list is the most common reason a salon can't explain its own numbers.
| Question | Backbar | Retail |
|---|---|---|
| Where does the cost land? | Cost of service | Cost of goods sold |
| What does success look like? | Lower % of service revenue | Higher turns per year |
| Who decides quantity? | Service mix and recipes | Sell-through rate |
| Typical mistake | Never deducted | Over-ordered on launch |
A twelve-week rollout that survives contact with a Saturday
Step 1
Weeks 1–2: top 20% only
Costs loaded, recipes written for ten services.
Step 2
Weeks 3–6: deduct at checkout
Team logs re-dos and staff use as zero-revenue draws.
Step 3
Weeks 7–9: par levels
Reorder points set from real usage, not memory.
Step 4
Weeks 10–12: price review
Services above target cost get repriced or re-scoped.
By week twelve you should be able to answer one question without opening a spreadsheet: what did product cost me on that service, for that stylist, last Tuesday? If the answer is instant, the system is working. If it takes an afternoon, you still have a spreadsheet — it just lives somewhere else now.
Related reading: What hair colour costs per service · Colour Studio · Client export checklist
Sources
- CRA — Input tax credits (GST/HST registrants)
- NeonO — Inventory Management
- CRA — Inventory and cost of goods sold
- Worked examples use illustrative Canadian wholesale pricing in CAD.
Common questions
- How often should a salon count backbar inventory?
- Count the fast-moving twenty percent of items weekly and everything else monthly. A full count of every SKU every week is the reason most salons abandon inventory tracking within two months.
- What is a good backbar cost percentage?
- There is no universal target established by this article. Calculate your own product cost as a percentage of service revenue, then set a target that reflects your service mix, wholesale costs and prices. The numerical ranges below are planning examples, not verified industry benchmarks.
- Why does a spreadsheet stop working for salon inventory?
- A spreadsheet records a count; it doesn't record consumption. It can't tell you a colour tube left the shelf during a specific service, so the number is stale the moment someone mixes a bowl. Deducting product at checkout is what makes the count self-maintaining.
- Should retail and backbar be tracked separately?
- Yes. Retail is sold inventory with a margin; backbar is consumed inventory that belongs in your cost of service. Mixing them into one number hides both a retail margin problem and a service pricing problem at the same time.
- What is shrinkage in a salon?
- Inventory variance is the difference between the recorded balance and the physical count. Investigate deliveries, units, unlogged service use, spills, samples and returns before assigning a cause. An unexplained difference is not proof of theft or waste.
Let checkout do the counting
NeonO deducts backbar product against the service that used it, so your on-hand number updates itself and your reorder list writes itself. No parallel spreadsheet to maintain.
See Inventory Management →