What Is a Sales Commission Clawback? (And How to Track One in Excel)

What is a sales commission clawback?

A sales commission clawback is a provision in a comp plan that allows a company to recover previously paid commissions if certain conditions occur after a deal closes — most commonly, the customer churning or cancelling within a defined window.

The logic is straightforward: if a rep closes a deal that immediately churns, they shouldn't keep the full commission. Clawbacks align rep incentives with actual customer outcomes, not just signature events.

Why SaaS companies use clawbacks

In subscription businesses, the value of a deal isn't realized at close — it's realized over the contract lifetime. Without clawbacks, a rep has every incentive to close any deal that will get through legal, even if the customer is a poor fit. With clawbacks:

• Reps have skin in the game on customer quality, not just volume
• There's a natural check on sandbagging deals at quarter-end that might not stick
• The cost of early churn is shared between the company and the person who brought the deal in

Most early-stage SaaS companies introduce clawbacks once churn becomes measurable — typically after 12–18 months of selling.

How the clawback window works

The clawback window defines how long after a deal closes a churn can trigger commission recovery. The most common windows:

The window is measured from the contract start date — not the date commission was paid. This matters: if you pay commission in the month following close, a 90-day window still runs from the original close date.

What triggers a clawback

Clawback triggers vary by company. The most common:

• Full churn / cancellation — the customer cancels entirely within the window. Full commission recovered.
• Significant downgrade — the customer reduces ARR materially (e.g., 50%+). Some plans clawback proportionally.
• Customer non-payment — less common, but some plans include failed payment after a grace period.
• Deal reversal — the contract is voided or refunded post-close.

How to track clawbacks in Excel

The cleanest approach is a dedicated Clawback Log tab with one row per churned deal. Here's the column structure:

The "Within Window?" formula checks whether the churn happened within 90 days of close. The "Clawback Amount" formula only applies the recovery if the window check returns "Yes".

To deduct clawbacks from a rep's current-period payout, use SUMIF to pull the total clawback amount per rep:

Then subtract that from their gross commission in the main calculator:

One thing to watch out for

If a clawback amount is larger than a rep's current-period commission — common if they had a slow month — you have two options: carry the balance forward to the next period, or cap the deduction at the current payout. Decide your policy upfront and build it into the formula.

How to communicate clawbacks to reps

Clawbacks only create friction when they're a surprise. To keep things clean:

• Put the window and triggers explicitly in the comp plan document (not just a verbal mention)
• Show clawback deductions as a line item on per-rep payout statements — not as a silent reduction to gross payout
• Give reps a heads-up when a deal enters the at-risk window, if possible
• Be consistent — applying clawbacks selectively is the fastest way to destroy rep trust