How to calculate sales commission: flat, tiered, split, clawback

To calculate sales commission, multiply the amount a rep is credited with (usually invoices paid in the period) by the rate in their plan, then adjust for splits, credits and anything carried over. A flat 5% on $60,000 paid is $3,000. Tiers, splits and clawbacks change the rate or the base, and each is worked below with round numbers. Your plan document governs; this is arithmetic, not advice on how to write a plan.

How do you calculate a flat commission?

Multiply the basis by the rate. Pay on what was collected in the month, so use the amounts on paid invoices dated in the period.

Example: a rep has $60,000 of invoices paid in September at a flat 5%.

$60,000 x 5% = $3,000

If the plan pays on gross margin instead, the basis is the margin on those invoices (amount paid minus cost). With $18,000 of margin at 10%, the commission is $1,800.

How do tiered commissions work?

A tiered plan changes the rate as the month's total grows. There are two ways to apply it, and they give different results, so your plan has to say which.

Example tiers: 4% on the first $50,000, 6% on $50,000 to $100,000, 8% above $100,000. The rep's September basis is $120,000.

Marginal tiers pay each band at its own rate:

• $50,000 x 4% = $2,000
• $50,000 x 6% = $3,000
• $20,000 x 8% = $1,600
• Total: $6,600

Retroactive tiers pay the whole month at the rate of the band reached:

• $120,000 x 8% = $9,600

The $3,000 gap is why a plan document must state the method. Commission Run supports both, with up to five tiers a month.

How do you split commission between two reps?

Apply each rep's share to the invoice, then the rate to that share. If a $10,000 invoice is split 60/40 at a 5% rate:

• Rep A: $10,000 x 60% x 5% = $300
• Rep B: $10,000 x 40% x 5% = $200

The shares must add up to 100%. If they do not, fix the split before you pay anyone. With tiers, each rep's share also counts toward their own month total, which can move them into a different band.

What is a commission clawback and how do you calculate it?

A clawback takes back commission when an invoice is credited or refunded after the rep was paid. Take back the same fraction of the commission that was paid as the fraction of the invoice that was credited.

Example: an $8,000 invoice paid $400 of commission (5%). The customer later receives a $2,000 credit.

$2,000 / $8,000 = 25%, and 25% x $400 = $100 taken back

Use the rate that was paid originally, not the rep's rate today, or a rate change will make the clawback wrong. Your plan sets the window, such as 180 days, after which a credit no longer takes commission back.

Which customers or products might be paid at a different rate?

Many plans pay a different rate on named customers, and a house account, one that no rep is credited for, is often paid 0%. Apply the customer's rate before the plan's flat or tier rate, and write the exception into the plan so nobody finds it by accident. Commission Run takes a rate per named customer on top of a rep's plan. Rates by product category are not handled, so a plan that depends on them needs an adjustment line.

How do overlapping exports affect the calculation?

Pulling "paid last month" from an accounting system often returns invoices already commissioned earlier, for example when a payment posts late or a date range overlaps. Check each invoice number against what you paid before. If an invoice shows up again for the same amount, skip it. If a later partial payment arrives on the same invoice, commission only the new amount.

What if a rep's month comes out negative?

If clawbacks exceed commission, the net is negative. Two common treatments: carry the negative balance into next month, or show it as owed. Pick one in the plan and apply it every time, then show it on the statement.

How do you put it together for a month?

For each rep:

1. List paid invoices and their shares.
2. Apply the rate: flat, tier, or a customer-specific rate (a house account can be 0%).
3. Subtract clawbacks for credits.
4. Add adjustments, such as a bonus or a correction, with a note.
5. Add last month's carry-forward.
6. The result is net payable.

Round each line to the cent once so the statement adds up. That is a lot of arithmetic for ten reps, which is what Commission Run is for: it applies steps 1 to 6 to your paid-invoice export, shows how each line was figured, and waits for your approval. The sample month on the free run includes a split invoice, a house account, tiers and a clawback.

Once the numbers are right, put them on a commission statement and a payroll sales commission report. If you are still on a sheet, see the commission tracking spreadsheet comparison.

Frequently asked questions

How do you calculate commission on a percentage of sales?

Multiply the amount of sales credited to the rep by the rate: $40,000 x 6% = $2,400.

What is the difference between marginal and retroactive tiers?

Marginal tiers apply each rate only to the band it covers; retroactive tiers apply the rate reached to the entire month.

Should commission be paid on invoiced or paid amounts?

It depends on the plan. Many distributors pay on collected cash, which is why the examples use paid invoices.