IntermediateTime: 30 minutes

How to Calculate Tiered Commission Structure for Sales Teams

Learn how to calculate tiered commission structures that motivate reps to exceed quota with accelerating rates at higher performance levels.

When to Use This Guide

  • ✓Incentivizing quota over-achievement
  • ✓Rewarding top performers more generously
  • ✓Creating commission acceleration at thresholds
Prerequisites
  • • Defined sales quotas
  • • Clear product pricing
  • • Budget for commission spend
Step-by-Step Instructions
1

Define Commission Tiers and Thresholds

Set the performance levels and corresponding commission rates.

Typical structure: 0-80% quota = 5%, 80-100% = 7%, 100-120% = 10%, 120%+ = 12%

Example

For $100K quota: Tier 1 (0-$80K) = 5%, Tier 2 ($80K-$100K) = 7%, Tier 3 ($100K-$120K) = 10%, Tier 4 ($120K+) = 12%

Pro Tips:
  • • Set meaningful jumps between tiers (2-3% increases)
  • • Place highest acceleration above 100% quota
  • • Limit tiers to 3-5 for simplicity
Common Mistakes to Avoid:
  • • Too many tiers creating confusion
  • • Small rate differences not motivating
  • • First tier starting too high
2

Calculate Commission Per Tier

Calculate commission earned within each tier separately.

Multiply revenue in each tier by that tier's rate, then sum all tiers.

Example

Rep with $115K sales: Tier 1 ($80K x 5% = $4K) + Tier 2 ($20K x 7% = $1.4K) + Tier 3 ($15K x 10% = $1.5K) = $6.9K total

Pro Tips:
  • • Calculate each tier separately, not as single percentage
  • • Use spreadsheet formulas to automate
  • • Verify calculations at tier boundaries
Common Mistakes to Avoid:
  • • Applying highest rate to all revenue
  • • Forgetting to calculate tier-by-tier
  • • Rounding errors accumulating
3

Handle Split Commissions in Tiers

Adjust tiered calculations when commissions are split between reps.

Apply splits before or after tier calculation depending on policy.

Example

50/50 split: Calculate tiers on total deal ($115K), then split result ($6.9K / 2 = $3.45K each)

Pro Tips:
  • • Decide: split before or after tier calculation
  • • Document split policy clearly
  • • Consider impact on quota credit
Common Mistakes to Avoid:
  • • Inconsistent split application
  • • Not crediting quota properly with splits
  • • Complex split rules in tiered structures
4

Account for Returns and Clawbacks

Adjust commission when deals are returned or cancelled.

Reverse commission in the tier where original sale occurred.

Example

$10K return from Tier 3: Reduce commission by $1K (10% of return), adjust current period calculation

Pro Tips:
  • • Track which tier original sale was in
  • • Apply reversal in current period
  • • Consider clawback time limits
Common Mistakes to Avoid:
  • • Not reversing commission on returns
  • • Applying wrong tier rate to reversal
  • • Unlimited clawback periods demotivating reps
5

Automate With Formulas or Software

Set up systems to calculate tiered commissions automatically.

Use nested IF formulas in spreadsheets or commission software to automate.

Example

Excel: =IF(sales<=80000, sales*0.05, 4000+IF(sales<=100000, (sales-80000)*0.07, 1400+IF(sales<=120000, (sales-100000)*0.10, 2000+(sales-120000)*0.12)))

Pro Tips:
  • • Test formulas at each tier boundary
  • • Build commission calculator for rep transparency
  • • Consider dedicated commission software
Common Mistakes to Avoid:
  • • Formula errors at boundaries
  • • Not making calculations transparent
  • • Manual calculation continuing despite automation

Formulas & Examples

basic Formula

Commission = Σ(Revenue in Tier n × Rate for Tier n)

example Scenario

{
  "quota": "$100,000",
  "actualSales": "$115,000",
  "tiers": [
    {
      "range": "$0 - $80,000",
      "rate": "5%",
      "revenue": "$80,000",
      "commission": "$4,000"
    },
    {
      "range": "$80,001 - $100,000",
      "rate": "7%",
      "revenue": "$20,000",
      "commission": "$1,400"
    },
    {
      "range": "$100,001 - $120,000",
      "rate": "10%",
      "revenue": "$15,000",
      "commission": "$1,500"
    }
  ],
  "totalCommission": "$6,900",
  "effectiveRate": "6%"
}

Recommended Tools

SalesPro Hub commission calculator

Excel with tiered formulas

Commission automation software

Spreadsheet templates

Frequently Asked Questions

Should I apply the highest tier rate to all revenue?

No. Calculate commission separately for revenue in each tier, then sum them. Only applying the highest rate would over-pay commissions.

How many commission tiers should I have?

3-5 tiers is optimal. More than 5 becomes confusing, fewer than 3 doesn't provide enough motivation for over-achievement.

What tier rates should I use?

Start with 5-7% at base, increase 2-3% per tier, with highest acceleration above 100% quota. Adjust based on margin and industry norms.

Need Expert Help?

Our team can help you implement these strategies

Talk to an Expert