Excel for salons, barbershops and spas

Q: How do I calculate stylist commission in Excel?

For a flat rate, multiply service sales by the rate: =B2*40%. For tiers paid on each slice: =MIN(B2,1500)*40%+MAX(0,MIN(B2,2500)-1500)*45%+MAX(0,B2-2500)*50%, with the steps and rates in their own cells.

For salon and spa owners, managers and booth renters who want the numbers behind a busy book. Excel works out tiered commission the right way, shows each stylist's rebooking and retail attach rate, finds your average ticket, prices services by the minute so every chair hour pays its way, and keeps a tip log. Every formula below runs on one week at an eight-chair salon you can edit.

Salon and spa owners
Salon managers and front desk leads
Barbershop owners
Stylists, barbers and estheticians tracking their own book
Booth and suite renters

Sample data

Every result on this page comes from this sheet, calculated by the same engine the Cellwise app uses. Change a number and watch the formulas react.

	A	B	C	D	E	F	G	H
1	Stylist	Services	Retail	Clients	Rebooked	Bought retail	Pay and targets
2	Ana	2860	410	34	24	12	Tier 2 starts at	1500
3	Bri	1740	95	29	13	4	Tier 3 starts at	2500
4	Cam	2210	260	31	21	9	Tier 1 rate	0.4
5	Dev	1320	40	26	9	2	Tier 2 rate	0.45
6	Eli	3050	520	30	23	14	Tier 3 rate	0.5
7	Fay	980	120	18	10	6	Retail commission	0.1
8	Gus	1460	75	42	31	3	Rebook target	0.6
9	Hana	2440	180	27	17	7	Retail attach target	0.3

What Excel does for salons and spas

Pay tiered commission on each slice of sales

A common tiered plan pays one rate on the first slice of service sales and a higher rate only on the sales above each step, the way tax brackets work. Here that is 40% up to $1,500, 45% from $1,500 to $2,500 and 50% above $2,500 for the week.

Each slice is a MIN or MAX: the first slice is the smaller of sales and the tier 2 start, the middle slice is whatever falls between the two steps (never less than 0), and the top slice is whatever is above tier 3. Add up each slice times its rate.

=MIN(B2,H2)*H4+MAX(0,MIN(B2,H3)-H2)*H5+MAX(0,B2-H3)*H6

Result: 1230

$1,230 for Ana on $2,860 of services: $600 on the first $1,500, $450 on the next $1,000 and $180 on the last $360.

Or pay the reached tier on everything

Some salons pay the rate of the tier reached on all of the week's sales instead. It is simpler to explain but expensive at the edges: one extra $40 service that pushes a stylist over a step raises the rate on every dollar before it.

Write down which plan you use and test both on a real week before you promise either. IFS checks the tiers from the top down and stops at the first one that is true.

=B2*IFS(B2>=H3,H6,B2>=H2,H5,TRUE,H4)

Result: 1430

$1,430 for Ana under this plan, $200 more than the slice method on the same $2,860 of sales.

Track your rebooking rate

Rebooking rate is the share of clients who book their next appointment before they leave. It is the best early sign of a full book next month, and it is coachable: the stylists who rebook well ask every client at the chair.

For the whole salon, divide total rebooked by total clients. Averaging each stylist's percentage would give Fay's 18 clients the same weight as Gus's 42.

=SUM(E2:E9)/SUM(D2:D9)

Result: 0.62447257384 shows as 62.4% with Percent format

62.4% of this week's 237 clients rebooked before leaving, just over the 60% target in H8.

Find who is below the rebook target

A number is easier to act on with names next to it. FILTER keeps the stylists whose rebooked clients divided by total clients is under the target, and TEXTJOIN lists them in one cell for the Monday huddle.

FILTER needs Excel 365 or Excel 2021 or later. In older versions, add a helper column with =E2/D2 and count with COUNTIF.

=TEXTJOIN(", ",TRUE,FILTER(A2:A9,E2:E9/D2:D9<H8))

Result: Bri, Dev, Fay

Bri, Dev and Fay are under 60%. Dev is lowest: 9 of 26 clients rebooked, 34.6%.

Measure retail attach rate

