All spreadsheet tools

Tiered Sales Commission Calculator for Small Sales Teams

Tiered Sales Commission Calculator for Small Sales Teams: preview of the example data

Set up to four commission tiers and a quota bonus, enter each rep's base pay, quota and sales, and see commission paid band by band, quota attainment, total pay and what the plan costs as a share of sales.

Tiered (graduated) commission plans pay a higher rate on each band of sales above a threshold: for example 5% on the first $20,000, 8% on the next $30,000, and so on. They reward top performers without paying the top rate on every dollar, but they are easy to calculate wrongly by hand, and the most common mistake is applying the highest reached rate to all sales.

This calculator applies each rate only to the sales inside its band, then adds an optional flat bonus for reps who reach quota. For every rep it shows quota attainment, commission, bonus, total pay, the effective commission rate and total pay as a share of their sales. The summary shows team totals, how many reps hit quota and what the whole plan costs as a percentage of sales.

Use it to pay commission each month and, before you change a plan, to see what the new tiers would have paid last quarter.

What is included

Who it is for

How it works

1) On Plan, enter the four tier thresholds (the first is always 0) and the rate for each tier, plus any quota bonus. 2) On Reps, list each rep with base pay, quota and sales for the period. 3) Read each rep's commission and total pay, and Summary for the team.

Limits

Related tools

Price: $12, one-time. Download: tiered_sales_commission_calculator.xlsx (Plan, Reps, Summary) and this guide. Works in Excel 2016 or later, Excel for Mac and Excel on the web; opens in Google Sheets and LibreOffice.

Buy on Gumroad ($12)

New product, listed 2026-10-31: no sales or reviews yet. Example figures in the workbook are illustrative.

This workbook is a calculation tool, not legal, tax, payroll or employment advice. Commission plans are governed by your written agreements and local employment law; check both before paying.