The NAV is overstated by almost a million and the published price is correct to the cent. Only a control against an independent source sees it.
When a subscription dealt at the last NAV per unit is booked twice, the fund's cash and its units in issue are both overstated, in the proportion of the price. The NAV per unit, their ratio, does not move. In our case the NAV is overstated by €0.944m and the price reported, EUR 104.96, is exactly the correct one.
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 →
A subscription of N units at price P adds N x P to the NAV and N to the units. If the fund's NAV per unit is P before the subscription, it is still P after: (NAV + N x P) / (units + N) = P. Booking the subscription a second time repeats the same operation. The price is unchanged again.
Lindenmoor Property Income Fund, fictional, receives a subscription of 9.0 thousand units in the week to 19 March 2027, at the last published price of EUR 104.89: €0.944m. The fund accountant books it twice.
| Line | Correct | File received | Difference |
|---|---|---|---|
| Cash (EUR m) | 16.071 | 17.015 | 0.944 |
| Net asset value (EUR m) | 252.847 | 253.791 | 0.944 |
| Units in issue (thousands) | 2,409.0 | 2,418.0 | 9.0 |
| NAV per unit (EUR) | 104.96 | 104.96 | 0.00 |
Three controls fail, and all three use a source the accountant does not control.
Investors dealing that week are not harmed: the price is correct. But the file feeds other documents: units in issue, cash, total assets, the regulatory report, the investor report. And the next week's NAV would start from a wrong opening position. The file is returned, and nothing is published from it.
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).
Not when it is dealt at the current NAV per unit: it adds NAV and units in the same proportion.
By reconciling units in issue with the transfer agent's records, and cash with the bank statement. Checks on the file alone do not see it.
In the worked case, no: the file is returned and corrected first, because other figures in it are wrong and other reports read them.
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