Systems Spine
Stop data breaks before payouts do.
The integration layer—how data flows from CRM to payout, and where it breaks.
When to Pull This Lever
- • ICM implementation or replacement
- • CRM migration, data quality issues, or payout accuracy problems
The Consequences
What It Moves
ICM selection • integration design • data validation • shadow elimination • reconciliation
Blast Radius
Payout errors • rep distrust • audit findings • manual rework • system abandonment
Scoreboard
Payout accuracy % • reconciliation exceptions • shadow system count • data latency
Default Artifacts
Data flow diagram • integration spec • validation rules • reconciliation SOP
Common Failures
- • ICM treated as "commission calculator" instead of data integration hub
- • No data validation before it hits the comp engine
- • Shadow systems (spreadsheets) running in parallel
- • No reconciliation between source systems and payout
Fast Wins
- • Map all data sources feeding the comp engine
- • Add validation rules at integration points
- • Kill one shadow spreadsheet per quarter
- • Build reconciliation report between CRM and ICM
Score This Lever
If you can't answer "yes" with proof, you don't score above 2.
- 1Data flow diagram exists (source → comp engine)
- 2Validation rules catch bad data before payout
- 3Shadow systems inventory exists and is shrinking
- 4Reconciliation runs before every payout cycle
- 5Data ownership is assigned per source
Score: 0 (Missing) → 1 (Documented) → 2 (Repeatable) → 3 (Controlled) → 4 (Optimized)
Maturity Ladder
Manual
spreadsheets are the system
Tool
ICM exists but data is manual
Integrated
data flows but isn't validated
Validated
data quality rules enforced
Automated
end-to-end with exception handling
The Kit
Starter Artifacts
Data flow diagram • integration inventory • shadow system list • reconciliation report