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.
| Sales | Graduated | Retroactive |
|---|---|---|
| 50,000 | 2,500 | 2,500 |
| 100,000 | 5,000 | 5,000 |
| 200,000 | 12,500 | 15,000 |
| 250,000 | 16,250 | 18,750 |
| 300,000 | 21,250 | 30,000 |
| 500,000 | 41,250 | 50,000 |
Graduated tiers pay each band at its own rate; retroactive tiers pay all sales at the highest rate reached, which jumps at each threshold.
An extra rate paid on sales above quota to reward overachievement.
An advance paid each period that is recovered from commission earned; if commission is lower, the gap is carried forward.
Total commission ÷ total sales.
No. Everything runs in your browser.
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.