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 →
| Step | Formulas or code | Assistant | Person |
|---|---|---|---|
| Check the files received | Date, layout, units, totals | ||
| Expected NAV, differences, statuses | Compute and compare | Fills inputs, reads results | |
| Tolerances and thresholds | Applies them | Sets them | |
| Commentary on a large movement | Attribution table | Drafts from the table only | Adds the evidence |
| Decision on the file | Proposes a code | Presents it with the reasons | Signs, or overrides in writing |
| Message to the administrator | Drafts | Sends |
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.
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.
| Line | Per year |
|---|---|
| Hours saved on the NAV controls | 125.7 |
| Hours saved on the reports filled from one data pack | 44 |
| Value of the time, net of the tool cost (EUR) | 13,222 |
| Setup cost: procedure, tests, training (EUR) | 3,400 |
| Payback | 13.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.
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.
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).
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.
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.
On past periods with planted errors, counting errors caught and false alerts, then in parallel with the manual control for several periods.
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