5 Things a Sales Commission Calculator Can't Handle

A sales commission calculator is a fine piece of arithmetic and a terrible system of record. It will tell you what one rep earned, on one plan, in one clean period, assuming nothing about the deal ever changes. That is not the job. The job is working out what 18 reps earned across a quarter in which two deals shrank, three were split, one plan changed on the 14th of the month, and payroll cuts off on Thursday.

TL;DR: A sales commission calculator computes a single figure from quota, rate and attainment — useful for sanity-checking a plan on a whiteboard, useless for running payroll. The five things it cannot handle are tiered rates that depend on period-to-date attainment, accelerators applied retroactively, clawbacks that restate an already-paid period, deal splits where commissionable credit differs from invoiced revenue, and mid-period plan changes. Commission is earnings, so HMRC requires PAYE and Class 1 National Insurance through payroll (GOV.UK guidance on bonuses) — which means a wrong calculator output becomes a wrong payslip, not a wrong draft. If you genuinely need a calculator every month, what you need is software with an audit trail.

What can a sales commission calculator actually work out?

The calculator above does the honest part of the job: one rep, one quota, one rate, one accelerator, one period. Use it to pressure-test a plan before you sign off on it — to see whether 3% with a 1.5× kicker actually pays the OTE you promised at 100% attainment, or whether you have quietly designed a plan that overpays at 140% and underpays at 90%.

What it cannot do is remember anything. Every commission problem that has ever caused a dispute is a problem of state and time: what was true last month, what changed since, what has already been paid, and which version of the plan applied on the day the deal closed. A calculator has no memory, so it has no answer.

The hard part of commission isn't the maths. It's the memory.

Worked example: a 70/30 split with a 1.5× accelerator

Take a UK mid-market AE on £60,000 OTE at a 70/30 split — £42,000 base, £18,000 variable — against an annual quota of £600,000 new ARR (£150,000 a quarter). The commission rate falls out of the plan, it isn't picked from the air: £18,000 ÷ £600,000 = 3%. Past 100% of quota, the plan pays 1.5× — so 4.5%.

The formula, in full:

Commission = (MIN(Revenue, Quota) × 3%) + (MAX(0, Revenue − Quota) × 4.5%)

Q2 closes at £190,000:

Component	Amount	Rate	Commission
Up to quota	£150,000	3%	£4,500
Over quota	£40,000	4.5%	£1,800
Total	£190,000	—	£6,300

At 15% employer's secondary Class 1 National Insurance on earnings above the secondary threshold — £96 a week for 2026 to 2027, per HMRC's rates and thresholds for employers — that £6,300 payout costs the business roughly £7,245 all-in. Worth remembering before you approve the accelerator.

That is the calculator's whole world, and inside it the calculator is right. Now watch it fall apart.

What are the five scenarios a sales commission calculator can't handle?

1. Tiered rates, because the rate depends on where you already are

The deal that takes our AE from £145,000 to £190,000 doesn't have a rate. £5,000 of it earns 3% and £40,000 earns 4.5%. That means the commission on any individual deal is a function of every deal booked before it in the period — and of the ordering rule you chose (close date? invoice date? signature date?). A calculator asks for total revenue because it cannot see the sequence. Once you owe reps a per-deal breakdown, total revenue isn't enough.

2. Accelerators, because they multiply mistakes as well as earnings

Accelerators are the single largest source of downstream pain in UK commission plans, and it isn't because reps over-earn. In practice, an accelerator that rewards over-attainment also magnifies the damage when a big deal later shrinks: the rep was paid the enhanced rate on a number that then falls, so the correction is larger than the original overpayment. Say £40,000 of that £190,000 quarter turns out to sit inside a deal with a customer opt-out window. The customer exercises it. Attainment drops to £150,000 — exactly quota — and the earned figure drops to £4,500. The clawback is £1,800: the entire accelerated tranche, at 4.5%, not 3%. The steeper the accelerator and the larger the deal, the more it pays to hold the payout until the value is genuinely firm. See our breakdown of accelerator design for UK teams for where to set the kink point.

3. Clawbacks, because they restate a period you have already paid

This is where a calculator stops being merely inadequate and becomes actively dangerous. A clawback isn't a calculation, it's an amendment to history: the Q2 figure was £6,300, it is now £4,500, £1,800 has already gone through payroll and been taxed, and someone has to decide whether it's recovered from the next payout, over three months, or waived. The root cause of most of these is not a maths error at all — it's Finance paying on the gross signing-day contract value in a rush to hit the payroll cut-off, before the opt-out window closed. Commission should be calculated on the value actually locked in, not the headline on the signature page, whenever a deal carries opt-out, ramp or cancellation clauses. Our clawback policy guide covers the wording that makes recovery lawful and survivable.

4. Splits, because commissionable credit isn't the invoice

