Ledger
Issue No. 002 · Failure Modes
Why most private equity funds still run on spreadsheets.
The right tool for eight LPs and one wire deadline becomes the wrong one the moment a second fund turns it into a database nobody designed.
By Owen E. H. Meyer · May 26, 2025 · 4 min read
Visit enough emerging funds and you'll eventually see the same spreadsheet. The colors differ, the column order differs, but the shape is identical: a tab for commitments, a tab for capital calls, a tab for wires, and usually a fourth tab someone built for a specific exception and never generalized.
Name. Commitment amount. Called-to-date. Wired status. A notes column that starts useful and slowly turns into a graveyard of abbreviations only one person can read.
For a fund's first close, this is the correct tool, not a compromise. Eight limited partners, one set of terms, one wire deadline — a spreadsheet built in an afternoon can track all of it more reliably than any software a first-time manager could justify buying. There is no retrieval problem yet, because there is nothing to retrieve that isn't already visible on a single screen.
The second fund changes the arithmetic, quietly enough that most firms don't notice until well after the fact. It introduces multiple closes, more LPs, side letters, amendments, and exceptions — and the spreadsheet grows to hold all of it.
The spreadsheet becomes a database nobody designed
What's unusual is that the spreadsheet has quietly become the system of record. It now encodes side letter terms, exception logic, multiple closes, and commitment history — not because it was designed for any of those things, but because it was already where the work happened.
This is the point where the spreadsheet stops being a tracking document and starts being a claim about reality — a claim that's only as good as the discipline of whoever last touched it.
Where it breaks
The failures are rarely dramatic. A capital call goes out before someone realizes an investor's wire instructions changed three weeks earlier, in an email that never made it back to the sheet — the update happened, just not in the place the team was relying on. A tool with no concept of version history, permissions, or relationships between fields will eventually be asked to hold the operating memory of a fifty-investor fund, not because anyone was careless, but because nothing about it was built to survive that load.
A spreadsheet accepts every answer with equal confidence, whether it's correct or six months out of date.
A spreadsheet accepts every answer with equal confidence, whether it's correct or six months out of date.
The person holding the system together
Every fund running this way has a person who functions as the spreadsheet's documentation. They know which tab is current, which color means "wired" versus "wire pending," why row 41 has a different formula than the rows around it.
None of that logic exists anywhere except in their head, which means the fund's actual operating knowledge is exactly as durable as that person's continued presence on the team. It's the same problem that shows up everywhere in fund operations once you start looking for it: the information was never missing, it just lived in a format only one person could reliably read.
A spreadsheet doesn't create that fragility on its own — it just has no mechanism for preventing it.
What replaces it
The instinct, once a spreadsheet starts breaking, is to build a better one — more tabs, more formulas, a stricter naming convention. That buys a few more months, not a fix. The structural problem is that nothing about the tool understands what an LP relationship is: a record that spans years, accumulates exceptions, and needs to answer specific questions on demand rather than simply display rows. Size was never the issue.
The other instinct is to buy a CRM, and this one fails for a more interesting reason. CRMs are built around a sales pipeline — a deal that opens, moves through stages, and closes. A private fund's relationship with an LP assumes the transaction already happened; the commitment was the close.
Everything that follows — capital calls, reporting, amendments, side letters, follow-ups — isn't a pipeline; it's stewardship. Asking a pipeline tool to manage a decade of stewardship is a structural mismatch, not a configuration problem, which is why so many funds buy a CRM, populate it for two quarters, and quietly go back to the spreadsheet.
Emerging funds outgrow spreadsheets when the nature of the work changes, not simply because the organization gets larger.
At some point, the challenge stops being recording information and starts being recovering it. That's a different kind of problem, and most funds are still using the same tool to solve it.