Free Excel template · Excel for salons and spas

Free salon commission calculator template

For salon owners and managers who pay stylists on commission and want every payday to be right and easy to explain. Enter each stylist's service sales, retail sales and tips for the pay period, and the template takes off the product charge, pays tiered commission on each slice of sales, adds retail commission and tips, and totals the pay. The tiers, product charge and retail rate are input cells, so you can model a new pay plan before you announce it.

cellwise-salon-commission-calculator.xlsxExcel workbook · 4.5 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	Stylist commission and pay
2	Pay period starts	Oct 19, 2026
3	Pay period ends	Nov 1, 2026
4
5	Service commission tiers: sales from	Rate on that slice
6	0	0.4
7	3000	0.45
8	5000	0.5
9	Product charge (% of service sales)	0.05
10	Retail commission	0.1
11
12	Stylist	Service sales	Product charge	Commissionable	Service commission	Retail sales	Retail commission	Tips	Total pay
13	Ana	5720	286	5434	2317	820	82	940	3339
14	Bri	3480	174	3306	1337.7	190	19	510	1866.7
15	Cam	4420	221	4199	1739.55	520	52	705	2496.55
16	Dev	2640	132	2508	1003.2	80	8	380	1391.2
17	Eli	6100	305	5795	2497.5	1040	104	1120	3721.5
18	Hana	4880	244	4636	1936.2	360	36	790	2762.2
19	Total	27240	1362	25878	10831.15	3010	301	4445	15577.15
20

How the formulas work

Product charge before commission

C13=ROUND(B13*$B$9,2)

Many salons take a small percentage off service sales to cover the color, developer and back-bar product used on clients, and pay commission on the rest. Set B9 to 0 if you do not. Ana's $5,720 has a $286 product charge, so commission is paid on $5,434.

Tiered commission, one slice at a time

E13=ROUND(MIN(D13,$A$7)*$B$6+MAX(0,MIN(D13,$A$8)-$A$7)*$B$7+MAX(0,D13-$A$8)*$B$8,2)

The first $3,000 earns 40%, the slice from $3,000 to $5,000 earns 45%, and anything above $5,000 earns 50%. MIN caps each slice and MAX(0, ...) keeps a slice at zero when sales never reach it. Ana: $1,200 + $900 + $217 = $2,317.

Retail commission

G13=ROUND(F13*$B$10,2)

A flat rate on product sales. Some salons pay a higher retail rate to encourage recommendations; change B10 and every row updates.

Total pay for the period

I13=E13+G13+H13

Service commission plus retail commission plus tips. Tips are kept in their own column so each stylist sees the full picture while B22 shows the commission the salon itself pays.

What commission really costs you

B21=IF(B19>0,E19/B19,0)

Service commission divided by service sales. With tiers and a product charge it is not any of the headline rates: here it is 39.8%, under the 40% first tier, because of the product charge. Use it when you price services, since it is the share of each service dollar that goes to the stylist.

Make it yours

Make the tier steps match the pay period. Weekly steps on a two-week pay period pay out tier 3 far too easily.
Pay rules for commission staff, such as minimum pay per hour and overtime, depend on where you are. Check them with your payroll provider; this sheet only does the commission math.
Pull service and retail sales from the same report in your booking software every time, so refunds and discounts are handled the same way.
Model a pay plan change by copying the sheet and editing A6:B10. Compare B21 on both copies before you decide.

FAQ

How do I calculate tiered commission in Excel?

Split sales into slices and multiply each slice by its rate: =MIN(sales,3000)*40%+MAX(0,MIN(sales,5000)-3000)*45%+MAX(0,sales-5000)*50%. Put the steps and rates in cells so you can change them without editing the formula.

What is a product charge or back-bar fee?

A percentage of service sales some salons deduct before calculating commission, to cover the professional products used during services. If your salon uses one, set the percentage in B9; if not, set it to 0.

Should tiers apply to each slice or to all sales?

Both plans exist. Slice-based tiers pay the higher rate only on sales above each step, so pay rises smoothly. All-sales tiers pay the reached rate on everything, which creates big jumps at each step. Whichever you use, write it down and show stylists the formula.

Functions used

Related guides

More free templates

Updated November 2, 2026