managing-fund-reporting

# Managing Fund Reporting

Structures LP fund reporting with NAV calculation, performance attribution, and portfolio updates for limited partners across PE, VC, and growth equity funds.

## When To Use

- Preparing quarterly or annual LP reports with fund-level and portfolio-level performance data
- Calculating or validating Net Asset Value (NAV) for a reporting period
- Building performance attribution analysis (gross/net IRR, TVPI, DPI, RVPI)
- Drafting portfolio company updates with operational and financial KPIs
- Responding to ad hoc LP data requests or ILPA-template reporting obligations
- Consolidating data across co-investment vehicles or parallel fund structures

## Inputs To Gather

- **Fund terms**: LPA-defined management fee structure, carried interest waterfall, preferred return, GP commitment percentage
- **Capital account data**: Cumulative capital calls, distributions, recallable amounts, and unfunded commitments per LP
- **Portfolio company financials**: Revenue, EBITDA, net income, cash position, debt levels, and any board-approved projections
- **Valuation marks**: Most recent fair value estimates per ASC 820 / IFRS 13, valuation methodology used (comparable transactions, DCF, market multiples), and date of last third-party valuation [VERIFY jurisdiction-specific fair value standards]
- **Cash flow schedule**: Drawdowns, distributions (return of capital vs. gain), and recycling activity during the period
- **Fee and expense detail**: Management fees accrued/paid, fund-level expenses, organizational costs amortization, broken-deal costs
- **Benchmark data**: Target benchmark indices (Cambridge Associates, Preqin, public market equivalent) for comparative context

## Workflow

1. **Validate source data**
   - Reconcile the trial balance and capital account statements from the fund administrator
   - Confirm all portfolio company valuations have been updated for the reporting period
   - Cross-check cash flow waterfall inputs against bank statements and call/distribution notices
   - Flag any stale valuations (>90 days old) or missing data points with [VERIFY]

2. **Calculate NAV**
   - Start with prior-period NAV, add capital called, subtract distributions, apply unrealized gain/loss adjustments
   - Deduct accrued management fees, fund expenses, and carried interest accrual per the waterfall
   - Reconcile ending NAV to the administrator's statement; investigate variances >0.5%
   - For multi-currency funds, document FX rates used and hedging adjustments

3. **Compute performance metrics**
   - **Gross IRR / Net IRR**: Use actual cash flow dates; specify whether SI-IRR or pooled methodology is applied
   - **TVPI** (Total Value to Paid-In): (NAV + cumulative distributions) / cumulative contributions
   - **DPI** (Distributions to Paid-In): Cumulative distributions / cumulative contributions
   - **RVPI** (Residual Value to Paid-In): NAV / cumulative contributions
   - **PME** (Public Market Equivalent): Calculate Kaplan-Schoar or Direct Alpha against the stated benchmark [VERIFY LP-agreed benchmark index]
   - Present since-inception, trailing 1-year, and current-quarter figures

4. **Build performance attribution**
   - Break down portfolio-level returns by investment vintage, sector, geography, and deal size
   - Identify top/bottom contributors to gross return with realized vs. unrealized splits
   - Include write-ups/write-downs with brief explanatory notes (e.g., new financing round, revenue miss, multiple expansion)

5. **Draft portfolio company updates**
   - For each active holding: investment date, cost basis, current fair value, ownership %, and board representation
   - Key operating metrics: revenue growth, EBITDA margin, customer/user counts, headcount, LTM trends
   - Material events: new rounds, management changes, M&A activity, regulatory developments
   - Expected hold period and path to exit (IPO pipeline, sponsor-to-sponsor, strategic)

6. **Assemble the LP report**
   - Cover letter from GP summarizing fund activity, market conditions, and outlook
   - Fund summary table: committed capital, drawn, distributed, NAV, net IRR, TVPI, DPI
   - Capital account statement per LP (or representative LP schedule)
   - Portfolio summary with individual company pages
   - Fee and expense disclosure
   - ESG / DEI reporting section if required by side letter or ILPA guidelines [VERIFY LP-specific reporting obligations]

## Output

- **Quarterly/Annual LP Report** formatted to ILPA Reporting Template standards or GP's custom template, including:
  - Fund-level financial summary and performance table
  - Individual capital account statements
  - Portfolio company detail pages with KPIs and valuation bridge
  - Cash flow summary (calls, distributions, net cash flow)
  - Fee and expense schedule
  - Benchmark comparison chart
- All figures should tie to the fund administrator's NAV statement with variance explanations for any differences

## Quality Checks

- NAV reconciliation: Ending NAV matches administrator statement within acceptable tolerance; all variances documented
- IRR validation: Cash flow dates are accurate, no duplicate entries, and IRR calculation converges (check for multiple IRR scenarios on unusual cash flow patterns)
- TVPI / DPI / RVPI arithmetic cross-checks: TVPI = DPI + RVPI
- Valuation support: Every portfolio company mark has a documented methodology and is no more than one quarter stale
- Waterfall accuracy: Carried interest and preferred return calculations follow LPA terms exactly [VERIFY specific waterfall structure — American vs. European style]
- Consistency: All figures in the report (cover letter, tables, capital accounts, portfolio pages) are internally consistent with no conflicting numbers
- Disclosure completeness: Side letter reporting obligations, ILPA best practices, and any regulatory requirements (e.g., Form PF data points) are addressed [VERIFY applicable regulatory filings]