To stop commission errors reaching payroll, lock the inputs at a cut-off, reconcile closed deals in the CRM to what was actually booked, test every plan rule, rate and split, send anything outside the rules to a named approver with the evidence, and publish a per-deal statement reps can check. The aim is to catch errors before payday, not in a dispute three months later.
Why errors keep happening
Commission errors are rarely about arithmetic. They come from the inputs: a deal marked closed-won in the CRM that was never booked, a split agreed in a hallway and never recorded, a mid-year plan change applied to the wrong months, a spreadsheet formula copied one row too far.
They are expensive in ways that do not show up in the payroll total. In CaptivateIQ's February survey of 500 US sales professionals (CaptivateIQ sells commission software), 77% had experienced payout errors, sellers spent an average of 1.6 hours a week checking their own pay, and 31% had left or considered leaving a sales role over repeated errors. Commissions also affect the books: under ASC 340-40, incremental costs of obtaining a contract, such as commissions, are generally capitalized and amortized, so an error in the payout is often an error in the accounts too.
Step 1: Lock the inputs before you calculate
Set a cut-off date each period and freeze what goes into the run:
- The signed plan document for each rep, with quota, territory, rates and any accelerators
- Approved SPIFs and one-off incentives, in writing
- The list of deals closed in the period, as of the cut-off
- Approved crediting and split agreements
Anything that changes after the cut-off goes into the next period, as a visible adjustment.
Step 2: Reconcile closed deals to booked revenue
Compare closed-won deals in the CRM with booked orders in the ERP or billing system. Check amount, close or booking date, term, product mix and customer. Explain every difference before you calculate anything.
The usual gaps: a deal closed in the CRM but not yet booked, a multi-year deal with only year one booked, a discount applied at booking that the CRM does not show, or a deal booked to a different customer account.
Step 3: Check plan rules, rates and splits
Recalculate independently from the plan rules rather than checking the spreadsheet against itself:
| Check | What goes wrong |
|---|---|
| Rate tiers and accelerators | Applied at the wrong attainment level, or before the quota is reached |
| Splits | Percentages that do not add to 100%, or a split on the wrong rep |
| Crediting | Deal credited to the wrong territory or to a rep who left |
| Caps, draws and clawbacks | Cap not applied, draw not recovered, clawback missed |
| New hires and leavers | Pro-rating missed for part-period quotas |
Step 4: Review exceptions and approve
Anything that breaks a rule or falls outside a tolerance goes to review with the evidence attached: the deal record, the booking, the plan clause. Sales leaders decide crediting disputes. Finance approves the totals and the payroll file.
Flag any rep whose payout moves sharply from the previous period without an obvious reason. Most errors show up as surprises.
Step 5: Publish statements reps can check
Give each rep a statement listing every deal that paid, the rate applied, any split, and any adjustment or clawback, with the reason. Set a short dispute window and a single way to raise a dispute. Track disputes by cause and fix the cause upstream, usually in CRM data or crediting rules.
Where AI agents fit
Steps 2 to 4 are where agents help most: reconciling CRM deals to bookings, recalculating each payout from the plan rules, and preparing a list of variances with the evidence attached before payroll closes. People still decide disputes and approve the run. In our revenue operations service, commission checks are measured on variances caught before payroll, and each check is recorded in the Evidence File.