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

• Calculation explanation - Break down how commission was computed

• Discrepancy identification - Find calculation errors or data issues

• Scenario modeling - Project earnings under different assumptions

• Plan documentation - Clarify complex comp plan rules

• 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

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

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

• Document plan rules clearly

• Run sample calculations

• Verify against actual statements

• Build exception handling guide

• 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