Folio
Quarterly LP Report Template: Sections, Filled Example and Checks
A quarterly LP report template is a fixed outline of eight sections that a fund's manager (the GP) fills in from the fund's ledger every quarter for its investors (the LPs). The template below carries each definition next to its field, so the person filling it in sees the agreed meaning every time. Without that, definitions drift: a recallable distribution (one the GP can call back) gets left out, and an LP's unfunded commitment (what the fund can still call) comes out too low.
This applies when a closed-end fund reports quarterly to several LPs. A fund-of-one, a single-deal SPV or a fund in wind-down can drop sections (see the table of cases before the FAQ).
Summary
What is a quarterly LP report template?
A quarterly LP report template, also called an LP report template or VC quarterly investor report template, is the reusable structure for the package a fund sends its LPs each quarter. It fixes the sections, their order and the definitions behind each number. Six of the eight sections below follow ILPA's Quarterly Reporting Standards.
What it is not
- Not the audited annual report. The quarterly report is unaudited and says so on its first line.
- Not a capital call notice. Calls go out as separate notices, on their own dates.
- Not a marketing deck. It reports what happened; fundraising material belongs elsewhere.
What sections should a quarterly LP report template have?
Our suggested quarterly LP report template has eight sections, each tied to one source in the fund ledger. Copy it and keep the notes in brackets: they are the definitions.
Sections 5 and 8 come from ILPA's guidance. ILPA's Principles 3.0 ask GPs to explain quarter-to-quarter valuation changes, including changes of method, and to show performance gross and net of accrued carried interest. ILPA's guidance on subscription lines asks for, among other items, the facility's size, its balance, the average days each drawdown stays outstanding and net IRR with and without the line. The 5% trigger in section 5 is our suggested default. For which fund metrics LPs read first, see the LP reporting metrics that matter beyond IRR.
If this template is filled by copying last quarter's file and editing numbers by hand, in our view the definitions in brackets are the first thing to go. For VC funds, family offices and their LPs, Folio's LP reporting module is where Folio handles LP updates. See LP reporting in Folio.
Field notes
The unfunded definition follows the basis in ILPA's Capital Call and Distribution Template guidance: on its default basis, recallable distributions increase the LP's unfunded balance. A GP that instead nets recallable distributions against calls says so in a footnote, and runs check 3 below on called to date before that netting.
Filled example: one LP's capital account statement
The table below fills in section 3 for one illustrative LP, quarter column only. LP B committed $2,000,000 to a $40,000,000 fund, a 5% share. By the end of the third quarter, the fund had called 25% of commitments. LP B had paid all $500,000 called and received $150,000 in distributions, of which $50,000 is recallable.
The lines down to the closing balance add up. The unfunded line in the first draft did not: it showed $1,500,000 ($2,000,000 − $500,000), leaving out the $50,000 recallable distribution. Adding it back gives $1,550,000. Check 3 below catches the $50,000 gap, far above its $1 tolerance, so the report is held and corrected. Sent as drafted, LP B would have set aside $50,000 less than the fund can still call.
The same capital account gives LP B's multiples: DPI is $150,000 ÷ $500,000 = 0.30x, and TVPI is ($150,000 + $625,000) ÷ $500,000 = 1.55x.
A filled company update for section 6, from the same quarter:
When every LP's capital account is built by hand, one missed recallable distribution repeats in every later quarter. For VC funds, family offices and their LPs, Folio's LP reporting module is where Folio handles LP updates. How LP reporting works in Folio.
Which checks should run before the report goes out?
Five tie-out checks should run on a filled quarterly LP report template before the summary letter is written, by someone other than the person who filled it in. The tolerances are our suggested defaults.
When should you adapt the template?
The eight-section quarterly LP report template fits a closed-end fund with several LPs. Adapt the template in these cases.
Fill the template from one record. Each new LP adds another capital account to roll forward and tie out. For VC funds, family offices and their LPs, Folio's LP reporting module is where Folio handles LP updates. Copy the template above, then see how Folio handles LP reporting.
FAQ
Does gross in section 2 mean before fees as well?
No. In section 2, gross means before accrued carry only, the basis ILPA's Principles 3.0 use. Our suggestion: if you also show a figure before management fees and fund expenses, put it on a separate line with its own label, so no LP compares it with another fund's gross-of-carry figure.
Who should approve the report?
In our view, one named person, usually the managing partner, approves the whole package after the checks have passed. Put the name on the cover. A report approved by "the team" has no one to ask when a number is wrong.
How do we correct a number after the report has gone out?
Send a short correction that shows the old figure, the new figure and the reason. In the next report, keep both figures in a footnote. Never overwrite the sent version in your own records; an LP or auditor may ask what was sent.
Should each LP get a separate file?
Our suggestion: yes, one file per LP, because section 3 is that LP's capital account and no other LP should see it. Sections 1, 2 and 4 to 8 are the same in every file.
What if an LP paid a capital call late?
Show the call in called to date and the payment in paid-in capital only when the money arrives. The gap is the outstanding amount. Note it in the capital account, so the LP's DPI and TVPI use what was actually paid.
About Folio
Folio is Incentiv's fund platform for private market investors: VC funds, family offices and their LPs. It covers deal flow, portfolio, LP and fund management. Its LP reporting module is where Folio handles LP updates. Explore LP reporting in Folio.
This post is general information, not legal, tax or investment advice. All fund figures are illustrative.