Back to Details

commission-intelligence

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

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
  • 销售代表对佣金报表有疑问时
  • 设计或更新薪酬计划时
  • 构建配额与OTE场景模型时
  • 解决薪酬支付纠纷时
  • 规划销售区域变更时

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
基于Alexander Group销售薪酬设计和WorldatWork激励薪酬原则，涵盖：
  • 固定薪酬+可变薪酬结构
  • 配额完成机制
  • 加速与减速提成规则
  • 分成与叠加规则

What Claude Does vs What You Decide

Claude的职责 vs 你的决策

Claude DoesYou Decide
Explains calculation logicFinal payout approvals
Identifies discrepanciesException handling
Models scenariosPlan design choices
Documents rules clearlyPolicy changes
Calculates examplesQuota assignments
Claude的职责你的决策
解释计算逻辑最终薪酬支付审批
识别差异问题特殊情况处理
构建场景模型计划设计选择
清晰记录规则政策变更
计算示例配额分配

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
  1. 计算解释 - 拆解佣金的计算过程
  2. 差异识别 - 找出计算错误或数据问题
  3. 场景建模 - 基于不同假设预测收益
  4. 计划文档化 - 明确复杂的薪酬计划规则
  5. 纠纷解决 - 提供清晰的审计追踪依据

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]
解释以下佣金计算：

销售代表: [姓名]
职位: [AE, SDR等]
配额: $[金额]/[周期]
本周期已成交: $[金额]

薪酬计划规则:
- 固定薪酬: $X
- OTE: $X
- 可变薪酬: 固定薪酬的X%
- 佣金率: 达到配额前为X%
- 加速提成: 超过配额后为X%

已成交客户:
- [列出客户及成交金额、成交日期]

报表显示佣金: $[佣金金额]
销售代表预期: $[预期金额]

Instructions

操作步骤

Step 1: Understand the Comp Plan Structure

步骤1：理解薪酬计划结构

Common Structures:
TypeDescription
Revenue Commission% of deal value
Quota-Based% payout based on attainment
TieredDifferent rates at different levels
DrawAdvance against future commissions
MBOBonus for specific objectives
常见结构:
类型描述
营收佣金成交金额的百分比
基于配额根据完成比例支付提成
阶梯式不同完成比例对应不同费率
预支提成从未来佣金中提前支取
MBO针对特定目标的奖金

Step 2: Calculate Attainment

步骤2：计算完成率

Attainment % = (Closed Revenue / Quota) × 100

Example:
- Quota: $500,000
- Closed: $450,000
- Attainment: 90%
完成率 = (已成交营收 / 配额) × 100

示例:
- 配额: $500,000
- 已成交: $450,000
- 完成率: 90%

Step 3: Apply Commission Rules

步骤3：应用佣金规则

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
标准计算:
基础佣金 = 已成交营收 × 佣金率

带配额阈值的计算:
- 完成率低于50%: 0%提成（常见规则）
- 完成率50-100%: 线性提成
- 完成率超过100%: 启用加速提成率
加速提成示例:
计划规则: 达到配额前10%，超过配额后15%
配额: $500K，已成交: $600K

佣金计算:
- 前$500K × 10% = $50,000
- 超出部分$100K × 15% = $15,000
- 总计: $65,000

Step 4: Handle Special Cases

步骤4：处理特殊情况

ScenarioRule
Split dealsDivide credit per agreement
Multi-yearRecognize per year or upfront
Churn/ClawbackDeduct if customer cancels
Ramped quotaReduced quota for new hires
SPIFsOne-time bonus amounts
场景规则
分成订单按协议分配提成 credit
多年期订单按年确认或一次性确认
客户流失/ clawback客户取消则扣除对应提成
渐进式配额新员工适用降低后的配额
SPIFs一次性奖金

Step 5: Reconcile Discrepancies

步骤5：调和差异问题

Common Issues:
IssueCauseResolution
Missing dealNot in CRMAdd deal, recalculate
Wrong amountIncorrect ACVVerify contract value
Wrong rateTier confusionCheck attainment level
Split errorCredit allocationReview split agreement
TimingRevenue recognitionCheck close date vs. pay period
常见问题:
问题原因解决方法
订单遗漏未录入CRM添加订单，重新计算
金额错误ACV不正确核实合同金额
费率错误阶梯规则混淆检查完成率层级
分成错误Credit分配问题审核分成协议
时间问题营收确认规则检查成交日期与薪酬周期是否匹配

Examples

示例

Example 1: Commission Explanation

