Sales commission calculator
Set up a flat, tiered or quota commission plan, with base pay and a cap if you have them. You get the commission, the effective rate and total pay for one person, or for a whole team pasted from a spreadsheet. It is plain arithmetic, not AI, and nothing you type or paste leaves this page.
The plan
The numbers already in the boxes are an example. Type over them.
One person
A whole team
Paste two columns from a spreadsheet: name and sales for the period. One person on each line. A header row is fine. The plan above is used for everyone.
Want commission worked out from your own sales, every month?
I connect your sales and accounting systems read-only and send one page each morning with sales to date, commission earned so far and who is close to their next band. A free 30-minute look shows what your systems could answer today.
How each plan works
Flat rate. One percent of every dollar sold.
commission = sales × rate
At 6%, $120,000 of sales earns $7,200.
Tiered. Sales are split into bands, each with its own rate. With bands of 5% up to $50,000, 8% up to $100,000 and 10% above that, $120,000 of sales earns $2,500 on the first band, $4,000 on the second and $2,000 on the last $20,000: $8,500 in all, an effective rate of 7.08%.
commission = sum of (sales inside each band × that band's rate)
Quota. One rate up to a sales target and a higher rate on sales past it. It is a tiered plan with two bands, where the line between them is the target. With a $100,000 quota, 5% up to it and 10% above, $120,000 of sales earns $5,000 plus $2,000: $7,000.
Base pay is added on top and does not change the commission. A cap limits the commission, not the base pay.
Why the two tiered methods give different answers
When each rate applies only inside its band, a higher band only pays more on the sales that reach it. The example above earns $8,500.
When reaching a band applies its rate to all sales, crossing a line raises the rate on every dollar already sold. The same $120,000 earns 10% of all of it: $12,000.
The second method has a jump at each line. At exactly $100,000 it pays $8,000. One dollar more pays $10,000.10, so that one extra dollar of sales is worth about $2,000 in commission. The first method has no jump: each extra dollar earns the rate of the band it falls in.
Questions
What does "up to $50,000" include?
It includes $50,000 itself. Sales of exactly $50,000 stay in the first band, and the next band starts with the dollar after it.
What is the effective rate?
The commission divided by the sales. It shows what the plan pays on average for each dollar sold, which makes plans of different shapes easy to compare.
We pay on gross profit, not sales. Does this still work?
Yes. The calculator works on whatever number you type. Type gross profit where it asks for sales, and set the bands in gross profit too.
How does the cap work?
The commission is worked out as usual and then held at the cap if it is higher. The table shows how much the cap took off. Base pay is added after the cap.
Is anything I type sent anywhere?
No. The arithmetic runs in your browser, and nothing you type or paste leaves this page.
Who made this?
Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This is one of its free tools.