Free Excel template · Excel for salons and spas

Free salon service menu pricing template

For salon and spa owners setting or reviewing a service menu. Enter how long each service takes, the product it uses and today's price, and the template shows revenue per hour, the break-even price after commission and overhead, a price that hits your profit target per chair hour, and which services need a look. It turns "what does everyone else charge" into "what does this service need to charge".

cellwise-salon-service-pricing.xlsxExcel workbook · 4.9 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	F	G	H	I
1	Service menu pricing
2	Stylist commission on services	0.45
3	Salon overhead per chair hour	24
4	Target profit per chair hour	12
5	Round prices up to the next	5
6
7	Service	Minutes	Product cost	Current price	Revenue per hour	Break-even price	Price for target	Profit at current	Check
8	Women's cut and style	60	4.5	75	75	51.82	75	12.75	OK
9	Men's cut	30	1.5	38	76	24.55	40	7.4	Under target
10	Kids cut (under 12)	30	1	28	56	23.64	35	2.4	Under target
11	Blowout	45	3	50	66.67	38.18	55	6.5	Under target
12	Single-process color	90	14	110	73.33	90.91	125	10.5	Under target
13	Partial highlights	120	22	165	82.5	127.27	175	20.75	Under target
14	Full balayage	180	38	260	86.67	200	270	33	Under target
15	Gloss or toner	30	8	45	90	36.36	50	4.75	Under target
16	Keratin smoothing	150	45	275	110	190.91	250	46.25	OK
17	Event updo	60	5	95	95	52.73	75	23.25	OK
18
19	Services below break-even	0
20	Services under target	7

How the formulas work

Revenue per hour

E8=IF(B8>0,ROUND(D8/B8*60,2),0)

Price divided by minutes, times 60. It puts a 30-minute toner and a 3-hour balayage on the same scale: the gloss brings in $90 an hour, the women's cut $75.

Break-even price

F8=ROUND((C8+B8/60*$B$3)/(1-$B$2),2)

The service has to cover its product and its share of overhead (hours in the chair times overhead per chair hour) out of what is left after commission. Commission is a share of the price, so you divide by 1 minus the commission rate rather than adding it on. A 60-minute cut with $4.50 of product needs $51.82 just to break even at 45% commission and $24 an hour of overhead.

Price for your target profit

G8=ROUNDUP((C8+B8/60*($B$3+$B$4))/(1-$B$2)/$B$5,0)*$B$5

The same idea with your target profit per chair hour added to overhead, rounded up to the next $5 (set in B5). It is a floor to compare with your market, not a price you must charge.

Profit at today's price

H8=ROUND(D8*(1-$B$2)-C8-B8/60*$B$3,2)

What the salon keeps from one service after commission, product and overhead. The check column turns it into Below break-even, Under target or OK, and B19:B20 count them.

Make it yours

Work out overhead per chair hour from a real month: rent, utilities, software, front desk, insurance and supplies, divided by the hours your chairs are booked, not the hours you are open.
Time services from booking to chair cleared, including processing time if the chair cannot be used. A color with a 30-minute process ties up the chair for all of it unless you double-book.
Use the commission rate you really pay. With tiers, that is the blended rate from your commission sheet, not the headline 40%.
Change one price at a time and watch client count for a month before moving the next.

FAQ

How do I price salon services?

Start from cost: product used, plus the service's share of overhead (minutes in the chair times overhead per minute), divided by 1 minus the commission rate. Add your target profit per hour for the price you want, then compare with nearby salons.

Why divide by 1 minus commission instead of adding it?

Commission is a percentage of the price, not of your costs. If 45% goes to the stylist, only 55% of the price is left for product, overhead and profit, so the price is costs / 0.55.

What is revenue per chair hour?

Price divided by the hours a service occupies the chair. Comparing it across services shows which ones fill the book profitably and which ones look busy but earn little per hour.

Functions used

Related guides

More free templates

Updated November 2, 2026