Commission Calculator
What is a commission calculator?
A commission calculator is a tool that computes what a rep earns on a given deal or at a given attainment level, by applying the plan's rules to a set of inputs. At its simplest it is deal value × rate. In any real plan it is not, because the rate is not one number and the deal is not one input.
The reason "commission calculator" is one of the most-searched terms in sales compensation is that reps cannot get this answer from their own company. So they build it themselves — which is the polite name for shadow accounting.
What a real calculation has to handle
What this means?
"What do I earn on this deal?" has seven inputs, and the rep has reliable access to one of them. That is the entire problem. A commission calculator is not a convenience feature — it is the difference between a plan that motivates behaviour and a plan that is merely a document.
A worked calculation
The deal: $150,000 new ACV, closed by a rep currently at 92% attainment against a $1,000,000 quota. Rate table: 8% to 100%, 12% from 100–120%, marginal application. Multi-year: 1.2x kicker on 3-year terms. This deal is a 3-year contract.
The rep's mental model produces $12,000. The plan produces $17,760. The rep is underestimating their own earnings by 48% — which means the plan is failing to motivate the deal it was designed to reward.
The error runs the other way just as often. Either way, a rep who cannot compute their pay is a rep whose behaviour the plan is not actually steering.
Why calculators matter for finance teams
Every rep-built calculator is an unsanctioned copy of your comp plan, maintained by someone who was not consulted about it, out of date the moment a rate changes, and used as evidence in every dispute. The average sales team has one per rep.
The second cost is quieter. A plan is a behavioural instrument. If a rep cannot see that a 3-year deal pays 20% more, they will not prioritise it — and you have paid for an incentive that never changed a decision.
Common mistakes with commission calculators
1. Publishing a calculator that ignores attainment
A calculator that multiplies deal value by a flat rate is wrong for every rep not sitting exactly inside one band, which is most of them.
2. Letting reps build their own
They will. The question is whether their version agrees with yours, and it does not.
3. A calculator that is not connected to live attainment
The answer depends on where the rep is right now. A static spreadsheet cannot know that.
How Visdum handles commission calculation
Visdum calculates commission from the live plan and live CRM data — so every rep can see what a deal is worth to them at their current attainment, including the band it falls into, any kicker that applies, and the effect on their projected payout. It is not a separate calculator bolted onto the plan; it is the same engine that produces the payout, which is why the number a rep sees before they close is the number they are paid. Reps stop maintaining private spreadsheets, and finance stops arguing with them.
Take a self-guided product tour →, or try the Visdum commission calculators.
Related terms
Sales Commission Calculation · Rate Table · Effective Commission Rate · Quota Attainment · Shadow Accounting
Calculate your OTE in 30 seconds
Frequently asked questions
How do you calculate sales commission?
In the simplest case, deal value × commission rate. In any real plan it depends on the rep's current attainment (which determines the rate band), whether the rate table applies marginally or retroactively, the deal type (new logo, renewal, expansion carry different rates), any split, any kicker or multiplier, and any draw being recovered or clawback being applied.
Why doesn't deal value times rate give the right commission?
Because the rate is not fixed. A rep at 92% attainment closing a $150,000 deal crosses their quota mid-deal — part of it pays at the pre-quota rate and part at the accelerated rate. Add a multi-year kicker and the correct answer can be nearly 50% higher than the flat-rate estimate the rep would make in their head.
What inputs does a commission calculator need?
Seven: current attainment, the rate table and its application method, deal type, any split percentage, quota retirement rules, applicable kickers or multipliers, and any outstanding draw or clawback. A calculator missing attainment is wrong for every rep who is not sitting cleanly inside one band — which is most of them.
Should reps be able to calculate their own commission?
Yes, and if they cannot, they will build something that approximates it. A plan is a behavioural instrument: if a rep cannot see that a three-year deal pays 20% more, they will not prioritise it, and the company has paid for an incentive that never changed a decision. Every rep-built spreadsheet is also an unsanctioned copy of your comp plan that disagrees with it.
Is a commission calculator the same as a commission statement?
No. A calculator is forward-looking: what will this deal earn me? A statement is backward-looking: what did I earn last period, and how. Both need to come from the same engine — if the calculator says one thing and the statement says another, reps stop trusting both.
How do accelerators affect a commission calculation?
They change the rate partway through. A rep at 92% attainment closing a large deal will have part of it commissioned at the below-quota rate and part at the accelerated rate — assuming marginal application. Under retroactive application, crossing the threshold re-rates everything already closed, which is a much larger and much less predictable number.