Cash Flow Forecast Template for Salons & Spas

Salons and spas turn appointments into cash quickly, but a lot of that cash belongs to someone else: stylists on commission, suppliers for colour and retail products, and the landlord. Quiet weeks after the holidays and summer holidays hit hard when rent and core staff costs stay the same. A cash flow forecast helps salon owners see how much is really left after commission and plan for the quiet months.

Why salon cash flow is different

• Commission follows sales. Stylists and therapists are often paid 35 to 50 percent of service sales, so costs move with revenue.
• Retail products need stock. Shampoo, skincare and styling products are bought ahead and sold at a margin.
• Chair rental changes the model. Renting chairs brings steady income but less upside.
• Memberships add stability. Monthly membership plans smooth income through quiet months.
• Gift cards are liabilities. Gift cards sold in December are services owed in January and February.

A worked example

A salon takes about $48,000 a month, of which $34,500 is services and $5,800 retail. Stylists earn 45 percent of service sales, and retail product costs 50 percent of retail sales.

January’s service sales fall 30 percent, but rent and overheads don’t. Gift cards sold in December will be redeemed in January, bringing in no new cash. Seeing that in November lets the owner push memberships and pre-booking before the holidays.

How to build a salon cash forecast

1. Forecast service and retail sales by month, using appointment history.
2. Calculate commission as a percentage of service sales.
3. Tie product purchases to retail sales and colour usage.
4. Add chair rent received, memberships and gift card sales.
5. Add rent, booking software, utilities, laundry and marketing.
6. Keep a buffer for January and the summer.

Common mistakes

Counting gift card sales as income to spend. Forgetting commission on a busy month’s sales when planning purchases. Overstocking retail. And paying yourself from December’s takings without checking January.

What the template gives you

The Salon & Spa template includes a Commissions tab that calculates stylist pay and retail product cost from sales, and a Memberships tab that builds monthly membership income from members, sign-ups, churn and price. Change your January forecast and the commission and product lines update automatically.

Key assumptions built into the Salon & Spa template

• The Memberships tab builds “Memberships” from members: 80 at the start, new members each month, 4% leaving each month and an average of $65 per member per month. It shows members lost, members at month end and revenue, so you can see exactly what a change in churn is worth.
• The Commissions tab calculates stylist commission at 45% of service sales and retail product cost at 50% of retail product sales. Change a percentage once and every month of the forecast updates, so costs rise and fall with the sales that drive them.
• 5 cash in lines and 7 cash out lines are already named for salon & spa businesses, and every one can be renamed or extended.
• The example figures follow a typical salon & spa year, busiest in December and October and quietest in January and February, so the tight months show up where they usually fall.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Salon & Spa template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Salon & Spa cash flow forecasting: questions

What commission do salon stylists usually earn?

Commonly 35 to 50 percent of the service revenue they generate, depending on experience and whether the salon provides products and bookings.

Are salon memberships good for cash flow?

Yes. Monthly memberships bring in predictable income, especially in quieter months, and encourage regular visits.

How should gift cards appear in a salon cash flow forecast?

Record the cash when sold, but remember the service is still owed. Plan for redemption periods when appointments bring in less new cash.