Financial Statement Consolidation: One Set of Books Across a Roll-Up
Agentic close and automated eliminations take a consolidated period close from roughly 21 business days to 3, which shortens the reporting cycle, surfaces margin by product line in week one, and turns DSO and inventory decisions into basis points. See the 100x ledger for the rows behind this lever.
What does "one set of books" actually mean?
It means every legal entity in the platform posts into the same general ledger structure, in the same system, under the same close calendar, with eliminations handled by the system rather than by a controller and a spreadsheet. Anything short of that is consolidation theatre: the numbers get assembled, but they cannot be audited back to source without manual work.
The practical test is simple. If your operating partner asks for consolidated gross margin by product line on day four of the month and the answer is "we can get that after close," you do not have one set of books yet.
Chart of accounts harmonization
Every acquisition arrives with its own account structure, usually shaped by whoever set up the books a decade ago. Harmonization is the unglamorous work that makes everything downstream possible.
- Extract the full account listing from every entity, with twelve months of posting volume per account so dormant accounts are visible.
- Build the target structure from the platform company forward, not as a compromise between the entities.
- Produce an explicit mapping table: source account to target account, with a documented owner and rationale for every merge and every split.
- Map the accounts that do not map. These are the ones that expose genuine differences in how the businesses operate, and they need a finance decision rather than a technical one.
- Restate prior periods against the target structure so trend reporting survives the transition.
Intercompany eliminations that actually close
Intercompany is where most roll-up closes stall. Entity A bills Entity B, the two sides book it differently, and someone reconciles the difference by hand every month forever. The fix is structural: matched intercompany accounts, automated elimination entries on a defined schedule, and an exception report that surfaces unmatched balances before close rather than during it.
- Dedicated intercompany account pairs, never commingled with third-party activity.
- Automated elimination journal entries generated by the system against the consolidation hierarchy.
- A pre-close exception report so unmatched balances are chased on day two, not day fourteen.
- Transfer pricing rules encoded once, applied consistently, and documented for audit.
From a 21-day close to a 3-day close
The eighteen recovered days are not found by working faster. They are found by removing the steps that should not exist.
| Close step | Typical roll-up | After consolidation | How |
|---|---|---|---|
| Subsidiary data collection | 5-7 days | Continuous | Entities post directly into the platform ledger. |
| Intercompany reconciliation | 3-5 days | Under 1 day | Automated eliminations plus pre-close exception report. |
| Inventory and receipt accrual | 2-4 days | Continuous | Received-not-billed cleared by system rule, not by hand. |
| Consolidation and mapping | 3-4 days | Instant | One chart of accounts, one hierarchy. |
| Review and reporting pack | 3-4 days | 1-2 days | Reports run against live data instead of assembled files. |
Why this moves the exit multiple
A buyer diligencing your platform in 36 months will ask the same questions you asked when you bought it. Consolidated financials produced by a system, on a three-day cycle, with an auditable trail back to source, remove an entire category of buyer objection. Financials assembled by hand invite a discount, a longer diligence period, and a larger escrow, all of which cost real money at exit.
Deliverables
- Target chart of accounts and a documented source-to-target mapping for every entity.
- Configured OneWorld subsidiary hierarchy with consolidation and currency rules.
- Automated intercompany elimination rules plus a pre-close exception report.
- A restated trailing-twelve-month comparative against the new structure.
- A written close calendar with named owners and a target close day.
Frequently asked questions
How long does consolidating an acquired entity take?
A single entity with clean books typically folds into an existing OneWorld tenant inside a two to four week sprint. The variable is not the technical migration, it is how much finance decision-making the chart of accounts mapping requires.
Do we have to move every entity at once?
No, and you usually should not. We sequence by materiality and by close pain, so the entity causing the most month-end suffering moves first and the calendar improves immediately.
What happens to historical data in the legacy systems?
We migrate the trailing comparative periods needed for reporting continuity and archive the remainder in a retrievable form. Migrating a decade of detail into the platform ledger is almost always the wrong tradeoff.
Can you do this without a full re-implementation?
Yes. If the platform company already runs NetSuite, folding in an acquisition is a configuration and mapping exercise rather than a fresh implementation. That distinction is the difference between a quarter and a year.
Related research
The 100-Day Post-Merger Unification Blueprint
A disciplined four-phase architectural roadmap to consolidate acquired entities into a single OneWorld tenancy, retire script sprawl, and automate intercompany eliminations by Day 100.
CFO Dialogue: Protecting EBITDA Multiple Expansion
A skeptical CFO grills Kyle on why traditional roadmaps fail, how phantom inventory receipts destroy exit value, and how 14-day production sprints eliminate $120k/yr middleware subscription tolls.
Technical Arbitrage and Multiple Expansion
Why bolt-on acquisitions fail to achieve multiple expansion when technology integration is deferred, and how a 48-72 hour NetSuite diligence read protects fund returns across SuiteScript 1.0 liabilities and role permission sprawl.
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.