Sales Commission Calculator

This sales commission calculator handles the plans sales teams actually use. Enter sales, your commission tiers — such as 5% up to 100,000, 7.5% up to 250,000 and 10% above — and whether they're graduated or retroactive, plus an optional quota accelerator and draw, and it shows commission earned, the effective rate, quota attainment and the payout. Paste the whole team's sales to calculate every rep's commission at once. It runs in your browser.

Tiers 5% to 100k, 7.5% to 250k, 10% above

SalesGraduatedRetroactive
50,0002,5002,500
100,0005,0005,000
200,00012,50015,000
250,00016,25018,750
300,00021,25030,000
500,00041,25050,000

When to use it

  1. Check a commission statement.
  2. Design a tiered commission plan.
  3. Compare graduated and retroactive tiers.
  4. Model an accelerator above quota.
  5. Run commissions for a sales team.

How to Use

  1. Enter sales for the period.
  2. Enter tiers and choose graduated or retroactive.
  3. Optionally add quota, accelerator and draw.
  4. Read commission and payout; paste the team's sales.

Features

  1. Flat or tiered rates
  2. Graduated or retroactive
  3. Quota accelerator
  4. Draw and carry-forward
  5. Effective rate and attainment
  6. Batch CSV
  7. 100% client-side

FAQs

What is the difference between graduated and retroactive tiers?

Graduated tiers pay each band at its own rate; retroactive tiers pay all sales at the highest rate reached, which jumps at each threshold.

What is a commission accelerator?

An extra rate paid on sales above quota to reward overachievement.

What is a draw against commission?

An advance paid each period that is recovered from commission earned; if commission is lower, the gap is carried forward.

What is the effective commission rate?

Total commission ÷ total sales.

Is anything uploaded?

No. Everything runs in your browser.

Technical Details

Tiers are bands of sales with a rate each. Graduated (marginal) tiers pay each band at its own rate; retroactive tiers pay all sales at the rate of the band reached. An accelerator adds an extra percentage on sales above quota. With a draw, the payout is the greater of the draw and commission earned, and any shortfall is carried forward to recover. Attainment = sales ÷ quota. Batch mode reads each rep's sales, quota and draw.

Business & Legal Tools

Business & Legal Tools

  • Employee Cost (CTC) Breakdown Calculator
  • Agent Commission Split Calculator
  • LTV and CAC Calculator
  • Meeting Cost Calculator
  • Pallet Calculator
  • Freight Class Estimator
  • Landed Cost Calculator
  • Incoterms 2020 Quick Reference