Articles

How do you check a management fee accrual in a NAV?

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 →

The formula

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.

Four weeks

Lindenmoor Property Income Fund (fictional), weekly management fee, March 2027.
EUR5 Mar12 Mar19 Mar26 Mar
Opening NAV (EUR m)250.000251.403252.166252.847
Fee expected57,53457,85758,03358,189
Fee in the file57,53457,85758,03372,737
Difference00014,547
Controlpasspasspassfail

The tolerance is EUR 2,000. Three weeks tie to the euro. The fourth is EUR 14,547 above the expected fee.

Why a small gap matters

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 three inputs, and where they go wrong

Why no other control finds 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.

What to hand to an AI assistant

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.

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 on valuation; Commission Delegated Regulation (EU) No 231/2013, articles 67 to 74
  3. Time, cost and frequency figures are assumptions of the worked case, not measurements

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

How is a management fee accrual calculated?

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.

How often should a management fee accrual be checked?

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.

What tolerance applies to a fee control?

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.

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 2221 articles →