Three inputs from the fund documents, one multiplication, one tolerance. The control costs a minute and catches an error no other control sees.
Check a management fee accrual by recomputing it from the terms of the fund: the annual rate, the base it applies to, and the day count. Compare your figure with the fee in the administrator's file, within a tolerance. In our case the fee is 1.20% a year of the opening NAV, accrued weekly: EUR 57,534 for the first week. In the fourth week the file uses an old rate of 1.50%; the gap is EUR 14,547, and the published price is one cent too low.
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 →
Fee of the period = annual rate x base x days / 365. For the first week: 1.20% x €250.0m x 7 / 365 = EUR 57,534. In Excel, with the rate, the base and the days in named cells: =rate*base*days/365.
| EUR | 5 Mar | 12 Mar | 19 Mar | 26 Mar |
|---|---|---|---|---|
| Opening NAV (EUR m) | 250.000 | 251.403 | 252.166 | 252.847 |
| Fee expected | 57,534 | 57,857 | 58,033 | 58,189 |
| Fee in the file | 57,534 | 57,857 | 58,033 | 72,737 |
| Difference | 0 | 0 | 0 | 14,547 |
| Control | pass | pass | pass | fail |
The tolerance is EUR 2,000. Three weeks tie to the euro. The fourth is EUR 14,547 above the expected fee.
EUR 14,547 is 0.57 basis points of the NAV. It is enough to move the published price from EUR 104.90 to EUR 104.89, because the price is rounded to the cent. Left in place for a year, the wrong rate would overcharge investors by €0.76m. A fee error does not correct itself: it accrues every period until someone recomputes it.
The balance sheet of the file still balances, the units agree with the transfer agent, and cash agrees with the bank, because an accrual moves no cash. Only a recomputation from the terms, or an expected NAV built independently, shows the gap. In the case the file of the fourth week passes 4 controls out of 6: the fee control and the expected NAV fail together.
The recomputation is a formula: it belongs in the workbook, with the rate, the base and the tolerance in input cells. An assistant is useful one step earlier, to read the fee clause and list the rate, the base, the day count and the dates at which they change, with the page of each. You check that list against the document once, then the formula runs every period.
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).
Annual rate times the fee base times the number of days in the period, divided by the days in the year. The base and the day count are defined in the fund documents.
At every NAV. The check is a single recomputation, and an error in the rate or the base repeats in every period until it is found.
One small enough that an accepted difference cannot change the published NAV per unit. In the worked case it is EUR 2,000 on a weekly fee of about EUR 58,000.
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