How to Calculate Sales Commission (Formulas + Examples)
Complete guide to commission calculation formulas — flat rate, tiered, quota-based, and accelerators. Worked examples for SDRs, AEs, and common edge cases.
Commission calculation isn't complex — until there are accelerators, splits, clawbacks, and four reps on the same deal. This guide covers every formula you'll need, with worked examples for the most common plan types.
The basic formula
Every commission calculation starts here:
Commission = Sale Amount × Commission Rate
If a rep closes a $50,000 deal on a flat 8% commission:
$50,000 × 0.08 = $4,000
Most plans add structure on top of this: tiered rates, quota thresholds, accelerators. But every variation is a modification of this base formula.
Flat-rate commission
A flat rate applies the same percentage to all revenue, regardless of how much a rep closes.
Formula: Commission = Total Revenue Closed × Rate
Example: Rep closes $780,000 in a quarter on a 9% flat rate.
$780,000 × 0.09 = $70,200
Flat-rate plans are easy to administer and explain. A rep can calculate their payout in their head after every deal. The downside: they don't specifically incentivize pushing above quota.
Quota-based commission (deriving the rate)
Most plans are quota-based — the commission rate isn't stated directly, it's derived from OTE and quota.
Formula: Commission Rate = On-Target Variable ÷ Quota
Then: Commission = Revenue Closed × Derived Rate
Example: Mid-Market AE
| Component | Value |
|---|---|
| OTE | $180,000 |
| Base salary | $99,000 |
| On-target variable (OTV) | $81,000 |
| Annual quota | $900,000 |
Derived commission rate: $81,000 ÷ $900,000 = 9%
At 100% quota ($900K closed): $900,000 × 0.09 = $81,000 ✓
At 85% quota ($765K closed): $765,000 × 0.09 = $68,850
At 115% quota ($1,035K closed): $1,035,000 × 0.09 = $93,150 — unless accelerators kick in.
Tiered commission (accelerators)
Tiered plans apply different rates to different attainment bands. The key rule: each rate applies only to the revenue in that band, not all revenue.
Formula:
Commission = (Tier 1 Revenue × Tier 1 Rate)
+ (Tier 2 Revenue × Tier 2 Rate)
+ (Tier 3 Revenue × Tier 3 Rate)
...
Example plan:
| Attainment | Rate |
|---|---|
| 0–100% of quota | 9% |
| 100–125% of quota | 13.5% |
| 125%+ of quota | 18% |
Quota: $900,000
Scenario A: Rep closes $900K (exactly on quota)
Tier 1: $900,000 × 0.09 = $81,000
Total commission: $81,000
Scenario B: Rep closes $1,080,000 (120% of quota)
Tier 1 cap: $900,000 Tier 2 revenue: $1,080,000 − $900,000 = $180,000
Tier 1: $900,000 × 0.09 = $81,000
Tier 2: $180,000 × 0.135 = $24,300
Total commission: $105,300
Scenario C: Rep closes $1,260,000 (140% of quota)
Tier 1 cap: $900,000 Tier 2 cap: $900,000 × 1.25 = $1,125,000 → Tier 2 revenue = $1,125,000 − $900,000 = $225,000 Tier 3 revenue: $1,260,000 − $1,125,000 = $135,000
Tier 1: $900,000 × 0.09 = $81,000
Tier 2: $225,000 × 0.135 = $30,375
Tier 3: $135,000 × 0.18 = $24,300
Total commission: $135,675
This is why "I closed 140% of quota" means different things depending on whether the plan is flat or tiered.
SDR quota bonus calculation
SDR plans often use a per-unit rate or milestone bonus structure rather than revenue percentage. The formula is simpler.
Per-unit formula: Commission = Units Completed × Rate Per Unit
Example: SDR earns $583 per qualified meeting booked (derived from $35,000 OTV ÷ 60 meetings/quarter).
If the rep books 52 meetings:
52 × $583 = $30,316
At 60 meetings (100% quota): 60 × $583 = $34,980 (rounds to $35,000)
Accelerator: 1.5x per meeting above quota
If the rep books 68 meetings (8 above quota):
Base (60 meetings): $35,000
Accelerator (8 meetings × $583 × 1.5): $6,996
Total: $41,996
Split commission calculation
When multiple reps share credit for a deal, commission is allocated by split percentage.
Formula: Rep Commission = Deal Value × Commission Rate × Split Percentage
Example: Two AEs co-sell a $200,000 deal. Rep A gets 60% credit, Rep B gets 40%.
Commission rate: 9%
Rep A: $200,000 × 0.09 × 0.60 = $10,800
Rep B: $200,000 × 0.09 × 0.40 = $7,200
Note: some plans apply splits to quota attainment as well — the $200K deal counts as $120K toward Rep A's quota and $80K toward Rep B's. Whether you track this at the deal level or only at payout depends on your CRM setup.
For more on when and how to design split policies, see commission splits: when and how to split sales credit.
Clawback calculation
A clawback recovers previously paid commission when a deal falls through within the clawback window (typically 60–90 days from close).
Full clawback: The entire commission paid on that deal is recovered.
Partial clawback: A prorated amount based on how far through the clawback window the churn occurred.
Example: Rep earned $9,000 commission on a $100,000 deal (9% rate). Customer cancels on day 45 of a 90-day clawback window.
Full clawback: Recover $9,000 from next payout.
Prorated clawback: $9,000 × (1 − 45/90) = $9,000 × 0.50 = $4,500
Most companies use full clawbacks within the window rather than prorated, since prorated calculations add administration overhead. For an analysis of when each approach makes sense, see commission clawbacks: when to use them.
Ramp period calculation
New hires on ramp quotas still earn commission on all revenue — the ramp affects the attainment threshold, not the commission rate.
Example: New AE on a 4-month ramp with full quota of $900K/year ($225K/quarter).
| Month | Ramp % | Ramp quota | Actual closed | Attainment |
|---|---|---|---|---|
| 1 | 25% | $56,250 | $40,000 | 71% |
| 2 | 50% | $112,500 | $85,000 | 76% |
| 3 | 75% | $168,750 | $150,000 | 89% |
| 4 | 100% | $225,000 | $210,000 | 93% |
Commission at 9% rate in month 3: $150,000 × 0.09 = $13,500
Attainment of 89% means no accelerator kicks in — but the rep still earns full commission on every dollar closed. If you're also using a draw structure during ramp, see draw against commission: how it works.
Calculating commission on multi-year deals
For multi-year contracts, commission is typically paid only on Year 1 ARR (or on total contract value at a reduced rate). The calculation depends on your plan's deal crediting rules.
Year 1 only: Commission = Year 1 ACV × Commission Rate
TCV with haircut: Commission = Total Contract Value × Reduced Rate
Example: Rep closes a 3-year contract at $60,000/year ($180,000 TCV). Commission rate is 9% on ACV.
ACV-based: $60,000 × 0.09 = $5,400
If the plan pays on TCV at a 3% rate (equivalent incentive): $180,000 × 0.03 = $5,400
The math should be equivalent — if it isn't, reps will game the deal structure to maximize payout rather than optimize for customer value.
Where manual calculation breaks down
A single rep on a flat commission rate takes 30 seconds to calculate. Add tiers, splits, clawbacks, ramp adjustments, and four product lines with different rates, and each payout cycle becomes a spreadsheet project.
The typical commission calculation process in a 20–30 rep team without dedicated tooling:
- Export closed-won deals from CRM
- Match deals to rep territories and plan versions
- Apply each rep's current rate and tier thresholds
- Subtract clawbacks from prior periods
- Handle split deals and deal modifications
- Cross-check against rep shadow spreadsheets when disputes arise
According to research by Forrester, sales reps spend an average of 4 hours per pay period on commission-related activities — checking their own numbers, following up with ops, or reconciling discrepancies. At a 30-rep team, that's 120 hours of selling time per month lost to commission uncertainty.
Tools like Carvd automate the calculation by pulling deal data from your CRM and applying plan rules. Reps can see exactly how each deal contributes to their payout without waiting for the end-of-month close. The output is the same calculation you'd do manually — but applied to every deal, every rep, every pay period, without the spreadsheet.
For a broader look at the software that handles this, see our guide to commission tracking software.
Related reading
- Commission formula for every plan type — formulas for revenue-based, unit-based, margin-based, and milestone plans
- Commission spreadsheet: free template + why you'll outgrow it — how to build a tracking spreadsheet and when to graduate from it
- Commission errors: the most common mistakes — calculation errors, data entry problems, and formula bugs that drive disputes
- Tiered commission structure: how to build one that scales — designing accelerator tiers that motivate without surprising finance
Last updated: February 3, 2026