Sales cycle
How do I automate sales commission tracking?
Pull every payment straight from your payment processor, match each one to the setter and closer who earned it using the CRM, and calculate commission from written rules in one place. Reps see their own numbers on a live dashboard. The monthly spreadsheet rebuild, and most of the disputes, go away.
Callum James, CXJ Labs · Updated 9 November 2026
Why spreadsheets get commission wrong
Raymond Panko's audits of real business spreadsheets found important errors in 91% of the 55 spreadsheets in his core studies. Commission sheets are a classic case: copied formulas, manual lookups and deals that change after they close.
In a 2025 survey by CaptivateIQ, a commission-software company, 66% of companies said they had overpaid and/or underpaid commission in the past year. Overpaying costs margin; underpaying costs trust with your best reps.
Five steps to automated commission
- 01
Write the rules down
Rates per role, splits between setter and closer, payment plans, refunds and clawbacks. If two people would calculate it differently, the rule isn't finished.
- 02
Use payments as the source of truth
Commission comes from money received, read directly from the payment processor, not from what someone typed into a sheet.
- 03
Attribute every payment to a deal
Match each payment to the lead, the booking and the reps on it. Payments that can't be matched go to a review queue rather than being guessed.
- 04
Calculate in one place
A database or commission tool applies the rules to every payment, including instalments and refunds, the same way every time.
- 05
Show reps their own numbers live
A dashboard each rep can check any day. Disputes surface while the deal is fresh, not at the end of the month.
Sources
- Spreadsheet Research: audits of operational spreadsheets, Raymond R. Panko, University of Hawaii
- Nearly two-thirds of companies report errors in commission payouts (CaptivateIQ survey), Albany CEO, May 2025
Related answers
Rather have it built for you?
45 minutes, free. We walk your business and you leave knowing exactly what to automate first.