Sales Commission Calculator Template
Tiered commission on every deal without a wall of nested IF formulas — set the tiers once and the payouts compute themselves.
Prefer the spreadsheet? Quote & Estimate Builder Template · Sales Commission Calculator Template · Pocket Price Waterfall — Discount Leakage · Route & Job Profitability Template · Engagement Profitability Template · Placement Margin & Consultant Template — free with an account, 3 free downloads.
See inside before you download: Quote & Estimate Builder Template · Sales Commission Calculator Template · Pocket Price Waterfall — Discount Leakage · Route & Job Profitability Template · Engagement Profitability Template · Placement Margin & Consultant Template
| Rep | Sales | Rate | Commission |
|---|---|---|---|
| A. Chen | £84,000 | 8% | £6,720 |
| R. Patel | £126,000 | 10% | £12,600 |
| M. Silva | £58,000 | 6% | £3,480 |
What's inside this template
How it works
It loads with realistic sample data so you see a finished result immediately — nothing to set up.
Type over the sample values, or upload your own file and map the columns in a couple of clicks.
The calculator recalculates instantly. Export to Excel or send a live link.
Related templates
Common questions
How do I calculate tiered commission without nested IFs?
Hold the tiers as a small rate table — threshold and rate per row — and look each deal up against it. That's what this template does, and it means changing the plan is editing one row rather than rewriting a formula.
What's the difference between tiered and accelerated commission?
Tiered pays a different rate on each band of sales. Accelerated raises the rate on everything once a threshold is crossed. Accelerated is a stronger incentive at the line and considerably more expensive above it.
Can it handle quotas, splits and draws?
Quota attainment and split deals are straightforward as extra columns. Recoverable draws work too, but they need a running balance per rep rather than a per-deal calculation.
Start from the Sales commission calculator template
Open it with sample data, swap in your own, and export in seconds — no formulas, no blank page.
Use this template free →