A £190,000 quarter looks very different if one £90,000 deal was worked 60/40 with another AE, or if an SDR carries 10% of it, or if the manager takes an override on top. Now a single invoice generates three or four different credit lines against three or four different quotas, and the sum of commissionable credit exceeds the invoiced value — correctly. A calculator that takes one revenue figure and one rate cannot express that at all.

5. Mid-period plan changes, because rates need effective dates

You raise quota on 1 July but the new accelerator lands on 14 August after board sign-off. Deals closed 1–13 August pay on the old scheme; deals from the 14th pay on the new one; a deal signed on the 12th and invoiced on the 20th pays on… whichever rule your plan document specifies, assuming it specifies one. Every rate in a real commission scheme has an effective date. A calculator has one rate box.

Why doesn't a spreadsheet fix this past five reps?

The usual answer is "put it in Excel", and for five reps on one flat scheme that genuinely works. It stops working not because the arithmetic gets harder but because the spreadsheet has to start doing four things it was never designed for:

• Effective-dated rates. Every tier needs a valid-from and valid-to date, which means rate lookups become date-range lookups across plan versions.
• Reversible history. A clawback must restate a closed month without destroying the record of what was paid and when — so you now need paid-vs-earned as two separate figures per rep per period.
• Many-to-many credit. Splits and overrides break the one-row-per-deal assumption that every commission spreadsheet is built on.
• An audit trail. When a rep queries a number from four months ago, "the formula says £4,500" is not an answer. You need who changed what, when, and why.

Five reps on a quarterly scheme with splits and one mid-quarter plan change is already dozens of interdependent lookups, and the person who built them is the only one who understands them. That's the real cost — modelled properly in our spreadsheet vs commission software cost comparison.

Does the tax treatment change what the calculator should show?

Yes, and this is where a lot of DIY calculators quietly mislead reps. Commission is earnings: HMRC guidance is that employers add it to the employee's other pay and deduct PAYE and Class 1 National Insurance through payroll (GOV.UK). Income tax under PAYE is cumulative across the tax year, so a lumpy commission month self-corrects. Employee National Insurance does not work that way: according to the Low Incomes Tax Reform Group, Class 1 NICs are calculated per pay period and are not cumulative, with the main 8% rate applying up to a monthly upper earnings limit of £4,189 for 2026/27 and 2% above it (LITRG).

The practical consequence: the same £6,300 of commission produces a different net figure depending on whether you pay it in one month or spread it across three, because more or less of it lands above the monthly upper earnings limit. No gross-commission calculator models that, which is why reps who build their own net-pay spreadsheets end up convinced they've been short-paid. Our guide to how commission is taxed in the UK walks through the mechanics.

Calculator vs spreadsheet vs commission software

Requirement	Online calculator	Spreadsheet	Commission software
One rep, one period, flat rate	Yes	Yes	Yes
Tiers and accelerators	Basic	Yes	Yes
Splits and manager overrides	No	Fragile	Yes
Clawback / restated periods	No	Manual, destructive	Yes, versioned
Effective-dated plan changes	No	Manual	Yes
Rep-facing real-time visibility	No	No	Yes
Audit trail of who changed what	No	No	Yes
Payroll export (e.g. Xero)	No	Manual CSV	Automated

So what should you actually do?

One more thing worth saying plainly, because it's the pattern behind almost every commission dispute we see discussed: reps don't lose faith because a number is occasionally wrong. They lose it when they can't see how the number was built and a correction lands with no warning. Real-time visibility and an audit trail prevent more disputes than a cleverer plan or a more precise calculator ever will.

Frequently Asked Questions

Is there a free sales commission calculator that handles clawbacks?

No, and there is a structural reason why not. A clawback requires knowing what was already paid, when, and under which plan version — that is stored state, not a calculation. Any tool that genuinely handles clawbacks is a commission system, not a calculator.

How do you calculate commission with an accelerator past quota?

Split the revenue at the quota line and apply each rate separately: (MIN(Revenue, Quota) × base rate) + (MAX(0, Revenue − Quota) × accelerated rate). On a £150,000 quarterly quota at 3% with a 1.5× accelerator, £190,000 of closed business pays £4,500 + £1,800 = £6,300.

Is commission taxed differently from salary in the UK?

No. HMRC treats commission as earnings, so it goes through payroll with PAYE income tax and Class 1 National Insurance deducted like normal pay (GOV.UK). The take-home figure can look inconsistent month to month because employee NICs are assessed per pay period rather than cumulatively.

At how many reps does a commission spreadsheet stop working?

Head count matters less than plan complexity. A flat-rate scheme can survive 30 reps in Excel; tiers plus splits plus clawbacks plus a mid-quarter plan change will break at five. If a single deal change forces you to edit more than two cells by hand, you have outgrown it.

Should reps be given access to the commission calculation?

Yes — and to the underlying deal-level workings, not just the total. Disputes are a visibility problem far more often than an arithmetic one, and a rep who can see how their number was built rarely needs to open a dispute at all.