Incitamenter

How to Calculate Commission: Formulas and Examples

The commission formula, then tiered, accelerator, split and clawback calculations with worked numbers, a model comparison and 8 drivers of payout errors.

The commission formula

The commission formula is Commission = Sale amount × Commission rate. A $100,000 deal at a 10% rate pays $10,000 in commission. Tiered, accelerator, margin, draw and split plans change either the amount the rate applies to or the rate itself. Run your own numbers in the free commission calculator.

To calculate sales commission, take the figure the plan pays on (revenue, gross margin or ARR), multiply it by the rate that applies to it, then add or subtract adjustments such as splits, clawbacks and draw recovery. This guide gives every formula with worked numbers in USD, compares the main commission models side by side, and lists the key drivers of commission calculation errors and how to prevent them.

Key findings

  • $10,000: commission on a $100,000 deal at 10%, using Commission = Sale amount × Rate. Every other plan type is a variation on this formula.
  • $7,000: the difference on the same $320,000 quarter between marginal tiers ($31,400) and retroactive tiers ($38,400) with identical rates. How a tier applies matters more than the rates themselves.
  • $5,000.22: the extra commission a rep earns for $2 more in sales when a retroactive tier boundary sits at $250,000. Marginal tiers remove this cliff.
  • 67% of firms say their sales compensation program always pays everyone accurately, so one in three cannot say that (Sales Management Association, 2017).
  • 38% of 217 employers advertising commission-paid sales roles promise uncapped commission, but only 7 (3%) mention accelerators and none mention clawbacks in the ad (Prowi analysis of public job ads, 2 November 2026).

The 6 most common commission formulas

Plan typeFormulaWorked example
Flat rateSales × Rate$80,000 × 8% = $6,400
Tiered (marginal)Σ (Sales in each tier × Tier rate)$100,000 × 8% + $150,000 × 10% + $70,000 × 12% = $31,400
Accelerator(Sales up to quota × Base rate) + (Sales above quota × Accelerated rate)$200,000 × 10% + $80,000 × 15% = $32,000
Margin-based(Revenue − Cost) × Rate($100,000 − $60,000) × 20% = $8,000
Draw against commissionPayout = the higher of draw and commission earned; a recoverable shortfall is deducted laterDraw $3,000, earned $2,200: rep is paid $3,000 and $800 is recovered from future commission
SplitDeal commission × Split %$10,000 × 20% = $2,000 to the SDR, $8,000 to the AE

Each formula is explained step by step further down, with a full quarterly example at the end.

Related formulas: rate, target and effective rate

What you wantFormulaExample
Commission on a saleSale amount × Commission rate$60,000 × 7.5% = $4,500
Commission rateCommission ÷ Sale amount × 100$4,500 ÷ $60,000 × 100 = 7.5%
Sales needed for a target payoutTarget commission ÷ Commission rate$10,000 ÷ 8% = $125,000
Commission on gross margin(Revenue − Cost) × Rate($80,000 − $50,000) × 15% = $4,500
Effective rateTotal commission ÷ Total sales × 100$31,400 ÷ $320,000 × 100 = 9.8%
Total pay for the periodBase salary + Commission$5,000 + $40,000 × 10% = $9,000

Definitions: commission rate, gross margin commission, tiered commission.

Quick examples: commission at common rates

The basic formula covers most everyday questions. Here is what it gives for some typical deal sizes and rates:

Sale amountRateCalculationCommission
$10,0005%$10,000 × 5%$500
$25,0008%$25,000 × 8%$2,000
$50,00010%$50,000 × 10%$5,000
$75,00012.5%$75,000 × 12.5%$9,375
$120,0007.5%$120,000 × 7.5%$9,000
$250,0003%$250,000 × 3%$7,500

To work backwards from a payout, divide the commission by the sale amount: $2,000 on a $25,000 deal is an 8% rate. To find the sales needed for a target, divide the target by the rate: a $5,000 payout at 10% takes $50,000 in sales. The same arithmetic works in EUR or any other currency, as long as every deal in the period is in one currency before you apply the rate.

When the basic formula works

The simple formula works when:

  • You have a flat commission rate for all sales
  • No thresholds or tiers
  • No adjustments for deal type, product, or customer
  • Commission is paid on the full amount

Most B2B sales teams need more than that: a higher rate above quota, a different rate for renewals, a split with an SDR, or a rule for refunds. The sections below cover each of these.

