Salon operations
How to Track Salon Backbar Inventory Without a Spreadsheet
A spreadsheet tells you what was on the shelf the day someone counted it. It never tells you what left the shelf, or why. Here's the system that does — and the four numbers worth running it for.
· 11 min read
Almost every salon starts inventory the same way: a tab in a spreadsheet, a Sunday-night count, and good intentions. It works for about six weeks. Then a busy Saturday happens, the count is skipped, and the file quietly becomes a record of what the shelf looked like in March.
The problem isn't discipline. A spreadsheet can only record a count. It cannot record consumption. The moment a stylist mixes a bowl, your number is wrong, and nothing in the file knows it. Any system that depends on a human remembering to write down a deduction will drift, because the deduction happens at the busiest moment of the day.
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 | Healthy 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 |
Industry Benchmark ranges commonly cited for small independent salons. Use them as a direction of travel, not a verdict — a colour-heavy salon sits differently from a barbershop.
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
Pre-tax, per gram or per millilitre — not per tube. You claim HST back as an input tax credit, so an HST-inclusive cost overstates your cost of goods by 13% in Ontario and makes every margin look worse than it is.
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
Take a four-stylist salon doing $42,000 a month in service revenue with backbar running at 14% — $5,880 a month in product. Here's a typical breakdown of where that spend goes once it's measured rather than estimated.
- 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%
That last band — roughly $760 a month — is the one no spreadsheet ever surfaces, because it's defined by the absence of a record. It's over-mixed bowls, unlogged re-dos, staff use and the bottle that got opened for a demonstration. It doesn't feel like $9,000 a year while it's happening.
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.
Sources
- CRA — Input tax credits (GST/HST registrants)
- NeonO — Inventory Management
- 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?
- Most healthy salons run total backbar at 8–12% of service revenue. Above 15%, the cause is usually over-mixing, service prices that haven't moved with product cost, or product leaving the shelf without being recorded.
- 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?
- Shrinkage is product you paid for that never turned into recorded revenue — samples, staff use, breakage, corrective re-dos, and product that simply walks. Under 2% of purchases is normal. Over 5% is a process problem, not a people problem.
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 →