Learn why manual commission tracking causes disputes and how to automate it based on real deal data.
It's the end of the month. A sales rep says he closed a $50K deal. You mark him down for commission: $3,750.
Two weeks later, the customer hasn't signed. The deal fell apart. But you already promised the rep his commission.
Or the opposite: The rep closes the deal, but another rep also claims credit (they did the initial demo). Now you have a dispute. Who gets the commission? You spend an hour arguing instead of celebrating the win.
This is why commission tracking is broken in most companies.
The Commission Problem
Manual tracking creates disputes
When commission is tracked in a spreadsheet, two people can look at it and see different things. Who closed the deal? Was it closed-won or still in negotiation? Did they collect the payment?
No single source of truth = disputes.
Commission is calculated incorrectly
A rep is owed commission on "closed" deals. But what does "closed" mean?
- Contract signed?
- Payment received?
- Subscription billing started?
Different companies have different answers. This ambiguity leads to errors.
Commission is disconnected from reality
A rep was told they'd get 10% of deal value. They close a $50K deal. But the sales manager says there was a 20% discount applied, so it's really $40K, so commission is $4K, not $5K. Rep disagrees.
No transparency = frustration.
Commission disputes kill morale
A rep feels cheated, even if they're not. They start looking for a new job. Turnover is expensive.
The Right Way to Structure Commission
Every rep should have a commission document that spells out:
- What deals qualify for commission (new customers? upsells? non-contracted?)
- What stage triggers commission (contract signed? payment received? both?)
- What's the commission rate
- Any exceptions or special cases
> - New customer contracts: 10% of contract value
> - Commission triggered when: Contract signed + first payment received
> - Exceptions: Deals discounted >30% require manager approval
> - Bonus: Close 5+ deals in a month = 12% commission for that month
Track based on deal progression
A deal moves through stages:
- Prospecting → Qualification → Proposal → Signed Contract → Payment Received
You should track commission based on the stage where payment/approval happens (usually contract signing or payment received).
Track by who did the work
If multiple people worked on a deal, credit should be split. Examples:
- Inside sales rep sourced the lead (20% credit)
- Account executive did the demo and closed (80% credit)
- Split: ISR gets 20% × commission, AE gets 80% × commission
Build in accuracy checks
Don't pay commission until:
- Deal is signed AND
- Payment is received (or first payment for subscriptions)
This prevents paying commission on deals that don't actually close.
Automated Commission Tracking
The problem with manual tracking: it's slow, error-prone, and creates disputes.
The solution: Automatic commission calculation
1. Deal is marked as "closed-won" in CRM
2. Payment is recorded (from payment processor or accounting system)
3. Commission is automatically calculated based on the rep's plan
4. Rep can see their commission anytime in their dashboard
5. No disputes because the system is transparent
Here's what automated tracking looks like:
Rep Sarah closes a $20K deal on Jan 15:
- Deal moves to "closed-won"
- Payment received Jan 16 ($20K hits your bank account)
- Commission auto-calculated: $20K × 10% = $2,000
- Sarah sees it in her dashboard immediately
- No argument. No guessing. No spreadsheet errors.
Compare to manual tracking:
Sales manager tracks commission in Excel. At month-end, he has a list of 47 deals. He manually calculates commission for each. He makes math errors on 3 of them. One rep disputes his calculation. Month-end takes 4 hours instead of 30 minutes.
Automation advantages:
- Real-time accuracy (no math errors)
- Transparency (reps see their commission whenever)
- No disputes (it's automatic, based on data)
- Audit trail (you can see exactly how commission was calculated)
- Time savings (manager saves 4 hours/month)
Commission Structures That Work
Structure 1: Percentage of contract value
Example: 10% of deal value
Pros: Simple, predictable, scales with deal size
Cons: Incentivizes big deals, not quality deals. A $100K bad fit counts the same as a $100K great customer.
Use when: You want to encourage deal volume.