Six controls, each against a source the administrator does not control, each with a tolerance. Two of four files fail, and one of them shows the right price.
A manager who delegates the calculation of the NAV still answers for it. A review that proves something rests on a few controls: each compares a figure of the file with an independent source, within a tolerance set in advance. Six are enough for a simple fund. In our case they return two files out of four, including one whose NAV per unit was exactly right.
The case comes from the Automate a Fund Reporting with AI course by Julian R. Sterling, author of The Private Equity Fund Controller Playbook.Get the DRM-free PDF, $19.99 →
| Control | Compared with | Tolerance in the case |
|---|---|---|
| 1. Balance sheet less NAV reported | The file itself | EUR 5,000 |
| 2. Units in issue | Opening units and the transfer agent's flows | nil |
| 3. NAV per unit | NAV and units of the file, recomputed | half a cent |
| 4. Management fee | The terms of the fund | EUR 2,000 |
| 5. Cash | The bank statement | EUR 5,000 |
| 6. NAV reported | The NAV expected by roll-forward | EUR 5,000 |
Controls 1 and 3 test the file against itself: they prove arithmetic. Controls 2, 4, 5 and 6 use outside sources: they are the ones that find errors.
Control 6 needs a figure of your own. Start from the last NAV you validated, add subscriptions and deduct redemptions at the last published price, add the income received and the change in value of the investments, deduct the fee. For Lindenmoor Property Income Fund, fictional, the opening NAV of €250.0m gives €251.403m on 5 March 2027.
| Control | 5 Mar | 12 Mar | 19 Mar | 26 Mar |
|---|---|---|---|---|
| 1. Balance sheet | pass | pass | pass | pass |
| 2. Units | pass | pass | fail | pass |
| 3. NAV per unit recomputed | pass | pass | pass | pass |
| 4. Management fee | pass | pass | pass | fail |
| 5. Cash | pass | pass | fail | pass |
| 6. Expected NAV | pass | pass | fail | fail |
| Controls passed | 6 of 6 | 6 of 6 | 3 of 6 | 4 of 6 |
On 19 March the accountant booked the week's subscription twice. Units are 9.0 thousand too high, cash is €0.944m above the bank balance, and the NAV is overstated by the same amount. The reported price, EUR 104.96, is correct: NAV and units are inflated together.
On 26 March the fee was accrued at an old rate. The gap is EUR 14,547, and the price is EUR 104.89 instead of EUR 104.90.
Decide before the file arrives. In the case, fewer than six controls passed means the file goes back to the administrator, with the failed controls, the two figures compared and the difference. Nothing is published from a returned file, even a price that looks right. A manager may override a failed control, in writing, with the reason.
Every figure is computed by script from the course's running case, Lindenmoor Property Income Fund, a fictional fund, and checked on 19 November 2026. Tolerances, thresholds, times and costs are assumptions of the case, and the errors in the files are planted for the course. For education, not legal or regulatory advice.
26 short video lessons on handing a recurring fund report to an AI assistant without losing control: expected NAV, six controls with tolerances, attribution, sign-off and minutes, a reporting data pack, the written procedure and the tests. You build the control pack of a weekly NAV in Excel, with step files, exercises, a prompt kit and a certificate exam ($149).
At least: the balance sheet against the NAV, units against the transfer agent, the NAV per unit recomputed, fees against the terms of the fund, cash against the bank, and the NAV against an independent roll-forward.
One sized to the published figure: small enough that an accepted difference cannot change the NAV per unit, large enough that rounding does not trigger alerts. It is set in advance, with an owner.
No. It proves that the file is consistent with itself. An error that inflates the NAV and the units together leaves the price unchanged.
This article is one calculation from The Private Equity Fund Controller Playbook. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.
See the course →Free companion files
Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada
Prefer a PDF? The same book is sold as a DRM-free PDF edition, searchable and printable. Get the PDF edition, $19.99