/commission-intelligence

name: commission-intelligence
description: Explain sales commission calculations, resolve discrepancies, and model compensation scenarios for quota planning
license: MIT
metadata:
  author: ClawFu
  version: 1.0.0
  mcp-server: "@clawfu/mcp-skills"

Commission Intelligence

> Demystify sales compensation by explaining commission calculations, identifying discrepancies, and modeling payout scenarios.

When to Use This Skill

• Reps questioning commission statements
• Designing or updating comp plans
• Modeling quota and OTE scenarios
• Resolving payout disputes
• Planning territory changes

Methodology Foundation

Based on **Alexander Group Sales Compensation Design** and **WorldatWork Incentive Compensation principles**, covering:

• Base + variable structures
• Quota attainment mechanics
• Accelerators and decelerators
• Split and overlay rules

What Claude Does vs What You Decide

| Claude Does | You Decide | |-------------|------------| | Explains calculation logic | Final payout approvals | | Identifies discrepancies | Exception handling | | Models scenarios | Plan design choices | | Documents rules clearly | Policy changes | | Calculates examples | Quota assignments |

What This Skill Does

1. **Calculation explanation** - Break down how commission was computed 2. **Discrepancy identification** - Find calculation errors or data issues 3. **Scenario modeling** - Project earnings under different assumptions 4. **Plan documentation** - Clarify complex comp plan rules 5. **Dispute resolution** - Provide clear audit trail

How to Use

Explain this commission calculation:

Rep: [Name]
Role: [AE, SDR, etc.]
Quota: $[Amount]/[Period]
Closed this period: $[Amount]

Comp plan rules:
- Base: $X
- OTE: $X
- Variable: X% of base
- Commission rate: X% up to quota
- Accelerator: X% above quota

Deals closed:
- [List deals with amounts and close dates]

Statement shows: $[Commission Amount]
Rep expected: $[Expected Amount]

Instructions

Step 1: Understand the Comp Plan Structure

**Common Structures:** | Type | Description | |------|-------------| | Revenue Commission | % of deal value | | Quota-Based | % payout based on attainment | | Tiered | Different rates at different levels | | Draw | Advance against future commissions | | MBO | Bonus for specific objectives |

Step 2: Calculate Attainment

Attainment % = (Closed Revenue / Quota) × 100

Example:
- Quota: $500,000
- Closed: $450,000
- Attainment: 90%

Step 3: Apply Commission Rules

**Standard Calculation:**

Base Commission = Closed Revenue × Commission Rate

With Quota Thresholds:
- Below 50% attainment: 0% payout (common)
- 50-100% attainment: Linear payout
- Above 100%: Accelerator rate kicks in

**Accelerator Example:**

Plan: 10% up to quota, 15% above quota
Quota: $500K, Closed: $600K

Commission:
- First $500K × 10% = $50,000
- Next $100K × 15% = $15,000
- Total: $65,000

Step 4: Handle Special Cases

| Scenario | Rule | |----------|------| | Split deals | Divide credit per agreement | | Multi-year | Recognize per year or upfront | | Churn/Clawback | Deduct if customer cancels | | Ramped quota | Reduced quota for new hires | | SPIFs | One-time bonus amounts |

Step 5: Reconcile Discrepancies

**Common Issues:** | Issue | Cause | Resolution | |-------|-------|------------| | Missing deal | Not in CRM | Add deal, recalculate | | Wrong amount | Incorrect ACV | Verify contract value | | Wrong rate | Tier confusion | Check attainment level | | Split error | Credit allocation | Review split agreement | | Timing | Revenue recognition | Check close date vs. pay period |

Examples

Example 1: Commission Explanation

**Input:**

Explain why Sarah's commission is $12,500:

Rep: Sarah (AE)
Quota: $200,000/quarter
Q4 Closed: $175,000

Comp plan:
- OTE: $200,000 (50/50 split)
- Variable: $100,000/year = $25,000/quarter
- At 100% attainment: Full $25K variable
- Linear payout from 50-100%
- Accelerator: 1.5x above 100%

Deals:
- Acme Corp: $80,000 (Oct 15)
- Beta Inc: $45,000 (Nov 3)
- Gamma LLC: $50,000 (Dec 20)
Total: $175,000

**Output:**

## Commission Breakdown: Sarah - Q4

### Step 1: Verify Closed Revenue
| Deal | Amount | Close Date | ✓ |
|------|--------|------------|---|
| Acme Corp | $80,000 | Oct 15 | ✓ Q4 |
| Beta Inc | $45,000 | Nov 3 | ✓ Q4 |
| Gamma LLC | $50,000 | Dec 20 | ✓ Q4 |
| **Total** | **$175,000** | | ✓ |

### Step 2: Calculate Attainment

Attainment = $175,000 / $200,000 = 87.5%

### Step 3: Apply Commission Formula

**Plan Rules:**
- 50% threshold: Below 50% = $0
- 50-100%: Linear from $0 to $25,000
- 100%+: 1.5x accelerator

**Calculation:**

Sarah is at 87.5% (between 50% and 100%)

Linear formula: Payout = (Attainment - 50%) / 50% × Full Variable Payout = (87.5% - 50%) / 50% × $25,000 Payout = 37.5% / 50% × $25,000 Payout = 75% × $25,000 Payout = $18,750

### ⚠️ Discrepancy Found!

**Statement shows**: $12,500
**Calculated**: $18,750
**Difference**: $6,250 underpaid

### Likely Cause

If system shows $12,500, it may be calculating:

$12,500 / $25,000 = 50% payout

This would happen if:
1. One deal not credited (Beta Inc $45K?)
2. Wrong formula (% of revenue vs % of variable)
3. Deal attributed to different quarter

### Recommended Action
1. Verify all 3 deals in commission system
2. Check if Beta Inc close date is in Q4
3. Confirm formula is linear 50-100%, not flat rate
4. Escalate to compensation admin with this breakdown

Example 2: Scenario Modeling

**Input:**

Model commission scenarios for Mike:

Current:
- Quota: $400,000/quarter
- OTE: $240,000 (60/40 split)
- Variable: $96,000/year = $24,000/quarter
- Rate: 6% of revenue up to quota
- Accelerator: 9% above quota

Q1 pipeline:
- Committed: $320,000
- Best case: $450,000
- Upside: $600,000

What would Mike earn in each scenario?

**Output:**

## Commission Scenarios: Mike - Q1

### Plan Summary
- Quota: $400,000
- At-quota commiss