Rapid Age Calculator
What do you want to work out?

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

Fill in the boxes. The answer and the working update as you type.

Used only for the profit plan.

Separate the amount and the rate with a space. Marginal tiers: the amount is the top of the band, and the last line has only a rate. Cliff tiers: the amount is where the band starts.

Added to the commission for total pay.

The percents must add up to 100.

Result

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.

All sources

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

Results follow the rules shown above and are for guidance. For formal use, check them against your form, contract or the official source.