Commission & Bonus Calculator with Audit Trail
Calculate complex commissions and bonuses with compliance audit trails
What You Can Do
You can parse complex commission structures (tiered, accelerated, draw-based, SPIFs), calculate individual payouts from source data like sales figures and KPIs, and cross-validate results against compensation plans and historical baselines. The skill automatically flags anomalies and recalculation triggers, then generates compliant audit trails documenting every calculation decision for regulatory reviews.
Features
handles tiered, accelerated, draw-based, and SPIF commission structures with complex nesting
processes individual commissions from sales data, margins, and KPI metrics with variance tracking
cross-references calculations against defined compensation plans to catch overpayments and underpayments
flags unusual payouts, tier jumps, and recalculation triggers before payroll processing
produces compliant documentation linking each payout to source data and plan rules
handles 50+ recipients simultaneously across multiple comp plans (sales, service, management)
investigates discrepancies between expected and actual payouts with root-cause analysis
computes corrections and adjustments for plan changes or historical errors
Example Output
Example 1: Monthly Commission Run
Employee: Sarah Chen | Territory: West | Month: Jan 2024
Gross Sales: $450,000 | Commissionable Amount: $425,000
Tier 1 (0-$300k @ 2.5%): $7,500
Tier 2 ($300k-$450k @ 3.2%): $4,800
Accelerator (>$425k @ +0.5%): $2,125
Base Commission: $14,425
ANOMALY FLAG: 23% variance vs. historical avg. ($11,759) — recommend verification
Audit Status: ✓ Plan-aligned | ✓ Data-validated | ✓ Ready for payroll
Example 2: Multi-Plan Reconciliation
| Employee | Plan Type | Calculated | System Payout | Variance | Status |
|---|---|---|---|---|---|
| John Doe | Sales | $12,340 | $12,340 | $0 | ✓ Match |
| Maria Garcia | Service | $8,920 | $8,500 | -$420 | ⚠ Investigate |
| David Lee | Management | $6,200 | $6,200 | $0 | ✓ Match |
Example 3: Audit Trail Documentation
Calculation ID: CB-2024-01-Q1-001
Processed: 2024-01-31 14:22 UTC
Data Source: CRM export (Salesforce) + margin calculations
Plan Applied: Q1 2024 Sales Comp Plan v2.3
Validation: 47/47 recipients passed plan checks
Exceptions: 3 flagged for review (>20% variance)
Certification: Reconciled to GL accounts, ready for ADP import
What's Included
- commission-bonus-calculator-auditor.md: core skill instructions for parsing plans, calculating payouts, and generating audit documentation
- Commission Plan Template: structured format for documenting tiered, accelerated, and SPIF plan rules
- Calculation Validation Checklist: step-by-step verification process to catch errors before payroll submission
- Audit Trail Framework: markdown template for documenting payout sources, plan rules applied, and compliance sign-off
- Variance Analysis Worksheet: structured prompts for investigating discrepancies and flagging anomalies
Who It's For
- Payroll Managers — processing monthly/quarterly commission runs and ensuring compliance documentation
- Finance Controllers — validating incentive compensation calculations and auditing payout accuracy
- Sales Operations Leaders — reconciling sales data to commission payouts and investigating variance
- Internal Auditors — preparing compensation records for regulatory reviews and compliance audits
- Compensation Analysts — modeling new commission structures and back-calculating adjustments for plan changes
Best For
- Batch commission processing for 50+ employees across multiple compensation plans
- Validating and reconciling commission payouts when third-party systems produce unexpected results
- Investigating commission variance and identifying root causes (data errors, plan misinterpretations, system bugs)
- Preparing audit-ready documentation for internal reviews, compliance audits, and regulatory inquiries
- Calculating back-pay adjustments and retroactive payouts due to plan corrections or historical errors
- Implementing new commission plan structures with tier changes and testing payout impact
You might also like
Turn project descriptions, timelines, and structured data into professional draw.io diagrams instantly. You can generate flowcharts, org charts, Gantt charts, swimlane diagrams, and process flows by describing what you need. Claude creates draw.io XML that you can open directly in the editor or modify further.
by skillslib
You can design culturally appropriate survey instruments tailored to international development contexts, analyze mixed-methods data by integrating quantitative findings with qualitative insights, and implement robust data quality management systems for your field operations. Claude helps you create survey templates with adaptive logic, develop validation protocols, and produce data quality reports that highlight issues before analysis begins.
by skillslib
You can evaluate whether products are viable remanufacturing candidates by conducting systematic disassembly analysis and identifying recovery opportunities. The skill helps you design efficient remanufacturing workflows, calculate ROI and environmental impact metrics (including embodied energy recovery of 85-90%), and create remanufacturability scorecards that guide design improvements and supply chain decisions.
by skillslib
You can diagnose warehouse bottlenecks using structured data analysis, then generate optimized layouts and flow improvements. The skill models space utilization, labor deployment, and throughput constraints to identify quick wins and long-term improvements, delivering quantified cost savings and performance gains for your specific facility.
by skillslib
You can systematically code qualitative data against your evaluation framework, surface patterns and themes across multiple responses, extract compelling impact stories with supporting evidence, and generate summary matrices that link narrative findings to your outcomes claims. This skill maintains analytical rigor while reducing the 40-60 hours typically spent manually reviewing transcripts and open-ended survey responses per evaluation cycle.
by skillslib
Get complete, ready-to-deploy lead magnets tailored to your ideal customer profile. Claude designs the concept, writes the persuasive copy, builds the email sequences, and creates deployment strategies that attract qualified prospects and build engaged lists fast. You'll capture 3-5x more subscribers with magnetic offers that actually resonate.
by skillslib
You can convert raw discovery call notes into polished, multi-section sales proposals that include executive summaries tailored to buyer personas, needs analysis mapped to your solution architecture, tiered pricing options with competitive positioning, ROI projections with financial justification, and realistic implementation timelines. The skill preserves personalization and strategic positioning while automating structural components, letting you respond to RFPs and time-sensitive opportunities without sacrificing quality or consistency.
by skillslib
This skill generates optimized facility layouts by analyzing material and personnel flow patterns, validating against operational constraints, and comparing multiple design options with quantified metrics. You provide your facility's dimensions, equipment locations, and operational requirements, and Claude produces detailed layouts with flow efficiency scores, space utilization analysis, and cost-benefit comparisons. Each layout option includes specific recommendations for improving throughput, reducing congestion points, and enhancing safety compliance.
by skillslib