Enter Renewal Commission Inputs
Use the fields below to model rep payout, retention bonus, overrides, clawback reserve, quota multiplier, cap behavior, and renewal pipeline economics.
Example Data Table
These sample rows show how different renewal situations can change payout behavior.
| Scenario | Previous ARR | Renewed ARR | Upsell ARR | Quota Attainment | Rep Final Payout |
|---|---|---|---|---|---|
| Standard Renewal | $100,000 | $100,000 | $5,000 | 95% | $6,156 |
| Expansion Renewal | $150,000 | $165,000 | $30,000 | 118% | $15,798 |
| Protected Renewal | $90,000 | $87,000 | $0 | 82% | $4,810 |
Formula Used
Renewal Rate (%) = (Renewed ARR ÷ Previous ARR) × 100
Revenue Uplift (%) = ((Renewed ARR + Upsell ARR − Previous ARR) ÷ Previous ARR) × 100
Base Commission = Renewed ARR × Base Renewal Rate
Upsell Commission = Upsell ARR × Upsell Rate
Retention Bonus = Renewed ARR × Retention Bonus Rate, when Renewal Rate meets the bonus threshold
Gross Commission = Base Commission + Upsell Commission + Retention Bonus
Operational Factor = Collection Rate × Split Percentage × (1 − Churn Risk Discount) × (Credit Months ÷ 12)
Adjusted Gross = Gross Commission × Quota Multiplier × Operational Factor
Clawback Reserve = Adjusted Gross × Clawback Reserve Rate
Rep Before Floor/Cap = Adjusted Gross − Clawback Reserve
Rep Final Payout = min(Commission Cap, max(Minimum Guarantee, Rep Before Floor/Cap))
Team Override = (Renewed ARR + Upsell ARR) × Collection Rate × Team Override Rate × (Credit Months ÷ 12)
Manager Override = (Renewed ARR + Upsell ARR) × Collection Rate × Manager Override Rate × (Credit Months ÷ 12)
Total Payout = Rep Final Payout + Team Override + Manager Override
How to Use This Calculator
- Enter the original contract’s ARR in Previous ARR.
- Enter the renewed amount in Renewed ARR.
- Add any cross-sell or expansion value in Upsell ARR.
- Set your commission percentages for renewal, upsell, bonus, and overrides.
- Choose quota multipliers that match your compensation plan bands.
- Adjust collection rate, churn discount, split percentage, and credit months.
- Add clawback reserve, cap, and minimum guarantee values if your plan uses them.
- Click Calculate Renewal Commission to view payout details, the graph, and export options.
FAQs
1. What does this calculator estimate?
It estimates renewal commission, upsell earnings, retention bonus, quota-based acceleration, reserve deductions, and optional team or manager override payouts for recurring revenue deals.
2. When is the retention bonus added?
The bonus is added only when the renewal rate reaches or exceeds your selected threshold. This helps mirror plans that reward strong retention performance.
3. Why does quota attainment change the payout?
Many compensation plans use accelerators. Higher quota attainment can multiply the same booked revenue into a larger payout, especially once the rep passes goal.
4. What is the split percentage field for?
Use split percentage when a renewal is shared across multiple reps or roles. A 50% split gives the rep half of the eligible commission credit.
5. Why include collection rate?
Some plans pay only on cash collected, not just on signed value. Collection rate reduces payout when invoices are not fully paid yet.
6. What does churn risk discount mean?
It represents a conservative haircut on expected payout. Teams may use it for at-risk accounts, delayed rollouts, or uncertain renewal execution quality.
7. How do cap and guarantee work together?
The guarantee sets a floor, while the cap sets a ceiling. The calculator applies the floor first, then limits the result if a cap exists.
8. Can I use this for team planning?
Yes. It is useful for rep modeling, manager forecast reviews, compensation design checks, and CRM pipeline planning around recurring revenue renewals.