示例1：佣金解释

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:
undefined
输入:
解释Sarah的佣金为何是$12,500:

销售代表: Sarah (AE)
配额: $200,000/季度
Q4已成交: $175,000

薪酬计划:
- OTE: $200,000（固定与可变各占50%）
- 可变薪酬: $100,000/年 = $25,000/季度
- 完成率100%: 全额获取$25K可变薪酬
- 完成率50-100%: 线性提成
- 加速提成: 超过100%后为1.5倍

订单:
- Acme Corp: $80,000（10月15日）
- Beta Inc: $45,000（11月3日）
- Gamma LLC: $50,000（12月20日）
总计: $175,000
输出:
undefined

Commission Breakdown: Sarah - Q4

佣金明细: Sarah - Q4

Step 1: Verify Closed Revenue

步骤1：核实已成交营收

DealAmountClose Date✓
Acme Corp$80,000Oct 15✓ Q4
Beta Inc$45,000Nov 3✓ Q4
Gamma LLC$50,000Dec 20✓ Q4
Total$175,000✓
订单金额成交日期是否计入本季度
Acme Corp$80,00010月15日✓ Q4
Beta Inc$45,00011月3日✓ Q4
Gamma LLC$50,00012月20日✓ Q4
总计$175,000✓

Step 2: Calculate Attainment

步骤2：计算完成率

Attainment = $175,000 / $200,000 = 87.5%
完成率 = $175,000 / $200,000 = 87.5%

Step 3: Apply Commission Formula

步骤3：应用佣金公式

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
计划规则:
  • 50%阈值: 低于50% = $0
  • 50-100%: 从$0到$25,000线性提成
  • 超过100%: 1.5倍加速提成
计算过程:
Sarah的完成率为87.5%（介于50%与100%之间）

线性公式:
薪酬 = (完成率 - 50%) / 50% × 全额可变薪酬
薪酬 = (87.5% - 50%) / 50% × $25,000
薪酬 = 37.5% / 50% × $25,000
薪酬 = 75% × $25,000
薪酬 = $18,750

⚠️ Discrepancy Found!

⚠️ 发现差异!

Statement shows: $12,500 Calculated: $18,750 Difference: $6,250 underpaid
报表显示: $12,500 计算结果: $18,750 差异: 少支付$6,250

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
如果系统显示$12,500，可能是按以下方式计算:
$12,500 / $25,000 = 50%薪酬比例
可能的情况:
  1. 某笔订单未被计入（比如Beta Inc的$45K?）
  2. 使用了错误的公式（营收百分比 vs 可变薪酬百分比）
  3. 订单被归属到其他季度

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
undefined
  1. 核实所有3笔订单是否在佣金系统中
  2. 检查Beta Inc的成交日期是否在Q4
  3. 确认公式是50-100%线性提成，而非固定费率
  4. 将该明细提交给薪酬管理员跟进
undefined

Example 2: Scenario Modeling

示例2：场景建模

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:
undefined
输入:
为Mike构建佣金场景模型:

当前情况:
- 配额: $400,000/季度
- OTE: $240,000（固定60%，可变40%）
- 可变薪酬: $96,000/年 = $24,000/季度
- 费率: 达到配额前为营收的6%
- 加速提成: 超过配额后为9%

Q1销售管道:
- 确定成交: $320,000
- 最佳情况: $450,000
- 超额情况: $600,000

Mike在每种场景下的收益是多少?
输出:
undefined

Commission Scenarios: Mike - Q1

佣金场景: Mike - Q1

Plan Summary

计划摘要

  • Quota: $400,000
  • At-quota commission: $24,000 (6% × $400K)
  • Accelerator: 9% above quota
  • 配额: $400,000
  • 达到配额时的佣金: $24,000（6% × $400K）
  • 加速提成: 超过配额后为9%

Scenario Analysis

场景分析

Scenario 1: Commit Only ($320K)

