How to Calculate Commission
Commission is variable compensation tied to sales, revenue, profit, collections, units, or another measurable result. A basic plan may pay one percentage of sales, while a more advanced plan may use quotas, tiers, accelerators, product rates, team splits, clawbacks, or recoverable draws. The arithmetic is usually easy; the difficult part is identifying the correct commission base and applying the plan rules consistently.
Before calculating commission, use the signed compensation plan and the company’s official transaction data. A spreadsheet formula cannot resolve unclear rules about cancellations, discounts, taxes, refunds, payment timing, or account ownership.
Quick Answer
For a simple percentage plan:
Commission = commissionable sales × commission rate
If a salesperson earns 6% on $40,000 of commissionable sales, the commission is $2,400. For tiered plans, calculate each tier separately. For gross-margin plans, apply the rate to eligible gross profit rather than revenue. Then adjust for splits, bonuses, draws, returns, and prior-period corrections.
Step 1: Read the Compensation Plan
Confirm the plan period, effective date, eligible employees, commission event, rate, quota, tiers, payment timing, and treatment of adjustments. Identify whether commission is earned when an order is signed, invoiced, delivered, accepted, paid, or no longer refundable.
Also check whether the plan excludes sales tax, freight, discounts, credits, internal sales, low-margin products, uncollected invoices, or house accounts. Use the written plan, not an informal memory of how the plan worked last year.
Step 2: Determine the Commission Base
The commission base is the amount to which the rate applies. Common bases include:
- Gross sales
- Net sales after discounts and returns
- Cash collected
- Gross profit or contribution margin
- Number of units or contracts
- Recurring revenue
- Renewal or expansion revenue
For net sales:
Commissionable sales = gross sales − excluded discounts − returns − credits − other plan exclusions
Do not automatically subtract taxes, delivery, or fees unless the plan says they are not commissionable.
Step 3: Convert the Rate to Decimal Form
Divide a percentage by 100 before multiplying. A 7.5% rate becomes 0.075. Then:
$32,000 × 0.075 = $2,400
In a spreadsheet, a cell formatted as 7.5% already stores 0.075. Entering 7.5 and formatting it as a percentage can create an incorrect result, so inspect the underlying value.
Step 4: Calculate a Flat-Rate Commission
Assume a representative has $55,000 in gross sales, $3,000 in returns, and an 8% commission on net sales:
Net sales = $55,000 − $3,000 = $52,000
Commission = $52,000 × 8% = $4,160
Keep a transaction-level schedule so the total can be traced to customer invoices and adjustments.
Step 5: Calculate Tiered Commission
A tiered plan applies different rates to different portions of performance. Suppose the plan pays:
- 3% on the first $20,000
- 5% on the next $30,000
- 7% above $50,000
For $68,000 of sales:
- $20,000 × 3% = $600
- $30,000 × 5% = $1,500
- $18,000 × 7% = $1,260
Total commission = $3,360
Do not apply the highest reached rate to all sales unless the plan is a retroactive or “cliff” plan. Marginal and retroactive tiers produce very different payouts.
Step 6: Calculate Commission Against Quota
Quota attainment is:
Attainment percentage = actual credited performance ÷ quota × 100
If a representative sells $120,000 against a $100,000 quota, attainment is 120%. The plan may pay a base rate up to quota and an accelerator above quota. Apply each rate only to the portion specified.
Some plans include a threshold below which no commission is paid. Confirm whether crossing the threshold activates payment on all eligible sales or only on sales above the threshold.
Step 7: Calculate Gross-Margin Commission
Margin-based plans reward profitable selling. First calculate eligible gross profit:
Gross profit = eligible revenue − eligible cost of goods sold
If a deal generates $25,000 of revenue and $16,000 of eligible direct cost, gross profit is $9,000. At a 12% commission rate:
$9,000 × 12% = $1,080
Define cost carefully. Standard cost, actual cost, freight, installation labor, rebates, and shared overhead can change the result. The compensation plan should state which cost source controls.
Step 8: Calculate Unit or Fixed-Amount Commission
Some plans pay a fixed amount per qualified unit:
Commission = eligible units × rate per unit
If an employee receives $35 for each of 48 activated accounts, commission is $1,680. Confirm that every unit meets the qualification rules and has not been cancelled, duplicated, or disqualified.
Step 9: Handle Split Commission
When multiple employees receive credit, calculate the total commission and allocate it according to the approved split. A $5,000 commission split 60/40 produces $3,000 and $2,000.
Confirm whether the split applies to revenue credit, quota credit, commission payout, or all three. A salesperson may receive partial payout but full quota credit under some plans.
Step 10: Apply Draws and Guarantees
A draw is an advance against future commission. A recoverable draw creates a balance that future earned commission must repay. A nonrecoverable draw generally acts more like guaranteed minimum compensation for the defined period.
If an employee receives a $2,500 recoverable draw and earns $3,200 commission, the net commission above the draw is $700. Track the opening balance, advances, earned commission, repayments, and closing balance. Check local employment rules because deductions and recovery may be restricted.
Step 11: Adjust for Returns, Cancellations, and Clawbacks
If a previously commissioned sale is reversed, follow the written clawback rule. Record the original transaction, prior commission, adjustment reason, date, and affected payout period. Avoid silently changing historical reports.
Some businesses wait until customer payment or the return window expires before treating commission as earned. This reduces clawbacks but delays payment. The plan should balance sales motivation, customer risk, and legal requirements.
Step 12: Add Bonuses and SPIFFs Separately
Bonuses may reward quota achievement, specific products, new customers, retention, team performance, or strategic behavior. Calculate the ordinary commission first, then add each independently verified bonus.
Total variable compensation = standard commission + accelerators + bonuses − approved adjustments
Separating components makes statements easier to audit and helps employees understand the payout.
Detailed Commission Example
A salesperson has $90,000 of invoiced revenue. The plan excludes $5,000 of taxes and freight and includes a $4,000 return. Commission is 4% up to $60,000 and 7% above $60,000. A colleague receives 20% of commission credit on a jointly sold $10,000 portion.
Commissionable sales before split are $81,000. The normal tier result is:
- $60,000 × 4% = $2,400
- $21,000 × 7% = $1,470
- Total before split adjustment = $3,870
The exact split adjustment depends on whether the plan splits transaction credit before tiering or splits the resulting commission for that deal. These approaches can produce different results, so the plan must specify the method.
Commission Statement Checklist
| Field | Purpose |
|---|---|
| Transaction identifier | Links payout to invoice, order, or contract |
| Customer and date | Supports verification |
| Commission base | Shows eligible sales, units, or margin |
| Rate or tier | Explains the calculation |
| Split credit | Documents shared ownership |
| Adjustments | Shows returns, clawbacks, or corrections |
| Bonus and draw | Separates other compensation |
| Total payout | Reconciles to payroll |
Common Commission Calculation Mistakes
- Using revenue instead of the defined commission base
- Applying the top tier to every dollar without plan support
- Confusing quota credit with payout credit
- Calculating percentages before returns and exclusions are finalized
- Counting cancelled or duplicate transactions
- Subtracting a draw incorrectly or twice
- Changing rates without documenting the effective date
- Rounding each line too early instead of rounding under a consistent policy
- Failing to reconcile commission with payroll and the general ledger
Writer’s Opinion
A good commission plan should be explainable by a salesperson using a small number of examples. If employees cannot independently estimate what a sale will pay, the plan may create disputes rather than motivation. I would favor transparent bases, a limited number of tiers, clear ownership rules, and a transaction-level statement.
I also recommend testing the plan against extreme scenarios before launch: very large deals, deep discounts, returns, split sales, employee departure, and performance far above quota. Many costly errors appear only outside the normal range.
Video: Sales Commission and Compensation Basics
[youtube=https://www.youtube.com/watch?v=VhwZ9t2b3Zk]
Frequently Asked Questions
Is commission calculated before or after tax?
The answer depends on the plan. Sales taxes collected for a government are often excluded from commissionable revenue, but the written plan and local rules control.
How do you calculate a 5% commission?
Multiply the eligible commission base by 0.05. For example, 5% of $18,000 is $900.
Is commission part of payroll?
Commission is generally compensation and normally must be processed under applicable payroll, tax, wage, and reporting rules. Requirements differ by jurisdiction.
What is an accelerator?
An accelerator is a higher commission rate or multiplier that applies after a performance level, often quota, is reached.
Should commission be based on sales or collections?
Sales-based plans pay sooner and emphasize booking business. Collection-based plans reduce bad-debt risk but may place payment risk outside the salesperson’s control. Choose and document the method that fits the role.
Final Calculation Checklist
- The correct plan version and period are used.
- The earning event and commission base are confirmed.
- Rates, tiers, quotas, and thresholds are applied correctly.
- Splits, returns, draws, bonuses, and clawbacks are documented.
- Transactions reconcile to approved sales or collection data.
- The payout reconciles to payroll and accounting records.
- The employee receives a clear statement and dispute process.
Commission accuracy depends on rules as much as formulas. Define the base, calculate each component separately, preserve an audit trail, and apply the plan consistently.

