Private equity waterfall software calculates who gets paid what, and when, under the terms of a fund’s limited partnership agreement (LPA). Many funds still run that calculation in a spreadsheet next to the books. This guide explains why the waterfall belongs inside the fund accounting system, what a waterfall model has to handle, and what to look for when you move it there.
It is the practical companion to our guides on distribution waterfalls, American vs European waterfalls, carried interest calculation, and the GP catch-up, which cover the terms and the math.
Key takeaways
- A waterfall is accounting, not only math. Every distribution, carry payment, and allocation has to land in the capital accounts and the general ledger.
- Spreadsheets break at the joins. Copying contributions and NAV out of the books, and results back in, is where errors, version drift, and audit gaps start.
- The terms are the hard part. Hurdles, catch-ups, whole-fund or deal-by-deal rules, side letters, transfers, and multiple vehicles all have to be modeled exactly.
- Accrued carry needs the same engine. NAV reporting runs a hypothetical liquidation through the same waterfall as real distributions.
- Inside the accounting system, results reconcile by construction. Notices, capital account statements, and the ledger come from one record.
- Test before you trust. Rebuild the history and reconcile it to past distribution notices before going live.
What a private equity waterfall model has to handle
A distribution waterfall reads like four tiers. In a real fund, the model behind it has to cover every term the LPA and side letters add.
| Term | What the model must do |
|---|---|
| Return of capital and preferred return | Track contributions, distributions, and the hurdle by date, with the LPA’s compounding and base |
| Catch-up and carry split | Apply a full, partial, or no catch-up, and tiered carry where the rate steps up |
| Whole-fund or deal-by-deal | Run the hurdle across the fund or per deal, with any loss recovery and write-down make-up |
| Fees, expenses, and offsets | Return capital called for fees and expenses, and apply fee offsets as the LPA defines them |
| Investor-level terms | Handle side letters, fee classes, late closers, and excused investors, one investor at a time |
| Transfers and multiple vehicles | Handle partial LP transfers, parallel funds, feeders, and alternative vehicles that share one waterfall |
| Accrued carry | Run a hypothetical liquidation at NAV on every reporting date |
| Clawback | Compare carry paid to date with what the GP would be entitled to on the final numbers |
| Tax allocations | Produce allocations that tie to the capital accounts and, in the US, the K-1s |
Why spreadsheet waterfalls break
A spreadsheet can do the arithmetic. The trouble is everything around it.
- Inputs are copied from the books. Contributions, distributions, and NAV are exported and pasted, and they go stale as soon as the ledger changes.
- Results are typed back in. Allocations and carry entries are re-keyed into the general ledger, so the two records can drift apart.
- Versions multiply. Each quarter, scenario, and investor request produces another copy of the model.
- Formulas hide the terms. A side letter or a hurdle change buried in a cell is hard to review and easy to break.
- One person understands it. When the model’s author leaves, so does the knowledge of how it works.
- There is no audit trail. Auditors and LPs want to see how each number was produced, not only the result.
Standalone calculator vs a waterfall inside fund accounting
| Question | Spreadsheet or standalone tool | Inside the fund accounting system |
|---|---|---|
| Where do the inputs come from? | Exports from the books | The same ledger, as transactions post |
| Where do the results go? | Re-keyed into the general ledger | Posted as allocations and journal entries |
| Investor-level results | Often a separate step or a separate file | Each investor’s capital account |
| Notices and statements | Built separately, then checked | Generated from the same records |
| Accrued carry in NAV | Another model run, another copy | The same engine on every reporting date |
| Audit trail | Cell formulas and file versions | Transactions, configuration, and history |
| Change control | Whoever has the file | Configuration with permissions |
Stop running waterfalls in spreadsheets
FundCount’s partnership engine runs the waterfall inside the books, so capital accounts, carry, notices, and the general ledger come from one record.
Types of private equity waterfall software
Waterfall tools fall into five groups. The right one depends on whether you want the calculation inside the books or next to them.
| Type | Examples | Best for | Watch-out |
|---|---|---|---|
| Waterfall engine inside fund accounting | FundCount, Allvue, LemonEdge, Relevant EquityWorks, FirstRate Vantage | Funds and administrators that want the books, capital accounts, and carry in one record | History has to be loaded and terms configured before go-live |
| Specialist waterfall software | Cascata PE Suite | Teams that want a dedicated waterfall engine next to their accounting system | Results still have to be posted to the books |
| Consulting-built solutions | Deloitte’s automated distribution waterfall solution | Managers that want a tailored build with advisory support | Cost, and reliance on the provider for changes |
| Online modeling tools | CRE Models | Quick deal-level scenarios | Not connected to the books or to investor accounts |
| Spreadsheet templates | Model libraries and training providers | Learning and one-off analysis | The risks described above |
Examples are taken from the vendors’ own descriptions as of November 2026 and are not a ranking.
What to look for in private equity waterfall software
- Can it model our LPA terms without custom code: hurdle base and compounding, catch-up rate, tiered carry, whole-fund and deal-by-deal?
- Does it calculate per investor, including side letters, fee classes, and transfers?
- Can it run a hypothetical liquidation for accrued carry on every reporting date?
- Does it track carry paid against entitlement, so the clawback position is always visible?
- Do the results post to the general ledger and the capital accounts automatically?
- Does it produce distribution notices and capital account statements from the same records?
- Can we rebuild our history and reconcile it to past notices before going live?
- Who can change the configuration, and is every change logged?
If you are comparing platforms, our review of fund accounting software with waterfall modeling covers the leading options.
How to move a waterfall out of Excel
-
Document the terms
Write the LPA, side letter, and amendment terms out in plain language, and have the deal and legal teams sign them off.
-
Configure and load history
Set up the terms, then load every contribution, distribution, and transfer since the fund’s first close.
-
Reconcile to past notices
Rerun past distributions and match each one to the notices LPs received.
-
Run in parallel
Run the spreadsheet and the system side by side for at least one distribution or quarter-end.
-
Cut over and lock
Retire the spreadsheet and control configuration changes from then on.
How FundCount runs waterfalls inside the books
FundCount’s partnership accounting is built for the problem this guide describes: running waterfalls and capital allocations in the ledger instead of in spreadsheets.
- A configurable waterfall engine. Preferred returns, catch-ups, tiered carry, deal-by-deal or whole-fund terms, and debt-provider participation, set to your LPA rather than a template.
- One record. Contributions, distributions, transfers, and allocations flow into one accounting-backed ledger. The capital accounts and the general ledger are the same record, so statements, K-1s, and waterfall notices reconcile by construction.
- Carry posts like everything else. Capital activity, profit and loss allocation, and GP carry crystallization post to the same real-time ledger as trades and cash.
- Complex structures, natively. Partial LP transfers, side pockets, series LLCs, multi-vehicle waterfalls, and Section 704(b), 704(c), and 754 tax allocations.
- Delivery. The investor portal delivers statements and notices, and reporting exports to Excel and to Power BI or a data warehouse through native connectors.
FundCount cites a migration of 743 investors and 14 entities off Excel and QuickBooks in 11 weeks. The same platform serves private equity firms and fund administrators.
Watch-outs
- The configuration is only as good as the reading of the LPA. Have it reviewed by the people who negotiated the terms.
- Plan time to load and reconcile history. A waterfall without complete history cannot get today’s numbers right.
See a waterfall run inside the books
A 45-minute walkthrough of FundCount’s demo environment: partial transfers, side pockets, multi-vehicle waterfalls, and Section 704 capital accounts, with no data exchange and no setup on your side.
FAQs
What is private equity waterfall software?
Software that calculates distributions, carried interest, and allocations under a fund’s LPA terms. It works best inside the fund accounting system, so the results post straight to the capital accounts and the general ledger.
What are examples of private equity waterfall software?
Fund accounting platforms with built-in waterfall engines, such as FundCount, Allvue, LemonEdge, Relevant EquityWorks, and FirstRate Vantage; specialist tools such as Cascata PE Suite; consulting-built solutions such as Deloitte’s; and online modeling tools such as CRE Models.
Can you model a waterfall in Excel?
Yes, and many funds do. The risk lies in moving data in and out of the books, in multiplying versions, and in depending on one person, and it grows with every investor, vehicle, and side letter.
What should waterfall software calculate?
Distributions by tier, carried interest paid and accrued, investor-level allocations, and the clawback position, all on the LPA’s own terms.
What is a hypothetical liquidation?
Running the waterfall as if the fund sold everything at NAV on the reporting date, to measure accrued carry and each investor’s share of NAV. Our carried interest calculation guide works through an example.
Does waterfall software replace legal review of the LPA?
No. It applies the terms as configured. The people who negotiated them should confirm the configuration before it goes live.
How long does it take to move a waterfall into fund accounting software?
It depends on the history and the complexity of the terms. FundCount cites a migration of 743 investors and 14 entities off Excel and QuickBooks in 11 weeks.
Should the waterfall run at the fund or the investor level?
Both. The fund-level waterfall decides what goes to LPs and what goes to the GP; investor-level allocations decide each LP’s share, including side letter terms.
Sources and methodology
Sources: FundCount product pages for partnership accounting, reporting, and the investor portal, reviewed in November 2026. The model scope, spreadsheet risks, and checklist reflect common fund accounting practice.
Scope: general information, not legal, tax, or accounting advice. Every LPA defines its own waterfall.
Published: November 2026.