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.

Lord AI Editorial Team

The Lord AI Editorial Team publishes practical, reader-focused guides and reliable information across technology, finance, digital safety, politics, and current affairs.