Sales commission calculator
Paste your closed deals with a rep name on each line, choose a flat rate or tiers, and the calculator shows what each rep earned. Refunds and cancellations can be entered as clawbacks, and the result downloads as a CSV statement.
Everything runs in your browser. Your text and files stay on your device and are never uploaded.
Add deals or load the example to see each rep's commission.
How to use it
- Paste one deal per line as a rep and an amount, such as Maya, 8400, or paste two columns copied from a spreadsheet or CRM export. Add the word clawback, or a minus sign, to a line that reverses an earlier deal.
- Choose a flat commission rate, or switch to tiers and list where each band starts and its rate, such as 15000 8 for 8% from $15,000.
- For tiers, pick whether each band pays its own rate or the tier a rep reaches pays on all of their sales.
- Choose how clawbacks are taken back: subtracted from sales before the plan applies, or deducted at the rate the rep earned.
- Set the share of each clawback you recover and a minimum payout if your plan has one, then copy or download the CSV.
Two ways to take back a clawback
Say a rep closes $20,000 on a plan that pays 5% up to $15,000 and 8% above, then $5,000 of it is reversed.
| Method | Working | Commission |
|---|---|---|
| Subtract from sales | $15,000 net sales, all in the 5% band | $750.00 |
| Take back at the rate earned | $1,150 earned on $20,000 (5.75%), minus 5.75% of $5,000 | $862.50 |
Subtracting from sales can drop a rep below a tier they already hit. Taking back at the rate earned removes only the commission that deal paid, so the rep keeps the higher rate on the rest. Use whichever your plan document says.
Questions
How do you calculate sales commission?
Multiply the sales amount by the commission rate. An 8% rate on $25,000 of closed deals pays $2,000. With tiers, the rate depends on how much the rep has sold in the period.
What is a commission clawback?
A clawback takes back commission already earned on a deal that was refunded, cancelled or charged back. Plans usually set a window, such as 90 days, during which a reversed deal reduces the rep's pay.
Should a clawback reduce sales or commission?
Both are common. Reducing sales can push a rep under a tier they had reached. Taking back commission at the rate earned removes only what was paid on that deal. Your plan document decides, and the calculator has a setting for each.
What is the difference between marginal and whole-tier plans?
Marginal tiers pay each band of sales at its own rate. Whole-tier plans pay the highest rate reached on every dollar, so crossing a threshold lifts the whole payout.
What happens when a rep's clawbacks are bigger than their sales?
The rep's commission for the period can go negative, which is the amount they owe back or carry into the next period. If you set a minimum payout, the payable column shows the minimum instead, and the commission column still shows the shortfall.
Are my deals saved or sent anywhere?
No. The math runs in your browser, so rep names and amounts are not uploaded. Closing the tab clears them.