Commission Calculator

What this calculator estimates

This tool estimates commission under two common structures. Flat mode solves the standard three-variable relationship among sales price, commission rate, and commission amount. Tiered mode calculates a progressive payout in which each rate applies only to the sales inside its own bracket. It can also add a fixed base commission or a base percentage of sales. The result is an estimate for planning and reconciliation, not a payroll, tax, legal, or employment-contract determination.

Flat commission inputs

Calculate identifies the unknown value. Choose Commission amount when sales and rate are known, Commission rate when sales and payout are known, or Sales price when payout and rate are known. The calculated field becomes read-only so there is no ambiguity about which two figures drive the formula.

Sales price is the revenue, transaction value, or eligible sales basis. Enter the amount before commission unless the applicable plan defines a different basis, such as collected revenue or gross profit. A higher sales price increases commission proportionally when the rate is unchanged.

Commission rate is the percentage paid on the sales basis. Enter 5 for 5%, not 0.05. A zero rate produces zero commission; a blank or nonnumeric rate is treated as invalid when it is required. Commission amount is the payout. When you solve for the rate or sales price, it becomes an input and should reflect the gross commission before taxes, splits, clawbacks, or deductions unless your policy states otherwise.

Tiered commission inputs

Total sales price is the accumulated eligible sales for the period. Has a base commission? adds either a fixed dollar amount or a percentage of total sales before the tier amounts. When switching between dollars and percent, the calculator converts the current value using the current sales basis, which preserves the approximate economic amount.

Commission varies with price? controls whether one rule applies to the whole period or progressive brackets apply. With No selected, a percentage is multiplied by all sales, while a fixed dollar amount is paid once. With Yes selected, each tier has a From threshold, an optional To threshold, a commission value, and a commission type. Percentage tiers pay only on sales that fall inside the bracket. A fixed-dollar tier is treated as a one-time award when sales enter that tier. Leave the final To field blank to create an unlimited top tier.

Use Add tier to extend the plan and Remove to delete a bracket that no longer applies. Tier boundaries should be ordered, nonnegative, and non-overlapping. For example, 0 to 20,000 at 3%, 20,000 to 25,000 at 5%, and 25,000 upward at 10% produces $1,050 on $27,000 of sales: $600 from the first bracket, $250 from the second, and $200 from the final bracket. A common mistake is applying the top rate to all sales after a threshold is reached; this calculator uses progressive bracket logic instead.

Understanding the results

Total commission is the sum of the flat payout or all tier contributions plus any base commission. Sales basis confirms the revenue used. Effective rate divides total commission by sales; it is useful for comparing a tiered plan with a simple flat rate. A high effective rate means a larger share of sales is allocated to commission, while zero means no payout under the current assumptions.

Revenue after commission subtracts commission from sales. It is not profit because it excludes product cost, payroll taxes, benefits, refunds, overhead, and other expenses. Active rule identifies the flat rate, current tier, or fixed-award rule affecting the next portion of sales. The donut chart uses the same current model as the legend and table. In tiered mode, it shows the contribution of each paid tier and the base component; in flat mode, it compares commission with revenue retained.

The detail table is the audit trail. Sales in range shows the portion of total sales exposed to each percentage tier. Rate or award shows the rule used. Commission shows the resulting contribution. The footer must equal the primary result. After changing assumptions, use Download Excel to export the current inputs, summary, breakdown, and detailed rows rather than a static template.

Practical interpretation and common tradeoffs

Flat plans are easy to explain and forecast, but they may not strongly reward overperformance. Progressive tiered plans can create stronger incentives, although they require precise bracket definitions and more careful reconciliation. Base commission provides income stability but raises fixed compensation cost. Fixed-dollar awards can be useful for milestones, yet they create payout jumps at thresholds. Percentage tiers produce smoother marginal economics.

Document whether commission is earned on bookings, invoices, cash collected, gross margin, or net revenue; how returns and cancellations are handled; whether commissions are split; and when payouts vest. Employment and wage rules vary by jurisdiction. For general U.S. context, review the U.S. Department of Labor guidance on retail commissions, the IRS overview of employment taxes, and the Bureau of Labor Statistics sales occupations overview. A plain-language background explanation is also available from Investopedia’s commission definition.