Financial Planning
Quarterly Fund Reports: Reconcile Beginning and Ending NAV
Reconcile a quarterly fund report from opening to closing NAV, separating capital activity, costs, gains and carry movements.
What you will learn
- Build a clear NAV roll-forward from stated inputs.
- Distinguish owner cash activity from investment gains and expenses.
- Find a missing or double-counted line before using the report.
Reconcile a quarterly fund report by rolling beginning NAV through contributions, distributions, income, expenses, gains, losses and carry adjustments. Keep each movement distinct. A closing number that matches is useful only if the scope, classification and valuation date also make sense.
Choose the investor and NAV basis
A total-fund statement and one LP’s capital account are different scopes. Opening and closing NAV must use the same scope and carry basis. ILPA’s reporting definitions distinguish total-fund, GP and LP interests and provide NAV-reconciliation categories. The worksheet below is simplified, not a replacement for a fund’s financial statements.
Work a fictional quarter
Use amounts in millions of US dollars. Opening NAV is $10 million, already net of the carry accrued at the opening date. During the quarter there are $2 million contributions, $0.8 million distributions, $0.2 million fees/expenses, $0.1 million income, $0.4 million realized gain, $0.7 million unrealized gain and an additional $0.1 million carry accrual. No other movement applies.
Original quarterly NAV roll-forward, $M
| Line | Change | Running NAV |
|---|---|---|
| Beginning NAV | Opening | $10.0 |
| Contributions | +$2.0 | $12.0 |
| Distributions | −$0.8 | $11.2 |
| Fees and expenses | −$0.2 | $11.0 |
| Investment income | +$0.1 | $11.1 |
| Realized gain | +$0.4 | $11.5 |
| Unrealized gain | +$0.7 | $12.2 |
| Additional accrued carry | −$0.1 | $12.1 |
The final check is $10 + $2 − $0.8 − $0.2 + $0.1 + $0.4 + $0.7 − $0.1 = $12.1 million. This example treats the listed expenses and carry as incremental movements, not amounts already deducted elsewhere.
Separate capital movement from economic change
Net contributions are $2M − $0.8M = $1.2M. The remaining $0.9M increase comes from income, gains, expenses and additional carry. Ending NAV is not an investment return by itself: adding contributions is not performance.
The ILPA reporting guidance uses the NAV roll to give context to fees, expenses and capital activity. Keep the contribution/distribution source rows available so an apparent change in returns is not simply a change in investor capital.
Look for the common double count
Issue-spotting checks
| Mismatch | What to inspect |
|---|---|
| Carry deducted twice | Was opening NAV already net? Is this only the period movement? |
| Sale proceeds treated as gain | Separate cost recovery, realized gain and retained cash. |
| Distribution also subtracted from investment value incorrectly | Trace the asset-to-cash-to-LP sequence. |
| Unexplained opening difference | Check scope, prior close version and later adjustments. |
| Cash flow missing from the roll | Inspect noncash, netted, transfer and FX categories. |
Do not insert an “other” amount merely to force agreement. Label the unresolved difference and return it to the administrator with an event reference.
Copy your reconciliation sheet
Quarterly capital-account check
Fund or LP scope / currency / quarter: [ ]
Opening NAV / prior approved report / carry basis: [ ]
Contributions / distributions / cash vs noncash: [ ]
Income / expenses / realized and unrealized gains: [ ]
Carry movement / FX / transfers / other identified items: [ ]
Calculated ending NAV / reported ending NAV: [ ]
Difference / exact evidence question / owner: [ ]
Valuation date / method changes / review status: [ ]Keep the report and next question together
A useful follow-up points to the exact line and expected bridge, rather than saying that the NAV “looks wrong.” Use Finta’s LP follow-up workflow to organize approved reports and questions. The administrator and finance reviewers remain responsible for the underlying capital accounts.
About this lesson. By Finta Editorial Team. Sources reviewed November 14, 2026. All example amounts, entities and outcomes are fictional teaching inputs, not observed fund performance. General education, not legal, tax, accounting or investment advice. Use qualified advisers and the governing documents for an actual fund.