Commission Tracker
Know exactly what you're owed before the commission statement arrives
Commission statements are often disputed or hard to verify. This skill calculates your commissions in real time from your deal data, so you never have to maintain a shadow spreadsheet or wonder if finance got it right.
INGREDIENTS
PROMPT
Create a skill called "Commission Tracker". I'll input my compensation plan rules: base commission rate, quota, tier breakpoints, accelerators, decelerators, SPIFs, and any special conditions. As deals close in my CRM, calculate my earned commission in real time. Show: per-deal commission earned, cumulative earnings, progress toward accelerator thresholds, and projected total earnings based on pipeline. Support what-if modeling: "if I close deals X, Y, Z this quarter, what's my total payout?" When I upload my official commission statement, compare line-by-line against my calculated amounts and flag any discrepancies with deal-level detail.
How It Works
Input your comp plan rules and the skill calculates commissions as deals close.
Real-time earnings visibility, what-if modeling for pending deals, and automatic
reconciliation against your official commission statement.
What You Get
- Real-time commission calculation as deals close
- Deal-level earnings breakdown
- What-if calculator: "if I close these 3 deals, my commission is..."
- Accelerator/decelerator tracking (where are you relative to thresholds?)
- Statement reconciliation: compare your calculated amount vs. official statement
- Monthly earnings summary with trend tracking
Setup Steps
- Input your comp plan: base rate, tiers, accelerators, SPIFs
- Connect your CRM or provide a recurring export or provide a recurring export closed-won data
- The skill calculates commissions automatically going forward
- Upload official statements for reconciliation
Tips
- Update your plan immediately when comp changes are announced — don't wait for a pay cycle to discover errors
- The what-if calculator changes how you prioritize deals — you can see exactly how accelerators kick in
- Flag discrepancies immediately with specific deal-level data — finance resolves faster when you show your work
- Share your calculation methodology with your manager for transparency