Sales Commission Calculator — Flat Rate + Tiered Accelerators

Marginal or retroactive — the choice that decides how sellers behave

A commission calculator is only useful if it matches how your plan actually works, and the thing most plan documents leave ambiguous is whether tiered rates apply marginally — each rate to its own slice of revenue — or retroactively, repricing everything at the higher rate once a threshold is crossed. The gap between them is large, and the behaviour it produces costs more than the difference in payout.

Marginal, worked through

Take the default plan: 3% above 0, 5% above 50,000, 8% above 100,000, on sales of 150,000.

• First 50,000 at 3% = 1,500
• 50,000 to 100,000 at 5% = 2,500
• 100,000 to 150,000 at 8% = 4,000
• Commission = 8,000; with a 40,000 base, total compensation is 48,000

Crossing 100,000 does not reprice the first 100,000. The 8% touches only the revenue above the line, so every additional sale is worth slightly more than the last and there is no step anywhere.

Retroactive, and the cliff it builds

The same tiers applied retroactively pay the top rate on everything: 150,000 at 8% is 12,000 — half again as much on identical revenue.

The payout difference is not the real problem. The problem is the cliff. A seller a few thousand short of a threshold with days left in the period is looking at a step change in their own pay, and the rational response is to move a deal — pull one forward with a discount that should never have been offered, or push one into next period because the threshold is unreachable now and the revenue is worth more later.

That distorts forecasts, discounting and customer conversations, and it is worth being clear that this is not people behaving badly. The plan asked for it. Marginal tiers remove the incentive entirely because there is no step to be on the wrong side of.

Which this one implements

Marginal. Enter a sales volume and an optional base salary, then choose a flat rate across all revenue or build any number of tiers, each with its own threshold and rate. Check which kind your own plan uses before comparing the output to your payslip — the two produce very different numbers on the same revenue, and plan documents are frequently vague about which they mean.

Commission as a share of base

The third output is the one worth reading carefully: it shows how much of the package depends on performance. On the defaults, 8,000 of commission against a 40,000 base is 20%.

A 50/50 split between base and on-target variable is a common convention for closing roles, meaning that hitting target roughly doubles what the base alone would pay. Newer sellers are usually weighted more heavily toward base, trading upside for predictability while they build a pipeline. Neither is a rule — but knowing where a plan sits on that spectrum tells you how much of someone's income moves with a quarter that goes badly for reasons outside their control.

What it deliberately does not model

Quota gates where commission only starts above a minimum, accelerators that switch on past target, split credit across sellers, and draws advanced against future commission.

Above all, clawback — commission recovered when a deal refunds or churns early. That is where real plans get genuinely complicated, and it is the clause most worth reading closely in your own, because it determines whether a commission cheque is actually yours yet. It belongs in the plan document, spelled out, rather than discovered in a payroll adjustment.

To work backwards from a target to the pipeline that produces it, the win rate calculator covers the conversion side.