Sales template
Sales commission calculator
Pay commission by quota attainment tier, either as one rate on all sales or as progressive tiers. Includes an accelerator bonus and a payout chart by rep.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Commissions
52 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 119 filled cells in all.
Built in
- Charts
- Conditional formatting
- Dropdowns
- Named ranges
- Frozen headers
- 1 chart
A look at the Commissions sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Sales commission calculator | |||||||
| 2 | Q3 2026. Set the tiers and method, then enter quota and sales for each rep. | |||||||
| 3 | Commission tiers | Settings | ||||||
| 4 | Attainment from | Rate | Step | Method | Progressive tiers | |||
| 5 | 0% | 2.0% | 2.0% | Bonus at attainment | 120% | |||
| 6 | 50% | 4.0% | 2.0% | Accelerator bonus | $2,000 | |||
| 7 | 80% | 6.0% | 2.0% | |||||
| 8 | 100% | 8.0% | 2.0% | |||||
| 9 | 120% | 10.0% | 2.0% | |||||
| 10 | Step is how much the rate rises at each tier (used by the progressive method). | |||||||
| 11 | ||||||||
| 12 | Rep | Region | Quota | Sales | Attainment | Tier rate | Commission | Bonus |
- commission
- quota
- sales compensation
- payroll
More sales templates
SalesSales quoteSend a professional quote with line discounts, optional items you can switch on or off, tax and a deposit. It shows how many days the quote stays valid.
SalesPricing calculatorSet prices from your costs with a target margin, then compare markup, margin and competitor prices per product. A quick converter turns markup into margin and back.
SalesSales dashboardA year to date sales dashboard with revenue, orders and average order value, monthly trend, region split and top products. Add orders to the Data sheet and everything updates.
SalesCRM sales pipelineTrack deals by stage with a probability for each stage and a weighted forecast by close month. Late deals and contacts going cold are flagged automatically.
Start your sales commission calculator now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.