compensation-modeler

name	compensation-modeler
description	Commission accrual simulation, payout forecasts, plan design validation, dispute audit trails, and what-if modeling for compensation changes. Tracks all changes for compliance.
allowed-tools	Read, Write
effort	high

When to activate

Monthly commission accrual, quarterly plan design review, or on-demand for what-if modeling. Requires commission plan structure and deal close data.

When NOT to use

Not for individual rep coaching (use quota-tracker). Not for general finance (use finance team). Non-negotiable: All commission changes require documented audit trail.

Commission Accrual Framework

Accrual calculation:

• Deal close date = trigger for accrual (not payment date)
• Commission = Deal value × commission rate (varies by quota attainment or segment)
• Accrual timing: Monthly reconciliation; monthly payout if deal revenue recognized

Dispute resolution:

• Commission only paid if: deal recorded in CRM, customer signed contract, revenue recognized by finance
• Dispute = documented conversation between rep and manager, escalated to comp lead with evidence
• All disputes logged with: date, rep, deal, claimed vs. actual, resolution, approver

Output Template

# Commission Accrual Report — {Month}

**Pay Period:** {Date range}  
**Report Date:** {Date}

---

## Summary

| Metric | Value |
|---|---|
| Total Commissionable Deals Closed | {N} |
| Total Gross Commission | ${} |
| Top Earner | {Rep} — ${} |
| Avg Commission per Rep | ${} |

---

## Rep Accrual Breakdown

| Rep | Deals | GrossRevenue | CommRate | Commission | YTD Accrued | Status |
|---|---|---|---|---|---|---|
| {Name} | {N} | ${} | {%} | ${} | ${} | Paid |

---

## Disputed Commissions (Audit Trail)

| Rep | Deal | Claimed | Actual | Variance | Reason | Status | Approver |
|---|---|---|---|---|---|---|---|
| {Rep} | {Deal ID} | ${} | ${} | ${} | [Note] | Resolved | {Name} |

---

## What-If: Proposed Plan Change

**Current:** Base: 0, OTE: $100K, Commission: 5% quota achievement 80–120%, 7% >120%  
**Proposed:** Base: $20K, OTE: $100K, Commission: 6% quota 80–120%, 8% >120%

**Impact (12-month projection):**
- Rep at 100% quota: Current $100K, Proposed $104K (+$4K/year)
- Rep at 150% quota: Current $110K, Proposed $114K (+$4K/year)
- Rep at 70% quota: Current $85K, Proposed $88K (+$3K/year)
- **Total cost increase:** {$X} / year

---

## Recommended Actions

- {Action}: {Recommendation}