Perspectives · Oversight
Six Fund Admins, One Certified NAV: Where Sign-Off Breaks
Six fund administrators, six NAV packs, one controller and a deadline. Where sign-off breaks at lean private markets firms, and what a certified NAV takes.
· 5 min read
Part of the guide Private Markets Fund Data: Common Problems and How to Fix Them
Why sign-off breaks at a lean firm
If your firm runs between $500 million and $10 billion with a three or four person back office, you know the pattern. Each fund administrator sends its NAV pack in a different layout, on a different day, in a different format. One sends a PDF with the trial balance buried on page nine. Another sends an Excel workbook whose tab names change each quarter. A third emails a summary schedule. One controller consolidates all of them in a spreadsheet against a sign-off deadline that does not move.
Firms use multiple administrators for good reasons. Different fund structures sit in different jurisdictions. Private credit, real estate, and venture funds each have their own administrator with their own reporting conventions. But the consolidation falls on you, and the logic for multi-administrator reconciliation against internal books lives in one person's head. There are no written tolerances and no audit trail. When that person is out, the NAV sign-off process stalls. When they leave, the knowledge leaves with them.
Valuation cadence is compressing at the same time. Evergreen and semi-liquid vehicles push valuations toward monthly or daily. The SEC adopted Rule 2a-5 in December 2020, requiring funds to assess and manage material valuation risks and oversee pricing services. The UK FCA published its review of private market valuation practices in 2025, identifying areas where firms should improve independence, expertise, and consistency in valuations. Checks that barely fit a quarter now have to happen in days with the same three people.
When that person leaves, the firm doesn't just lose a headcount. It loses the checklist nobody wrote.
An illustrative scenario
Illustrative scenario, not an account of an actual client engagement.
A firm runs a master fund with two feeder funds. Administrator A handles Feeder 1. Administrator B handles Feeder 2. Each administrator's pack balances to zero on its own. The controller signs off on both feeders and rolls them up to the master NAV.
But Administrator A booked a PIK interest rate amendment this quarter. Administrator B did not. The amendment changes the accrual on a single position. Each feeder still balances to zero because the adjustment is internal to each fund. The gap only appears where the two feeders meet in the master NAV, a roughly $340,000 difference that sits under the aggregate tolerance.
A single-position escalation rule catches it. The aggregate is under tolerance, but the position-level dollar floor triggers a review. Without that rule, the gap rolls forward undetected into the next cycle. In private credit NAV reconciliation, this is how silent breaks compound across quarters and surface months later as restatements.
What a governed process looks like
The fixes below cost discipline, not money. You can start most of them before you evaluate any platform.
One tracked workflow shows what is expected, arrived, checked, and open. Replace the spreadsheet with a single view of every administrator pack and its status, so nothing sits in an inbox waiting to be noticed.
Written rules with materiality thresholds replace tribal knowledge. Tier your tolerances by fund and administrator, and set single-position dollar floors that escalate even when the aggregate is under tolerance.
Roles and sign-off with an audit trail make the process defensible. Assign preparer, reviewer, and approver roles. Log every sign-off with a name and timestamp so you can reconstruct who checked what and when.
Administrator scoring against SLAs turns a one-sided relationship into a managed one. Track which administrator delivers on time, which sends clean packs, and which requires rework.
Automate last, not first. Build the rules, agree on the tolerances, and establish the workflow. Then automate the comparison. Automation without rules just speeds up the wrong answer.
What to evaluate for
If you are evaluating how to move beyond spreadsheets for fund administrator oversight, look for a platform that puts every administrator's pack into one governed model without re-keying. Aquata's NAV Oversight use case ingests whatever the administrator sends, whether PDF, Excel, or flat file, maps each pack to your chart of accounts, and lets your fund accountants write the validation logic as explicit data quality rules. Materiality thresholds are tiered by fund and administrator, including single-position dollar floors that escalate even when the aggregate is under tolerance. One tracked workflow shows what is expected, arrived, checked, and open, with preparer, reviewer, and approver roles and every sign-off logged with a name and timestamp. Administrators are scored against SLAs. Automation of the comparison comes last, once the rules exist.
No data engineer or ticket queue is required. Most firms start with NAV oversight and prove it in a quarter. The goal is to transform fragmented data into action today, with a foundation that makes all your investment data accessible, actionable, and AI-ready as you grow and take on new vehicles. Your back office can certify the NAV with confidence instead of scrambling against a deadline that does not move.
