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 type | Formula | Worked example |
|---|---|---|
| Flat rate | Sales × 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 commission | Payout = the higher of draw and commission earned; a recoverable shortfall is deducted later | Draw $3,000, earned $2,200: rep is paid $3,000 and $800 is recovered from future commission |
| Split | Deal 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 want | Formula | Example |
|---|---|---|
| Commission on a sale | Sale amount × Commission rate | $60,000 × 7.5% = $4,500 |
| Commission rate | Commission ÷ Sale amount × 100 | $4,500 ÷ $60,000 × 100 = 7.5% |
| Sales needed for a target payout | Target commission ÷ Commission rate | $10,000 ÷ 8% = $125,000 |
| Commission on gross margin | (Revenue − Cost) × Rate | ($80,000 − $50,000) × 15% = $4,500 |
| Effective rate | Total commission ÷ Total sales × 100 | $31,400 ÷ $320,000 × 100 = 9.8% |
| Total pay for the period | Base 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 amount | Rate | Calculation | Commission |
|---|---|---|---|
| $10,000 | 5% | $10,000 × 5% | $500 |
| $25,000 | 8% | $25,000 × 8% | $2,000 |
| $50,000 | 10% | $50,000 × 10% | $5,000 |
| $75,000 | 12.5% | $75,000 × 12.5% | $9,375 |
| $120,000 | 7.5% | $120,000 × 7.5% | $9,000 |
| $250,000 | 3% | $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.
| Model | Rule used in the example | Payout at 60% ($150,000), USD | Payout at 100% ($250,000), USD | Payout at 130% ($325,000), USD |
|---|---|---|---|---|
| Flat rate | 10% 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 |
| Accelerator | 10% up to quota, 20% above quota | $15,000 | $25,000 | $40,000 |
| Decelerator | 5% on all sales below 70% of quota, 10% otherwise | $7,500 | $25,000 | $32,500 |
| Capped | 10% on all sales, capped at $30,000 | $15,000 | $25,000 | $30,000 |
| Gross margin | 20% 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
| Model | Income risk for the rep | Cost predictability for the company | Behavior it drives | Typical calculation error |
|---|---|---|---|---|
| Flat rate | Low to medium | High: cost moves in line with sales | Steady effort, no push past quota | Wrong deal value or close date copied from the CRM |
| Tiered | Medium | Medium | Volume growth through the year | Retroactive and marginal tiers mixed up |
| Accelerator | Medium | Medium to low above quota | Closing more after quota is hit | Accelerated rate applied to all sales, not only sales above quota |
| Decelerator | High below the threshold | High | Reaching a minimum level | Threshold measured on the wrong period or before credits |
| Capped | Low | Very high | Holding deals back once the cap is near | Cap applied per deal instead of per period |
| Gross margin | Medium | High | Protecting price and margin | Cost data missing or changed after the deal |
| Draw against commission | Low at the start | Medium | Ramp-up without income stress | Recoverable balance not carried to the next period |
| Split | Depends on the share | High if splits sum to 100% | Team selling and handovers | Shares 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 Type | Formula | Best For |
|---|---|---|
| Flat rate | Sales × Rate | Simple, transactional sales |
| Tiered | Each tier × tier rate | Motivate higher volume |
| Accelerator | Base rate + bonus rate above quota | Reward overperformance |
| Decelerator | Reduced rate below threshold | Ensure minimum performance |
| Gross margin | Margin × Rate | Protect profitability |
| Draw against commission | Higher of draw and earned commission | New 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:
| Deal | Amount | Rate | Commission |
|---|---|---|---|
| Deal 1 | $50,000 | 10% | $5,000 |
| Deal 2 | $75,000 | 10% | $7,500 |
| Deal 3 | $120,000 | 10% | $12,000 |
| Total | $245,000 | 10% | $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:
| Tier | Sales Volume | Rate |
|---|---|---|
| Tier 1 | $0 - $100,000 | 8% |
| Tier 2 | $100,001 - $250,000 | 10% |
| Tier 3 | $250,001+ | 12% |
Calculation example: A sales rep sells $320,000 in a quarter.
| Tier | Amount in Tier | Rate | Commission |
|---|---|---|---|
| Tier 1 | $100,000 | 8% | $8,000 |
| Tier 2 | $150,000 | 10% | $15,000 |
| Tier 3 | $70,000 | 12% | $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:
| Component | Amount | Rate | Commission |
|---|---|---|---|
| Up to quota | $200,000 | 10% | $20,000 |
| Above quota | $80,000 | 15% | $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:
| Deal | Sales Price | Cost | Margin | Rate | Commission |
|---|---|---|---|---|---|
| Deal A | $100,000 | $60,000 | $40,000 | 20% | $8,000 |
| Deal B | $100,000 | $80,000 | $20,000 | 20% | $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.
| Month | Commission earned | Paid | Balance 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 type | Formula | Worked example (USD) | When it fits |
|---|---|---|---|
| Fixed amount per sale | Number of sales × Amount per sale | 7 × $500 = $3,500 | Deals of similar size, volume focus |
| Commission on ACV | Monthly price × 12 × Rate | $2,000 × 12 × 10% = $2,400 | Subscription and SaaS sales |
| Multi-year contract | Year-1 ACV × Rate + Later-year ACV × Lower rate | $24,000 × 10% + $48,000 × 5% = $4,800 | Contracts longer than one year |
| Base plus commission | Base salary + Sales × Rate | $5,000 + $40,000 × 10% = $9,000 a month | Most 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
| Model | How It Works | Example |
|---|---|---|
| Fixed split | Predetermined percentage per role | SDR 20%, AE 80% |
| Overlay | Multiple people get full (or partial) credit | AE 100%, SE 25% |
| Territory split | Based on customer location or segment | Regional rep 60%, National rep 40% |
Calculation example: SDR + AE split
Deal: $100,000 ACV
Commission pool: 10% = $10,000
Split: SDR 20%, AE 80%
| Role | Split % | Commission |
|---|---|---|
| SDR (Sarah) | 20% | $2,000 |
| AE (Mike) | 80% | $8,000 |
| Total | 100% | $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 Period | Clawback Amount |
|---|---|
| 0-3 months | 100% of commission |
| 4-6 months | 50% of commission |
| 7-12 months | 25% of commission |
| 12+ months | No 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 driver | What goes wrong | Example (USD) | Fix |
|---|---|---|---|
| Tier logic | Retroactive and marginal tiers mixed up | $320,000 pays $38,400 instead of $31,400 | State "marginal" or "retroactive" in the plan, with a worked example |
| Rounding | Each deal rounded to whole dollars | 200 deals overpaid by $81.60 | Round once per statement, to cents |
| Timing | Deal counted at signature by one person, at payment by another | A $50,000 deal counted in two periods | One recognition rule for all deals |
| Credits and refunds | Commission not reversed | $10,000 credit at 10% leaves $1,000 overpaid | Link credits to the original deal |
| CRM data | Wrong owner, amount or close date | A $40,000 deal credited to the wrong rep | Calculate from the CRM record, not a copy |
| Mid-period changes | Quota or territory change not prorated | Quota should be $260,000, not $300,000 | Prorate by days or months in each setup |
| Currency | Different exchange rates or dates used | $200 difference on one EUR 50,000 deal | Fix the rate source and the conversion date |
| Spreadsheet handling | Overwritten formulas, duplicated rows | A deal pasted twice pays twice | Pull 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 point | When the deal counts | Main risk |
|---|---|---|
| Signature (closed won) | The day the deal is marked won in the CRM | Paying on deals that are later cancelled or never paid |
| Invoice | When the invoice is issued | Delays outside the rep's control; split invoices |
| Payment received | When the customer pays | Long 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) | Employers | Share of 217 |
|---|---|---|
| Uncapped commission | 83 | 38% |
| OTE or on-target earnings | 74 | 34% |
| Accelerators | 7 | 3% |
| Clawbacks, draws or margin-based commission | 0 | 0% |
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
| Feature | Spreadsheets | Commission Software |
|---|---|---|
| Calculation accuracy | Error-prone | Automated, consistent |
| Real-time visibility | End of month/quarter | Live, after each deal |
| Audit trail | Manual version control | Complete history |
| Dispute resolution | Back-and-forth emails | Self-service breakdown |
| Time spent | Hours per pay period | Minutes |
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
| Deal | Amount | SDR | Notes |
|---|---|---|---|
| Acme Corp | $85,000 | Sarah | New business |
| TechStart | $120,000 | Mike | New business |
| GlobalInc | $95,000 | Sarah | New 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%.
| Deal | Deal Commission | SDR 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
| Line | Amount (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.
| Calculation | Formula | Result 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
- How their commission is calculated - the formula, in plain language
- What their current earnings are - updated after every deal
- What they need to do to earn more - clear path to accelerators
- 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
- Sales Management Association, Managing Sales Compensation (2017): accuracy, dispute processes and spreadsheet use, survey of 72 firms.
- ICONIQ Growth, Definitive Guide to Sales Compensation (2023): accelerators, caps and clawbacks.
- Larkin, Journal of Labor Economics (2014): revenue lost to deal timing under accelerating plans.
- UK Employment Rights Act 1996, Part II: deductions from wages.
- California Labor Code § 2751: written commission agreements.
- Prowi job ad analysis: 2,375 open sales job ads from 879 employers, open on 2 November 2026, aggregated, no employers named.
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 →