场景1：仅确定成交 ($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
完成率: 80%
营收: $320,000

佣金（6%费率）: $320,000 × 6% = $19,200

季度可变薪酬: $19,200
年化可变薪酬: $76,800
与OTE可变薪酬($96K)对比: 少$19,200
状态: 未达到配额，适用标准费率

Scenario 2: Best Case ($450K)

场景2：最佳情况 ($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
完成率: 112.5%
营收: $450,000

达到配额部分: $400,000 × 6% = $24,000
超过配额部分: $50,000 × 9% = $4,500

总佣金: $28,500

季度可变薪酬: $28,500
与达到配额时的薪酬($24K)对比: 多$4,500（19%奖金）
状态: 启用加速提成，业绩优秀的季度

Scenario 3: Upside ($600K)

场景3：超额情况 ($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
完成率: 150%
营收: $600,000

达到配额部分: $400,000 × 6% = $24,000
超过配额部分: $200,000 × 9% = $18,000

总佣金: $42,000

季度可变薪酬: $42,000
与达到配额时的薪酬($24K)对比: 多$18,000（75%奖金）
状态: 业绩极佳，最大化加速提成收益

Summary Table

摘要表格

ScenarioRevenueAttainmentCommissionvs Plan
Commit$320K80%$19,200-$4,800
Best Case$450K112%$28,500+$4,500
Upside$600K150%$42,000+$18,000
场景营收完成率佣金与计划差异
确定成交$320K80%$19,200-$4,800
最佳情况$450K112%$28,500+$4,500
超额情况$600K150%$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
  1. 收支平衡点: $400K（100%完成率）
  2. 加速提成价值: 每超过配额$10K，额外获得$900
  3. 确定成交缺口: 还需$80K才能达到配额
  4. 超额潜力: 如果管道全部转化，佣金将增加75%

Recommendations for Mike

给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
undefined
  1. 重点推进将最佳情况中的$80K转化为确定成交
  2. 争取超额订单 - 9%的费率收益可观
  3. 优先处理大额订单以最大化加速提成影响
undefined

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
  • 政策例外或特殊审批
  • 需要审计的历史调整
  • 计划设计决策
  • 法律或HR相关的薪酬问题

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%."
  • "如果Mike多成交一笔$50K的订单，结果会如何？"
  • "展示达到OTE的收支平衡点。"
  • "将该计划与固定8%费率的计划进行对比。"
  • "模拟Mike的配额提高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
  1. 清晰记录计划规则
  2. 运行样本计算
  3. 与实际报表进行验证
  4. 构建特殊情况处理指南
  5. 创建面向销售代表的常见问题解答

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
  • 核实计算中包含所有订单
  • 确认成交日期属于当前薪酬周期
  • 检查分成/叠加Credits
  • 验证完成率层级
  • 审核是否有Clawbacks/调整项
  • 与计划文档进行对比

Comp Plan Documentation Template

薪酬计划文档模板

markdown
undefined
markdown
undefined

[Role] Compensation Plan - [Year]

[职位]薪酬计划 - [年份]

Structure

结构

  • Base Salary: $X
  • OTE: $X
  • Variable: $X (X% of OTE)
  • Pay Period: [Monthly/Quarterly]
  • 固定薪酬: $X
  • OTE: $X
  • 可变薪酬: $X（占OTE的X%）
  • 薪酬周期: [月度/季度]

Commission Mechanics

佣金机制

  • Quota: $X/[period]
  • Base Rate: X%
  • Accelerator: X% above quota
  • Threshold: X% minimum attainment
  • 配额: $X/[周期]
  • 基础费率: X%
  • 加速提成: 超过配额后为X%
  • 阈值: 最低完成率X%

Special Rules

特殊规则

  • Splits: [Policy]
  • Clawbacks: [Policy]
  • Ramping: [New hire policy]
  • 分成: [政策]
  • Clawbacks: [政策]
  • 渐进式配额: [新员工政策]

Examples

示例

[Include 3 scenarios at 80%, 100%, 120%]
undefined
[包含完成率80%、100%、120%的3种场景]
undefined

References

参考资料

  • Alexander Group Sales Compensation Design
  • WorldatWork Incentive Compensation Handbook
  • Salesforce Sales Cloud Commission Documentation
  • Xactly Commission Best Practices
  • Alexander Group销售薪酬设计
  • WorldatWork激励薪酬手册
  • Salesforce Sales Cloud佣金文档
  • Xactly佣金最佳实践

Related Skills

相关技能

  • pipeline-forecasting
    - Project commission from forecast
  • deal-risk-scoring
    - Prioritize high-commission deals
  • quota-planning
    - Set achievable targets
  • pipeline-forecasting
    - 根据预测数据预估佣金
  • deal-risk-scoring
    - 优先处理高佣金订单
  • quota-planning
    - 设置可实现的目标

Skill Metadata

技能元数据

  • Domain: RevOps
  • Complexity: Advanced
  • Mode: centaur
  • Time to Value: 15-30 min per analysis
  • Prerequisites: Comp plan document, deal data
  • 领域: RevOps
  • 复杂度: 高级
  • 模式: centaur
  • 价值实现时间: 每次分析15-30分钟
  • 前提条件: 薪酬计划文档、订单数据