River
Y CombinatorBacked by Y Combinator
FREE TEMPLATE

Quarterly LP Reporting Template

The return your LPs saw and the return the same portfolio would have made without the credit line are 421 basis points apart. Both are correct.

Free download  ·  No account needed

A subscription facility shortens the time LP capital is outstanding, and internal rate of return is a function of time. So the same portfolio, with the same valuations and the same fees, produces one IRR on the cash flows your investors actually saw and a different one if every call is restated to the day you funded the deal. The gap is a financing decision rather than an investment result, and it is large enough to move a fund between quartiles.

Most GPs assume the line always flatters the number. In the worked example it does not. At the first year end the facility made the reported IRR worse by 2,123 basis points, because it was charging interest against a portfolio still carried at cost while deferring the capital that would have been earning the return. By the second year end the usual direction had reasserted itself. ILPA's own guidance notes the effect is largest early and never equal to an unlevered IRR, and which way it cuts is not predictable from the facility terms.

From 1 January 2026 the ILPA Performance Template applies to new funds and makes reporting both bases the standard. The catch is that the without-facility figure is only derivable if every call recorded, at the time, what its draw paid for. This pack puts that column first, then rolls the accounts forward the way a balance sheet substantiation pack does, and feeds the quarterly LP letter.

One portfolio, two sets of numbers, and the column that makes both derivable

The four sheets the quarterly package is assembled from.

Performance Metrics

Illustrative, for a fictional $150m 2024-vintage fund with a $45m subscription line bridging each investment 120 days. Same portfolio, same valuations, same fees. Only the LP-level call timing differs.

MetricAs atWith facilityWithout facilityDifference
Net IRR2024-12-31-29.73%-8.50%-2123 bps
Net IRR2025-12-3117.72%14.44%328 bps
Net IRR2026-06-3023.73%19.52%421 bps
TVPI2024-12-310.9211x0.9611x-400 bps
TVPI2025-12-311.1492x1.1488x3 bps
TVPI2026-06-301.2440x1.2719x-280 bps

The sign reverses. At the first year end the facility made the reported IRR worse by 2,123 basis points, charging interest against a portfolio still held at cost while deferring the capital that would have been earning the return. At 31 December 2025 the two figures straddle the vintage's 17.50% top-quartile break. And at June the rate and the multiple disagree: +421 bps on the IRR, -280 on TVPI, because interest and fees enlarge paid-in capital without adding value.

Capital Call Register

The first sheet in the pack, ahead of the capital accounts it feeds. Whether a call was funded off the line, and what the draw paid for, is recorded at the moment of the call or lost.

CallPurposeAmountOff lineDays outSource recordedRestatable
CC-01Halvorsen Instruments18,400,000Yes120YesYes
CC-02Pentland Diagnostics21,250,000Yes120YesYes
CC-03Ashgrove Controls15,900,000Yes120YesYes
CC-04Merrilees Aerospace24,700,000Yes120NoNo
CC-05Tarbolton Water12,300,000Yes120YesYes
CC-06Kirkhope Analytics19,800,000Yes120NoNo
CC-07Drumsheugh Foods16,600,000No0YesYes

Two of the seven investment calls carry no funding source, covering $44.5m of $128.95m invested, or 34.5% of cost. The without-facility figure across those two rests on an assumed 120-day bridge rather than a record, and the methodology note says so. Recovering it means going back to the lender's drawdown statements and re-deriving what each draw paid for. Fee calls are in the register too, so its total ties to paid-in capital.

Capital Account Statements

Rolled forward per LP rather than recomputed, so this quarter can be reconciled to the last one. Allocated on commitment percentage, to the cent, with the rounding residual placed by a stated convention.