How do sales commission models compare?

Sales commission models differ in one thing: how the payout responds to performance. A flat rate pays the same percentage on every dollar, tiered and accelerator plans pay more per dollar as sales grow, decelerators pay less below a threshold, caps stop the payout at a ceiling, and margin-based plans pay on profit instead of revenue. The clearest way to compare them is to run the same rep through each plan.

The table below uses one quarterly plan for all models: a $250,000 quota and $25,000 target commission, so every model pays exactly $25,000 at 100% of quota. Only the shape around quota changes.

ModelRule used in the examplePayout at 60% ($150,000), USDPayout at 100% ($250,000), USDPayout at 130% ($325,000), USD
Flat rate10% on all sales$15,000$25,000$32,500
Tiered (marginal)8% to $125,000, 12% to $250,000, 15% above$13,000$25,000$36,250
Accelerator10% up to quota, 20% above quota$15,000$25,000$40,000
Decelerator5% on all sales below 70% of quota, 10% otherwise$7,500$25,000$32,500
Capped10% on all sales, capped at $30,000$15,000$25,000$30,000
Gross margin20% of gross margin, at a 50% margin$15,000$25,000$32,500

Read across a row to see the incentive. The accelerator pays $40,000 at 130%, $7,500 more than a flat rate, which is why it is the standard tool for rewarding overperformance. The decelerator pays half of the flat rate at 60%, which protects the budget but hits a rep in a bad quarter hard. The capped plan stops at $30,000, so a rep who is already at 120% of quota has no reason to close more this period. The margin plan matches the flat rate only while margin stays at 50%; if a rep discounts and margin falls to 40%, the same $325,000 pays $26,000.

Commission models compared: risk, cost and behavior

ModelIncome risk for the repCost predictability for the companyBehavior it drivesTypical calculation error
Flat rateLow to mediumHigh: cost moves in line with salesSteady effort, no push past quotaWrong deal value or close date copied from the CRM
TieredMediumMediumVolume growth through the yearRetroactive and marginal tiers mixed up
AcceleratorMediumMedium to low above quotaClosing more after quota is hitAccelerated rate applied to all sales, not only sales above quota
DeceleratorHigh below the thresholdHighReaching a minimum levelThreshold measured on the wrong period or before credits
CappedLowVery highHolding deals back once the cap is nearCap applied per deal instead of per period
Gross marginMediumHighProtecting price and marginCost data missing or changed after the deal
Draw against commissionLow at the startMediumRamp-up without income stressRecoverable balance not carried to the next period
SplitDepends on the shareHigh if splits sum to 100%Team selling and handoversShares that add up to more or less than 100%

Accelerators are the most common choice for account executives: in ICONIQ Growth's 2023 sales compensation guide, 82% of companies offer AEs accelerators, only 14% cap commission and 53% formally enforce clawbacks. For a deeper comparison of all models with payout curves, see 7 sales commission models and when to use each, and for plans written out per role, commission plans by role.

6 commission types and how to calculate them

The six commission types below cover almost every B2B plan: flat rate, tiered, accelerator, decelerator, gross margin and draw. Each one is the basic formula with a different rule for which rate applies to which part of the sales.

Commission TypeFormulaBest For
Flat rateSales × RateSimple, transactional sales
TieredEach tier × tier rateMotivate higher volume
AcceleratorBase rate + bonus rate above quotaReward overperformance
DeceleratorReduced rate below thresholdEnsure minimum performance
Gross marginMargin × RateProtect profitability
Draw against commissionHigher of draw and earned commissionNew hires, long sales cycles

1. Flat rate commission

Flat rate commission pays one rate on every sale. It is the simplest model to explain and to check.

Formula: Commission = Sales Amount × Commission Rate

Example:

DealAmountRateCommission
Deal 1$50,00010%$5,000
Deal 2$75,00010%$7,500
Deal 3$120,00010%$12,000
Total$245,00010%$24,500

Pros: Easy to understand and calculate
Cons: No incentive to exceed expectations

2. Tiered commission

Tiered commission pays a higher rate as sales volume grows. In a marginal tier plan, each rate applies only to the sales inside its own band.

Formula: Commission = Σ (Volume in each tier × Tier rate)

Example structure:

TierSales VolumeRate
Tier 1$0 - $100,0008%
Tier 2$100,001 - $250,00010%
Tier 3$250,001+12%

Calculation example: A sales rep sells $320,000 in a quarter.

