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 commission: $24,000 (6% × $400K)
- Accelerator: 9% above quota

### Scenario Analysis

#### Scenario 1: Commit Only ($320K)

Attainment: 80% Revenue: $320,000

Commission at 6%: $320,000 × 6% = $19,200

Quarterly Variable: $19,200 Annualized: $76,800 vs OTE Variable ($96K): -$19,200

**Status**: Below quota, standard rate applies

---

#### Scenario 2: Best Case ($450K)

Attainment: 112.5% Revenue: $450,000

Below quota: $400,000 × 6% = $24,000 Above quota: $50,000 × 9% = $4,500

Total Commission: $28,500

Quarterly Variable: $28,500 vs At-Quota ($24K): +$4,500 (19% bonus)

**Status**: Accelerator kicks in, strong quarter

---

#### Scenario 3: Upside ($600K)

Attainment: 150% Revenue: $600,000

Below quota: $400,000 × 6% = $24,000 Above quota: $200,000 × 9% = $18,000

Total Commission: $42,000

Quarterly Variable: $42,000 vs At-Quota ($24K): +$18,000 (75% bonus)

**Status**: Excellent quarter, maximizing accelerator

---

### Summary Table

| Scenario | Revenue | Attainment | Commission | vs Plan |
|----------|---------|------------|------------|---------|
| Commit | $320K | 80% | $19,200 | -$4,800 |
| Best Case | $450K | 112% | $28,500 | +$4,500 |
| Upside | $600K | 150% | $42,000 | +$18,000 |

### Key Insights

1. **Break-even point**: $400K (100% attainment)
2. **Accelerator value**: Each $10K above quota = $900 extra
3. **Commit gap**: Need $80K more to hit quota
4. **Upside potential**: 75% more commission if pipeline converts

### Recommendations for Mike
1. Focus on moving $80K from Best Case to Commit
2. Push for upside deals - 9% rate is lucrative
3. Prioritize larger deals for accelerator impact

Skill Boundaries

What This Skill Does Well

• Explaining commission math step-by-step
• Identifying calculation discrepancies
• Modeling what-if scenarios
• Documenting plan rules clearly

What This Skill Cannot Do

• Access actual payout systems
• Make policy exceptions
• Override approved calculations
• Handle edge cases without rules

When to Escalate to Human

• Policy exceptions or special approvals
• Historical adjustments requiring audit
• Plan design decisions
• Legal or HR compensation issues

Iteration Guide

Follow-up Prompts

• "What if Mike closes an extra $50K deal?"
• "Show me the break-even point to hit OTE."
• "Compare this plan to a flat 8% rate."
• "Model the impact of increasing Mike's quota by 20%."

Refinement Cycle

1. Document plan rules clearly
2. Run sample calculations
3. Verify against actual statements
4. Build exception handling guide
5. Create rep-facing FAQ

Checklists & Templates

Commission Dispute Resolution Checklist

• Verify all deals in calculation
• Confirm close dates in pay period
• Check split/overlay credits
• Validate attainment tier
• Review for clawbacks/adjustments
• Compare to plan document

Comp Plan Documentation Template

## [Role] Compensation Plan - [Year]

### Structure
- Base Salary: $X
- OTE: $X
- Variable: $X (X% of OTE)
- Pay Period: [Monthly/Quarterly]

### Commission Mechanics
- Quota: $X/[period]
- Base Rate: X%
- Accelerator: X% above quota
- Threshold: X% minimum attainment

### Special Rules
- Splits: [Policy]
- Clawbacks: [Policy]
- Ramping: [New hire policy]

### Examples
[Include 3 scenarios at 80%, 100%, 120%]

References

• Alexander Group Sales Compensation Design
• WorldatWork Incentive Compensation Handbook
• Salesforce Sales Cloud Commission Documentation
• Xactly Commission Best Practices

Related Skills

• pipeline-forecasting - Project commission from forecast
• deal-risk-scoring - Prioritize high-commission deals
• quota-planning - Set achievable targets

Skill Metadata

• Domain: RevOps
• Complexity: Advanced
• Mode: centaur
• Time to Value: 15-30 min per analysis
• Prerequisites: Comp plan document, deal data