Attach rate is the share of service clients who also bought a product. It tells you more than retail dollars alone: one big sale can hide a week when nobody recommended anything.

Count a client once even if they bought three products. Then set a target and track it per stylist.

=SUM(F2:F9)/SUM(D2:D9)

Result: 0.24050632911 shows as 24.1% with Percent format

24.1%: 57 of 237 clients took home a product, under the 30% target in H9. Eli leads at 46.7% (14 of 30).

Work out your average ticket

Average ticket is total sales, services plus retail, divided by the number of clients. A SUM over the two columns at once adds both.

Watch it next to client count: raising prices lifts the ticket, but if clients drop it is not a win. Per stylist, the ticket also shows who is offering add-ons like gloss or treatment.

=SUM(B2:C9)/SUM(D2:D9)

Result: 74.936708861 shows as $74.94 with Currency format

$74.94 per client: $17,760 of sales across 237 tickets. Gus's barber chair runs a lower ticket ($36.55) on many more clients.

Practice: 8 exercises

Use the sample data above. Type a formula and press Check: it is graded by a real spreadsheet engine, the way Cellwise grades lessons.

1What were total service sales this week?

Your formula for exercise 1

Show answer
=SUM(B2:B9) = 16060. SUM adds every stylist's service sales: $16,060.
2How many clients did the salon see?

Your formula for exercise 2

Show answer
=SUM(D2:D9) = 237. The eight stylists saw 237 clients between them.
3What is Cam's rebooking rate (row 4)?

Your formula for exercise 3

Show answer
=E4/D4 = 0.67741935484. 21 of 31 clients rebooked: 67.7%.
4What retail commission does Eli (row 6) earn at the rate in H7?

Your formula for exercise 4

Show answer
=C6*H7 = 52. $520 of retail at 10% is $52.
5How many stylists sold more than $2,000 of services?

Your formula for exercise 5

Show answer
=COUNTIF(B2:B9,">2000") = 4. Ana, Cam, Eli and Hana: 4 stylists.
6What is Gus's average ticket (row 8), services plus retail per client?

Your formula for exercise 6

Show answer
=(B8+C8)/D8 = 36.547619048. ($1,460 + $75) / 42 is $36.55. Brackets make the addition happen before the division.
7Using the slice method and the tiers in H2:H6, what service commission does Bri (row 3) earn?

Your formula for exercise 7

Show answer
=MIN(B3,H2)*H4+MAX(0,MIN(B3,H3)-H2)*H5+MAX(0,B3-H3)*H6 = 708. $1,500 at 40% is $600, and the $240 above it at 45% is $108: $708. Nothing reaches tier 3.
8Which stylist has the highest retail attach rate?

Your formula for exercise 8

Show answer
=INDEX(A2:A9,MATCH(MAX(F2:F9/D2:D9),F2:F9/D2:D9,0)) = Eli. Eli: 14 of 30 clients bought retail, 46.7%, ahead of Ana at 35.3%.

Free templates for salons and spas

Guided project: Weekly tips and income log

Log a week of tips, work out tip % and tips per client, and find your best day.

6 steps in the Cellwise app. Each step checks your formula in a real grid, with hints when you get stuck. Part of Cellwise Plus.

Open guided projects

Guides for these formulas

FAQ

How do I calculate stylist commission in Excel?

For a flat rate, multiply service sales by the rate: =B2*40%. For tiers paid on each slice: =MIN(B2,1500)*40%+MAX(0,MIN(B2,2500)-1500)*45%+MAX(0,B2-2500)*50%, with the steps and rates in their own cells.

How do I calculate rebooking rate?

Divide the clients who booked their next visit before leaving by all clients seen in the period: =E2/D2 per stylist, or =SUM(E2:E9)/SUM(D2:D9) for the salon. Format the cell as a percentage.

What is retail attach rate for a salon?

The share of service clients who also bought a retail product: clients with a retail purchase divided by total clients. It shows how often stylists recommend products, which retail dollars alone can hide.

How do I track tips in Excel?

Log card and cash tips per day in separate columns, add them for a daily total, and divide by service sales for tip %. Total the week with SUM and divide total tips by total services, rather than averaging the daily percentages.

Excel for other fields

Updated November 2, 2026