A tier table does not fully specify the formula
Tiered commission can mean that each portion of sales earns its own rate, or that the highest attained rate applies to all eligible sales. The first approach is marginal, also described as cumulative or per-band in some systems. This guide calls the second approach whole-sales. Labels vary between plans, so identify the actual formula and threshold convention rather than treating the word tiered as a complete compensation specification.
The Commission Calculator supports both explicit methods using lower sales thresholds. It does not infer which method a contract intends, convert a quota-attainment percentage into eligible sales or determine when earnings are payable. All examples are hypothetical arithmetic in one currency for one measurement period. Confirm the eligible-sales definition and independently additive base before using the model to compare an actual statement or planning worksheet.
Specify lower bounds and a complete rate schedule
Consider three tiers: sales from 0 at 3%, from 20,000 at 5% and from 25,000 at 10%. For this tool, lower bounds are inclusive and must increase strictly, with the first at zero. The rates apply under the selected method; the entries are not three independent bonuses. At sales of 27,000, all three bands have been reached, but that fact alone still does not identify the correct payout.
Enter the thresholds as sales amounts, not as commission values or upper limits. Keep every tier in the schedule valid even when current sales have not reached it. A repeated threshold or a missing starting zero leaves an ambiguous table and is rejected. Actual plans may define thresholds using different conventions, periods or quota percentages. Translate those terms independently only if the supported lower-bound model genuinely represents the agreement.
Calculate marginal commission one band at a time
At 27,000 of eligible sales, the first 20,000 earns 3%, giving 600. The next 5,000 earns 5%, giving 250. The remaining 2,000 earns 10%, giving 200. Add the band commissions to obtain 1,050. The highest rate applies only to the final portion in this method. Applying 10% to all sales would replace the per-band structure with a different formula rather than simplify it.
The effective commission rate is 1,050 / 27,000 × 100, or about 3.8889%. It is below the highest tier's 10% because earlier sales retained their earlier rates. An independent base of 1,000 would raise gross total to 2,050 but would not change that effective commission percentage. The band rows and separate base result make both checks visible without treating base compensation as another revenue commission tier.
Calculate whole-sales commission separately
With the same schedule and 27,000 sales, whole-sales mode selects the highest attained lower bound, 25,000, and applies its 10% rate to the entire 27,000. Commission is therefore 2,700, and adding the hypothetical independent base of 1,000 gives 3,700. The effective commission rate is 10%. These figures differ from marginal mode because earlier sales are repriced, not because one calculation rounded more generously.
A whole-sales formula can create a jump at a threshold. At 19,999, a 3% rate gives 599.97. At exactly 20,000, this tool's inclusive lower-bound convention selects 5% for the whole amount and gives 1,000. That 400.03 jump follows from the chosen formula. It is not evidence that a real employer uses this convention or a recommendation that either party should adopt such a plan.
Test the exact boundary rather than guessing
At exactly 20,000, marginal commission is 600: the first band is complete and the second has zero additional sales. At exactly 25,000, marginal commission is 850, while whole-sales commission is 2,500 because the 10% threshold has been attained. The table preserves those exact cases. Replacing greater-than-or-equal with strictly greater-than would change the whole-sales result at the boundary, so the comparison must name its convention.
For your own worksheet, test a value just below each threshold, exactly at it and just above it. This can reveal an unintended method or an off-by-one-cent interpretation that a high-sales example would hide. Do not round sales up to the next tier to make a threshold appear reached. Eligibility and measurement precision come from the underlying records and plan, not from a desired payout or the number of decimals shown in a result.
| Eligible sales | Marginal commission | Whole-sales commission |
|---|---|---|
| 19,999 | 599.97 | 599.97 |
| 20,000 | 600 | 1,000 |
| 25,000 | 850 | 2,500 |
| 27,000 | 1,050 | 2,700 |
Hypothetical lower bounds 0 at 3%, 20,000 at 5%, and 25,000 at 10%. Lower bounds are inclusive; base pay is excluded.
Separate the marginal rate from the effective rate
In marginal mode, one additional unit of sales above 25,000 earns 0.10 commission while that tier remains applicable. That ten-percent incremental rate is different from the effective percentage on all sales to date. At 27,000, total commission remains 1,050 and the effective rate is about 3.8889%. A statement can legitimately display both quantities, provided each is labeled with the amount or sales portion it describes.
The same distinction matters when comparing scenarios. A rate shown for the last band cannot simply multiply the total to estimate marginal commission. Conversely, a blended effective rate from yesterday's sales cannot be assumed to apply to tomorrow's additional sales. Recalculate using the complete schedule. If rates decrease in a later tier, the tool follows the entered arithmetic; it does not interpret that schedule as a mistake or endorse its compensation design.
Do not add unsupported contract features
A plan might measure attainment as a percentage of quota, apply a cap, reset quarterly, carry balances or reverse credit for returned sales. Those features require definitions and potentially additional state. The supported model takes one eligible-sales amount, one explicit tier schedule and an optional independent base. It does not predict future bookings, settle a recoverable draw or decide how an incomplete period should be prorated.
Keep thresholds, sales and base in the same currency and period. The currency selector does not convert international revenue, and the gross total excludes tax withholding or other deductions. A difference from a payroll statement should trigger a reconciliation of source lines and plan rules, not a switch to the more favorable method. Arithmetic can compare specified structures but cannot resolve an ambiguous entitlement or an employment dispute.
Preserve the method with the result
Record the tier lower bounds, rates, boundary convention, method and eligible-sales amount with the computed commission. For the 27,000 example, saving only the schedule is insufficient because it permits either 1,050 marginal commission or 2,700 whole-sales commission. Include the separate 1,000 base only if it is independently additive. A reviewer should be able to reconstruct the band amounts or the selected whole-sales rate without guessing which interface option was active.
Retain unrounded calculations and label displayed money precision. At zero eligible sales the commission is zero but its effective percentage is undefined, while a specified independent base may remain. These boundary checks help distinguish missing ratios from valid zero amounts. This is an educational comparison, not financial, tax or legal advice, and neither the calculator nor this guide establishes which commission structure applies to any real employment or sales agreement.