formualizer

ILPA-format statements from the fund model you already trust.

Your waterfall, carry, and clawback logic live in Excel because your LPA is bespoke. Keep it there — and give your LPs and GPs statements where capital calls, distributions, and carry all trace to your actual cells.

ILPA reportingcarried interestclawbackrecallable distributionscapital callswaterfall

Emerging and mid-size fund managers, CFOs, and the fund administrators who serve them.

Book a working session
ILPA Capital Account Statement
Cedarline Partners II, LP
Fund II · European waterfall · Q2 2026
Model v13 · ILPA 3.0 templateVerified
Trace
Carry Accrual
Waterfall!K22
  1. $312,400Carry AccrualWaterfall!K22= 20% of profit above pref
  2. $1,562,000Profit above PrefWaterfall!K18
  3. $208,300GP Catch-UpWaterfall!K14
  4. $980,400Preferred Return (8%)Waterfall!K10
  5. $4,200,000Contributed CapitalCapAccts!D9

Carry accrual of $312,400 = 20% of profit above the 8% preferred return, on a hypothetical liquidation of the fund (Waterfall!K22).

Click any figure — this is what your counterparties get. The trace walks the number through your model to the cells that produced it.

Platforms verify against your Excel. So the Excel is the truth.

The industry's own workflow admits it: fund accounting platforms get reconciled against the manager's model every quarter. If your Excel is the arbiter, the six-month migration bought you a second system to check.

Bespoke LPAs don't fit configured waterfalls.

Recallable distributions, side letters, tiered carry with catch-up, European vs deal-by-deal — your terms exist because you negotiated them. Rebuilding them in a platform's configuration language is where the errors creep in.

Clawback questions deserve better than a promise.

When an LP asks about clawback exposure, the real answer is a hypothetical liquidation run through your model. That should be a button they can press, not a memo they have to trust.

Carry Schedule · GP
Cedarline Partners II, LP
Distributions to date$1,650,000Waterfall!H30
Carry accrued to date$312,400Waterfall!K22
Carry earned (hyp. liq.)$312,400Waterfall!K28

Flip to a hypothetical liquidation and watch carry recompute — clawback exposure surfaces on its own line, cells and all.

How the counterparty experience works

01

Send your fund model

Waterfall, capital accounts, carry schedule — sanitized, exactly as your LPA shaped it.

02

We map it to ILPA format in 48 hours

Your outputs, rendered as the ILPA reporting template LPs already ask for. Your formulas stay the system of record.

03

LPs and GPs get their statements

Capital account, called and distributed capital, carry accrual — permissioned per recipient, every figure traceable to your cells.

04

Clawback on demand

Hypothetical-liquidation toggle runs the scenario through your own model, so the exposure number is computed, not asserted.

Questions

How is this different from a fund administration platform?

Platforms rebuild your waterfall in their engine and take months to implement; you then verify their output against your Excel anyway. Formualizer runs your Excel directly — the statement and the model can't disagree because they're the same computation.

Do you produce ILPA-standard reporting?

Yes — the LP statement renders in ILPA template format, with the difference that every line item is click-traceable into the model that produced it rather than a static quarterly PDF.

We're a fund administrator. Does this work across clients?

That's the natural fit: each client's bespoke model becomes a portal without per-client engine configuration. One admin, many funds, no waterfall rebuilds. Talk to us about admin partnerships.

What does it cost?

A paid pilot: $2–3k setup, your first fund live in 48 hours, then a monthly per-LP fee. Bespoke-LPA complexity is exactly what the concierge setup absorbs.

48 hours from workbook to live statements.

Concierge pilot: send a sanitized workbook, we map it and stand up your counterparty portal in 48 hours. Pilots are paid — $2–3k setup, then a monthly fee per recipient. If the pilot doesn't earn the subscription, walk away.