Finance AI Skill
Sales Commission Compensation
Design, calculate, and audit sales commission structures including variable compensation plans, accelerator/decelerator tiers, SPIFFs, quota attainment, commission disputes, and clawback provisions. Use when designing compensation plans, calculating commiss...
Sales Commission & Compensation
Design, calculate, and audit sales commission and variable compensation plans including quota attainment, accelerators, SPIFFs, disputes, and clawbacks.
Workflow
1. Commission Plan Design
COMMISSION PLAN ARCHITECTURE
═══════════════════════════════════════
COMPENSATION MIX:
═══════════════════════════════════════
Role Base Salary Variable Comp OTE Mix
($/year) Target ($/year) ($/year) (Base/Var)
─────────────────────────────────────────────────────────────────────
SDR/BDR $45,000 $15,000 $60,000 75/25
Account Executive $75,000 $75,000 $150,000 50/50
(Mid-Market)
Account Executive $100,000 $200,000 $300,000 33/67
(Enterprise)
Account Manager $80,000 $40,000 $120,000 67/33
(Renewal/Expansion)
Channel Sales Mgr $90,000 $110,000 $200,000 45/55
Sales Director $140,000 $160,000 $300,000 47/53
VP Sales $180,000 $220,000 $400,000 45/55
QUOTA SET METHODOLOGY:
═══════════════════════════════════════
Method Use Case Pros Cons
────────────────────────────────────────────────────────────────────────
Historical + Growth Stable book Simple, transparent Ignores territory potential
Market potential New territory Science-based Data intensive
Quotient (reps:opportunities) Balanced Market-driven Requires opportunity data
Top-down allocation Executive control Fast, strategic May not be fair bottom-up
Hybrid Most companies Balanced Complex to administer
QUOTA ATTAINMENT DISTRIBUTION TARGET:
═══════════════════════════════════════
Target distribution (Gaussian, calibrated to company growth):
→ <50% attainment: 15% of reps (underperformers)
→ 50-75% attainment: 20% of reps (needs improvement)
→ 75-90% attainment: 25% of reps (solid performers)
→ 90-110% attainment: 25% of reps (top performers)
→ 110-130% attainment: 10% of reps (star performers)
→ >130% attainment: 5% of reps (exceptional)2. Commission Calculation Engine
COMMISSION CALCULATION — Enterprise AE Example
═══════════════════════════════════════
REP DETAILS:
═══════════════════════════════════════
Sales Rep: Jane Smith
Role: Enterprise Account Executive
OTE: $300,000 ($100K base + $200K variable)
Quarterly Quota: $500,000 (New Logo NRR)
Period: Q1 2024
COMMISSION STRUCTURE:
═══════════════════════════════════════
ATTAINMENT TIERS:
═══════════════════════════════════════
Attainment Range Commission Rate Acceleration
─────────────────────────────────────────────────────
0-25% of quota 0% (threshold not met)
26-50% of quota 8% (decelerator zone)
51-75% of quota 12% (standard rate)
76-100% of quota 15% (standard rate)
101-125% of quota 20% (accelerator tier 1)
126-150% of quota 25% (accelerator tier 2)
151%+ of quota 30% (super accelerator)
SPIFF PROGRAMS (additional):
→ Strategic vertical win: +$5,000 per logo (max 2)
→ Multi-year deal: +2% of ACV for each year beyond year 1
→ Product A adoption: +$2,000 per deal (limited time)
MULTIPLIER FACTORS:
→ Gross margin > 75%: 1.1x multiplier on commission
→ Gross margin < 65%: 0.8x multiplier on commission
→ Discount > 20%: 0.9x multiplier on commission
Q1 2024 PERFORMANCE:
═══════════════════════════════════════
Closed Deals:
Deal 1: $180,000 ACV (3-year, $60K/yr) — Enterprise, Margin 80%, 5% discount
Deal 2: $220,000 ACV (2-year, $110K/yr) — Strategic vertical, Margin 78%, 10% discount
Deal 3: $150,000 ACV (1-year, $150K/yr) — Mid-market upsized, Margin 72%, 8% discount
Deal 4: $80,000 ACV (1-year) — SMB tier, Margin 70%, 15% discount
Total NRR Closed: $630,000
Quota Attainment: $630K / $500K = 126.0%
COMMISSION CALCULATION:
═══════════════════════════════════════
Step 1: Base commission by tier
Tier 1 (26-50%): $500K × 25% = $125,000 × 8% = $10,000
Tier 2 (51-75%): $500K × 25% = $125,000 × 12% = $15,000
Tier 3 (76-100%): $500K × 25% = $125,000 × 15% = $18,750
Tier 4 (101-125%): $500K × 25% = $125,000 × 20% = $25,000
Tier 5 (126%+): ($630K - $625K) = $5,000 × 25% = $1,250
─────────────────────────────────────────────
Base Commission: $70,000
Step 2: Apply margin/discount multipliers (per deal)
Deal 1: Margin 80% → 1.1x, Discount 5% → 1.0x → combined 1.1x
Deal 2: Margin 78% → 1.1x, Discount 10% → 1.0x → combined 1.1x
Deal 3: Margin 72% → 1.0x, Discount 8% → 1.0x → combined 1.0x
Deal 4: Margin 70% → 1.0x, Discount 15% → 1.0x → combined 1.0x
Commission by deal (pro-rated by ACV):
Deal 1: $70,000 × (180/630) × 1.1 = $21,000
Deal 2: $70,000 × (220/630) × 1.1 = $25,667
Deal 3: $70,000 × (150/630) × 1.0 = $16,667
Deal 4: $70,000 × (80/630) × 1.0 = $8,857
Adjusted Commission: $72,191
Step 3: Add SPIFF bonuses
Strategic vertical win (Deal 2): +$5,000
Multi-year deal (Deal 1): +$1,200 ($60K × 2% × 1 extra yr)
Multi-year deal (Deal 2): +$2,200 ($110K × 2% × 1 extra yr)
Product A adoption: +$2,000 (Deal 1 qualifies)
─────────────────────────────────────────────
SPIFF Total: +$10,400
Step 4: Gross Commission
Base: $72,191
SPIFFs: $10,400
─────────────────────────────────────────────
GROSS COMMISSION: $82,591
Step 5: Apply clawbacks (if applicable)
→ Deal 4 customer churned in month 2: Clawback = ($8,857 / 12) × 10 = ($7,381)
(10 months remaining in first year, pro-rated clawback)
─────────────────────────────────────────────
NET COMMISSION: $75,210
TOTAL Q1 COMPENSATION:
Base Salary: $25,000 ($100K / 4)
Commission: $75,210
─────────────────────────────────────────────
TOTAL PAY: $100,210
Effective commission rate: $75,210 / $630,000 = 11.9%3. Commission Accrual & Accounting
COMMISSION ACCRUAL — Month-End
═══════════════════════════════════════
PRINCIPLE: Accrue commission when revenue is recognized, not when deal closes.
(This aligns expense with related revenue per matching principle.)
DEAL TIMELINE:
═══════════════════════════════════════
Deal Closed: January 15, 2024
→ ACV: $120,000 (12-month contract)
→ Commission rate: 15%
→ Total commission: $18,000
Revenue Recognition: $10,000/month (straight-line over 12 months)
Commission Accrual: $1,500/month (15% of $10,000/month revenue)
MONTHLY JOURNAL ENTRIES:
═══════════════════════════════════════
January (partial month):
Dr Sales Commission Expense $875
Cr Commission Payable $875
(Accrual for 15 days: $1,500 × 15/30)
February:
Dr Sales Commission Expense $1,500
Cr Commission Payable $1,500
March:
Dr Sales Commission Expense $1,500
Cr Commission Payable $1,500
Payment (March 31 — paid monthly in arrears):
Dr Commission Payable $3,875
Cr Cash/Bank $3,875
ACCRUAL RECONCILIATION — Q1 2024:
═══════════════════════════════════════
Beginning payable balance: $45,000
Add: Commission accrued: $32,500
Less: Commissions paid: ($40,000)
Add: Clawbacks recovered: $2,000
Less: Clawbacks accrued: ($1,500)
─────────────────────────────────────────────
Ending payable balance: $38,000
Validation:
→ Open deals with recognized revenue: $250,000
→ Average commission rate: 15.2%
→ Expected payable: $250,000 × 15.2% = $38,000 ✓4. Commission Dispute Resolution
COMMISSION DISPUTE MANAGEMENT
═══════════════════════════════════════
COMMON DISPUTE TYPES:
═══════════════════════════════════════
Dispute Type Frequency Avg Value Resolution Time Root Cause
────────────────────────────────────────────────────────────────────────────────
Territory conflict 25% $3,200 5 days Duplicate tracking
Deal registration 20% $5,500 7 days Ambiguous rules
Team vs individual 15% $4,800 3 days Split unclear
Discount impact 15% $2,100 2 days Multiplier unknown
Clawback disagreement 10% $3,800 10 days Churn definition
Credit split 10% $2,500 4 days Split rules
Others 5% $1,200 3 days Misc
DISPUTE RESOLUTION PROCESS:
═══════════════════════════════════════
Step 1: Rep submits dispute via system (within 30 days of payout)
Step 2: Commission administrator reviews (2 business days)
Step 3: If factual: Resolve immediately (credit/debit memo)
Step 4: If policy: Escalate to sales leadership (5 business days)
Step 5: If complex: Escalate to CFO compensation committee
Step 6: Resolution documented and communicated
Step 7: System updated; policy clarified (if systemic issue)
Q1 2024 DISPUTE METRICS:
═══════════════════════════════════════
Total disputes filed: 24
→ Resolved favorably for rep: 16 (67%)
→ Resolved per existing policy: 8 (33%)
→ Pending (>30 days): 0
Total disputed amount: $58,400
→ Credited to reps: $42,100
→ Upheld per policy: $16,300
Avg resolution time: 4.2 days
Top dispute type: Territory conflict (6 cases)
RECOMMENDATION: Clarify territory rules in comp plan document;
implement deal registration SLA (48-hour response required)5. Compensation Plan Modeling
COMPENSATION PLAN CHANGE MODELING
═══════════════════════════════════════
SCENARIO: Introduce team quota (20% of individual quota)
CURRENT PLAN: 100% individual quota
PROPOSED PLAN: 80% individual + 20% team quota
MODELING BY REPRESENTATIVE:
═══════════════════════════════════════
Rep Current OTE Current Comm Team Attain New Comm Delta Impact
Attainment (Q1) (Q1) (Q1) ($/Q) (%)
────────────────────────────────────────────────────────────────────────────────
Rep A 120% $75,000 110% $72,500 ($2,500) -3.3%
Rep B 95% $52,000 110% $58,400 +$6,400 +12.3%
Rep C 85% $42,000 110% $49,200 +$7,200 +17.1%
Rep D 140% $95,000 110% $91,000 ($4,000) -4.2%
Rep E 105% $60,000 110% $60,800 +$800 +1.3%
────────────────────────────────────────────────────────────────────────────────
TEAM TOTAL 109% $324,000 110% $331,900 +$7,900 +2.4%
ANALYSIS:
═══════════════════════════════════════
Impact on individuals:
→ Top performers lose some commission (taxation effect)
→ Middle/lower performers gain (subsidy effect)
→ Team cohesion improves (shared goals)
→ Revenue concentration risk reduces
Impact on company:
→ Total comp cost increases 2.4% in this scenario
→ Better alignment with team selling motions
→ Potential to improve overall attainment (collaboration)
→ Reduces churn of underperformers (more stable income)
BUDGET IMPACT:
→ Current annual commission expense: $1,200,000
→ Projected increase: 2-5% (depending on team performance)
→ Additional cost: $24,000-$60,000/year
→ Offset by: Improved team revenue (+estimated 5-8% from collaboration)Edge Cases
- Territory transfers: Commission continuity during rep reassignment; credit to prior/current rep
- Job changes: Rep leaves mid-period; prorate or pay on recognized revenue
- Deal restructuring: Contract terms change after commission calculation
- M&A impact: Commission plans may differ between merged entities
- International reps: Currency conversion, local regulations on variable comp
Integration Points
- CRM: Salesforce (deal data, pipeline, territory)
- Comp platforms: Xactly, Cap, Spiff, Catalyst (calculation, payment)
- ERP: Oracle, SAP (revenue recognition, accruals)
- Payroll: Workday, ADP (commission payment)
- Reporting: Tableau, Power BI (attainment dashboards)
- HCM systems: Workday, BambooHR (comp plan administration)
Output
Commission Summary Report
COMMISSION REPORT — Q1 2024
═══════════════════════════════════════
Total commission paid: $324,000
Accrued but unpaid: $38,000
Total commission expense: $362,000
Effective commission rate: 12.7% of revenue
Quota attainment:
→ Team average: 109%
→ Above quota: 60% of reps
→ Below 75%: 15% of reps
Dispute resolution:
→ Disputes filed: 24 (2.8% of payouts)
→ Avg resolution: 4.2 days
→ Rep-favorable: 67%
Top recommendations:
→ Clarify territory rules (most common dispute)
→ Implement commission self-service portal
→ Review accel/decel thresholds for new plan