Articles

How do you review a NAV file from a fund administrator?

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 →

The six controls

Controls on a weekly NAV file and their sources.
ControlCompared withTolerance in the case
1. Balance sheet less NAV reportedThe file itselfEUR 5,000
2. Units in issueOpening units and the transfer agent's flowsnil
3. NAV per unitNAV and units of the file, recomputedhalf a cent
4. Management feeThe terms of the fundEUR 2,000
5. CashThe bank statementEUR 5,000
6. NAV reportedThe NAV expected by roll-forwardEUR 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.

The expected NAV

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.

Four weeks

Lindenmoor Property Income Fund (fictional), status of the six controls on four weekly NAV files, March 2027.
Control5 Mar12 Mar19 Mar26 Mar
1. Balance sheetpasspasspasspass
2. Unitspasspassfailpass
3. NAV per unit recomputedpasspasspasspass
4. Management feepasspasspassfail
5. Cashpasspassfailpass
6. Expected NAVpasspassfailfail
Controls passed6 of 66 of 63 of 64 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.

What to do with a failed control

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.

Sources

  1. Julian R. Sterling, Automate a Fund Reporting with AI (video course, 2026): running case Lindenmoor Property Income Fund
  2. Directive 2011/61/EU (AIFMD), Article 19; Commission Delegated Regulation (EU) No 231/2013, Articles 67 to 74 (valuation and calculation of the net asset value)
  3. Regulation (EU) 2016/679 (GDPR), Article 5 (data minimisation); NIST AI Risk Management Framework 1.0 (2023)

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.

Build the whole control pack, step by step

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).

Watch module 1 free →

Questions readers ask

Which controls should a manager run on a NAV received from an administrator?

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.

What tolerance should a NAV control use?

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.

Is recomputing the NAV per unit enough?

No. It proves that the file is consistent with itself. An error that inflates the NAV and the units together leaves the price unchanged.

Read the whole case

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

Also on this site

All 2164 articles →