Perspectives · Data Operations
When the Tool That Built Your Firm Starts to Cap It
Excel didn't fail your firm. It kept working past what one spreadsheet, one person and one deadline can hold. Where lean private markets firms hit the cap.
· 5 min read
Part of the guide Private Markets Fund Data: Common Problems and How to Fix Them
At lean private markets firms, Excel is the plumbing. A workbook built for one person's Tuesday gets copied, linked and stacked until it feeds the numbers that reach LPs, auditors and regulators. The file everyone calls FINAL_v15 is load-bearing, and nobody scheduled it to be.
The file everyone depends on and nobody owns
Walk into any private markets firm under $10 billion in AUM and you will find the same architecture: a handful of Excel workbooks doing the work of a system of record. One analyst builds a tracker for deal terms. A colleague copies it, adds tabs, links it to a capital call schedule. Six months later that workbook feeds the NAV, the LP report and the audit file. There is a macro only one person understands. There is no version control, no named owner and no audit trail.
The risk concentrates in the 10 to 20 files that produce investor-facing numbers, and in the one person who maintains them. This is Excel key person risk in fund operations: the firm's most important numbers depend on someone who has never been assigned to own them. Practitioners describe a ceiling: tracking deal terms in spreadsheets gets cumbersome around 500 positions, and manual data management breaks near 1,000. Team hours do not scale with AUM. Stopgaps become systems of record, and nobody notices the moment they do.
Why the same spreadsheet that saves the team puts it at risk
The tool that made the firm fast is also the tool that makes it fragile. Research compiled by the European Spreadsheet Risk Interest Group finds that roughly 90 percent of operational spreadsheets contain errors, with cell error rates averaging over 5 percent (EuSpRIG, 2006). These are not hypothetical risks. In 1994, Fidelity's Magellan fund withdrew its year-end dividend after an accountant omitted a minus sign on a $1.3 billion capital loss, throwing the estimate off by $2.6 billion (Los Angeles Times, 1994). In 2020, Public Health England dropped 15,841 positive COVID cases from its daily figures because an Excel file hit its row limit (BBC, 2020).
None of these organizations were careless. They were running at scale on a tool built for a single user, and the tool did what tools do: it broke at the seam where one person's work meets everyone else's. Spreadsheet risk in private equity is not a hypothetical. It is the predictable cost of asking a personal productivity tool to carry institutional reporting.
It means a tool built for one person's Tuesday got asked to carry a department's Thursday, every week, indefinitely.
The staged way out and why banning Excel is not on the list
Banning Excel fails by week two because fund accountants and LP analysts are fast in it. The fix has to be staged.
Inventory the load-bearing files. List the 10 to 20 workbooks that produce investor-facing numbers. Name the owner of each. If a file has no owner, that is the first thing to fix.
Put light controls on that list only. Version naming, a shared location and a change log for the files that matter. Do not try to govern every spreadsheet in the firm.
Move the highest-risk workflow first. Pick the one calculation that would hurt most if it broke, usually a waterfall or an accrual, and move it out of the workbook.
Codify what moved. Write the calculation as a rule that changes in one place, not as a formula pasted across twelve tabs.
Leave Excel connected as the sandbox. Analysts keep the tool they are fast in. The difference is that Excel becomes a window onto governed data rather than the place the data lives.
What to look for once the inventory is built
A real fix has three marks. Every input has a documented source. Every file has a named owner and version discipline. Every calculation governed by contract language, accruals, covenant checks, waterfalls, is codified as a rule changed once, not a formula maintained by one person. If you have those three, you have spreadsheet governance for fund finance without banning the tool your team relies on.
For firms ready to move past stopgaps, Aquata's Central Data Layer gives you one governed source for every fund, entity, investor and deal. It ingests PDFs, administrator packs and Excel financials without re-keying, and it speaks the format of whichever administrator or vendor you add next. Calculations move out of twelve tabs into one place, codified as rules. Validation rules are written by accountants, not filed against an engineering backlog. Named ownership, version discipline and a documented source for every input come with the layer. No data engineer or enterprise budget is assumed. You can see how it works in the Central Data Layer use case.
The goal is not to get rid of Excel. It is to stop asking it to be your system of record for fund data. Transform fragmented data into action, and let the spreadsheet go back to what it was built for: one person, one problem, one Tuesday.
