guia-matthieu/commission-intelligence
Explain sales commission calculations, resolve discrepancies, and model compensation scenarios for quota planning
npx skills add https://github.com/guia-matthieu/clawfu-skills --skill commission-intelligence> Demystify sales compensation by explaining commission calculations, identifying discrepancies, and modeling payout scenarios.
Based on Alexander Group Sales Compensation Design and WorldatWork Incentive Compensation principles, covering:
| 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 |
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]
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 |
Attainment % = (Closed Revenue / Quota) × 100
Example:
- Quota: $500,000
- Closed: $450,000
- Attainment: 90%
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
| 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 |
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 |
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
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
## [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%]
pipeline-forecasting - Project commission from forecastdeal-risk-scoring - Prioritize high-commission dealsquota-planning - Set achievable targetsTake guia-matthieu/commission-intelligence from the repository into ~/.claude/skills for personal
use, or into .claude/skills inside a project.
The agent identifies a skill by the name field in its header. Two skills with the
same name cannot sit side by side — one of them will be ignored.