Folio

Quarterly LP Report Template: Sections, Filled Example and Checks

Cover: 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

  • Use the same eight sections in the same order every quarter, so LPs can compare one quarter with the next.
  • Keep each definition inside the template, next to its field, and explain every holding whose fair value moved more than 5% this quarter.
  • Calculate unfunded commitment as commitment minus called to date plus recallable distributions. In the example below that is $1,550,000, not $1,500,000.
  • Roll each LP's capital account from opening to closing balance with the section 3 lines, including the change in accrued carry (carried interest, the manager's share of the profits). Check that it adds up to the dollar: $625,000 in the example below.
  • Fill the template from the fund ledger, then run five tie-out checks before anyone writes the letter; a gap above $1 in unfunded commitment or above 0.01x in DPI or TVPI holds the report.

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.

Template · copy and adapt
[Fund name] quarterly report: [Quarter] (unaudited) Prepared [date] · Approved by [one named person] 1. Summary letter What changed this quarter: calls, distributions, exits, marks, risks. (Every reported figure is pasted from sections 2 to 8, never retyped.) Next quarter: expected capital calls (amount and month), if known. 2. Fund snapshot and financial statements At quarter end, in [fund currency]. Attach the unaudited balance sheet, statement of operations and cash flow statement. Total commitments: Paid-in capital (capital calls paid, including the fee portion): Cumulative distributions: NAV (net of accrued carried interest): DPI (cumulative distributions ÷ paid-in capital): TVPI ((cumulative distributions + NAV) ÷ paid-in capital): Net IRR (after fees, expenses and accrued carry): TVPI and IRR before accrued carry (labelled gross): 3. Capital account statement (this LP only) Columns: this quarter · year to date · since inception Commitment: Opening balance: + Contributions: - Distributions: - Management fees: - Fund expenses: +/- Net investment gain or loss: - Change in accrued carried interest: = Closing balance: Called to date: Recallable distributions to date: Unfunded commitment (commitment - called to date + recallable distributions): 4. Schedule of investments Company · First investment date · Cost · Fair value · Ownership · Valuation method 5. Valuation note Every holding whose fair value moved more than 5% this quarter: what changed, the evidence, the method. 6. Company updates One short block per company: what happened, key figures with their date, main risk. 7. Fees, expenses and carry Management fees (quarter and to date) · Fee offsets · Fund expenses by type · Accrued carry 8. Borrowing (only if the fund used a credit line) Facility size · Balance drawn · Average days outstanding · Net IRR with and without the line

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

FieldDefinitionCommon error
Paid-in capitalCapital calls the LP has paid, including the fee portionUsing called instead of paid when a payment is late
Recallable distributionA distribution the LPA lets the GP call backShown only as a distribution, so unfunded looks too low
Unfunded commitmentCommitment minus called to date plus recallable distributionsLeaving out recallable distributions
NAVFair value of holdings plus cash and other assets, minus liabilities including accrued carryGross of accrued carry under a net label
DPICumulative distributions ÷ paid-in capitalDividing by commitment
TVPI(Cumulative distributions + NAV) ÷ paid-in capitalUsing NAV before accrued carry
Valuation methodThe approach behind each fair value, as set in the fund's valuation policyMethod changed without a note; see how startups are valued

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.

LineAmount
Commitment$2,000,000
Opening balance$560,000
Contributions$100,000
Distributions−$50,000
Management fees−$10,000
Fund expenses−$5,000
Net investment gain or loss$36,000
Change in accrued carried interest−$6,000
Closing balance$625,000
Called to date$500,000
Recallable distributions to date$50,000
Unfunded commitment$1,550,000

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:

Filled example
Company: an illustrative Series A software company · Figures as at 30 September What happened: two new enterprise customers; a head of sales hired. Key figures: MRR $96k against a $120k plan; cash $3.0M; 7.2 months of runway on a 3-month average burn. Main risk: revenue 20% under plan while runway is under 12 months. The board meets in October to agree a cost plan.

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.

  1. 1Capital accounts add up. The sum of all partners' closing capital equals fund NAV on the balance sheet. Any difference stops the cycle until it is found.
  2. 2Called stays within commitment. For each LP, called to date minus recallable distributions is no more than the commitment. If it is more, look for a call posted twice.
  3. 3Unfunded ties. Unfunded commitment equals commitment minus called to date plus recallable distributions. A difference above $1 is fixed before sending.
  4. 4Multiples recompute. Recompute DPI (distributions ÷ paid-in capital) and TVPI ((distributions + NAV after accrued carry) ÷ paid-in capital) from the ledger. If the draft fund metrics differ by more than 0.01x, hold the send and correct them before the letter is written.
  5. 5Currency is stated. Any converted figure names its rate, the quarter-end rate for NAV. A converted figure with no rate named holds the send. Figures already reported keep the rate they were reported at.
In India
An INR fund, such as an Indian AIF, whose LPs want USD figures can add them to sections 2 and 3. Put the rate and its date in each USD column heading. Check 5 already sets the rate for NAV and for past quarters; for calls and distributions, our suggested default is the rate on the payment date. Tie out the INR figures first. Then add a line for exchange-rate effects to the USD capital account, so its opening and closing balances still add up. The AIF operational checklist covers the rest of the quarter's fund routine.

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.

SituationWhat to change
Fund-of-one or managed accountAgree the sections with the single LP and drop the rest in writing
Single-deal SPVKeep sections 2, 3 and one company update; drop the valuation note unless the mark moved more than 5%
No credit line usedDrop section 8 and say "No credit line used this quarter" in section 7
Fund in wind-downKeep sections 2 and 3 every quarter; company updates only when something changes
Family office as an LPSame template; add the schedule of investments in the format its own reporting uses, on request

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.