Free salon commission tracking spreadsheet
A ready-made tracker for Excel or Google Sheets: six settings at the top, one row per person, and every formula visible so you can check it. Below, what each column does and the two places spreadsheets usually go wrong.
Updated September 28, 2026
Download the template (CSV) — opens in Excel, Google Sheets or Numbers. In Google Sheets, use File → Import → Upload. The formulas come in live.
The six example rows are made up so you can see the sheet working. Replace them with your own people, and change the settings in column B to match your plan.
The settings
| Setting | Example | What it does |
|---|---|---|
| Team sales goal | $12,000 | The month's target for the whole floor |
| Minimum to earn | 50% | Below this share of their own goal, a person earns nothing |
| Rate at the minimum | 2% | The rate the moment someone crosses the minimum |
| Rate at goal | 4% | The rate at 100% of goal; above it the rate keeps climbing |
| Product share for the bonus | 25% | How much of a person's sales must be retail to earn the bonus |
| Product bonus | $25 | Flat amount for beating that product share |
The columns, left to right
Total sales is service plus product. Personal goal is the team goal split by unique clients: someone who served a third of the team's clients carries a third of the goal. That is the fairest split most salons find, because it measures what a person sold per client they actually saw rather than rewarding whoever worked the most shifts.
% of goal is sales over personal goal. Commission rate is zero below the minimum, then rises in a straight line from the rate at the minimum to the rate at goal, then keeps rising past goal. Sales commission is that rate applied to all of the person's sales, not just the part above the line. Product bonus needs both the minimum and the product share.
What the example rows show
| Person | Sales | Clients | Goal | % of goal | Earned |
|---|---|---|---|---|---|
| Sam | $1,860 | 120 | $2,938.78 | 63.3% | $72.09 |
| Alex | $2,220 | 160 | $3,918.37 | 56.7% | $50.31 |
| Riley | $580 | 45 | $1,102.04 | 52.6% | $37.21 |
| Jordan | $1,050 | 95 | $2,326.53 | 45.1% | $0.00 |
Two things in there surprise people the first time:
- Alex sold the most and isn't first. Alex also saw the most clients, so Alex's goal is the biggest. Sam got more out of each client, and a 27% product mix added the $25 bonus.
- Riley sold $580 and earns $37.21; Jordan sold $1,050 and earns nothing. Riley cleared 50% of a small goal; Jordan is at 45% of a bigger one. That is the minimum-to-earn cliff doing exactly what it is designed to do — and why it needs explaining to staff before payday, not after. More on how thresholds behave.
Where spreadsheets go wrong
1. The goal is worked out once and never again
Because the personal goal is a share, it moves every time anyone serves a client. A sheet that fills in goals on the 1st and pastes sales in on the 20th is comparing today's sales with a goal from three weeks ago. Keep the goal as a formula, as the template does, and refresh the client counts whenever you refresh sales.
2. Somebody types over a formula
One hand-typed number in the rate column and that row stops following the plan — and nothing on the sheet says so. If you need to adjust someone's pay, add a separate "adjustment" column rather than overwriting a calculated one, so the reason is visible.
3. The month is closed on the wrong numbers
Whatever the sheet says when you stop updating it is what gets paid. Pull the final report after the last shift of the month, and pull it for the whole month — first to last day — rather than keeping the last mid-month export.
When a spreadsheet stops being enough
A sheet is fine for the owner. The problem is everybody else: staff can't see where they stand until you send it, so the numbers only motivate once a month, after the month is over. If you want your team checking their own progress on their phones during the month, that's what CommissionBoard does — same maths as this sheet, updated from your POS through the day. Or try the numbers for one person in the salon commission calculator.
CommissionBoard turns a POS export into a live commission leaderboard your staff can see on their phones. Start a trial, try the commission calculator or read the other guides.