"What's 8% of $127,000?" If your sales reps are pulling out calculators after every deal, something's wrong. Commission calculations should be clear, predictable, and - ideally - automatic.
But reality often looks different. Tiered rates, accelerators, split deals, clawbacks... Commission structures have become increasingly complex. And complexity leads to errors, disputes, and demotivated sales reps.
In this guide, you'll get the formulas, methods, and examples you need to calculate commission correctly - no matter how complex your model is.
What you'll learn in this guide
- The basic commission formula (and when it's not enough)
- How to calculate 5 different commission types
- Tiered models: Step-by-step with examples
- Accelerators and decelerators: The math behind them
- Split deals and team commission
- Clawbacks: When and how to calculate them
- The most common calculation mistakes - and how to avoid them
The basic commission formula
Let's start with the foundation:
Commission = Sales Amount × Commission Rate
Simple, right? If your sales rep closes a deal for $100,000 with a 10% commission rate:
$100,000 × 10% = $10,000 in commission
When the basic formula works
The simple formula works when:
- You have a flat commission rate for all sales
- No thresholds or tiers
- No adjustments for deal type, product, or customer
- Commission is paid on the full amount
But most modern sales organizations need more nuance. Let's look at the different calculation methods.
5 commission types and how to calculate them
| Commission Type | Formula | Best For |
|---|---|---|
| Flat rate | Sales × Rate | Simple, transactional sales |
| Tiered | Each tier × tier rate | Motivate higher volume |
| Accelerator | Base rate + bonus rate above quota | Reward overperformance |
| Decelerator | Reduced rate below threshold | Ensure minimum performance |
| Gross margin | Margin × Rate | Protect profitability |
Let's go through each one.
1. Flat rate commission
The simplest model. One rate for everything.
Formula: Commission = Sales Amount × Commission Rate
Example:
| Deal | Amount | Rate | Commission |
|---|---|---|---|
| Deal 1 | $50,000 | 10% | $5,000 |
| Deal 2 | $75,000 | 10% | $7,500 |
| Deal 3 | $120,000 | 10% | $12,000 |
| Total | $245,000 | 10% | $24,500 |
Pros: Easy to understand and calculate
Cons: No incentive to exceed expectations
2. Tiered commission
Different rates for different sales volumes. Higher volume = higher rate.
Formula: Commission = Σ (Volume in each tier × Tier rate)
Example structure:
| Tier | Sales Volume | Rate |
|---|---|---|
| Tier 1 | $0 - $100,000 | 8% |
| Tier 2 | $100,001 - $250,000 | 10% |
| Tier 3 | $250,001+ | 12% |
Calculation example: A sales rep sells $320,000 in a quarter.
| Tier | Amount in Tier | Rate | Commission |
|---|---|---|---|
| Tier 1 | $100,000 | 8% | $8,000 |
| Tier 2 | $150,000 | 10% | $15,000 |
| Tier 3 | $70,000 | 12% | $8,400 |
| Total | $320,000 | - | $31,400 |
Note: The effective rate is 9.8% ($31,400 / $320,000), even though the top tier is 12%.
Learn more about tiered commission structures and how to design them.
Tired of manual commission calculations?
Prowi handles tiered calculations automatically. Your sales reps see their earnings in real-time - and you avoid errors and disputes.
Book a demo →3. Accelerators
Higher commission rate when you exceed quota. Designed to reward overperformance.
Formula: Commission = (Sales up to quota × Base rate) + (Sales above quota × Accelerated rate)
Example:
- Quarterly quota: $200,000
- Base rate: 10%
- Accelerated rate (above quota): 15%
- Actual sales: $280,000
Calculation:
| Component | Amount | Rate | Commission |
|---|---|---|---|
| Up to quota | $200,000 | 10% | $20,000 |
| Above quota | $80,000 | 15% | $12,000 |
| Total | $280,000 | - | $32,000 |
Without accelerator: $280,000 × 10% = $28,000
With accelerator: $32,000 (14% more commission)
This $4,000 difference motivates the sales rep to keep selling after hitting quota rather than "sandbagging" deals for next quarter.
Read more about how accelerators work and when to use them.
4. Decelerators
Lower commission rate below a minimum threshold. Ensures sales reps don't coast on base salary.
Formula: Commission = Sales × Reduced rate (when below threshold)
Example:
- Minimum threshold: 70% of quota ($140,000)
- Full rate: 10%
- Reduced rate (below threshold): 5%
- Actual sales: $120,000 (60% of quota)
Calculation:
$120,000 × 5% = $6,000
Compare to full rate: $120,000 × 10% = $12,000
The decelerator costs the underperforming sales rep $6,000 - a strong incentive to at least hit the minimum threshold.
5. Gross margin commission
Commission based on profit margin, not sales value. Protects company profitability.
Formula: Commission = (Sales Price - Cost) × Commission Rate
Example:
| Deal | Sales Price | Cost | Margin | Rate | Commission |
|---|---|---|---|---|---|
| Deal A | $100,000 | $60,000 | $40,000 | 20% | $8,000 |
| Deal B | $100,000 | $80,000 | $20,000 | 20% | $4,000 |
Same sales price, but Deal A earns twice the commission because of higher margin. This discourages excessive discounting.
Split deals: How to calculate team commission
When multiple people contribute to a sale, you need a system for splitting commission.
Common split models
| Model | How It Works | Example |
|---|---|---|
| Fixed split | Predetermined percentage per role | SDR 20%, AE 80% |
| Overlay | Multiple people get full (or partial) credit | AE 100%, SE 25% |
| Territory split | Based on customer location or segment | Regional rep 60%, National rep 40% |
Calculation example: SDR + AE split
Deal: $100,000 ACV
Commission pool: 10% = $10,000
Split: SDR 20%, AE 80%
| Role | Split % | Commission |
|---|---|---|
| SDR (Sarah) | 20% | $2,000 |
| AE (Mike) | 80% | $8,000 |
| Total | 100% | $10,000 |
Calculation example: Overlay model
Deal: $100,000 ACV
AE commission: 10% = $10,000
SE overlay: 2.5% = $2,500
Total commission paid: $12,500 (125% of "standard" commission pool)
Overlays cost more but ensure specialists are motivated to support deals.
Clawbacks: When and how to calculate them
A clawback recovers commission when a customer churns or cancels within a specified period.
Common clawback structures
| Cancellation Period | Clawback Amount |
|---|---|
| 0-3 months | 100% of commission |
| 4-6 months | 50% of commission |
| 7-12 months | 25% of commission |
| 12+ months | No clawback |
Calculation example
Original deal: $60,000 ACV
Original commission: $6,000 (10%)
Customer cancels: After 5 months
Clawback rule: 50% for 4-6 months
Clawback amount: $6,000 × 50% = $3,000
The $3,000 is deducted from the sales rep's next commission payment.
Automated clawback tracking
Prowi tracks clawback periods automatically and calculates adjustments when customers churn. No spreadsheets. No surprises.
See how it works →The 5 most common calculation mistakes
Mistake 1: Confusing retroactive and marginal tiers
Marginal (correct for most): Each tier has its own rate. Selling $320,000 means $100k at 8%, $150k at 10%, $70k at 12%.
Retroactive: Hitting a new tier applies that rate to ALL sales. Selling $320,000 means all $320k at 12%.
Retroactive tiers create "cliff effects" - selling $249,999 vs $250,001 could mean thousands in difference. Most organizations use marginal tiers.
Mistake 2: Rounding errors that compound
Small rounding errors in individual deals add up over hundreds of transactions.
Solution: Define rounding rules (always round to 2 decimals, round at the end not each step) and apply consistently.
Mistake 3: Unclear timing of commission recognition
When is commission earned?
- When the deal is signed?
- When the invoice is sent?
- When payment is received?
Different rules for different deals create confusion. Define one clear policy.
Mistake 4: Forgetting to adjust for credits and refunds
If a customer gets a $10,000 credit, should the commission on that $10,000 be reversed? Often overlooked until it's a big number.
Mistake 5: Manual spreadsheet calculations
Spreadsheets break. Formulas get overwritten. Copy-paste creates errors. The more complex your commission model, the more errors manual calculations produce.
From formulas to automation: Making calculations reliable
Understanding the formulas is step one. Making them reliable and scalable is step two.
The spreadsheet problem
Most companies start with Excel or Google Sheets. It works until:
- You have more than 10 sales reps
- Your commission model has more than 2 components
- Someone changes a formula by mistake
- You need to audit historical calculations
- Sales reps dispute their numbers
What commission software does differently
| Feature | Spreadsheets | Commission Software |
|---|---|---|
| Calculation accuracy | Error-prone | Automated, consistent |
| Real-time visibility | End of month/quarter | Live, after each deal |
| Audit trail | Manual version control | Complete history |
| Dispute resolution | Back-and-forth emails | Self-service breakdown |
| Time spent | Hours per pay period | Minutes |
Learn more about what commission software is and whether you need it.
Practical example: Complete quarterly calculation
Let's put it all together with a real-world example.
Setup
Sales rep: Alex
Quarterly quota: $300,000
Commission structure:
- Base rate: 8%
- Accelerator (above quota): 12%
- Decelerator (below 70% of quota): 5%
- SDR split: 15% of commission pool
Alex's Q3 results
| Deal | Amount | SDR | Notes |
|---|---|---|---|
| Acme Corp | $85,000 | Sarah | New business |
| TechStart | $120,000 | Mike | New business |
| GlobalInc | $95,000 | Sarah | New business |
| FastGrow | $50,000 | - | Self-sourced |
| Total | $350,000 | - | 117% of quota |
Step 1: Calculate base commission
Up to quota ($300,000): $300,000 × 8% = $24,000
Above quota ($50,000): $50,000 × 12% = $6,000
Total gross commission: $30,000
Step 2: Calculate SDR splits
| Deal | Deal Commission | SDR Split (15%) | Alex Gets |
|---|---|---|---|
| Acme Corp | $6,800 | $1,020 (Sarah) | $5,780 |
| TechStart | $9,600 | $1,440 (Mike) | $8,160 |
| GlobalInc | $7,600 | $1,140 (Sarah) | $6,460 |
| FastGrow | $6,000 | $0 (self-sourced) | $6,000 |
Alex's Q3 commission: $26,400
Sarah's Q3 SDR commission: $2,160
Mike's Q3 SDR commission: $1,440
Communicating calculations to your team
The best commission model is worthless if your team doesn't understand it.
What every sales rep should know
- How their commission is calculated - the formula, in plain language
- What their current earnings are - updated after every deal
- What they need to do to earn more - clear path to accelerators
- When they'll be paid - predictable schedule
How to create transparency
- Commission statements: Detailed breakdown with each payment
- Real-time dashboards: Current earnings and progress to quota
- Calculation examples: Show exactly how the math works
- Open door policy: Make it easy to ask questions
Learn more about the psychology behind sales motivation.
Get your calculations right - automatically
Commission calculations don't have to be complicated. With the right formulas and - ideally - the right tools, you can:
- Eliminate calculation errors
- Give sales reps real-time visibility
- Reduce disputes and questions
- Free up hours of admin time
The formulas in this guide give you the foundation. Automation makes them scale.
Ready to automate your commission calculations?
Prowi handles tiered models, accelerators, splits, and clawbacks automatically. Your sales reps see their earnings in real-time, and you get hours back every month.
Book a demo →