What's the Best Way to Calculate Tiered Commissions? (From Someone Who's Actually Done It)
Been trying to figure this out for my team and honestly getting frustrated with all the conflicting advice out there. Our current system is a disaster - half the reps can't figure out their pay, and I'm spending hours every month explaining calculations.
We're a 35-person SaaS company, mix of inside sales and field reps. Quotas range from $800K to $2M annually. Right now we have this overly complex thing with different rates for new business vs expansion, territory multipliers, and quarterly adjustments that nobody understands.
CEO wants it simplified by next quarter. Finance wants predictable costs. Sales team wants to actually know what they're earning.
Here's what I've learned trying to fix this mess:
The Problem With Our Current Setup (And Probably Yours Too)
Our system tries to do everything:
- Different rates for different product lines
- Territory difficulty adjustments
- Quarterly performance bonuses
- Team achievement multipliers
- Seasonal variations
Result? Reps spend more time questioning their paychecks than selling.
Last month, our top performer thought she earned $8,400. Actual payout was $6,200. She couldn't figure out why, and honestly, neither could I without diving into the spreadsheet for 30 minutes.
Three Systems I've Actually Tested
Option 1: Simple Progressive Tiers
How it works:
- 0-80% quota: 2% commission
- 80-100% quota: 4% commission
- 100-120% quota: 6% commission
- 120%+ quota: 8% commission
Example: $150K sales on $125K quota
- First $100K (80%): $2,000
- Next $25K (to 100%): $1,000
- Final $25K (above 100%): $1,500
- Total: $4,500
What happened when we tested this:
- Reps could calculate earnings instantly
- Finance loved the predictability
- Motivation stayed consistent across all performance levels
Downside: Top performers said the jump from 6% to 8% wasn't motivating enough
Option 2: Accelerator Model
How it works:
- Base 3% on all sales
- 100% quota = 1.5x multiplier on total commission
- 120% quota = 2.2x multiplier on total commission
Same example: $150K sales on $125K quota
- Base commission: $4,500 (3% of $150K)
- Hit 120% quota: Apply 2.2x multiplier
- Total: $9,900
What happened when we tested this:
- Our top 20% went absolutely crazy trying to hit accelerators
- Created massive motivation spikes at threshold levels
- Middle performers felt like the system wasn't built for them
Downside: Super volatile commission costs, and people just below thresholds felt screwed
Option 3: Flat Monthly Tiers
How it works:
- 0-75% quota: $1,000/month
- 75-100% quota: $3,500/month
- 100-125% quota: $6,000/month
- 125%+ quota: $8,500/month
Same example: Hit 120% quota = $6,000 commission
What happened when we tested this:
- Finance could budget commission costs perfectly
- Reps knew exactly what hitting each level meant
- Eliminated the "what's my commission rate on this deal?" questions
Downside: Felt disconnected from actual sales performance - selling $200K vs $180K paid the same
What Actually Matters (Learned This the Hard Way)
Simplicity beats optimization. Our fancy system with 12 variables performed worse than basic progressive tiers.
Reset frequency is huge. Annual accumulation killed motivation. Quarterly resets kept energy high all year.
Transparency tools are non-negotiable. Built a simple calculator in Google Sheets. Commission disputes dropped to almost zero.
Don't change mid-year. We adjusted thresholds in July once. Team revolted. Learned that lesson.
Which One Are We Going With?
Progressive tiers (Option 1) with quarterly resets.
Why? It's simple enough that everyone gets it, fair across all performance levels, and predictable enough for finance.
We're tweaking the rates a bit:
- 0-80%: 1.5%
- 80-100%: 3.5%
- 100-120%: 6%
- 120%+: 9%
The bigger jump to 9% addresses the top performer feedback about motivation.
The Mistakes That Almost Killed Our Implementation
Even with the progressive tier model, we screwed up the rollout initially. Sharing these so you don't make the same errors:
Mistake 1: Not accounting for pipeline timing We launched the new system January 1st. Sounds logical, right? Wrong. Our sales cycle is 4-6 months, so reps had deals in pipeline from the old system closing under new commission rules. Created massive confusion about which rates applied to which deals.
Fix: We ended up honoring old rates for any deal that was in "proposal sent" stage or further on launch day. Much cleaner.
Mistake 2: Forgetting about split deals Our old system had complex rules for deals involving multiple reps. New system had nothing. First split deal that closed, two reps both claimed full commission under the new tiers.
Fix: Simple rule now - split deals divide the commission dollar amount equally, not the commission rate. So if a $100K deal generates $4,000 commission, each rep gets $2,000, regardless of tier.
Mistake 3: No transition period We killed the old system overnight. Reps who were used to calculating earnings one way suddenly had to learn a completely different method. Led to lots of "Is this right?" conversations.
Fix: Ran both systems in parallel for one month, showing reps what they would have earned under each. Massive confidence builder.
Mistake 4: Underestimating the Excel questions Built our calculator assuming reps would use it monthly. Reality? They use it daily, sometimes multiple times per day, modeling different scenarios.
Fix: Had to make the calculator much more robust. Added deal probability weighting, pipeline forecasting, and "what if I close this deal" scenarios.
If You're In the Same Boat
Start with progressive tiers. Seriously. Even if you think your team needs something more sophisticated, get the simple version working first.
Build a calculator immediately. Whatever system you choose, make sure reps can figure out their earnings without asking you.
Plan your reset schedule upfront. Monthly payouts with quarterly tier resets seems to be the sweet spot.
Get buy-in before you launch. Walk through examples with actual reps. If they don't immediately understand it, simplify more.
Plan for edge cases upfront. Split deals, pipeline transitions, territory changes, partial months - figure these out before launch day.
Run systems in parallel initially. Show people what they would earn under both systems for at least one month. Builds massive confidence.
The goal isn't the perfect commission system. It's a commission system that actually works for real people trying to make real money.
Anyone else dealt with this? What worked for your team?