TierAmount in TierRateCommission
Tier 1$100,0008%$8,000
Tier 2$150,00010%$15,000
Tier 3$70,00012%$8,400
Total$320,000-$31,400

Note: The effective rate is 9.8% ($31,400 / $320,000), even though the top tier is 12%.

Learn more in our guide to tiered commission, including how to set tier boundaries.

Tired of manual commission calculations?

Prowi handles tiered calculations automatically. Your sales reps see their earnings in real-time - and you avoid errors and disputes.

Book a demo →

3. Accelerators

An accelerator pays a higher commission rate on sales above quota. It rewards overperformance without raising the cost of sales below quota.

Formula: Commission = (Sales up to quota × Base rate) + (Sales above quota × Accelerated rate)

Example:

  • Quarterly quota: $200,000
  • Base rate: 10%
  • Accelerated rate (above quota): 15%
  • Actual sales: $280,000

Calculation:

ComponentAmountRateCommission
Up to quota$200,00010%$20,000
Above quota$80,00015%$12,000
Total$280,000-$32,000

Without accelerator: $280,000 × 10% = $28,000
With accelerator: $32,000 (14% more commission)

This $4,000 difference motivates the sales rep to keep selling after hitting quota rather than "sandbagging" deals for next quarter. Accelerators also have a cost beyond the payout: in a study of about 8,000 enterprise software deals, accelerating plans led reps to time deals and accept poorer pricing, costing an estimated 6 to 8% of revenue (Larkin, Journal of Labor Economics, 2014). Measure attainment on the right period and watch for deals that slip just across a period boundary.

Read more about how accelerators work and when to use them.

4. Decelerators

A decelerator lowers the commission rate when a rep is below a minimum threshold, usually a share of quota. It makes sure the plan does not pay full rate for low performance.

Formula: Commission = Sales × Reduced rate (when below threshold)

Example:

  • Minimum threshold: 70% of quota ($140,000)
  • Full rate: 10%
  • Reduced rate (below threshold): 5%
  • Actual sales: $120,000 (60% of quota)

Calculation:

$120,000 × 5% = $6,000

Compare to full rate: $120,000 × 10% = $12,000

The decelerator costs the underperforming sales rep $6,000, a strong incentive to at least hit the minimum threshold. Write down whether the reduced rate applies to all sales in the period (as here) or only to sales below the threshold; both versions exist, and they give different payouts once the rep crosses the line.

5. Gross margin commission

Gross margin commission pays a rate on the profit of a deal instead of its sales value. It protects profitability, because a discount lowers the rep's commission as well as the company's margin.

Formula: Commission = (Sales Price - Cost) × Commission Rate

Example:

DealSales PriceCostMarginRateCommission
Deal A$100,000$60,000$40,00020%$8,000
Deal B$100,000$80,000$20,00020%$4,000

Same sales price, but Deal A earns twice the commission because of higher margin. This discourages excessive discounting. See discounts and commission for how to stop discounting from eating margin.

6. Draw against commission

A draw is an advance on commission that gives the rep a minimum payout while pipeline builds. With a recoverable draw, any shortfall is deducted from later commission. With a non-recoverable draw, it is not.

Formula: Payout = the higher of (Draw, Commission earned). Recoverable balance = Draw − Commission earned, when commission is below the draw.

Example: $3,000 monthly recoverable draw.

MonthCommission earnedPaidBalance to recover
Month 1$2,200$3,000$800
Month 2$3,500$3,000$300
Month 3$4,800$4,500$0

In month 2 the $500 above the draw goes to the balance. In month 3 the remaining $300 is deducted and the rest is paid out.

For all 12 models with payout curves and a calculator for each, see sales commission models explained.

Other commission formulas: per unit, recurring revenue and base plus commission

Three more formulas come up often: a fixed amount per sale, commission on recurring revenue (ACV or ARR), and total pay when commission sits on top of a base salary. Each is a small change to the basic formula.

Formula typeFormulaWorked example (USD)When it fits
Fixed amount per saleNumber of sales × Amount per sale7 × $500 = $3,500Deals of similar size, volume focus
Commission on ACVMonthly price × 12 × Rate$2,000 × 12 × 10% = $2,400Subscription and SaaS sales
Multi-year contractYear-1 ACV × Rate + Later-year ACV × Lower rate$24,000 × 10% + $48,000 × 5% = $4,800Contracts longer than one year
Base plus commissionBase salary + Sales × Rate$5,000 + $40,000 × 10% = $9,000 a monthMost B2B sales roles

