# Sales commission calculator: five worked examples, and which CRM numbers to feed it

https://salesbond.app/blog/sales-commission-calculator-closed-won-crm-worked-examples/
Published: 2026-10-28 · Updated: 2026-11-13

To calculate a sales commission, multiply the commissionable amount by the rate in the plan, using the closed-won amount in the month of its won date, net of discounts; refunds come back as a clawback on a later payout. In a marginal tiered plan each rate applies only to the slice of revenue in its band; an accelerator is a higher rate on revenue above quota; splits divide the commissionable amount before any rate applies.

The calculators that rank for this query (omnicalculator’s [commission calculator](https://www.omnicalculator.com/finance/commission), calculator.net’s [tiered commission calculator](https://www.calculator.net/commission-calculator.html)) do the multiplication fine. What they cannot do is tell you which amount to type in, and that is where payouts go wrong. Each of the five plans here is worked on one small team with every number shown, a few rows and one formula you can rebuild in a spreadsheet as you read. Which plan to choose is a different question; we covered it in [sales commission structures for a small team](https://salesbond.app/blog/sales-commission-structures-small-team/).

## The input matters more than the formula: which deal amount counts

How to reconcile payouts against the CRM every month is its own job, covered in [monthly commission reconciliation](https://salesbond.app/blog/sales-commission-tracking-crm-reconciliation/). Here we need only the definition. The commissionable amount is the deal’s value at the moment the CRM marked it won, after any discount, in the period that the won date falls into. Three decisions sit inside that sentence, and the plan has to make each of them in writing.

First, the date. A deal belongs to the month of its won date, the timestamp the CRM sets when the status changes to won. The expected close date the rep typed in August, the invoice date and the day the money arrived all stay out. We pay on won date and claw back when a customer cancels, because the won date is already in the CRM and the cash date usually is not.

Second, gross or net. A $48,000 list price with a 12.5% discount is a $42,000 commissionable amount. If your team records list price in the deal value and the discount somewhere else, subtract before you multiply. At 8%, paying on gross here is a $480 overpayment on one deal.

Third, refunds and cancellations. A deal that is won, paid out and then cancelled is a clawback: a negative line on a later payout, never an edit to a month already closed. An unpaid invoice is not a refund. On a won-date plan it still counts, and the clawback rule covers the case where it is never paid.

Everything below uses one hypothetical team of three reps. Each has a quota, the monthly revenue target the plan measures against, of $100,000. The amounts are October’s closed-won, already net. Example numbers only.

| Rep | Won deals in October | Commissionable amount (net) | Quota | Above quota |
| --- | --- | --- | --- | --- |
| Ana | 4 | $120,000 | $100,000 | $20,000 |
| Ben | 3 | $80,000 | $100,000 | $0 |
| Chloe | 2 | $100,000 | $100,000 | $0 |
| **Team** | **9** | **$300,000** | | **$20,000** |

## Example 1: flat rate on closed-won amount

A flat-rate commission is the rate times the commissionable amount: here 8%, with no quota and no tiers.

Ana: $120,000 x 8% = $9,600. Ben: $80,000 x 8% = $6,400. Chloe: $100,000 x 8% = $8,000. Team total $24,000, which is 8% of $300,000, and that is the only check a flat plan needs. If the rep lines do not add up to 8% of the team’s closed-won total, an input is wrong. The formula is fine.

This is the plan every online calculator assumes. It is also the plan where a wrong input costs the most, because nothing in the formula pushes back.

## Example 2: tiered commission, marginal vs retroactive

The plan: 6% on the first $50,000 of the month, 8% on the next $50,000, 10% on everything above $100,000. The rates are marginal: each one applies only to the revenue inside its band.

![Stacked bar splitting a $120,000 month into three marginal tiers, beside the wrong flat top-rate reading](https://salesbond.app/wp-content/uploads/2026/10/sales-commission-calculator-closed-won-crm-worked-examples-2.png)

| Rep | Band 1 ($0-50k x 6%) | Band 2 ($50-100k x 8%) | Band 3 (above $100k x 10%) | Commission |
| --- | --- | --- | --- | --- |
| Ana | $3,000 | $4,000 | $2,000 | $9,000 |
| Ben | $3,000 | $2,400 | $0 | $5,400 |
| Chloe | $3,000 | $4,000 | $0 | $7,000 |

Ana’s $120,000 earns less here than under the flat 8% plan ($9,000 against $9,600) because $100,000 of it sits in the two lower bands. Under marginal tiers the higher rate only touches revenue above each boundary, so no single deal re-prices a rep’s whole month.

A retroactive tier works the other way. Once the total crosses a threshold, the higher rate re-prices every dollar in the period, including the ones below it; Qobra’s [guide to tiered commission](https://www.qobra.co/blog/tiered-commission) calls this a “cliff”. Read that way, Ana’s month is $120,000 x 10% = $12,000. Both readings are legitimate plans, and a calculator cannot tell which one you have. The plan document has to say “marginal” or “retroactive”. If yours says neither, decide today; the difference on Ana’s month is $3,000.

## Example 3: accelerator after quota

Think of an accelerator as a two-band tiered plan whose boundary is the quota. The plan here: 8% up to quota, 12% on the slice above it, applied marginally, so only the revenue above the line gets the higher rate.

Ana: $100,000 x 8% + $20,000 x 12% = $8,000 + $2,400 = $10,400. Ben: $80,000 x 8% = $6,400. Chloe lands exactly on quota: $100,000 x 8% = $8,000, and nothing at 12%, because there is nothing above the line.

Against the flat plan the accelerator paid Ana $800 more and the other two exactly the same. It cost the team $800 in October and sent one message: a dollar above quota is worth more than a dollar below it. Where that line sits is its own subject; [how to set sales quotas](https://salesbond.app/blog/how-to-set-sales-quotas/) covers it.

## Example 4: draw against commission

A draw is an advance on commission, paid at the start of the period and deducted from what the rep earns. The question the calculator cannot answer is what happens when the rep earns less than the draw. That depends on one word in the plan. A recoverable draw is an advance the rep pays back out of later commission; a non-recoverable draw does not carry over as a debt, as Salesforce’s explainer on the [recoverable draw](https://www.salesforce.com/blog/sales/recoverable-draw/) puts it.

Ben is on a $5,000 monthly recoverable draw under the flat 8% plan. In September he closed $47,500, so he earned $3,800, received the $5,000 draw, and ended the month owing $1,200. In October he earned $6,400.

| Month | Earned (8%) | Draw paid | Balance from last month | Paid at close | Balance carried |
| --- | --- | --- | --- | --- | --- |
| September | $3,800 | $5,000 | $0 | $0 | -$1,200 |
| October | $6,400 | $5,000 | -$1,200 | $200 | $0 |

October’s line: $6,400 earned, minus the $1,200 he still owed, minus the $5,000 already paid as this month’s draw, leaves $200 at month close. If the draw were non-recoverable, September’s shortfall would be forgiven and October would pay $1,400 at close.

The balance column is the input that gets lost. The CRM knows deals, not advances, so the balance lives in the payout sheet and is carried forward by hand every month. Keep it as its own column rather than folding it into “earned”, so a rep can see where thier money went. What a draw means at the offer stage is in [OTE for a first sales hire](https://salesbond.app/blog/ote-sales-first-hire/).

## Example 5: split commission on a deal two reps worked

Chloe’s $60,000 deal in October was sourced by Ben and closed by Chloe, with a 50/50 split written into the deal. The split applies to the commissionable amount, not to the cash: $30,000 of credit moves from Chloe to Ben before any rate is applied. Chloe’s October is now $70,000; Ben’s is $110,000. The team total is still $300,000, which is the check.

Under the flat plan the split changes who gets paid but not how much the team pays: Ben $8,800, Chloe $5,600, still $24,000 in total. Under the accelerator plan from example 3 it changes the total too, because Ben is now above quota. Ben: $100,000 x 8% + $10,000 x 12% = $9,200. Chloe: $70,000 x 8% = $5,600. The split pushed Ben over the line, and $10,000 of his credit now pays 12% instead of 8%: $400 the team would not have paid without the split.

The common mistake is to calculate the deal’s commission at the closing rep’s rate and hand half the cash to the sourcing rep. On the accelerator plan that pays Ben $6,400 plus $2,400, or $8,800: $400 less than the plan owes him, because the $30,000 never counted toward his quota. Whatever your CRM calls the split field, the shares on a deal have to add up to 100%, and the the report you calculate from has to carry them.

## Pull the numbers from your CRM

One report feeds every example above: deals with status won and a won date inside the period, one row per deal with net amount, owner and split share, minus whatever the plan excludes (test deals, renewals on a new-business plan). Quota and the draw balance come from the plan and last month’s payout sheet, outside the CRM. Two links if the report itself is the problem: [CRM access for commission-only reps](https://salesbond.app/blog/commission-only-reps-pipedrive-access/) and [bookings vs billings vs revenue](https://salesbond.app/blog/bookings-vs-billings-vs-revenue-pipedrive/). If the won dates and amounts themselves look unreliable, SalesBond’s free CRM audit reads the last 30 days of the CRM and sends a PDF report with a CRM score and the findings to fix first, a useful check before the first payout run from CRM data.

## Where the arithmetic goes wrong

Each of these is an input or a reading error, and each one has a dollar figure on the team above.

- Applying the top tier to the whole month instead of the band. Ana, example 2: $3,000 overpaid.
- Gross instead of net. Ana’s $48,000 list price deal at 8%: $480 overpaid on a single row.
- Paying split credit as cash after the rate instead of as attainment before it. Ben, example 5: $400 underpaid, and no one notices because the deal’s own commission looks right.
- Dropping the draw balance between months. Ben, example 4: the $1,200 he owed is never recovered, so he is overpaid by $1,200.
- Filtering on expected close date instead of won date. Every deal that lands in the wrong month moves its commission with it: a $25,000 deal is $2,000 at 8% in the wrong payout, more if it tips a rep over quota.
- Splits that do not add up to 100%. Chloe’s $60,000 deal entered as 50/70 credits $72,000, and the $12,000 nobody sold pays $960 at 8%.

Run the team total as the first check: on a flat plan it equals the rate times closed-won revenue, and on any plan the credit still sums to the closed-won total. When the totals agree and a rep still disputes a line, the argument is about one deal’s won date, amount or split, and all three are fields a person can open and read.
