PE: Portfolio Consolidation

What Is the Approach?

How We Build This

• Normalize the data before consolidating it. The real problem isn’t consolidation. It’s inconsistency upstream. We unify nightly extracts from every portfolio company into a shared warehouse and map each company’s chart of accounts into a standardized taxonomy. The mapping rules are co-built with the ops team and each controller so they reflect business intent, not surface-level name matching.
• Automate the close orchestration. On the first business day post-month-end, the workflow verifies every company has closed, then runs intercompany eliminations, currency adjustments, and minority interest calculations following rules signed off by the firm’s external auditors. Companies that haven’t closed get automated reminders with the specific outstanding items.
• Flag variances with context, not just alerts. Anomalies surface with full drill-down (not “revenue is off 12%” but “portco X, account Y, these transactions”). Reviewers chase real issues instead of spot-checking the entire package.
• Deliver a live partner dashboard. Drill-through from fund level down to individual transactions. Partners get preliminary consolidated results within days of month-end instead of waiting three weeks, so portfolio decisions run on current data.

Where This Fits Best

Firms with 6–12 portfolio companies across mixed industries and different ERPs hit the sweet spot: enough complexity to justify the build, small enough that the ops team can engage meaningfully on the normalization rules. Single-industry funds with homogeneous portcos see smaller wins because manual consolidation is already tractable.