The multi-year example is a three-year, $2,000-a-month contract: $24,000 in year one paid at 10% and $48,000 for years two and three paid at 5%. Paying full rate on total contract value would be $7,200, which front-loads cost for revenue the company has not yet collected. See the multi-year deal commission plan for a full example with multipliers.

Split deals: How to calculate team commission

To calculate commission on a split deal, multiply the deal's commission by each person's split percentage, and check that the shares add up to 100% unless the plan deliberately pays an overlay on top.

Common split models

ModelHow It WorksExample
Fixed splitPredetermined percentage per roleSDR 20%, AE 80%
OverlayMultiple people get full (or partial) creditAE 100%, SE 25%
Territory splitBased on customer location or segmentRegional rep 60%, National rep 40%

Calculation example: SDR + AE split

Deal: $100,000 ACV
Commission pool: 10% = $10,000
Split: SDR 20%, AE 80%

RoleSplit %Commission
SDR (Sarah)20%$2,000
AE (Mike)80%$8,000
Total100%$10,000

Calculation example: Overlay model

Deal: $100,000 ACV
AE commission: 10% = $10,000
SE overlay: 2.5% = $2,500

Total commission paid: $12,500 (125% of "standard" commission pool)

Overlays cost more but ensure specialists are motivated to support deals. Decide before the deal closes whether quota credit follows the commission share or whether both people get full quota credit; the two choices change attainment, and with it any accelerator.

Clawbacks: When and how to calculate them

A clawback recovers commission already paid when a customer churns, cancels or does not pay within a set period. It is calculated as the original commission × the clawback percentage for the period in which the customer left.

To see how a clawback moves to the next open statement, try the clawback and correction calculator.

Example clawback structure

Cancellation PeriodClawback Amount
0-3 months100% of commission
4-6 months50% of commission
7-12 months25% of commission
12+ monthsNo clawback

Calculation example

Original deal: $60,000 ACV
Original commission: $6,000 (10%)
Customer cancels: After 5 months
Clawback rule: 50% for 4-6 months

Clawback amount: $6,000 × 50% = $3,000

The $3,000 is deducted from the sales rep's next commission payment.

Pro-rata clawbacks

A pro-rata clawback recovers commission in proportion to the contract time the customer did not serve: Clawback = Commission × (Unserved months ÷ Contract months). On the same $6,000 commission and a 12-month contract cancelled after 5 months, the clawback is $6,000 × 7 ÷ 12 = $3,500. Pro-rata rules are fairer to the rep for late cancellations, step rules are easier to explain.

In Prowi, a paid statement is never rewritten when the deal behind it changes later; the difference lands as a correction on the rep's current statement, so the history of what was paid stays intact. Whatever system you use, whether a clawback can be deducted from pay depends on local law. In the UK, deductions from wages generally need a written contractual basis agreed in advance (Employment Rights Act 1996, Part II). In the US, state wage laws differ, and California requires commission agreements to be in writing (California Labor Code § 2751). EU countries have their own rules on deductions and on commission after termination. Check local employment counsel before you write a clawback clause. Our commission clawbacks guide covers policy design.

Automated clawback tracking

Prowi tracks clawback periods automatically and calculates adjustments when customers churn. No spreadsheets. No surprises.

See how it works →

What are the key drivers of errors in commission calculations?

The key drivers of errors in commission calculations are unclear plan rules, wrong or copied CRM data, unclear timing of when commission is earned, adjustments that are not applied (credits, refunds, churn, plan changes) and manual spreadsheet handling. The arithmetic itself is rarely the problem; the inputs and the rules around it are.

Independent data on commission errors is scarce. In a Sales Management Association survey of 72 firms, only 67% said their sales compensation program always pays everyone accurately, 54% had a clear dispute resolution process, and 42% called spreadsheets "extremely important" to managing sales compensation (Sales Management Association, 2017). For more figures with sources, see our sales commission statistics.

