
Commission Clawback Calculator: Full, Prorated & Tiered
Free commission clawback calculator: see how much commission comes back when a deal churns, is refunded or downgraded, and plan the recovery.
The clawback amount is the sum the rep returns, or the sum withheld if the commission has not yet been paid. The other KPIs, the comparison of treatment methods and the repayment schedule show what that figure means for the rep and for Finance.
How to calculate a commission clawback
Whatever the method, the starting point is the commission originally paid on the value the business has lost. The method then decides what share of that commission is recovered.
Full clawback formula
Under a full method, the amount recovered equals the lost value multiplied by the commission rate, provided the event falls inside the clawback period. Once the period has ended, the rep keeps the commission in full.
Prorated clawback formula
A prorated method reduces the recovery for every month the customer stayed: lost value × commission rate × (clawback period − months of service) ÷ clawback period. On a 12-month period, a customer who leaves after 4 months triggers a recovery of 8/12 of the commission.
Stepped clawback schedule
A stepped schedule sets one percentage per band of months. One illustrative set of bands is 100% to month 3, 50% to month 6 and 25% to the end of the period, which is an example rather than a UK market norm. Applied to a £30,000 refund commissioned at 10%, an event in month 4 falls in the 50% band and claws back £1,500.
Worked commission clawback examples in pounds sterling
All three scenarios below are presets in the calculator, and each one uses a 10% commission rate.
Full churn inside the window
A customer worth £24,000 in ARR cancels in month 3 of a 6-month full clawback period. At 10%, the rep was paid £2,400 on the deal, and the whole £2,400 is recovered. With a 50% cap and a £6,000 commission statement, the balance is cleared on a single statement.
Partial downgrade
A £60,000 customer moves down to £36,000 after 3 months on a 12-month prorated policy. Only the £24,000 of lost ARR is in scope. Nine of the twelve months remain, so 75% applies: £24,000 × 75% × 10% = £1,800 is recovered, and the rep keeps £4,200 of the £6,000 earned on the deal.
When accelerators are involved
Take a rep on a £100,000 quota per period, paid 10% up to quota and 15% beyond it. The rep books £70,000, then a £48,000 deal, then £40,000. That deal line was worth £5,700: £30,000 at 10% plus £18,000 at 15%. The customer leaves after 4 months of a 12-month prorated period, which puts £32,000 of value in scope.
The treatment method then drives the sales commission clawback. Payout reversal recovers two thirds of the deal line, or £3,800. A negative credit booked in a current period that already holds £80,000 costs £3,200 at the 10% rate. Retroactive recalculation strips £32,000 from the top of the original period, where the 15% rate applied, for £4,800.
For the retroactive, non-retroactive and combined approaches, read our guide on how commission clawbacks work.
Clawback triggers and the length of the clawback period
The triggering event sets the value at stake, and the clawback period decides whether that value still counts.
Churn, cancellation and refunds
When a customer churns or cancels, the full deal value is at stake. A partial refund only puts the refunded sum in scope. When the recovery appears as a negative line on the commission statement, some teams call it a commission chargeback.
Downgrades and non-payment
For a downgrade, only the commission on the lost ARR comes back. Unpaid invoices follow the same logic on the outstanding amount, and a plan that pays on cash received simply holds the commission until the money arrives. To check how commission was paid in the first place on ARR, ACV or multi-year contracts, use the saas commission calculator.
Choosing a clawback period
Size the period to the risk it is meant to cover. It should be long enough to catch customers who never really onboarded, yet short enough for reps to know when their commission is safe. Try 3, 6 and 12 months in the calculator and watch how the Finance exposure moves.
Recovering the clawback amount through UK payroll
Once the amount is known, the commission scheme must spell out how it is recovered and over what timescale.
Offset against future commissions
An offset nets the balance off against the next commission statements. Capping each deduction, for example at 50% of a statement, keeps take-home pay predictable. The calculator lists the deduction, the net commission and the remaining balance for each statement.
Most UK employee jobs are paid monthly (77.6% in ONS figures for April 2021), so if statements follow payroll, a recovery over three statements spans roughly a quarter. ACAS guidance on overpayments offers a sensible model for any recovery: tell the worker before deducting anything, agree how the money will be repaid and use a repayment plan for larger sums.
Direct repayment
A direct repayment settles the balance in one go, typically when a rep leaves before future commission can absorb it. HMRC's employer guide says a payment made after the P45 has been issued goes through PAYE on code 0T, on a non-cumulative basis. What happens to commission owed or recovered on leaving depends on the plan's written terms, so take advice from an employment lawyer before asking a leaver to repay.
Splitting a clawback across reps
Where several people shared the credit, the clawback follows the same split, so at a 60% credit share every figure is scaled to 60%. To agree the split itself between an AE, an SDR and an overlay role, use the commission split calculator.
Commission clawbacks and UK employment law: deductions from wages
This calculator sizes an amount, and whether you can recover it is a separate question. In Great Britain, the answer turns on the Employment Rights Act 1996, the employment contract and the wording of the commission scheme. The points below are general information, not legal advice.
Commission counts as wages
Section 27 of the Employment Rights Act 1996 defines wages as including any fee, bonus, commission or holiday pay referable to the employment. Commission is therefore subject to the same rules on deductions as basic salary. HMRC guidance treats it the same way for tax, since commission goes through payroll for both PAYE and Class 1 National Insurance contributions.
Section 13: a written basis before any deduction
Under the Employment Rights Act 1996 (section 13), an employer may only deduct from a worker's wages if the deduction is required by law, authorised by a written term of the contract given to the worker beforehand, or agreed by the worker in writing in advance. Section 13(3) also treats paying less than the wages properly payable as a deduction, so withholding commission that is already due falls under the same rule. That is why the plan should state clearly when commission counts as earned, not only how it is calculated.
Overpayments: do not assume the exception applies
Section 14 of the Act excludes deductions that reimburse an overpayment of wages. No official guidance says that commission recovered after a customer cancels counts as an overpayment, so a clawback policy should not rest on that assumption. Ask an employment lawyer how your clause should be framed.
Minimum wage and payslips
ACAS guidance says a deduction must not take pay below the National Minimum Wage unless it is for specific reasons, such as tax, National Insurance or an overpayment made by mistake. For workers aged 21 and over, the National Living Wage has been £12.71 an hour since April 2026, and the OTE calculator explains how commission counts towards it. Every deduction must also be shown on the payslip, which gov.uk guidance says must give pay before and after deductions.
Time limit for a tribunal claim
A worker who disputes a deduction from wages can bring a claim before an Employment Tribunal. According to gov.uk, the time limit for most claims rose from three months to six on 1 October 2026. The text of section 23 published on legislation.gov.uk still shows three months, because the change has not yet been incorporated there. Check the deadline that applies to a given case with an employment lawyer.
Put the clawback in the written plan
Set out the triggers, period, method and recovery terms in the commission scheme document, and give it to the rep before any commission is paid. The written statement of employment particulars must already cover how pay is calculated and how often it is paid, and the sales quota calculator page covers what that means for targets. Our sales commission agreement template gives you a structure to start from, and the calculator's clause draft reuses your inputs. Have an employment lawyer review the final wording before you apply any clawback.



