Twelve portfolio companies. Eight different ERPs. Five CRMs. Three HRIS platforms. And one operating partner is trying to answer the question: "What's our consolidated revenue this quarter?" That question shouldn't require two weeks and four phone calls. But right now, it does.
The path to portfolio intelligence isn't a multi-year transformation project with a Big Four consultancy and a seven-figure budget. It's a focused 90-day effort that starts producing value in the first month. Here's the week-by-week breakdown, based on what we've seen work across growing PE portfolios.
Weeks 1 to 2: Map the Landscape
Before connecting anything, you need to see the full picture. Not a 6-month discovery engagement that produces a binder nobody reads. Two weeks. Clear deliverables.
System inventory across every portfolio company. What ERP does each company run? What CRM? What HRIS? Where do financials actually live (the system of record, not the spreadsheet someone maintains on the side)? Which companies have clean data, and which ones make your team wince when they open the files?
Chart of accounts analysis. How does each company categorize revenue and expenses? Where do the definitions align naturally? Where do they diverge in ways that matter for consolidation? Company A's "Professional Services" revenue and Company B's "Consulting Revenue" might be the same thing, or they might not. This mapping work is the foundation on which everything else builds.
Data quality assessment. Which companies have reliable, auditable financial data? Which ones have gaps, manual overrides, spreadsheet-based adjustments, or that mysterious "Other" category containing millions in unclassified items? Knowing this upfront prevents surprises in week 4.
Prioritization. Which company should connect first? Two viable strategies: pick the company with the cleanest data for the fastest proof of concept, or pick the company causing the most reporting pain for the fastest relief. Either approach works. The wrong approach is trying to connect all 12 at once.
The deliverables at the end of week 2: a prioritized connection sequence, a common chart of accounts framework, and a realistic timeline for each company. No ambiguity. No consultant-speak. A clear plan that your operating team and your board can evaluate.
Weeks 3 to 4: First Company Connected, First Value Delivered
The first company connection is the proof point. It's where the theory becomes something people can see and touch.
- Read-only connection to the first company's financial system. NetSuite, QuickBooks, Sage, SAP, Xero. Whatever they run. No migration. No disruption to their finance team. The CFO doesn't need to do anything differently.
- Financial data flowing into the portfolio intelligence layer. Revenue, expenses, cash position, key KPIs. All are mapped to the common chart of accounts established in week 2.
- First live view ready: the company's financials in a standardized format that the operating team can access anytime, with automated alerts when numbers fall outside expected ranges. No calls. No emails. No waiting for someone to build a report.
This is the moment the operating team sees what "connected" actually means. Not a slide deck with arrows and boxes. Not a demo with sample data. Their actual numbers, from their actual system, in a format that didn't require three days of manual assembly. For most operating partners, this is the moment they realize what's been possible all along while they've been building decks by hand.
What would it mean for your operating team to see real portfolio numbers without a single phone call?
Schedule a 30-minute portfolio assessment — see what connected data looks like for your portfolio.
Weeks 5 to 8: Portfolio Visibility Takes Shape
With the first company proven, the next 3 to 4 companies connect faster. The common chart of accounts is already built. The connection patterns are established. Each additional company takes days rather than the weeks required for the first one.
What comes online during this phase:
- Consolidated financial application: revenue, EBITDA, cash position across 4 to 6 companies, with automated alerts surfacing variances the moment they appear. The board deck starts building itself. Numbers that used to take two weeks to assemble are available on demand.
- Variance analysis: plan versus actual at the company level and portfolio level. Which companies are ahead? Behind? By how much? With drill-down detail available so the operating team can investigate root causes without requesting another report.
- Trend analysis: quarter-over-quarter performance by company, by acquisition cohort, by industry vertical. Not static snapshots, but trajectories that show whether a company is accelerating, plateauing, or declining. Patterns that are invisible in quarterly spreadsheets become obvious in connected time-series data.
- Value creation tracking for recent acquisitions: combined vendor spend for purchasing negotiations, customer overlap for cross-sell identification, and headcount benchmarking across entities. The metrics from the value creation plan are tracked against actuals.
By week 8, the VP of Portfolio Operations has something they've never had before: a single screen that answers "how is the portfolio performing?" without making a single phone call. That changes the operating rhythm of the entire firm.
It also changes the quality of conversations with portfolio companies. When an operating partner sits down with a portfolio company CEO, they're no longer starting with "walk us through your numbers." They already have the numbers. The conversation starts with "your gross margin dropped 200 basis points last quarter. Let's talk about why and what we're going to do about it." That's a more productive use of everyone's time.
Weeks 9 to 12: Full Portfolio, Full Automation
The remaining portfolio companies connect during this phase. The pace is faster now because every chart-of-accounts mapping challenge has been solved at least once.
- All portfolio companies are connected with financial data flowing automatically on the schedule you've defined. Daily for companies you're watching closely. Weekly for stable performers.
- Board deck automation: consolidated reports pulled from actual systems with full audit trail. Distribution calculations built in. Formatted to meet institutional investor reporting standards. Assembly time drops from three weeks to two to three hours of review and approval.
- LP reporting templates: standardized formats that match what institutional LPs expect for quarterly updates. Updated automatically from connected data. No more fire drills when an LP sends a data request at 4 PM on a Friday.
- Role-based access configured for every stakeholder: portfolio company CFOs see their own company's data (and only their own). Operating partners see the consolidated view across all companies. Board members see the portfolio summary with key metrics and trends. LPs see exactly what you choose to share, in the format they expect, with the level of detail that's appropriate.
What It Costs and What Changes
The total investment for a portfolio intelligence layer across a growing PE portfolio is less than one operating partner's annual compensation. It's a one-time build. You own it outright. No per-company licensing that charges you more every time you close an add-on. No per-seat fees that scale with headcount. No annual renewal where the vendor raises prices because they know you're dependent.
What changes after 90 days:
- Board deck prep drops from 3 weeks of manual assembly to 2-3 hours of review, verification, and approval.
- LP data requests are answered in hours, not days of scrambling across multiple companies for numbers.
- New acquisitions integrate into the portfolio view within weeks of closing. No more islands.
- Value creation initiatives tracked against actual financials, not qualitative narratives. Real numbers for real conversations.
- Exit-ready data exists as an ongoing process, not a 6-month pre-sale scramble that delays the exit timeline and raises buyer concerns.
EY reports that 72% of PE firms cite weak data as their biggest finance issue at exit. Portfolio intelligence built during the hold period means you walk into exit diligence with documentation, metrics, and value creation already proven with numbers. That's a material difference in diligence timelines, buyer confidence, and ultimately in the multiple you command.
Is weak data putting your next exit at risk?
Schedule a 30-minute portfolio assessment — see what connected data looks like for your portfolio.
Where to Start Right Now
The starting point depends on what's causing the most pain or costing the most time today.
- Board deck takes three weeks? Start with consolidated financial reporting. Connect 2 to 3 companies and prove the automation works. The rest of the portfolio follows quickly.
- Recent acquisition not integrating? Start with that company. Get its data into the portfolio view in the first 30 days after close. Stop the island from becoming permanent.
- LP quarterly update approaching? Build the first connected reporting tool in time for that update. Replace the narrative with numbers. Set the standard for every future update.
- Value creation plan is unmeasurable? Pick the biggest line item, connect the data needed to track it, and start reporting actuals at the next board meeting. One measured initiative is better than five unmeasured ones.
You don't need to solve the entire portfolio in the first two weeks. You need to connect with one company, prove the value, and expand from there. The roadmap is 90 days. But the first proof point comes in 2-3 weeks. That's fast enough to show results before the next board meeting.
Every PE firm knows it needs better data across its portfolio. The question has never been "should we?" It's always been "when?" and "how?" Ninety days from now, you can have a single version of truth across every company. Or you can still be calling CFOs, reconciling spreadsheets, and presenting stale numbers to a board that deserves better.
The economics favor moving now. The hold period clock doesn't wait.
Ready to start your 90-day roadmap? Talk to us about building portfolio intelligence, or explore our full private equity solutions.