Error driverWhat goes wrongExample (USD)Fix
Tier logicRetroactive and marginal tiers mixed up$320,000 pays $38,400 instead of $31,400State "marginal" or "retroactive" in the plan, with a worked example
RoundingEach deal rounded to whole dollars200 deals overpaid by $81.60Round once per statement, to cents
TimingDeal counted at signature by one person, at payment by anotherA $50,000 deal counted in two periodsOne recognition rule for all deals
Credits and refundsCommission not reversed$10,000 credit at 10% leaves $1,000 overpaidLink credits to the original deal
CRM dataWrong owner, amount or close dateA $40,000 deal credited to the wrong repCalculate from the CRM record, not a copy
Mid-period changesQuota or territory change not proratedQuota should be $260,000, not $300,000Prorate by days or months in each setup
CurrencyDifferent exchange rates or dates used$200 difference on one EUR 50,000 dealFix the rate source and the conversion date
Spreadsheet handlingOverwritten formulas, duplicated rowsA deal pasted twice pays twicePull data from the CRM and approve every statement

Prowi calculates commission live from deal data in HubSpot, Pipedrive or Salesforce, so the formula runs on the CRM record itself instead of on a copy pasted into a spreadsheet at month-end. That removes the copy-paste step behind many of the errors above, but not unclear rules, which is why each driver also needs a written decision.

Mistake 1: Confusing retroactive and marginal tiers

Marginal (correct for most): Each tier has its own rate. Selling $320,000 means $100k at 8%, $150k at 10%, $70k at 12%.

Retroactive: Hitting a new tier applies that rate to ALL sales. Selling $320,000 means all $320k at 12%.

Retroactive tiers create "cliff effects": a tiny change in sales moves every dollar to a new rate. With the tiers above, this is what happens either side of the $250,000 boundary:

Quarterly sales (USD)Marginal tiers, commission (USD)Retroactive tiers, commission (USD)
$249,999$22,999.90$24,999.90
$250,001$23,000.12$30,000.12
$320,000$31,400$38,400

Under retroactive tiers, $2 more in sales pays $5,000.22 more in commission. Under marginal tiers it pays $0.22 more. Cliffs like this invite deal timing and disputes, so marginal tiers are the safer default.

Mistake 2: Rounding errors that compound

Small rounding errors in individual deals add up over hundreds of transactions. Take 200 deals of $1,234.56 at 7.5%. The exact commission per deal is $92.592. Rounded once at the end, the total is $18,518.40. Rounded to cents per deal, it is $18,518.00. Rounded to whole dollars per deal, it is $18,600.00, an overpayment of $81.60 that nobody decided on.

Solution: Define rounding rules (always round to 2 decimals, round at the end not each step) and apply consistently.

Mistake 3: Unclear timing of commission recognition

When is commission earned?

Recognition pointWhen the deal countsMain risk
Signature (closed won)The day the deal is marked won in the CRMPaying on deals that are later cancelled or never paid
InvoiceWhen the invoice is issuedDelays outside the rep's control; split invoices
Payment receivedWhen the customer paysLong wait for the rep; commission lands in a later period

Different rules for different deals create confusion. Define one clear policy, and if you pay at signature, pair it with a clawback rule for non-payment.

Mistake 4: Forgetting to adjust for credits and refunds

If a customer gets a $10,000 credit on a deal paid at 10%, $1,000 of commission should normally be reversed. It is often overlooked until it's a big number. Decide in the plan whether credits reverse commission in full, in part or not at all, and in which period the reversal lands.

Mistake 5: Manual spreadsheet calculations

Spreadsheets break. Formulas get overwritten, and every copy-paste from the CRM is a chance to drop or double a deal. The more components your plan has, the more errors manual calculation produces. Pull deal data straight from the CRM and have someone approve each statement before payroll.

Mistake 6: Calculating from bad CRM data

A commission formula is only as good as the deal record it runs on. The fields that cause most problems are the deal owner, the amount, the close date and the deal stage. A deal closed in March but dated April moves commission into the wrong period, and an owner change after handover can send the whole commission to the wrong person. Treat commission as a data quality check: reps will report wrong deal data quickly when it changes their pay. See commission and CRM data quality.

Mistake 7: Not prorating mid-period changes

When a rep changes territory, role or quota part-way through a period, the target should be prorated: Prorated quota = Σ (Quota in each setup × Share of the period in that setup). A rep with a $300,000 quarterly quota for one month and a $240,000 quota for two months has a prorated quota of $300,000 × 1/3 + $240,000 × 2/3 = $260,000. Using either full figure changes attainment, and with it any accelerator. See changing sales targets mid-year.

Mistake 8: Converting currencies inconsistently

