CalcTrace

Commission Calculator

Work out commission on sales at a flat rate, on tiered rates, or on top of base pay. For tiers, the calculator shows the two ways a plan can apply them side by side, because they can pay very different amounts on the same sales. It also finds the sales needed to reach a target income.

Last updated .

Your commission plan

How commission is paid

Use whatever your plan pays on: revenue, gross profit or payments received.

The calculator finds the sales that would pay this much under the plan above.

Result

Commission

–

–Sales
–Commission
–Base pay
–Commission as a share of sales

Where the pay comes from

    Show the working

      Commission formulas

      Commission is a percentage of sales. What changes from plan to plan is which sales the percentage is applied to.

      Flat rate: commission = S × r ÷ 100

      Base plus commission: pay = B + (S − Q) × r ÷ 100, with no commission when S is below Q

      S is the sales for the period, r is the commission rate in per cent, B is the base pay and Q is the level of sales at which commission starts (zero if it is paid from the first dollar).

      A tiered plan has several rates, each tied to a band of sales. It can apply them in two ways:

      Marginal tiers: commission = (sales inside band 1 × r₁ + sales inside band 2 × r₂ + …) ÷ 100

      Whole-amount tiers: commission = S × rₖ ÷ 100, where rₖ is the rate of the band that S falls in

      To find the sales needed for a target income T, the formulas are turned around. At a flat rate, S = T ÷ (r ÷ 100). With base pay, S = Q + (T − B) ÷ (r ÷ 100).

      Worked example: the same tiers, two answers

      A plan pays 3% on sales up to $10,000, 5% from $10,000 to $30,000 and 8% above $30,000. Sales for the month are $40,000.

      1. Marginal, band 1. The first $10,000 earns 3%: $300.
      2. Marginal, band 2. The next $20,000 earns 5%: $1,000.
      3. Marginal, band 3. The last $10,000 earns 8%: $800.
      4. Marginal total. $300 + $1,000 + $800 = $2,100, which is 5.25% of sales.
      5. Whole amount. $40,000 falls in the 8% band, so 8% applies to all of it: $40,000 × 0.08 = $3,200.

      The same sales and the same three rates give $2,100 one way and $3,200 the other, a difference of $1,100. A table of tiers does not tell you what a plan pays until you know which method it uses.

      Marginal and whole-amount tiers

      Under marginal tiers a higher rate only ever applies to the sales above the limit. Pay rises smoothly: one more dollar of sales earns one more dollar’s worth of commission at the current rate, and crossing a limit never changes what was earned below it.

      Under whole-amount tiers, crossing a limit re-prices every dollar already sold. That creates a jump. With the tiers above, sales of exactly $30,000 earn 5% of the lot, $1,500. Sales of $30,001 earn 8% of the lot, $2,400.08. One extra dollar of sales is worth $900.08. Under marginal tiers the same dollar moves the commission from $1,300 to $1,300.08.

      The jump also leaves gaps in what the plan can pay. No level of sales produces a commission between $1,500 and $2,400 under the whole-amount method. The size of the jump means that sales landing just short of a limit at the end of a period cost far more than their own commission. Plans describe the two methods in different words: “retroactive”, “back to dollar one” or “on all sales” usually signal the whole-amount method, while “on sales above” or “on the excess” signal marginal tiers.

      Sales needed for a target income

      1. Flat rate. To earn $3,000 at 5%: $3,000 ÷ 0.05 = $60,000 of sales.
      2. Base plus commission. Base pay is $3,000 and commission is 4% of sales above $20,000. Sales of $40,000 pay $3,000 + $20,000 × 0.04 = $3,800. To reach $5,000, the commission must be $2,000, which needs $2,000 ÷ 0.04 = $50,000 of sales above the starting level: $70,000 in all.
      3. Marginal tiers. With the example tiers, the first two bands pay $300 + $1,000 = $1,300 in full. To reach $3,000, the remaining $1,700 must come from the 8% band: $1,700 ÷ 0.08 = $21,250, so sales of $30,000 + $21,250 = $51,250.
      4. Whole-amount tiers. $3,000 ÷ 0.08 = $37,500, which is inside the 8% band, so that is the answer. A target of $2,000 behaves differently: at 5% it would need $40,000, which is outside the 5% band, and at 8% it would need only $25,000, which is below the 8% band. The target falls in the gap, so it is first passed by any sales just over $30,000, where the commission jumps to $2,400.

      Reading the result

      Check what counts as sales

      Plans pay on different things: the invoiced amount, the amount actually collected, or the gross profit on the sale. Enter the figure your plan uses. If commission is paid on gross profit, a discount given to win a sale cuts the commission by a larger proportion than it cuts the price.

      The period matters for tiers

      Tiers are measured over a period, usually a month, quarter or year, and normally start again from zero in the next one. The same yearly sales can pay differently depending on how they fall across periods, so enter the sales and the limits for one period at a time.

      What is left out

      The result is pay before tax and other deductions; no tax rules are applied. The calculator does not model caps on commission, draws that are repaid from later commission, clawbacks when a customer cancels, bonuses for reaching a quota, or commission split between people. Those terms are set by each plan, so read the plan document for anything beyond the rates.