LPInvestorCommitment%CalledUnfundedDistributionsBank
LP-01Kirkcaldy Universities Endowme40,000,00026.67%37,000,2902,999,7106,613,333Yes
LP-02Brechin Mutual Assurance32,500,00021.67%30,062,7352,437,2655,373,333Yes
LP-03Auchterarder Family Office22,000,00014.67%20,350,1591,649,8413,637,333Yes
LP-04Strathblane Pension Scheme28,500,00019.00%26,362,7062,137,2944,712,000Yes
LP-05Craigmillar Foundation15,000,00010.00%13,875,1091,124,8912,480,000Yes
LP-06GP Commitment (Ardenmoor Partn12,000,0008.00%11,100,087899,9131,984,000Yes
TOTALS6 investors150,000,000100.00%138,751,08611,248,91424,800,000All 6 agree to the

The reconciliation runs both ways, because the two records that agree are usually the two produced from the same source. Register total against paid-in capital across all accounts, and each LP's called-to-date against the wires actually received in their name. An account that does not tie is named, never plugged. The GP commitment gets a statement like any other.

Statement of Investments

A valuation basis per position, not one for the fund. Stating a single fund-level basis hides that some positions are marked on comparables reviewed quarterly and others are sitting at cost.

PositionCostRealisedValueGross MOICValuation basis
Halvorsen Instruments18,400,000033,600,0001.83xComparable company multiples, quarter...
Pentland Diagnostics21,250,000029,400,0001.38xComparable company multiples, quarter...
Ashgrove Controls15,900,00024,800,00001.56xRealised, exit consideration received
Merrilees Aerospace24,700,000031,800,0001.29xComparable company multiples, quarter...
Tarbolton Water12,300,000010,950,0000.89xComparable company multiples, quarter...
Kirkhope Analytics19,800,000024,600,0001.24xComparable company multiples, quarter...
Drumsheugh Foods16,600,000017,450,0001.05xComparable company multiples, quarter...
TOTALS128,950,00024,800,000147,800,0001.34xGross of fees, expenses and carry; se...

Held at cost is a statement about evidence, not value: nothing has happened since funding that would justify moving the mark. The gross 1.34x is before fees, expenses and carry, so it does not reconcile to the 1.244x net multiple and the review says so rather than leaving a reader to assume it should. Nothing here is ranked by multiple, because that ranks by holding period as much as by performance.

What is in the pack

01

Capital Call Register

One row per call with its purpose named specifically, whether it was funded off the line, days outstanding, and whether it can still be restated. Populated from the call notice that went out, which is where the funding source and the allocation basis were decided

02

Performance Metrics

Net IRR, TVPI, DPI and RVPI on both bases, each row carrying the calculation in a sentence and the record its inputs came from

03

Capital Account Statements

Rolled forward per LP and reconciled to the bank in both directions, with each investor's share of the outstanding facility balance

04

Statement of Investments

Cost, proceeds, current value and gross multiple per position, each carrying its own valuation basis rather than one for the fund. A track record pack carries the same list across every vintage, write-offs included, for a fundraise rather than one quarter

05

How Every Figure Is Calculated

The methodology note that ships inside the package, including what is not derivable from the record and the share of cost that affects

06

Quarterly LP Letter

Both figures in the first paragraph, realisations before marks, and markdowns given more words than mark ups rather than fewer

07

Portfolio Review

One section per position separating the marks that moved because a company traded from the marks that moved because a comparable set repriced

08

Reporting Cycle Sweep

Runs weekly against the deadlines in your LPA and side letters, which are a date per LP, and flags any call that closed without its funding source

How it works

  1. 1

    Send the documents

    The LPA and side letters, the commitment schedule, whatever your administrator produces, the facility statements, and last quarter's package.

  2. 2

    Build the register first

    Every call gets its purpose named and an honest yes or no on funding source. Some historical calls come back no, and that is a finding rather than a failure.

  3. 3

    Reconcile, then compute twice

    Accounts roll forward per LP and tie to the bank both ways. Then performance runs on the cash flows LPs saw and on the restated ones.

  4. 4

    Assemble against the real deadline

    Which is a set of dates, since side letters modify the LPA per investor. Every figure in the letter has to exist in a sheet first.

Frequently asked questions

Which IRR is the real one?

Neither, and that is the point. One answers what return your investors experienced on the capital they actually parted with. The other answers what the portfolio produced independent of how it was financed. An LP comparing you to another manager needs the second; an LP computing their own realised return needs the first.

Do I have to report both?

For funds commencing operations on or after 1 January 2026 the ILPA Performance Template makes net IRR and TVPI on both bases the standard, with the gross equivalents optional. Separately, the marketing rule already requires any gross figure shown to a prospective investor to be accompanied by net, at equal prominence and on the same methodology.

Why does the multiple move the other way?

Because facility interest and unused-line fees are real money the fund pays. They enlarge paid-in capital without adding value, so the denominator of every multiple grows. In the worked example the facility improves the IRR by 421 basis points and worsens TVPI by 280 at the same reporting date.

What if we never recorded which calls used the line?

Then the without-facility figure for those calls is not derivable from the record, and the pack says so rather than quietly assuming a bridge period. Name the calls, name the share of invested cost, and give the route, which is the lender's drawdown statements. Two of seven calls in the example, 34.5 per cent of cost.

Does this replace our fund administrator?

No. It reconciles to the administrator and reports the differences rather than becoming a second set of books. It does not value positions either; it takes what your valuation process produces and makes each position's basis explicit, which a single fund-level basis hides.

What about the audit and the annual meeting?

The methodology note and per-position valuation basis are most of what an auditor asks for, and assembling them quarterly is what stops the request arriving cold. Pair it with an audit confirmation tracker for the confirmations, and the deck outline covers the meeting.

We are raising. Does this help?

The track record an LP interrogates is this data on a longer horizon, and inconsistency between what you reported quarterly and what appears in the deck is what diligence finds. A pitch deck analysis reads the deck the way an LP will, and a diligence response pack keeps every prospect's DDQ answers consistent with it.

Find out which of your figures depends on the facility

Send the LPA, the administrator's output and the facility statements. The first pass computes both bases and names the calls that cannot be restated.

Build my LP package