Folio

LP Reporting Software: 8 Tests to Run Before You Choose One

Cover: LP Reporting Software: 8 Tests to Run Before You Choose One

Choose LP reporting software by loading a small demo dataset with planted problems and running eight pass-or-fail tests. Make four of them critical: a failure on any one blocks signing until the vendor fixes it and the fix passes a re-run. In our view, a vendor's demo runs on clean data; without planted problems, a fund can sign a tool that overwrites a quarter it has already sent to LPs.

This applies when a fund reports to 15 or more LPs, runs two or more funds, or has LPs in two currencies (our suggested thresholds).

Summary

  • Build a demo dataset of one fund, six LPs and four quarters, with six planted traps.
  • Run eight tests and score each one pass or fail, never on a 1 to 5 scale.
  • Treat four tests as critical: capital accounts tie to NAV, unfunded includes recallable distributions, restated quarters keep the original, and each LP sees only its own account.
  • Pick on critical failures, not on score: a tool passing 7 of 8 with one critical failure loses to one passing 6 of 8 with none.
  • Ask for the vendor's SOC 2 report (an auditor's report on its controls) and read which criteria it covers, which period, and which exceptions it lists.

What does LP reporting software do?

LP reporting software, also called investor reporting software or fund reporting software, turns a fund's ledger into the documents its investors (the LPs) receive: capital account statements, quarterly reports, notices and an LP portal where each LP finds them. Net asset value (NAV) is what the fund is worth after what it owes; an LP's unfunded commitment is what the fund can still call from it. The test is whether its numbers match the ledger every quarter, under messy conditions, and whether each LP sees only what belongs to it.

What it is not

  • Not the fund's accounts. The ledger, kept by the fund or its administrator, is the source; reporting software presents it.
  • Not only a document store. A folder of PDFs cannot recompute an unfunded commitment.
  • Not an investor CRM. Tracking prospective LPs for the next fund is a different job.

Which kinds of LP reporting software are there?

Four kinds of tool do LP reporting: a spreadsheet plus email, a fund administrator's portal, a virtual data room and a fund platform. The trade-offs below are our view; run the eight tests on whichever you shortlist.

ApproachDoes wellBreaks whenFits
Spreadsheet plus emailFull control, no licence feeTwo funds, two currencies or a restated quarterFund I with few LPs
Fund administrator's portalStatements tied to the administrator's booksYou change administrators, or want company data beside fund dataFunds whose administrator keeps the ledger
Virtual data roomAccess control and download logsAny number has to be calculatedFundraising and one-off document sets
Fund platformLedger, capital accounts, company data and LP access in one recordThe data migration is skipped or rushed, or its ledger drifts from the administrator'sFunds with several LPs, funds or currencies

How do you build a demo dataset with planted traps?

A demo dataset is a small, fictional fund that you load into every tool on the shortlist: one fund, six LPs and four quarters, with six problems planted on purpose. Write down the correct answer for each trap before the demo, so a pass is a match, not an opinion.

The traps below use one $40,000,000 fund. LP A ($12,000,000), LP B ($2,000,000), LP C ($9,000,000), LP D ($6,000,000) and LP E ($7,000,000) join at the first close; LP F ($4,000,000) joins at a second close. The fund calls 12% of commitments in quarter 1, 8% in quarter 2 and 5% in quarter 3.

TrapWhat to plantCorrect outputTest
Side letterLP A's side letter cuts the 2% yearly management fee on commitment to 1.5%LP A is charged $45,000 a quarter, not $60,000; LP B is charged $10,0001
Recallable distributionLP B: commitment $2,000,000, called $500,000, $50,000 recallable (the fund can call it back)Unfunded $1,550,0002
Restated quarterAfter the quarter 2 report is sent, correct one holding's quarter 2 value from $4,000,000 to $3,400,000Both versions kept, with the reason: LP B $560,000 as sent, $530,000 restated3
Second closeLP F joins at the start of quarter 2, before that quarter's callA $480,000 catch-up (12% of $4,000,000) on its own line5
Second currencyLP E gets statements in EUR: 0.92 EUR per USD at quarter 3 end, 0.90 at quarter 4 endLP E's quarter 4 NAV at 0.90, rate and date shown; quarter 3 still at 0.92; a currency-effect line makes the EUR roll-forward tie6
Late payerLP D pays its $300,000 quarter 3 call after quarter endAt quarter 3 end: called $1,500,000, paid $1,200,000, outstanding $300,000; DPI and TVPI use paid7

If your current process cannot produce these six answers today, the problem is in the records, not in how the report looks. For VC funds, family offices and their LPs, Folio's LP reporting module is where Folio handles LP updates. See LP reporting in Folio.

What are the eight tests?

The eight tests for LP reporting software check capital accounts, recallable distributions, restated quarters, LP access, second closes, currency, late payments and export. Tests 1 to 4 are critical, our suggested default: one failure blocks signing. In our view, load the dataset into each tool yourself, with its own import; a dataset the vendor loads tests the vendor's team, not the import you will use.

