Articles

What can an AI assistant safely do in a NAV review?

It can read the files, run the controls, draft the note and prepare the sign-off. It should not compute in its head, repair a figure, or approve.

In a NAV review, an AI assistant is safe as a preparer that follows a written procedure: it reads the files, fills the inputs of a control workbook, reports the status of each control, drafts a commentary from a table, and prepares the sign-off. The arithmetic is done by formulas or code, and the approval by a person. On the assumptions of our case, that takes a weekly review from 180 to 35 minutes.

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 division of work

Who does what in an automated weekly NAV control.
StepFormulas or codeAssistantPerson
Check the files receivedDate, layout, units, totals
Expected NAV, differences, statusesCompute and compareFills inputs, reads results
Tolerances and thresholdsApplies themSets them
Commentary on a large movementAttribution tableDrafts from the table onlyAdds the evidence
Decision on the fileProposes a codePresents it with the reasonsSigns, or overrides in writing
Message to the administratorDraftsSends

Three rules for figures

Stop rules

A stop rule is a condition under which the assistant hands over without trying to fix anything. In the case there are four: an input file fails a file check; fewer than six controls pass; a figure needed is missing or ambiguous; the reporting pack does not tie. Over four weeks, the second rule fires twice: 3 and 4 controls passed out of six on 19 and 26 March.

Test it before relying on it

Run the process on past periods, with errors planted in copies of the files: a flow booked twice, a fee at an old rate, a file of the wrong date. Count the errors caught and the false alerts. Then run it beside the manual control for several periods. Test again whenever a file layout, the procedure or the tool changes.

Is it worth it?

Time and payback on the assumptions of the case (weekly NAV, four quarterly reports).
LinePer year
Hours saved on the NAV controls125.7
Hours saved on the reports filled from one data pack44
Value of the time, net of the tool cost (EUR)13,222
Setup cost: procedure, tests, training (EUR)3,400
Payback13.4 weeks

These are assumptions to replace with your own measurements. The benefit that the table leaves out is usually larger: a wrong NAV that is not published.

Before the first run

Use only a tool your firm has approved for the data involved. Remove what the control does not need, such as investors' names. Give the assistant the access of a new colleague on one task: it reads the task folders, writes its own outputs, sends nothing. Keep the inputs, the workbook, the minutes and the approval together.

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

Can an AI assistant calculate a fund's NAV?

It should not do the arithmetic itself. Formulas or code compute; the assistant reads files, fills inputs, reports the controls and drafts text; a person approves.

What is a stop rule in an automated control?

A condition under which the assistant must stop and hand over to a person without trying to fix anything, for example fewer than six controls passed.

How do you test an automated NAV review?

On past periods with planted errors, counting errors caught and false alerts, then in parallel with the manual control for several periods.

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 →