Map Extract
Free tool

Tiered sales commission calculator

Enter the sales for the period and set up the tiers: the sales level where each one starts and its rate. Choose whether each rate applies only to its own band or to the whole amount once a tier is reached. You get the commission and the effective rate.

Runs in your browser. Nothing you enter is uploaded.

The two tier methods

Tiered: each rate on its band
Sales up to the first break earn the first rate, sales between the first and second break earn the second rate, and so on. Also called marginal or stepped commission.
Whole amount at the band reached
Once total sales reach a tier, every pound of sales earns that tier's rate. Also called retroactive commission. It pays more, and creates a big jump at each threshold.
Effective rate
Commission divided by sales, the single rate that would have paid the same.

Setting up the plan

  1. Enter sales for the period

    The figure the plan is measured on, such as invoiced sales for the month or quarter.

  2. Choose the method

    Tiered or whole amount, as your commission plan describes it.

  3. Edit the tiers

    Each tier has a From amount and a rate. Use Add a tier for more and Remove to drop one. The first tier normally starts from £0.

  4. Read the result

    Commission in pounds and the effective rate update as you change any figure.

Example: a quarter for a field sales rep

A rep selling commercial cleaning contracts closes £63,500 in a quarter. Her plan has three steps: 3% on sales from £0, 5% once she passes £20,000, and 8% beyond £45,000.

On the tiered method she earns £600 on the first £20,000, £1,250 on the next £25,000 and £1,480 on the £18,500 above £45,000: £3,330, an effective 5.24%. If the plan paid the whole amount at the band reached, all £63,500 would earn 8%, which is £5,080.

Input
Sales £63,500
Tiers: from £0 pay 3%, from £20,000 pay 5%, from £45,000 pay 8%
Result
Tiered, each rate on its band: commission £3,330.00, effective rate 5.24%
Whole amount at the band reached: commission £5,080.00, effective rate 8%

Designing a fair plan

For a small sales team the tiered method is easier to live with: every extra sale earns a little more, and there is no cliff where one deal changes the payout by thousands. The whole amount method rewards hitting a target hard, but can tempt people to move deals between periods.

Base commission on what you can afford to pay. If margins vary between products, paying on gross profit rather than sales protects the business, and the profit margin calculator helps you see what a sale is really worth. Commission is taxable pay and goes through payroll with tax and National Insurance.

Questions people ask

How is tiered commission calculated?

Each tier's rate applies only to the sales inside that tier. With 4% up to £25,000 and 6% above, £30,000 of sales earns £1,000 on the first £25,000 plus £300 on the last £5,000, so £1,300. The calculator adds up every band for any number of tiers.

What is the difference between tiered and retroactive commission?

With tiered commission each rate covers only its own band. With retroactive commission, reaching a tier means all sales earn that tier's rate. The retroactive method pays more at the same sales level and jumps sharply at each threshold. Switch the method in the calculator to compare.

What is a typical sales commission rate?

It varies a lot by industry, deal size and how much of the pay is base salary. Rather than copying a figure, work out what share of the gross profit on a sale you can pay and still cover your costs, then set tiers that reward the results you want most.

Is commission taxed?

Yes. For employees, commission is part of earnings and is taxed through PAYE with National Insurance, often in the month it is paid. A big commission month therefore has a bigger deduction. The calculator shows gross commission before tax, so check your payslip for the amount you actually receive.

Where your data goes

Sales figures and tier settings are worked out in the page and are not stored or sent anywhere.

Checked against the tool on

Top