Why commission spreadsheets go wrong

Nobody sets out to pay someone wrongly. Spreadsheet commission errors almost never come from bad arithmetic — the sheet does the arithmetic perfectly. They come from the sheet doing perfect arithmetic on the wrong cells.

1. The new hire outside the range

A total like SUM(C2:C9) covers eight people. Hire a ninth, add them in row 10, and the team total — and every goal share calculated from it — silently leaves them out. Nothing turns red. The sheet is simply wrong until someone notices the totals don’t match the POS.

2. A formula overwritten by hand

Someone types a number over a formula to “fix” one month — a returned product, a manager’s adjustment. Next month the formula is gone, the typed number stays, and that cell no longer changes when sales do. Spreadsheets don’t distinguish a calculated cell from a typed one unless you go looking.

3. Thresholds off by one

“More than 25% product” and “at least 25% product” are different rules, and in a formula they differ by one character: > or >=. The person at exactly 25.0% gets a different answer depending on which was typed, and whoever built the sheet may not remember which rule you meant. The threshold guide shows how much rides on that edge.

4. The pasted report that shifted

Most commission sheets start with a POS report pasted into a tab. If the POS adds a column, reorders employees, or someone’s name appears slightly differently, every lookup that relied on position points at the wrong numbers — and still returns a number, so nothing looks broken. See what to watch for in a POS report.

5. Last month’s rules on this month’s sales

When the plan changes — a new rate, a new bonus — a sheet copied from last month carries the old rules forward unless every affected cell is updated. When the sheet is also the only record of past months, correcting it can quietly rewrite what you already paid.

6. One person holds it together

Every commission sheet has an author who knows which cells not to touch. When they are on holiday or leave, month end stops or someone guesses. The rules of your pay plan end up living in formulas rather than written down where staff can read them.

7. Nobody sees it until payday

This is the costliest problem and the one no formula fixes. A sheet updated once at month end tells staff what happened, not what to do. Share the sheet during the month and you share everyone’s sales with everyone; keep it private and people work blind until the 1st. Either way the commission can’t do its real job, which is to change what happens on the floor while there’s still time.

What to do instead

1. Write the plan down in plain words — rates, goals, thresholds and bonuses, including which side of each line counts. If it only exists as formulas, it isn’t a plan anyone can check.
2. Calculate from the POS report itself, not from numbers retyped or pasted into positions. The report is the source; everything else is a copy that can drift.
3. Show each person their own numbers during the month, privately, and keep coworkers to what you are comfortable sharing — usually earnings, not sales.
4. Keep each closed month as it was paid, separate from the current one, so fixing this month can’t change last month.

That is what commission software is for. CommissionBoard reads your POS report — Helios salons connect directly — applies your written plan the same way every time, shows each person where they stand on their phone, and closes each month into a PDF payroll report. It is $20 a month per location — see how it works, or read what to look for in commission software. To check a single number by hand in the meantime, the commission calculator does one person’s month.