Guide
How to calculate sales commissions (without spreadsheet chaos)
A practical framework for structuring commission calculations — from base rates and tiers to accelerators and clawbacks.
Start with the compensation plan structure
Every commission calculation begins with the plan: what is being measured (revenue, bookings, margin), who is credited, and what rate or tier applies. Document these rules before building any model — in a spreadsheet or platform.
Core commission formula
The simplest form is credited amount × commission rate. Most real-world plans add tiers (higher rates above quota), splits (multiple reps on one deal), and product-specific rates. Define each variable explicitly so finance and RevOps agree on definitions.
- Credited amount: revenue, ARR, or margin — pick one and stick to it
- Commission rate: flat, tiered, or accelerator-based
- Quota attainment: how progress toward target affects the rate
- Payout timing: when earned vs when paid (e.g. on collection)
Common pitfalls
Ambiguous deal credit rules cause the most disputes. Shadow spreadsheets appear when reps cannot see deal-level logic. Manual CRM exports introduce errors. A system connected to your CRM reduces all three.
When to move beyond spreadsheets
If payout cycles take days to reconcile, plan changes require formula surgery, or reps routinely challenge numbers — it is time for dedicated commission management software. SalesComp is building exactly this; book a call to see early direction.