International teams sell in several currencies. A EUR 50,000 deal at 10% pays $5,400 at 1.08 USD per EUR and $5,600 at 1.12, a $200 difference on one deal. Write down which rate source you use and on which date (close date, invoice date or month-end), then apply it to every deal.

What sales job ads reveal about commission plans

Most sales job ads say nothing about how commission is calculated. In Prowi's analysis of 2,375 open sales job ads from 879 employers, mostly European B2B companies, 217 employers (25%) said the role pays commission or variable sales pay. Of those, 83 (38%) promised uncapped commission, 74 (34%) used the term OTE, 7 (3%) mentioned accelerators, and none mentioned clawbacks, draws or margin-based commission.

What the ad says (employers with commission-paid roles)EmployersShare of 217
Uncapped commission8338%
OTE or on-target earnings7434%
Accelerators73%
Clawbacks, draws or margin-based commission00%

Method: Prowi's dataset of public sales job ads collected from employers' career pages, open on 2 November 2026. Sales roles only (sales reps, SDR/BDR, account executives, account and key account managers, business developers, sales managers); recruitment agencies excluded. Each ad was checked for commission or variable pay in its own language; the plan terms were matched by keyword, mainly in English, with Danish, Swedish and German variants for uncapped and margin-based pay. An ad that says nothing about commission may still pay it. Results are counted per employer, so a company that posts the same role many times counts once.

The gap matters for calculation: the rules that drive most disputes (tiers, clawbacks, timing, splits) are the ones a candidate never sees before signing. Put them in the written plan, with a worked example for each, before the first payout.

From formulas to automation: Making calculations reliable

Commission calculations become reliable when the formula runs on the source data, every plan rule is written down, and each statement is approved before payroll. Understanding the formulas is step one. Making them run the same way every period is step two.

With live commission calculation, the formula runs on each deal the moment it closes in the CRM, so nobody recalculates by hand at month-end.

The spreadsheet problem

Most companies start with Excel or Google Sheets. It works until:

  • You have more than 10 sales reps
  • Your commission model has more than 2 components
  • Someone changes a formula by mistake
  • You need to audit historical calculations
  • Sales reps dispute their numbers

What commission software does differently

FeatureSpreadsheetsCommission Software
Calculation accuracyError-proneAutomated, consistent
Real-time visibilityEnd of month/quarterLive, after each deal
Audit trailManual version controlComplete history
Dispute resolutionBack-and-forth emailsSelf-service breakdown
Time spentHours per pay periodMinutes

Learn more about what commission software is and whether you need it.

Practical example: Complete quarterly calculation

A complete quarterly calculation applies the rates to total sales first, then allocates the result to deals for splits, then subtracts split shares to get the rep's payout. Here is the full calculation for one account executive.

Setup

Sales rep: Alex
Quarterly quota: $300,000
Commission structure:

  • Base rate: 8%
  • Accelerator (above quota): 12%
  • Decelerator (below 70% of quota): 5%
  • SDR split: 15% of commission pool

Alex's Q3 results

DealAmountSDRNotes
Acme Corp$85,000SarahNew business
TechStart$120,000MikeNew business
GlobalInc$95,000SarahNew business
FastGrow$50,000-Self-sourced
Total$350,000-117% of quota

Step 1: Calculate base commission

Alex is at 117% of quota, above the 70% threshold, so the decelerator does not apply.

Up to quota ($300,000): $300,000 × 8% = $24,000
Above quota ($50,000): $50,000 × 12% = $6,000
Total gross commission: $30,000

Step 2: Calculate SDR splits

The plan allocates commission to deals in the order they closed, so the last deal, FastGrow, carries the sales above quota at 12%. The other three deals are paid at 8%.

DealDeal CommissionSDR Split (15%)Alex Gets
Acme Corp$6,800$1,020 (Sarah)$5,780
TechStart$9,600$1,440 (Mike)$8,160
GlobalInc$7,600$1,140 (Sarah)$6,460
FastGrow$6,000$0 (self-sourced)$6,000

Alex's Q3 commission: $26,400
Sarah's Q3 SDR commission: $2,160
Mike's Q3 SDR commission: $1,440

Step 3: Alex's payout, line by line

LineAmount (USD)
Commission up to quota (8%)$24,000
Accelerator above quota (12%)$6,000
SDR splits (Sarah and Mike)−$3,600
Total payable to Alex$26,400

Alex's effective rate is 7.5% ($26,400 ÷ $350,000). If the allocation rule had put the accelerated sales on a deal with an SDR, Alex's share would be lower and the SDR's higher, which is why the allocation order belongs in the written plan.

