How to calculate sales commission
The bases, rates, and accelerators that make up a commission calculation - with worked formulas and a way to stop doing it by hand.
The building blocks
A commission calculation has three moving parts: the base (what you pay on), the rate (the percentage), and the modifiers (accelerators, margin adjustments, clawbacks). Getting the base right is the part teams most often botch - paying on bookings, billings, or collections has very different cash implications.
Base commission
Commission = Commissionable Amount × Commission Rate
The commissionable amount depends on the basis - booking value, invoiced amount, or cash collected.
Pick the right basis
| Basis | Pay when | Trade-off |
|---|---|---|
| Booking | Deal is signed/accepted | Motivates closing; pays before cash |
| Billing | Invoice is posted | Aligns with revenue recognition |
| Collection | Cash is received | Protects cash; slower to reps |
Add accelerators and clawbacks
Accelerated commission
Payout = Base Commission × Accelerator (when attainment > 100%)
Reps over quota earn an elevated rate on the portion above target; margin-aware plans reduce the rate on thin-margin deals.
Stop calculating by hand
Doing this in a spreadsheet each month is where errors and disputes live. Fintra’s engine fires a commission event for every revenue moment, resolves the correct rate per event type, applies accelerators and margin multipliers, and reverses clawbacks automatically - so the calculation is reproducible and every payout traces to its deal.
Frequently asked questions
What is the basic sales commission formula?
Commission equals the commissionable amount times the commission rate. The commissionable amount depends on your basis - booking value, invoiced amount, or cash collected - and the result is then adjusted by accelerators for over-quota reps and reduced for thin-margin deals if your plan is margin-aware.
Should I pay commission on bookings, billings, or collections?
It depends on your cash position and goals. Paying on bookings motivates closing but pays before cash arrives; paying on collections protects cash but pays reps later. Fintra supports all three bases, firing the commission event at the moment your plan specifies.
How do accelerators change the calculation?
Once a rep passes 100% of quota, an accelerator raises the rate on the portion above target. Fintra applies the accelerator bracket automatically based on attainment, so you do not have to compute the tiered math by hand each period.
How are clawbacks handled in the calculation?
A clawback reverses a previously earned commission when a deal is voided or a payment is returned. Fintra records it as a negative counter-event linked to the original, so the net commission is correct without editing prior payouts - something spreadsheets handle poorly.
Stay in the loop
One practical finance briefing a week - new guides, checklists, and benchmarks.
Let deals calculate their own commission
Fintra fires an event per revenue moment and applies the right rate. Start free, no card required.
Talk to us