How to calculate sales commission
The basic formula is commission = commissionable sales × commission rate. If the rate is 5% and a rep closes a $10,000 deal, the commission is $10,000 × 0.05 = $500. The real decisions sit around that formula: what counts as a commissionable sale, whether you pay on revenue or profit, how tiers work, and when commission is earned.
| Component | What it defines | Why it matters |
|---|---|---|
| Calculation base | What commission is paid on, usually revenue or gross margin | Rewards large deals or profitable deals |
| Commission rate | The percentage of the base paid out | Sets the rep’s earning potential and your cost of sale |
| Base salary | The fixed part of pay, if any | A higher base usually means a lower rate, and the reverse |
| Quota | The target for full or accelerated commission | Often triggers tiers or kickers |
| Payout timing | When commission is earned and paid | Affects cash flow for both sides |
How to calculate commission rate
To find the rate behind a payout, use commission rate = commission earned ÷ commissionable sales × 100. A $5,000 commission on $50,000 of sales is a 10% rate. Exclude any base salary from the commission earned, and use sales and commission from the same period. Choose Solve for rate above to check your numbers.
Gross profit commission calculator
Choose Gross margin above to calculate commission on gross profit rather than revenue. Enter commissionable sales, eligible product cost and the commission rate. The calculator shows the payout and the gross profit remaining after commission.
A revenue plan pays a percentage of the sale price. It’s simple and rewards volume. A gross margin plan pays a percentage of the profit after cost of goods, so discounting reduces the rep’s commission too. For example, a $10,000 sale at 5% of revenue pays $500. If the cost is $6,000, the $4,000 gross margin at 12% pays $480, and a discount would shrink both the margin and the commission. Use the Gross margin mode above to model your own numbers.
Tiered commission: marginal vs. retroactive
Tiers raise the rate as sales grow. Take tiers of 5% up to $50,000, 7% from $50,000 to $100,000, and 9% above $100,000, on $120,000 of sales:
- Marginal: each rate applies only to sales inside its band. $50,000 × 5% + $50,000 × 7% + $20,000 × 9% = $7,800.
- Retroactive: the attained rate applies to all sales. $120,000 × 9% = $10,800.
Retroactive tiers create a large jump at each threshold, which can encourage reps to time deals. Whichever you choose, say so explicitly in the agreement. Each tier limit must be higher than the one before it; the calculator checks this for you.
Split commission
When more than one person wins a deal, agree the split before the sale starts. A split doesn’t have to be 50/50. It should reflect each person’s role: for example, a share for whoever sourced the lead, a share for technical support, and the largest share for whoever ran the negotiation. Write the rule into your commission agreement so there’s nothing to argue about later.
Territories, quotas and kickers
Territories aren’t equal. Rather than paying different rates, many companies keep the rate and set quotas from each territory’s real potential, so a mature market carries a higher quota than a greenfield one. A kicker (or accelerator) raises the rate once a quota is met. For example, 6% until the quarterly quota, then 9% on every sale for the rest of the quarter.
Comparison of commission models
| Model | Best for | Main motivator | Complexity |
|---|---|---|---|
| Flat rate | High-volume sales with one closer | Closing as many deals as possible | Low |
| Tiered | Rewarding sales above target | Reaching the next tier | Medium |
| Gross margin | Varying profit per deal | Holding price and avoiding discounts | Medium |
| Territory based | Teams sharing a region | Regional results | Medium |
| Split | Multi-person B2B sales | Collaboration | High |
Commission formulas for Excel or Google Sheets
These formulas assume your first data row is row 2. Enter rates as percentages such as 10%, not the number 10.
Flat commission
=A2*B2A = commissionable sales; B = rate
Base plus commission
=C2+(A2*B2)C = base pay for the period
Solve for rate
=IFERROR(C2/A2,0)C = commission earned; format the result as %
Sales required for target pay
=IFERROR((D2-C2)/B2,0)D = target total pay; C = base pay
Gross-profit commission
=(A2-C2)*B2C = eligible product cost
Split credit
=(A2*B2)*D2D = rep credit share as %
Sales commission calculation examples
| Mode | Inputs | Result | Use it when |
|---|---|---|---|
| Flat + base | $50,000 × 10% + $2,000 | $7,000 total pay | One rate applies to all sales |
| Solve for rate | $5,000 ÷ $50,000 | 10% rate | Checking an actual payout |
| Sales for target | ($8,000 − $2,000) ÷ 10% | $60,000 sales | Setting a quota from target pay |
| Gross margin | ($50,000 − $30,000) × 10% | $2,000 commission | Protecting margin from discounts |
| Marginal tiers | $50k × 3% + $50k × 5% + $50k × 8% | $8,000 commission | Accelerating sales inside each band |
| Split credit | $15,000 × 70% | $10,500 rep share | Two sellers share one deal |
Setting a rate that works for both sides
Too low and good reps go elsewhere. Too high and the plan eats your margin. Start from your gross margin, support costs, sales cycle and repeat revenue, not from a generic percentage. For independent manufacturers’ reps, compare with the sourced ranges in our commission rate benchmarks. Then stress-test the plan: work out what you’d pay if a rep hit 200% of quota, and make sure you’d be happy to write that check.
Common commission plan mistakes
- Too complex to explain. If a rep can’t estimate what a deal will pay, the plan won’t motivate them.
- Not in writing. Define when commission is earned and paid, how clawbacks work after cancellations or non-payment, and how disputes are raised. The agreement builder covers each of these.
- Caps on earnings. Caps remove the reason to close the next deal. If big payouts worry you, fix the structure rather than capping success.
Frequently asked questions
How do you calculate a sales commission?
For a flat rate, multiply commissionable sales by the commission percentage. For example, $10,000 at 5% is $500. The calculator also supports reverse rate, target sales, gross-margin, tiered, and split-credit calculations.
How do you calculate the commission rate?
Divide the commission earned by commissionable sales, then multiply by 100. For example, $5,000 divided by $50,000 equals a 10% commission rate.
How do you calculate tiered commission?
For marginal tiers, apply each rate only to the sales inside its band and add the results. For retroactive tiers, the attained rate applies to all commissionable sales.
What is a typical commission rate?
There is no reliable universal rate across salaried employees, commission-only sellers, and independent reps. For independent manufacturers’ reps, a MANA survey of 402 members reports customer-type ranges of 5–7% for OEM sales, 5–9% for distributor sales, and 7–14% for end-user sales. Test any rate against your margin, support, and sales cycle.
Should commission be based on revenue or profit?
Revenue-based commission is simple and rewards volume. Gross-profit commission protects margin when discounts and costs vary, because the payout shrinks when the deal is less profitable. The agreement should define the basis and how returns, freight, taxes, credits, and bad debt are treated.
How often should you review a commission plan?
Review it at least once a year, and again when something material changes: a major product launch, a new market or territory, or a shift in strategy such as moving from volume to profitability.
Have the numbers? Find reps who’ll sell on them.
Preview independent reps for your products before you sign up.
More free sales tools
By the Zilla Sales team · Last reviewed