Home / Case Studies / pe Roll up Consolidation
Field retrospective

Four ERPs to One Set of Books in a Chemical Distribution Roll-Up

A sponsor acquired four chemical distributors in 14 months across four different ERPs. Consolidated reporting took 27 days. We migrated all four into one governed NetSuite tenant and took the close to 3 days.

The problem

The sponsor acquired four independent chemical distributors in 14 months. Each ran an isolated ERP: two on QuickBooks Enterprise, one on Dynamics GP, one on a neglected NetSuite instance. Consolidated reporting took 27 business days each month, inventory visibility was effectively zero, and custom scripts were failing during peak hours.

What we did

We ran a 72-hour diligence read to identify schema linkages and role risks, then re-architected a single multi-subsidiary NetSuite tenant: standardized chart of accounts, harmonized lot numbering, and migrated four disparate systems into one governed environment.

Results

MeasureBeforeAfter
Consolidated month-end close27 business days3 business days
Redundant SaaS and admin overhead$420,000 / year$85,000 / year
Time to cash68 days DSO41 days DSO
Audit readinessHigh risk, control findingsClean opinion

DataOngoing bypassed six months of vendor slideshows. They delivered a working multi-entity architecture in three weeks that our previous integrator said was impossible.

Composite retrospective; client shown as an archetype. Related service: Financial Statement Consolidation in NetSuite

Talk to the architect, not a salesperson

AI automation for private-equity portfolios, measured in basis points: a few hours of operating-partner time in, hundreds of engineering hours and margin out, delivered as working code in two-week sprints.

Get a 72-Hour Diligence Read   Read the 100x Ledger

(844)-991-3648  •  2doai@dataongoing.com