MihsabaShare this free calculator
Send this tool to someone who needs the calculation.
How to use
Use the commission calculator for either a single flat sales rate or a graduated marginal tier structure. In tiered mode, each percentage applies only to the slice of sales inside that band; the calculator then adds the bands and optional base pay.
- Choose a flat rate or graduated marginal tiers.
- Enter sales for one period and optional base pay for that same period.
- For a flat plan enter one rate; for tiers enter both limits and the three band rates.
- Review each tier contribution, total commission and effective variable rate.
How it is calculated
Example
Tiered example: on 80,000 of sales, with 3% on the first 20,000, 5% from 20,000 to 50,000 and 8% above 50,000, commission is 600 + 1,500 + 2,400 = 4,500. Add 2,000 base pay and the period total is 6,500. With sales of 30,000, tier limits of 20,000 and 50,000, and rates of 3%, 5% and 8%, tier contributions are 600, 500 and zero: commission is 1,100 and the effective rate about 3.6667%. At exactly 20,000 sales, commission is 600; the higher rate applies only to the next slice.
Important notes
This is arithmetic, not an interpretation of a compensation agreement. Real plans may use retroactive rates, returns adjustments, splits, caps, draws or taxes. Mihsaba’s tiered mode is explicitly marginal, so check the actual plan before treating the estimate as payable earnings.
Worked examples and interpreting results
Sales 10000 at an assumed 5% commission give 500. With base pay 2000, total pay is 2500 in flat-rate mode.
| Case | Calculation | Result |
|---|---|---|
| Commission | 10000 × 0.05 | 500 |
| Total including base | 2000 + 500 | 2,500 |
| Commission on 30,000 with 3%, 5%, 8% tiers | 20000 × 0.03 + (30000 − 20000) × 0.05 | 1,100 |
| Effective commission rate excluding base pay | 1100 ÷ 30000 × 100 | 3.666667 % |
How to check the result
Base pay does not enter the commission calculation itself. In tiered mode, each rate applies to its own sales portion, not the highest rate to all sales.
Frequently asked questions
What is the difference between flat and tiered commission?
A flat plan applies one percentage to all sales. Marginal tiers apply different percentages to different slices of sales.
Can I mix annual base pay with one month of sales?
No. Base pay and sales should cover the same time period if you want a meaningful total.
Does this include taxes or returns?
No, unless those adjustments are already reflected in the sales figure you enter. Your compensation agreement controls actual eligibility.
Does crossing a tier change the rate on all sales?
Not in this marginal-tier mode. At 30,000 sales, the first 20,000 stay at 3% and the next 10,000 use 5%. A retroactive plan applying the highest rate to all sales requires a different calculation.
Does base pay count toward the effective commission rate?
No. Effective rate = commission alone/sales×100. Base pay is added to the modeled total earnings, but does not change the displayed commission percentage.