Sales Compensation Software Benchmark
Download
Diagonal gradient streaks in soft orange, purple, and blue fading into white at the bottom.
Revenue Ops
Reading time
10
min

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.

By
·
October 2, 2026

How to use the commission clawback calculator

This commission clawback calculator shows how much commission a rep returns when a customer churns, downgrades, receives a refund or leaves an invoice unpaid during the clawback period.

01

Choose the event and enter the deal

Select churn, downgrade, refund or non-payment, then fill in the deal value (ARR or ACV), the commission rate, the rep's credit share and the number of months of service before the event.

02

Define the clawback policy and plan

Choose the clawback period and a full, prorated or stepped method, state whether the commission has already been paid, and add the plan's accelerator where there is one.

03

Compare methods and plan the recovery

Compare payout reversal, negative credit and retroactive recalculation, then set a cap per statement to build the repayment schedule. Share the scenario with a link or export it as a CSV file.

What the calculator models

Each element of a commission clawback policy, from the event that triggers it to the final repayment, sits in one tool.

01

Four clawback events

Run a full churn, a downgrade to lower ARR, a partial refund or an unpaid invoice, and bring only the value actually lost into scope.

02

Full, prorated or stepped

Recover everything, prorate by months of service or define your own bands, and see the amount due at each month of the period.

03

Treatment methods compared

Put payout reversal, negative credit and retroactive recalculation side by side when the plan pays an accelerator above quota.

04

Recovery plan

Spread the balance across future commission statements with a cap on each, and read the deduction, net commission and remaining balance statement by statement.

05

Split deals and Finance exposure

Scale the clawback to the rep's credit share, track the team commission still exposed in open periods and generate a draft clause from your inputs.

Commission Clawback Calculator

Size the clawback on a lost deal, compare treatment methods and plan the recovery.

Deal and event
Clawback policy
Clawback method
Until month%
Until month%
Rest of period%
Plan and treatment
Commission status
Treatment method ?
Recovery and Finance
Clawback amount
—
—
Commission kept
—
—
% recovered
—
—
Fully earned after
—
—
Clawback amount by month of service
Treatment methods compared
MethodClawbackvs payout reversal
Recovery plan
StatementCommission dueDeductedPaid to repBalance left

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.

From calculator to automation

From one-off calculation to automated clawbacks

The calculator works on one deal at a time. A live commission scheme sees clawbacks every month, from churn flagged in the CRM to refunds and unpaid invoices, each under its own period and method.

Qobra picks up those events from the CRM, applies each plan's clawback rules and posts the adjustment to the rep's commission statement, with an audit trail behind every figure. Reps can see why their commission moved, Finance can see what remains exposed, and the result feeds the payroll export. UK teams are supported from Qobra's UK office, opened in June 2024.

Automate clawbacks with Qobra →
Events picked up from the CRMChurn, refunds and unpaid invoices recorded in the CRM trigger the clawback automatically, so nobody rebuilds the calculation in a spreadsheet.
Each plan's rules appliedEvery plan's clawback period and method are applied as written, and the adjustment appears on the rep's commission statement ready for payroll.
Clear for reps, visible to FinanceReps understand why their commission changed, Finance tracks the amounts still exposed, and each adjustment keeps a full audit trail for review.

FAQ — Commission clawback calculator

What is a commission clawback?

A commission clawback is a term in the commission scheme that lets the organisation recover commission it has already paid, or cancel commission not yet paid, when the revenue behind it is lost. Usual triggers are churn, cancellation, refunds, downgrades and unpaid invoices within a clawback period set out in writing.

How is a clawback calculated?

Take the lost value, multiply it by the commission rate, then apply the share your method recovers: 100% under a full method, (period − months of service) ÷ period under a prorated one, or the relevant band's percentage under a stepped schedule. Where the plan pays accelerators, the treatment method changes the result too.

Can you give me an example of a clawback?

Yes. A rep paid 10% on a £24,000 deal receives £2,400. If the customer cancels after 3 months, inside a 6-month full clawback period, all £2,400 is recovered. Under a 12-month prorated policy, a cancellation after 4 months would recover 8/12 of the commission, or £1,600.

Are commission clawbacks legal?

In Great Britain, recovering commission through a deduction from pay is governed by the Employment Rights Act 1996 (section 13). The deduction needs a written contractual term given to the worker beforehand, or the worker's written agreement in advance. Whether a particular clawback is lawful also depends on the plan's wording and on when commission counts as earned. This page is not legal advice, so take advice from an employment lawyer before applying a clawback.

Are bonus clawbacks enforceable?

A bonus can carry a clawback if the document that sets it up says so clearly. Bonuses count as wages under section 27 of the Employment Rights Act 1996, so the same rules on deductions apply as for commission. Ask an employment lawyer to review the clause before you request repayment of a bonus already paid.

What is a clawback payment?

A clawback payment is the sum a rep pays back, or the deduction taken from future commission, once a clawback is triggered. It can be settled in one repayment or through several capped deductions, such as 50% of each statement. Because commission runs through PAYE and National Insurance, ask your payroll team or accountant how a repayment of pay already processed should be handled, including any effect on commission capitalised under IFRS 15 or FRS 102.

How long after a sale can a company claw back commission?

Only for as long as the clawback period in the plan allows. The period is a design choice, so test 3, 6 and 12 months against your own churn before you fix it. Once the period ends, the commission is earned in full.

What is the difference between a clawback and a chargeback?

In sales compensation, the two words describe one recovery from different angles. The clawback is the policy that recovers commission when revenue is lost. A commission chargeback usually refers to the negative line that results on the rep's statement, a term also widely used in insurance. The arithmetic is the same in both cases.

By
·
October 2, 2026