Sales Commission Calculator

What Is the Sales Commission Calculator?

This tool calculates sales commission using either a flat rate, or a tiered structure where the portion of a sale above a threshold earns a higher rate -- a common real-world commission plan design.

How to Use This Tool

Enter the sale amount and base commission rate. Optionally enable a tier to set a threshold and higher rate for the amount above it. Commission appears instantly.

The Formula

Worked Example With Hypothetical Numbers

The calculator opens with a sale of 15,000, a base rate of 10 percent, and a tier that starts above 10,000 at 15 percent. The first 10,000 earns 10 percent, which is 1,000. The remaining 5,000 earns 15 percent, which is 750. The commission is 1,750.

Compare that with a flat plan: turn the tier off and 15,000 at 10 percent earns 1,500. And if a sale is 8,000, which is below the threshold, the tier never applies and the commission is 800 either way. The tier only affects the slice of the sale above the threshold; it does not lift the earlier portion to the higher rate.

Marginal Tiers vs. Retroactive Tiers

The tool implements a marginal structure, like tax brackets: each rate applies only to the dollars inside its band. Some commission plans work differently and pay the higher rate on the entire amount once the threshold is passed. In the example above, a retroactive plan would pay 15 percent of 15,000, which is 2,250, a difference of 500 from this tool. Read your compensation plan carefully to find out which structure it uses. If it is retroactive, this calculator will understate the payout, and you would need to work it out by hand or with the flat-rate option using the higher rate.

Step-by-Step Usage

• Enter the sale amount that the plan says commission is based on. Plans differ on whether this is revenue, profit, or amount collected, so use the same basis as your agreement.
• Enter the base commission rate as a percentage, such as 10 for 10 percent.
• Leave the tier checkbox on if a higher rate applies above a threshold, then enter the threshold amount and the tier rate. Untick it for a simple flat-rate commission.
• Read the commission earned figure, and use the copy or download action if you want a plain-text record.

Edge Cases and Assumptions

• The tool supports one base rate and one tier. Plans with several bands would need separate calculations for each band, added together.
• If the tier threshold or tier rate is left at zero or blank, the tier is ignored and the flat base rate is used for the whole sale. That means a tier rate of exactly zero percent cannot be modeled.
• Quota thresholds are often measured over a month or quarter of cumulative sales, not a single deal. In that case, enter the total for the measurement period as the sale amount rather than each deal separately.
• The tool does not handle splits between reps, draws against future commissions, clawbacks on refunds or cancellations, caps, or accelerators tied to other targets.
• Results appear in US dollar formatting to two decimal places, and the commission is gross, before any tax or withholding.

Using the Tool for Planning

Managers can try different thresholds and rates to see how a plan pays out at typical sale sizes before committing to it, and salespeople can estimate earnings at different deal sizes. Actual commission agreements are contractual documents, so for disputes or unclear terms, refer to the signed plan and, if necessary, seek advice from a qualified professional.

Frequently Asked Questions