How to calculate commission in Excel or Google Sheets

To calculate commission in Excel or Google Sheets, multiply the sale amount by the rate (=A2*B2), and for tiers or accelerators use MIN and MAX to split sales into bands. The formulas below work the same in both, with sales in cell A2.

CalculationFormulaResult for the example
Flat rate (rate in B2)=A2*B2$50,000 at 10% gives $5,000
Three marginal tiers=MIN(A2,100000)*8%+MAX(MIN(A2,250000)-100000,0)*10%+MAX(A2-250000,0)*12%$320,000 gives $31,400
Accelerator above a $200,000 quota=MIN(A2,200000)*10%+MAX(A2-200000,0)*15%$280,000 gives $32,000
Commission rate from a payout (payout in B2)=B2/A2$4,500 on $60,000 gives 7.5%
Step clawback (commission in B2, months served in C2)=B2*IF(C2<=3,100%,IF(C2<=6,50%,IF(C2<=12,25%,0)))$6,000 after 5 months gives $3,000

Keep rates in separate cells instead of typing them into formulas, so a rate change is made once. Danish and some other European versions of Excel use semicolons instead of commas between arguments. Our free commission Excel template has these formulas set up with a payroll file.

Communicating calculations to your team

Reps trust a commission calculation when they can see the formula, the deals behind it and their current earnings without asking anyone. The best commission model is worthless if your team doesn't understand it.

What every sales rep should know

  1. How their commission is calculated - the formula, in plain language
  2. What their current earnings are - updated after every deal
  3. What they need to do to earn more - clear path to accelerators
  4. When they'll be paid - predictable schedule

How to create transparency

  • Commission statements: Detailed breakdown with each payment
  • Real-time dashboards: Current earnings and progress to quota
  • Calculation examples: Show exactly how the math works
  • Open door policy: Make it easy to ask questions

A Prowi commission statement lists the deals it is built from and shows the formula with the rep's own values, so a rep can check the arithmetic on their phone instead of asking finance. For more on preventing arguments about pay, see avoiding commission disputes and the psychology behind sales motivation.

FAQ: commission formulas

What is the commission formula?

The commission formula is Commission = Sale amount × Commission rate. A $50,000 deal at 10% pays $5,000. To find the rate from a payout, divide the commission by the sale amount and multiply by 100: $3,000 on a $40,000 sale is a 7.5% rate.

How do you calculate sales commission?

Start with the figure the plan pays on for the period: revenue, gross margin or ARR. Apply the rate, or each tier's rate to the sales inside that tier, then subtract split shares, clawbacks and any recoverable draw. Round once, at the end, not at every step.

How do you calculate commission in Excel?

For a flat rate, with the sale amount in A2 and the rate in B2: =A2*B2. For the three-tier example above (8% up to $100,000, 10% up to $250,000, 12% above), with sales in A2: =MIN(A2,100000)*8%+MAX(MIN(A2,250000)-100000,0)*10%+MAX(A2-250000,0)*12%. For $320,000 it returns $31,400.

How do you calculate pay mix ratio?

Divide base salary by on-target earnings (OTE) to get the base share, and target variable pay by OTE to get the variable share. With OTE of $120,000 and a base of $72,000, the pay mix is 60/40. A higher variable share means more of the rep's pay depends on the commission formula. See what OTE means for pay mix by role.

How do you reduce commission calculation errors?

Write every plan rule down with a worked example, and decide once when commission is earned: at signature, invoice or payment. Pull deal data directly from the CRM instead of retyping it, and have a manager approve each statement before it goes to payroll, so errors are caught before they are paid.

Is commission calculated on gross or net sales?

Most plans pay on net sales: the invoiced amount after discounts, excluding VAT or sales tax, shipping and other pass-through costs. Some pay on gross margin instead. Neither is required by law in general; what matters is that the plan states the base, and that credits and refunds reduce it consistently.

Sources

Get your calculations right - automatically

Start with the basic formula and add tiers, accelerators or margin rules only when they drive behavior you want. Write down how splits, clawbacks and credits are handled before the first payout, and show reps their numbers as deals close. The formulas in this guide give you the foundation; automation makes them scale.

Ready to automate your commission calculations?

Prowi handles tiered models, accelerators, splits, and clawbacks automatically. Your sales reps see their earnings in real-time, and you get hours back every month.

Book a demo →