Comprehensive asset consolidation across 5 acquired financial services companies, harmonizing disparate asset registers into a unified platform and establishing standardized management processes for a PE-backed financial group.
A private equity firm had acquired 5 financial services companies over 18 months, creating a combined entity with 67 office locations across 28 states. Each acquisition brought its own asset management practices, ERP systems, and depreciation methodologies, creating a complex consolidation challenge.
Five different ERP platforms (SAP, Oracle, NetSuite, Sage, and a custom legacy system) with incompatible asset classification schemes, depreciation methods, and data structures.
Combined asset registers contained 92,000+ records with duplicate entries, inconsistent naming conventions, missing acquisition dates, and conflicting depreciation schedules across entities.
PE sponsor required consolidated financial reporting within 14 months to support planned refinancing. External auditors needed clean, reconciled asset records for the combined entity's first consolidated audit.
67 office locations across 28 states with varying lease terms, leasehold improvements, and local property tax requirements requiring location-specific asset tracking.
We executed a comprehensive three-phase approach combining data analysis, physical verification, and system migration to create a unified asset management platform.
Extracted asset data from all 5 ERP systems, performed comprehensive data profiling to identify duplicates, gaps, and inconsistencies. Developed unified classification taxonomy and mapping rules for harmonization.
Conducted wall-to-wall physical verification across all 67 locations, confirming asset existence, condition, and location. Applied standardized asset tags and captured detailed attributes for each verified item.
Merged verified physical data with cleansed financial records into a unified asset register. Standardized depreciation methods, useful life assignments, and asset classifications across all entities.
Supported purchase price allocation for all 5 acquisitions, identifying fair market values for tangible and intangible assets. Established proper goodwill calculations and opening balance sheet entries.
Migrated all consolidated asset data into the target SAP environment with validated opening balances, correct depreciation schedules, and proper entity coding. Provided hypercare support during go-live.
Developed unified asset management policies, capitalization thresholds, and depreciation guidelines. Trained 120+ finance and operations staff on standardized procedures and ongoing maintenance protocols.
The consolidation program delivered a single, accurate asset management platform supporting the PE sponsor's growth strategy and enabling clean consolidated financial reporting.
Successfully merged asset records from 5 disparate systems into a unified SAP platform with 99.3% data accuracy, eliminating 14,000+ duplicate and ghost asset entries.
Identified and corrected $34 million in asset value discrepancies including unrecorded additions, incorrect depreciation, and misclassified capital vs. operating expenses.
Enabled the combined entity's first consolidated audit with unqualified opinion and zero material weaknesses, supporting the PE sponsor's refinancing timeline.
Established standardized onboarding procedures enabling rapid integration of future acquisitions, reducing expected integration time from 12 months to 4 months per entity.
"CPCON delivered exactly what we needed: a clean, unified asset register that gave our auditors confidence and our PE sponsors the financial clarity they required for refinancing. The team's ability to navigate five different systems and cultures was remarkable."
Multi-entity asset consolidation at enterprise scale
Our experienced teams specialize in multi-entity asset consolidation, register harmonization, and ERP migration for financial services organizations.