Free sales commission tool
Commission Calculator
Enter eligible sales and your rate. Add tiers, a base amount or a dated sales statement when you need more detail.
Use the plan you actually have
How to calculate sales commission
For a flat rate, multiply eligible sales by the percentage: 25,000 × 6% = 1,500. Start there if you only need one answer. Use your plan’s eligible sales amount; this calculator does not decide whether a discount, tax or uncollected invoice belongs in it.
Marginal tiers apply to slices of sales
When your plan has marginal tiers, each rate applies only within its sales band. Crossing a threshold changes the rate on the next slice; it does not replace the rates below it. Add your fixed base once, for the same selected period, to see modeled gross earnings.
Review a period before saving the statement
The optional ledger sorts rows by date, then visible entry order for ties. Start and end dates are inclusive. Rows outside those dates remain visible as excluded. A same-period reduction reduces the cumulative sales base under the entered plan; it cannot take that running base below zero.
Your CSV and PDF include the plan, period, signed changes and reconciled totals. They are calculations of entered assumptions, not pay stubs or evidence that anyone was paid.
Synthetic worked example
25,000 in sales gives 1,750 in marginal commission
These figures show how the math works. The rates and base are examples, not suggested compensation terms.
| Eligible slice | Rate | Commission |
|---|---|---|
| First 10,000 | 5% | 500.00 |
| Next 10,000 | 7.5% | 750.00 |
| Last 5,000 | 10% | 500.00 |
| Sales commission | 1,750.00 | |
| Fixed base for this period | 2,000.00 | |
| Modeled gross earnings | 3,750.00 |
Applying the final 10% rate to all 25,000 would give 2,500 commission. That is a different, retroactive plan and does not match this calculator’s marginal rule.
A same-period reduction changes the cumulative amount
Sales of 9,000, then 3,000, then 13,000 contribute 450, 200 and 1,100 commission. A 6,000 reduction then takes sales from 25,000 to 19,000. Cumulative commission becomes 1,175, so the reduction row contributes −575. The unchanged 2,000 period base gives 3,175 modeled gross earnings.
Why every row adds up to the final commission
The calculator uses exact decimal inputs and rounds cumulative commission half-up to two decimals. Each row receives the rounded cumulative amount after it minus the amount before it. This preserves negative adjustments and makes the displayed rows reconcile exactly.
For two 0.05 sales at 10%, cumulative commission rounds to 0.01 after each row. Row amounts are therefore 0.01 and 0.00, totaling 0.01. Rounding each small transaction separately would give 0.02. Your actual contract may use another convention; this worksheet does not interpret or replace it.
Commission questions & limits
Does the highest tier rate apply to all sales?
No. This calculator uses marginal tiers: each rate applies only to the sales within that band. If your contract uses a retroactive rate on all sales, its rule is outside this model.
What counts as eligible sales?
Use the amount your plan defines as eligible, after any exclusions you have established. This tool does not decide how discounts, returns, tax, collection or profit should affect eligibility.
Can I add monthly base pay?
Yes, when the selected period covers that same month and the entered amount is the base for it. No annual-to-monthly conversion or prorating happens automatically.
How does a refund change the commission?
A same-period reduction subtracts eligible sales and recalculates the cumulative commission under the entered plan. Its row amount is the difference from the previous cumulative commission. A running total below zero is an error; earlier-period clawbacks are unsupported.
Why can two small rows have different commission amounts?
Cumulative half-up rounding avoids a mismatch between rows and period totals. Two 0.05 sales at 10% yield rounded cumulative commissions of 0.01 and 0.01, so their row amounts are 0.01 and 0.00.
Is this take-home pay?
No. Commission and base are gross modeled amounts. Withholding, employment rules, deductions and payments are not calculated.
What are the input and export limits?
Up to 200 rows, 10 marginal tiers per plan and two plans on the same sales. Money has two decimals and is bounded to 999,999,999.99 per field and total; rates are 0–100% with up to four decimals. USD, EUR, GBP, CAD, AUD, INR, PKR and AED are labels, with no conversion. Dates are 1900–2100.
No automatic saving, uploads, customer names or accounts are required. PDF export checks font coverage and identifies fields containing unsupported characters; CSV preserves them. Formula-like CSV references are prefixed with an apostrophe, changing the field’s text. That treatment is not a universal spreadsheet-safety guarantee.
Which plans are outside the calculation?
Retroactive all-sales tiers, historic chargebacks, profit-based commission, separate product rates, team splits, draws, guarantees, caps and bonuses are unsupported. No tax withholding, deductions, overtime, minimum wage or employment entitlement is calculated.
Model & source notes
The flat and marginal formulas follow the entered plan. Stable date ordering, same-period reduction handling and cumulative half-up cents are explicit worksheet conventions, not universal payroll rules.
Calculator.net — Commission Calculator — Definitions and worked examples of flat, base-plus and marginal-tier structures. Our cumulative rounding and period-ledger conventions are explicitly stated model choices.
Method and input rules checked: . Engineering validation; no professional specialist review is claimed.