- Before
- Ticks and ties the administrator's spreadsheet against a shadow model, with the evidence spread across email threads and file versions.
- Now
- Opens each distribution with both models compared tier by tier and each gap explained, and checks with a reason code.
One fund's distribution, two models apart on the preferred return
A Delaware private equity fund with $1.4 billion of commitments from 214 LPs and a European, whole-fund waterfall has sold a portfolio company and is distributing $48,000,000 on a set date, with notices due a week before. Here is how the controller, the agents and the GP CFO work it through, screen by screen, in the working solution.
A worked example on sample data. Names, IDs and figures on the screens and in this section come from the demo.
- 01Tuesday morning
What needs the controller today, one next step each
Fund controllerThe controller checks each distribution before it goes to the GP CFO. The Today screen shows 23 open distributions worth $478.6M, 5 differences to decide ($1.78M between the independent runs and the administrator models), 11 notices due by Friday and 1 clawback exposure not covered. At the top of Needs you: the fund's distribution, check the corrected waterfall. Beside it, what the agents did overnight, each line cited.
Diff agent, early that morning: “The administrator agreed to the $412,000 correction; model v3 matches.”
- 02The queue
Each distribution, grouped by what it needs
Fund controllerDistributions lists 23 open distributions, one per vehicle, in three groups: needs a decision, with the agents or an administrator, and with the controller. Each row shows the amount, the notice date, the independent run against the administrator's model and who holds it. The controller can filter by strategy, waterfall type (European, American, IRR promote, deal-level, MOIC-tiered, incentive allocation), administrator and notice date. This distribution reads “Agreed in model v3 · $412,000 corrected to the LPA”.
An opportunistic credit fund: “Administrator model missing”. The independent run is ready and the request is drafted.
- 03Before any run
The LPA as a cited term table
Terms agentThe fund's waterfall terms sit in term table v4, prepared by the fund finance manager and approved by the controller earlier in the year, read by the Terms agent from the agreement, 3 amendments and 61 side letters. Each term cites its clause with a confidence: a European (whole-fund) waterfall, an 8% preferred return compounded annually at each year-end, Actual/365, a 100% GP catch-up until the GP has 20% of profits and an 80/20 carried interest split. The §9.5 in-kind valuation read at 86%, below the 95% line, so a person confirms it, and it is flagged for fund counsel with the question already drafted; proposed Amendment No. 3 waits for the checker.
Below 95% confidence a person confirms the term; an ambiguous clause goes to counsel instead of a guess.
- 04A week before the notices
The waterfall, run on its own from the LPA
Model agentThe Model agent ran the distribution from the approved term table and the capital ledger alone. The $48,000,000 pours through four buckets: return of capital $36,374,871 (§9.1(a)), preferred return $8,937,129 at 8% compounded yearly (§9.1(b)), and $2,688,000 of GP catch-up, 100% to the GP until it has 20% (§9.1(c)). The 80/20 carried interest split is not reached. The clawback gauge beside it shows $2.69M of carry paid against $247.5M of whole-fund carry at the last quarter-end NAV: no exposure.
The Model agent does not read the administrator's model or overwrite a run: what-ifs are separate scenarios.
- 05Six minutes later, then Tuesday
Two models, two tiers apart, and the §9.1(b) arithmetic
Diff agent, with the fund controllerSix minutes after the run, the Diff agent opened the administrator's model v2, received by file drop, read every formula and compared it tier by tier. Return of capital agrees; the preferred return is $412,000 lower and the GP catch-up $412,000 higher, $3,100,000 where the LPA allows $2,688,000. On Tuesday morning the controller asks in the thread beside the waterfall, “Show the §9.1(b) arithmetic”: unpaid preferred return of $6,055,242 at the last year-end, plus $148,553 accrued on a December capital call, makes a base of $6,203,795 that compounds into this year, and 8% × 303/365 of it is $412,000. Each figure links to its clause, ledger entry or cell.
Diff agent: “The administrator's 'Pref'!F18 leaves the base out. §9.1(b) puts it in.”
- 06The next two days
The clause beside the formula, and the query
Fund finance managerThe difference in plain words: what the agreement says, §9.1(b), beside what the administrator's model does, 'Pref'!F18 = C18*0.08*D18/365, a simple accrual on capital only. The fund finance manager accepted the independent run with reason code R1, the Diff agent drafted the query, and the controller approved sending it. The next morning the administrator replied: model v3 compounds per Section 9.1(b). The look-across found the same formula in a distribution from the fund's Luxembourg parallel: $91,600.
The Diff agent does not edit the administrator's model or send a query without approval.
- 07Minutes later
214 LPs, five exceptions, two payments held
Allocation agentThe Allocation agent split the distribution across 214 LPs, and the LP totals tie to the tiers to the dollar. Five exceptions: an insurer's W-8BEN-E expired last month, and a health foundation changed its bank details through the portal, so both payments are held. A German pension LP's side letter sets its carry at 15%, shown in the German original beside the English; a university endowment's transfer and a county retirement system's excused call are applied.
The Allocation agent does not pay or change LP bank details: the foundation stays held until the call-back to the contact on file confirms them.
- 08Checked, then signed
The controller checks; the GP CFO signs the correction
Fund controller, then the GP CFOThe controller checks $48,000,000, $45,312,000 to the LPs and $2,688,000 of GP carry; the check confirms the controller did not prepare it and holds no carry in the fund, and the controller records reason code R1, Independent run follows the LPA. The GP CFO then sees who prepared and who checked, that the CFO holds no carry in the fund and that each tier cites its clause, and signs with a passkey: “Signed on the independent run: §9.1(b) compounds annually. Catch-up $2,688,000, in place of $3,100,000.” The payment file goes to the treasury payment system with 212 LP payments, $43,481,577, and 2 held, and the evidence pack is sealed.
“I approve this distribution and the carry it pays, as officer of the General Partner.”
- 09Released
212 notices released; two stay held with their payments
Investor relations managerThe Notice agent drafted all 214 notices with the tier breakdown, the payment date and the account ending, and courtesy translations where an LP asked. The investor relations manager previews the German pension LP's distribution notice with the German translation beside the English, then releases 212 notices to the investor portal. Release was locked until the signature; the two held LPs are excluded.
The Notice agent does not send: notices release only after the GP CFO signs.
- 10Each quarter
The whole-fund GP clawback test
Clawback agent, then the Chief Compliance OfficerThe Clawback agent tests each main fund that has paid interim carry, each with its parallel funds and AIVs, at the last quarter-end NAV; this fund, with this distribution, shows no exposure. A real estate fund with an American (deal-by-deal) waterfall has paid $14,200,000 of carry against $9,600,000 the whole fund supports. After tax at 41% under §12.6 and $1,894,000 of escrow under §12.4, $820,000 is not covered, so it is escalated to the GP CFO and the CCO with an LPAC note drafted; the CCO accepts the escalation or edits the note.
The Clawback agent does not move or release escrow, and does not contact LPs.