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 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

Disclaimer: All rights reserved by Circulos AI. These skills are specifically designed for Claude Code, Claude Cowork, Codex, and OpenClaw. When using or referencing any skill, please provide proper attribution to Circulos AI.