Producing the ILPA Performance Template: 5 steps to delivery

Download the ILPA Performance Template v1.1 from the ILPA templates hub. Choose the granular methodology if you can itemise fund-to-investor cash flows, or the gross-up methodology if you work from aggregates. Map every capital call and distribution to the template's transaction types, populate fund-level net IRR and TVPI with and without the subscription facility, and deliver in Excel. A Q1 2026 fund's first delivery is due in Q1 2027, four full quarters after operations begin.
Before you start
ILPA released the Performance Template on January 22, 2025, alongside the updated Reporting Template v2.0. It is a wholly new template with no predecessor. Version 1.1 arrived on April 28, 2025, updated to reflect two SEC Marketing Rule FAQs published in March 2025.
The Performance Template applies only to funds commencing operations on or after January 1, 2026. Legacy funds are excluded. The first delivery is due four full quarters after the fund begins operating: a fund that starts in Q1 2026 delivers its first template in Q1 2027. After the first delivery, ILPA's framework is quarterly: 60 days after quarter end for direct funds, 120 days for fund-of-funds and 180 days for fund-of-fund-of-funds.
The Reporting Template handles fees, expenses and carried interest. The Performance Template handles performance metrics: IRR, TVPI, DPI, RVPI and MOIC. The two templates are designed to be delivered together. The Capital Call and Distribution Template, refreshed in September 2025 with a transaction type mapping spreadsheet, aligns its classifications to both.
Timeline: from the template's release to the first delivery
The Performance Template applies to funds commencing January 1, 2026 or later. Legacy funds are excluded.
- 1Jan 2025Template releasedVersion 1.0, January 22
- 2Apr 2025v1.1 updateSEC Marketing Rule FAQs
- 3Sep 2025Transaction mapping publishedCapital Call and Distribution alignment
- 4Jan 2026Data capture beginsFunds commencing Q1 2026
- 5Jan 2027First delivery dueFour full quarters after fund start
Step 1: Choose your methodology
The template offers two tracks. You choose one for the life of the fund.
Granular methodology. You itemise every fund-to-investor cash flow. Each capital call is classified by utilisation: investment, management fee, expense, or carried interest. Only investment-related transactions feed the gross performance calculation. This method gives LPs full visibility into which dollars went where, but it requires your ledger and your administrator to tag every call at the line-item level.
Gross-up methodology. You work from aggregate fund-to-investment cash flows and adjust quarterly for fees, expenses and performance-based compensation. The gross figure is reconstructed by adding back the deductions rather than by tracking each call's purpose. This is the path for funds that cannot or do not itemise individual capital calls.
Both methods produce the same output tables. Both require subscription facility side-by-sides: every metric shown with and without the facility.
Granular or gross-up: the one decision that shapes the template
Choose one methodology for the fund's life. Both produce levered and unlevered figures.
Step 2: Classify transaction types
The template uses a standardised set of transaction type codes for capital calls and distributions. ILPA published a mapping spreadsheet in September 2025 that aligns the Capital Call and Distribution Template's classifications with the Performance Template's cash-flow categories.
Map your existing call and distribution notices to these types. Every capital call must resolve to one of the template's utilisation categories: investment capital, management fees, partnership expenses, organisational expenses, or carried interest. Every distribution must classify as return of capital, realised gain, carried interest payment, or recallable distribution.
If you use an outside administrator, agree on the classification with them before the first quarter closes. A transaction mapped differently in your records and the administrator's will produce different IRR figures. The classification is not revisable after the fact without restating the template.
Step 3: Build the fund performance table
This table reports performance between the fund and all fee-paying LPs in aggregate. The required metrics:
- Net levered investor IRR: since inception, reflecting the subscription facility
- Net unlevered investor IRR: since inception, stripping out the facility's timing effect
- Net TVPI: distributions plus residual value, divided by paid-in capital, net of all fees and expenses
ILPA recommends (but does not require) gross levered and unlevered investor IRR and gross MOIC at the fund level. DPI and RVPI are included as point-in-time multiples.
All IRR figures are since-inception, money-weighted. The template does not use time-weighted return. Every metric appears twice: once with the subscription facility and once without. The unlevered column shows LPs what the return would be if every call had been funded by LP capital on the draw date rather than by the credit line.
Step 4: Build the portfolio performance table
This table reports performance between the fund and its portfolio investments. It breaks out:
- Gross investment IRR and MOIC: the return on deployed capital before fees, for realised investments, unrealised investments and the total portfolio
- Net investment IRR and MOIC: the same, after deducting the fees and expenses allocated to each investment
The portfolio table is where the granular and gross-up methodologies diverge. Under granular, the inputs are the actual fund-to-investment cash flows tagged at the line-item level. Under gross-up, the inputs are the aggregate cash flows adjusted quarterly for fees, expenses and performance-based compensation.
Realised, unrealised and total columns must reconcile. The sum of the realised and unrealised portfolios, weighted by their shares, must produce the total portfolio figure. An LP who sees a total that does not match the parts will ask.
Step 5: Reconcile, review and deliver
Run the subscription facility side-by-side before anything else. The "with facility" column uses the actual call dates and amounts. The "without facility" column restates each call as if the LP had funded it on the draw date at the full amount. The two columns isolate how much of the IRR is explained by the facility's timing.
Cross-check the fund performance table against the capital account statement. Paid-in capital, distributions and residual value in the performance template must match the capital account to the dollar.
Cross-check the portfolio table against the schedule of investments. Invested cost, fair value and realised proceeds must agree.
Deliver in Excel through the LP portal, alongside the ILPA Reporting Template v2.0 and the quarterly narrative letter. ILPA recommends against PDF. The first delivery covers inception to date; after that, each quarter adds one period.
What goes wrong
- Methodology chosen late. Both tracks require different data from the first capital call. Choosing at Q4 means reconstructing a year of cash-flow classifications. Decide before the fund's first close.
- Transaction types not mapped. A capital call that funds both an investment and a management fee must be split into two transaction lines. Administrators who receive a single-line call cannot classify it. Tag each call at the notice.
- Subscription facility not modelled without. Stripping the facility requires knowing what the LP draw dates and amounts would have been. If the credit line was drawn before any LP was called, you need the hypothetical call schedule. Build the model from the first drawdown.
- Portfolio table does not reconcile. The sum of realised and unrealised must produce the total. Rounding differences of more than a basis point in the IRR or a cent in the MOIC will prompt questions.
- Delivered as PDF. LPs feed the template into portfolio management systems. A PDF cannot be ingested. Deliver in Excel.
- First delivery missed. Four full quarters passes faster than it sounds. A fund that commenced January 1, 2026 owes its first template by the end of May 2027 (60 days after Q1 2027). Start building the tables in Q3 2026, not Q1 2027.
Frequently asked questions
Which funds need the ILPA Performance Template?
What is the difference between the granular and gross-up methodologies?
When is the first Performance Template due?
Do I need the Performance Template if I already produce the Reporting Template?
Does the template require gross IRR?
How does the subscription facility side-by-side work?
Sources
- ILPA templates hub (Reporting, Performance and Capital Call templates, 2025)ilpa.org/industry-guidance/templates-standards-model-documents/ilpa-templates-hub/
- ILPA release announcing the updated templates, January 22, 2025ilpa.org/news/ilpa-releases-updated-reporting-template-and-new-performance-template-for-industry-adoption/
- ILPA Performance Template Gross Up Methodology v1.1 (April 28, 2025)ilpa.org/resources-tools/resource-library/ilpa-performance-template-gross-up-methodology-v-1-1/
- ILPA Performance Template Suggested Guidance, Granular Methodology (January 2025)ilpa.org/wp-content/uploads/2025/01/ILPA-Performance-Template-Suggested-Guidance-Granular-Methodology.pdf
- ILPA Capital Call and Distribution Transaction Type Mapping (September 2025)ilpa.org/wp-content/uploads/2025/09/ILPA-CCD-Transaction-Type-Mapping-to-Performance-Template.xlsx
- ILPA: outcomes from the comment period (adoption figures)ilpa.org/news/outcomes-from-comment-period/
Terms used in this article
- IRR (internal rate of return) IRR, internal rate of return, is the annualised discount rate at which the present value of all capital contributions to a fund equals the present value of all distributions plus the residual net asset value.
- TVPI (total value to paid-in capital) TVPI, total value to paid-in capital, is the sum of distributions to limited partners and the current net asset value of the fund, divided by the capital LPs have contributed.
- DPI (distributions to paid-in capital) DPI, distributions to paid-in capital, is the total cash and stock distributed to limited partners divided by the total capital they have contributed.
- RVPI (residual value to paid-in capital) RVPI, residual value to paid-in capital, is the current net asset value of a fund's remaining holdings divided by the capital limited partners have contributed.
- ILPA Reporting Template The ILPA Reporting Template is a standardised quarterly schedule, published by the Institutional Limited Partners Association, in which a fund breaks out management fees, partnership expenses, fee offsets and carried interest for each limited partner, quarter to date, year to date and since inception.
- Subscription line (capital call facility) A subscription line is a revolving credit facility, secured on the limited partners' uncalled commitments and the general partner's right to call them, that a fund draws to pay for investments and expenses before calling capital from LPs and repays from the later capital call.
- LP portal (investor portal) An LP portal, or investor portal, is the secure website where a fund's limited partners log in to view their capital account statements, capital call and distribution notices, quarterly reports, tax documents and fund legal documents, replacing email and PDF distribution.
- Capital account statement A capital account statement is the periodic report, usually quarterly, that shows a single limited partner the movement in their capital account over the period: opening balance, contributions, allocated income, gains and losses, management fees and expenses, distributions, and closing balance, alongside their commitment and unfunded commitment.
- Gross versus net returns Gross versus net returns is the distinction between performance measured on a fund's investments before management fees, partnership expenses and carried interest, and performance measured on the cash limited partners actually paid in and received after those costs.
- Carried interest Carried interest is the general partner's share of a fund's profits, typically 20%, paid through the distribution waterfall only after limited partners have received their contributed capital and, usually, a preferred return.
- Management fee The management fee is an annual charge paid by the fund to the management company, typically 2% of committed capital during the investment period, often stepping down afterwards to a lower rate or a basis of invested capital, to cover salaries, rent and the cost of running the firm.
- Fund administrator A fund administrator is the firm, or the software operated in-house, that maintains a private fund's books: partner capital accounts, capital call and distribution processing, fee and waterfall calculations, NAV, investor statements and audit support.
For people actually running a fund
One operating problem a week: capital calls, K-1s, LP reporting, waterfall math, onboarding. Every Tuesday. Free.