Commission Calculator
Choose how your plan pays, enter the sales figure and the rate or tiers, and the calculator returns the commission, the effective rate and the total pay with any base. It handles a flat rate, tiers that pay the higher rate only on the excess, tiers that pay one rate on all sales, and a rate on profit. The working is shown band by band.
Work out your commission
Result
The working
Fill in the boxes above to see the answer and every step.
-
Checked on
Method: the convention this calculator uses, stated in full on the page. It is not an official rule.
Flat, marginal and cliff plans
The steps of the worked example appear here.
Money is held as exact decimals and rounded half up to two decimals once, on the final figure. A flat plan is sales times the rate. Marginal tiers pay each band of sales its own rate. Cliff tiers pay the rate of the band your total reaches on every sale, so sales just under a threshold are paid at the lower rate on everything. A rate on profit uses sales less costs, and a floor at zero stops a loss from producing negative commission. For ten thousand in sales and four thousand in costs at ten percent, the commission is 600.00. A commission split by percentage is rounded so that the parts add up exactly to the whole, for example 50.02, 30.02 and 20.01. Adding base pay gives total pay, such as 3500.00 in the example.
Worked example
Take sales of twenty-five thousand with tiers that pay five percent up to ten thousand, seven percent up to twenty thousand and ten percent above that. With marginal tiers each rate applies only to the sales inside its band, and the commission is 1700.00. The same tiers set up as cliff tiers, where the rate of the band you reach applies to all sales, pay 2500.00.
Splitting commission and adding base pay
Marginal tiers pay each band of sales its own rate.
A commission split by percentage is rounded so that the parts add up exactly to the whole, for example 50.02, 30.02 and 20.01.
Adding base pay gives total pay, such as 3500.00 in the example.
Frequently asked questions
How to find commission rate calculator?
Divide the commission you were paid by the sales it was paid on, then multiply by one hundred to get a percentage. In the flat example a commission of 500.00 on ten thousand in sales is a rate of five percent. The calculator also shows the effective rate for tiered plans.
How to create a commission calculator in Excel?
In a spreadsheet, multiply sales by the rate for a flat plan. For tiers, work out each band separately, which is the part of sales inside the band times its rate, and add the bands. This page does that for you and shows the working, so you can check a spreadsheet against it, for example 1700.00 in the marginal tier example.
Sales commission what if calculator?
Change the sales figure, the rate or the tiers and watch the commission change. Compare marginal and cliff tiers on the same sales to see how a plan rewards a big month: the example pays 1700.00 with marginal tiers and 2500.00 with cliff tiers.
Related calculators
Enter carton size and quantity to get CBM per carton and in total, air volumetric weight and how much of a container the load fills. Estimates only.
Total your weekly hoursTotal a week of start and end times with unpaid breaks, overnight shifts and rounding. See hours as hh:mm and decimal, plus overtime over the weekly limit.
Check an exact ageFind your exact age in years, months and days today or on any cut-off date. Shows the month-end rule, the leap-day choice and your next birthday.
Results follow the rules shown above and are for guidance. For formal use, check them against your form, contract or the official source.