| Scenario | Gross sales | Returns | Discounts | Eligible sales | Final commission | Effective % |
|---|---|---|---|---|---|---|
| Starter month | Rs 25,000 | Rs 1,200 | Rs 800 | Rs 23,000 | Rs 1,410 | 6.13% |
| High growth | Rs 55,000 | Rs 2,500 | Rs 1,000 | Rs 51,500 | Rs 3,805 | 7.39% |
| Team split | Rs 40,000 | Rs 1,000 | Rs 1,000 | Rs 19,000 (50%) | Rs 1,060 | 5.58% |
- Net Sales = Gross Sales − Returns − Discounts
- Eligible Sales = Net Sales × (Split % ÷ 100)
- Tier Commission = Σ [Sales in tier × (Tier Rate % ÷ 100)]
- Final Commission = min(max(Tier Commission + Bonus − Draw, 0), Cap)
- Effective Commission % = (Final Commission ÷ Eligible Sales) × 100
- Net Payout = Final Commission − (Final Commission × Tax % ÷ 100)
- Enter your gross sales, then add returns and discounts.
- Set your split percentage for joint or team deals.
- Add one or more tier rules that match your plan.
- Include bonuses, draw recovery, and an optional cap.
- Click Calculate to view the effective percentage.
- Download CSV or PDF for payroll, budgeting, or reporting.
Sales plan benchmarks
In many inside-sales teams, entry tiers start near 2%–4% on net sales and step up as quota attainment improves. A three-tier ladder can reduce volatility while still rewarding stretch performance. Use the tier table above to test if your plan keeps the effective percentage competitive when returns and discounts are realistic.
Net sales adjustments that change outcomes
Commission plans frequently pay on net sales, not invoice totals. Returns, credits, and discounting lower eligible revenue and can shift a rep into a lower-paying tier slice. If your business sees 3% refunds and 2% discounting, a Rs 100,000 month may become Rs 95,000 eligible before any split.
Split deals and shared credit
Splits are common for co-selling, renewals support, or territory overlaps. A 50% split halves eligible sales, which may pull a rep below a tier breakpoint. Modeling splits helps leaders decide whether to split revenue, split commission, or apply special rules for strategic accounts.
Tier design and marginal incentives
The calculator pays each tier rate only on the portion of sales inside that band. This structure improves predictability: moving from 5% to 7% does not retroactively reprice earlier sales. Review the Plotly bars to see which tier is doing the “work,” then adjust breakpoints so the biggest commissions align with the hardest goals.
Caps, draws, and payout governance
Caps can control risk on unusually large deals, but they also reduce the effective percentage and may create end-of-period “stop selling” behavior. Draw recovery lowers payouts until prior advances are repaid. If you use a cap, consider pairing it with accelerators before the cap so top performers still feel rewarded.
Using exports for audit-ready reporting
The CSV export supports spreadsheet review and payroll reconciliation. The PDF is helpful for approvals, dispute resolution, and monthly close. Save exports with the generated timestamp, and include the tier rules used, so the same inputs always reproduce the same effective commission percentage.
1) What does “effective commission percentage” mean?
It is the final commission divided by eligible sales. It reflects tiering, splits, bonuses, draw recovery, and any cap, giving one comparable rate for the period.
2) Why do returns and discounts matter so much?
Many plans pay on net sales. When refunds and discounting reduce revenue, the same gross month can produce a lower payout and may shift sales into lower-paying tier slices.
3) How should I set tier ranges?
Start with quota and historical performance. Place breakpoints where attainment meaningfully changes, and verify the marginal reward feels stronger after each breakpoint using the tier table and chart.
4) What if my plan uses a single flat rate?
Enter one tier with a “From” value of 0 and a “To” value of 0 (open-ended), then set the rate. The effective percentage will match the flat rate after adjustments.
5) Does the tax field calculate exact payroll tax?
No. It estimates withholding on the commission value using the percentage you enter. Actual payroll outcomes vary by jurisdiction, deductions, and pay frequency.
6) How do I document a payout for approval?
Use the PDF export, then attach it to your approval workflow. It includes key inputs, tier breakdown, and a timestamp, helping reviewers validate the numbers quickly.