Sales commission calculator

Work out a rep's commission for the period, with an optional accelerator for sales above quota.

How to use the sales commission calculator

Enter:

1. Sales for the period: the amount the rep closed.
2. Base commission rate as a percentage.
3. Optionally, a quota and an accelerator rate (%) paid on sales above that quota.

Leave the quota blank for a flat rate on everything. If you set a quota but leave the accelerator blank, sales above quota earn the base rate. The calculator returns the commission, the effective rate and the sales above quota (or "No quota set").

The formula in plain words

Commission = (sales up to the quota × base rate) + (sales above the quota × accelerator rate).

The effective rate is total commission ÷ total sales. When a rep passes quota, it lands between the base rate and the accelerator rate. The amount above quota is sales minus quota, or zero if the rep hasn't reached it.

A worked example

A rep sells $500,000 in a quarter. The base rate is 4%, the quota is $400,000 and the accelerator is 6%.

• Up to quota: $400,000 × 4% = $16,000.
• Above quota: $500,000 − $400,000 = $100,000, and $100,000 × 6% = $6,000.
• Commission: $16,000 + $6,000 = $22,000.
• Effective rate: $22,000 ÷ $500,000 = 4.4%.

If the same rep had sold $350,000, they'd be below quota: $350,000 × 4% = $14,000, with $0 above quota and an effective rate of 4%.

What a good commission plan looks like

A good plan is easy to explain and hard to argue about. A rep should be able to work out their own payout on the back of an envelope.

• Set the quota where a strong rep can reach it with real effort.
• Keep the accelerator meaningfully higher than the base rate, or it won't change behaviour.
• Pay on the number that matters to you. In product sales that may be revenue, or gross profit if discounting is a worry.

Run the plan at a few sales levels before you launch it. Check what it costs you if everyone beats quota.

How to improve the plan

• Pay on closed, invoiced sales, not on deals still open.
• Avoid disputes. Agree where the numbers come from, such as the CRM's closed deals and sales orders.
• Use margin. If reps can discount freely, consider commission on gross profit. The margin and markup calculator shows how price cuts hit margin.
• Review quotas each period against the pipeline. The pipeline coverage calculator shows whether a quota is within reach.

When to use the calculator

Use it when you design a plan, when you check a rep's statement and when you explain a payout. Seeing the figure with and without the accelerator makes the plan easier to discuss.

It's also useful for modelling. Enter a few levels of sales and see what each costs. With the plan above (a $400,000 quota, 4% base and 6% accelerator):

The 130% row is $16,000 on the quota plus $120,000 × 6% = $7,200 above it. Multiply each row by the number of reps you expect at that level, and you know whether the plan is affordable before anyone is paid on it.

Frequently asked questions

What is an accelerator in sales commission?

An accelerator is a higher commission rate paid on sales above quota. It rewards reps who beat their target.

Is the accelerator paid on all sales or only above quota?

In this calculator it is paid only on sales above the quota. Some plans apply it to every sale once quota is met, so check your own plan terms.

What is the effective commission rate?

It is total commission divided by total sales. It shows the blended rate once the base and accelerator rates are both in play.

Should commission be paid on revenue or profit?

Either can work. Revenue is simple. Profit protects margin when reps can discount, but it needs reliable cost data.

Does the calculator handle splits or clawbacks?

No. It covers a base rate, an optional quota and an accelerator. Splits, caps and clawbacks need to be worked out separately.