You pay for fund management software. Investor portal, K-1 generation, reporting dashboards. It handles a lot. But every quarter when distributions come due, someone on your team opens Excel. The software handles everything except the one calculation that carries the most risk.
The Waterfall Module That Doesn't Quite Work
Most fund management tools include a waterfall feature. It handles simple structures: one pref tier, one promote split, a straightforward American-style waterfall. That covers the demo. It doesn't cover your deal.
Real structures have multi-tier hurdles with GP catch-up after each tier. They have side letter overrides that modify pref rates for specific investors. They have clawback provisions that track across the fund lifecycle. The module can't flex to match your LPA. So you export the data, run the real math in Excel, and import the results back.
You're Paying Twice
You're paying the subscription fee for a waterfall module you can't use, then spending controller hours in Excel doing the work anyway. The software gives you a checkbox feature for the sales demo. You give yourself the actual math.
The cost isn't the subscription. It's the controller time spent maintaining a parallel process. Every distribution cycle, your team pulls data out of the system, runs the waterfall in a spreadsheet, and manually enters the results back in. That's not a workflow. That's a workaround.
The software covers reporting and administration. The actual waterfall math still requires a spreadsheet.
Side Letters Break Everything
When investor A has a modified pref rate and investor B has a fee waiver, the waterfall calculation changes on a per-investor basis. Most fund management tools treat all investors identically through the same waterfall structure. You can't override terms per LP without exporting to a spreadsheet.
Side letters get mixed up and accounted for on non-applicable terms. That's not a hypothetical. It's one of the most common errors in waterfall modeling. When you can't model investor-specific overrides in the system, you model them in Excel. And in Excel, the override is a manual cell edit with no guardrails.
The Spreadsheet Becomes the System of Record
Once you're running the real waterfall in Excel, the software's numbers are decorative. Your LPs get paid based on the spreadsheet, not the system. But the spreadsheet has no audit trail, no version control, no locked records. You're back to all the risks of manual calculations, just with an extra software bill on top.
The system shows one set of numbers. The spreadsheet shows another. When an auditor or an LP asks which is correct, the answer is "the spreadsheet." That's not a good answer when you're defending your distribution math.
The Question That Matters
The question isn't whether your software has a waterfall feature. It's whether you trust it enough to stop opening Excel. If the answer is no, you don't have waterfall software. You have a reporting tool with a waterfall label on it. The calculation that determines who gets paid what is still on you.