#TestPasses ifCritical
1Capital accounts tie to NAVThe sum of all partners' closing capital equals fund NAV, to the dollar, and only the side-letter LP shows the lower feeYes
2Unfunded includes recallablesLP B shows $1,550,000Yes
3Restated quarter is keptThe original quarter 2 figure, the new one and the reason are all visibleYes
4Access is per LPLogged in as LP C, you see LP C's capital account and no one else'sYes
5Second close is handledThe new LP's catch-up appears as its own lineNo
6Currency is statedEvery converted figure names its rate and its date, the quarter-end rate for NAV; past quarters keep their rate, and a currency-effect line makes the roll-forward tieNo
7Late payment is separateCalled, paid and outstanding each show as a separate figure, and DPI and TVPI use paidNo
8Data exportsEvery capital account and its full history export to a spreadsheet in one stepNo

Test 2 follows ILPA's Capital Call and Distribution Template guidance: on its default basis, recallable distributions increase the LP's unfunded balance. A fund that nets recallable distributions against calls says so in a footnote; LP B's unfunded is still $1,550,000.

Ask two more questions that are not scored. Can the tool show performance both gross and net of accrued carried interest, labelled, as ILPA's Principles 3.0 ask? Can it fill ILPA's updated Reporting Template, released in January 2025, from the same ledger, if your LPs request it? For which multiples LPs read first, see the LP reporting metrics that matter beyond IRR.

Worked example: the higher score loses

An illustrative fund runs the eight tests on two shortlisted tools.

ToolTests passedFailedCritical failures
Tool A7 of 8Test 3: the restated quarter overwrote the original1
Tool B6 of 8Tests 5 and 80

In the restated-quarter trap, LP B holds 5%, so its share of the $600,000 correction is $30,000 (ignoring accrued carry): its quarter 2 statement showed a closing balance of $560,000, and the restated figure is $530,000. Tool A shows only $530,000, with no trace of the $560,000 statement LP B was sent.

Counted by score, Tool A wins, 7 to 6. Under the critical-test rule, Tool A cannot be signed: an overwritten quarter means the fund can no longer show an LP or an auditor what it sent. The fund picks Tool B and writes two conditions into the order: a catch-up line for second-close LPs and a full export, each re-tested before the first live quarter. Tool A goes back on the list only if it fixes test 3 and passes a re-run.

In our view, the second-close and export gaps cost a few hours of workaround each quarter; a lost original costs the fund's credibility the first time an LP asks. 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.

What should you ask about security?

Ask any LP reporting software vendor for its SOC 2 report and read three things: which criteria it covers, which period, and which exceptions it lists. The AICPA's SOC 2 guide, listed on its SOC suite page, names five areas: security, availability, processing integrity, confidentiality and privacy. Then ask four questions of your own:

  • Can access be set per fund and per LP, and who at the vendor can see your data?
  • Is there an audit log of every view, download and change, kept for how long?
  • Where is the data stored, and can you choose the region?
  • If you leave, how do you get every document and number back, and in what format?
In India
Funds with domestic and foreign LPs may send statements in INR and USD. Run test 6 with an INR fund and one USD LP, and ask where the data is hosted, because your LPs may ask you the same question.

When should you not buy LP reporting software yet?

In our view, LP reporting software solves a reporting problem only when the ledger behind it is right. In these cases, do something else first.

SituationWhat to do instead
Fewer than 15 LPs, one fund, one currencyKeep the spreadsheet and add a second reviewer and the eight tests as a checklist
Capital accounts do not tie to the ledger todayFix the ledger first; software will only publish the gap faster
Your administrator already sends statements you trustTest whether its portal passes the eight tests before adding a second tool
No one owns the data migrationName an owner and budget a full quarter before signing
Fundraising for the next fund is the urgent jobUse a data room for the raise; choose reporting software after the close

Reporting software is one part of running a VC fund. The company figures in each LP report still have to arrive from founders every month, and manual portfolio data collection is where that slows down.

Choose on evidence, not on the demo. Build the dataset, run the eight tests and let the critical ones decide. For VC funds, family offices and their LPs, Folio's LP reporting module is where Folio handles LP updates. Run the same tests on LP reporting in Folio.

FAQ

How long should a pilot run?

Our suggestion: one full real quarter, run in parallel with your current process. Compare every capital account line by line. A pilot on demo data alone never meets your own exceptions.

Should the software calculate IRR, or import it?

Either works if the result can be checked. Give the tool a cash-flow series whose IRR (the yearly return those cash flows earn) you have already computed, and confirm it returns the same IRR to within 0.1 percentage points (our suggested tolerance). If it imports IRR from the administrator, confirm it shows the date and source.

Can LPs download their own documents?

In our view, yes, within test 4's rule: each LP downloads its own capital account and the shared fund documents, and nothing else. Check that every download appears in the audit log. For the LP side of the relationship, see how family offices track their fund investments.

What data should we migrate first?

Every LP's capital account history from the first close, by quarter, with calls, distributions and recallable amounts. Company data and documents can follow. Without the full capital account history, tests 1 to 3 cannot pass.

Does LP reporting software replace a fund administrator?

No. In our view, they do different jobs: the administrator keeps the books and the controls around them, and the software presents the results to LPs. Some funds use both; test whether the two agree each quarter.

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. Tool results in the example are illustrative.