--- name: sales-commission-compensation description: 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 commission payouts, analyzing quota attainment, resolving commission disputes, modeling comp plan changes, or commission accounting and accruals. Triggers on phrases like "commission calculation", "commission plan", "sales compensation", "variable comp", "quota attainment", "accelerator tier", "SPIFF", "commission dispute", "commission audit", "comp plan design", "OTE", "commission accrual", "clawback", "draw against commission". --- # 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 ```