Most portfolio monitoring is still a collection exercise
Spreadsheets remain common. A 2018 Preqin survey found 46% of fund managers monitored their portfolios in Excel alone, and many still do. Newer software improves analysis but follows the same collection process. Portfolio companies fill out a template, upload a board pack or reply to an email. Software now uses AI to extract the figures for analysis. Each company’s finance team still prepares those numbers by hand every month while the sponsor follows up on late submissions. Our guide to AI portfolio monitoring covers how to set the process up well.
The sponsor’s view is only as good as the company’s data
When a KPI moves, the deal team wants to know why. A figure extracted from a board pack can show that gross margin fell two points. Explaining which customers, contracts or jobs caused the fall requires detail still held in the company’s systems. Definitions drift as well. Utilization at one company excludes travel time and at another it does not, so the portfolio totals combine different measures. Consistent reporting requires an agreed model of each business, with definitions set once and every number traced to its source record. We cover how that model works in the company ontology guide.
What the portfolio company gets each week
Template monitoring gives the portfolio company another reporting deadline with little benefit to its own team. Connecting at the source gives the CFO and operators views built from their own systems: billing checked against contracts, branch or crew productivity, cash and working capital, and an operating review drafted before the Monday meeting. Because they use it every week, the numbers the sponsor sees stay current without anyone chasing them. At one PE-backed field services company, this work began by connecting the warehouse, finance, billing, HR and every customer contract.
Each portfolio company takes less time to connect
The first company takes the most work because engineers must connect its systems and agree on what each KPI means. The second uses proven integrations and definitions, as does the third. Over time, the firm builds one consistent model across its portfolio. Teams can then answer portfolio-wide questions from source data and read the KPI pack without rebuilding it. This is the forward-deployed model we use across a portfolio.






