Folio
How to Choose Portfolio KPI Software: 10 Tests Every VC Should Run
Before you sign for portfolio KPI software, load a small demo dataset with planted problems and run 10 pass-or-fail tests on how the tool stores definitions, calculates formulas, keeps history and handles blanks and currencies. 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, demos run on clean data, so the errors that later reach an LP report only show up when you feed the tool messy data yourself.
This applies when a fund or family office tracks company KPIs (revenue, burn, runway, headcount, custom metrics) across 10 or more portfolio companies (our suggested threshold). Fund return metrics such as TVPI and IRR need a separate test set.
Summary
What should portfolio KPI software get right for VC funds and family offices?
Portfolio KPI software stores each company metric with its definition, calculates derived metrics the same way every month, keeps every past value when a figure changes, and rolls company figures up to the portfolio without hiding gaps. Charts and dashboards sit on top of those four jobs and cannot repair them.
What it is not
- Not fund performance software. TVPI, DPI and IRR come from the fund's cash flows and valuations, a different dataset.
- Not a data warehouse. It holds agreed metrics with definitions, not every number a company produces.
- Not the company's accounts. Monthly KPIs are unaudited management information.
How do you build a demo dataset for portfolio KPI software?
Build one demo dataset for testing portfolio KPI software from your own portfolio's shape, and give the same file to every vendor. Three companies and three months are enough: one clean company as the control and two that carry the traps. A trap is a planted error or edge case that shows whether the tool breaks. All figures below are illustrative.
Write the expected answer for every test before the first demo, so nobody grades the tool by what it happens to show.
Which 10 tests should portfolio KPI software pass?
Run all 10 acceptance tests on every portfolio KPI software tool on your shortlist, in order, and record pass or fail with a screenshot. The critical tests are our suggested defaults: they cover the errors that change a number in an LP report without anyone noticing.
Test 2 has a known answer because runway is a simple ratio. The Business Development Bank of Canada defines it as cash balance divided by burn rate, the net cash outflow, typically monthly. It also warns that two months of data will not capture spending fluctuations. The 3-month average is our suggested default: $3.0M ÷ (($380k + $410k + $460k) ÷ 3) = 7.2 months. A tool that divides by the last month alone shows 6.5 months.
Test 6 matters because spreadsheets make the error easy. Microsoft's COUNTBLANK function counts empty cells but not cells holding 0, so once someone types 0 for a missing month, nothing marks it as missing any more. A tool should store missing as missing.
Test 9 is easier to trust with an independent report. The AICPA's SOC suite includes SOC 2 reports on controls relevant to security, availability, processing integrity, confidentiality or privacy; ask for the latest report alongside the test.
If you chase founders every month for the same five numbers, every late or restated figure ends up in the tool you sign for. For VC funds and family offices, once founder numbers arrive, Folio's portfolio monitoring module is where they're meant to live. See how portfolio monitoring works in Folio.
What does a failed critical test look like?
A failed critical acceptance test changes a review decision, which is why it blocks signing. In this illustrative example, Cedar has $1.5M of cash, net burn of $290k in July and $310k in August, and has not yet sent September.
Tool X fails test 6. A late report makes the company look healthier, and the review gives it two weeks instead of one. Tool Y averages the months available in the 3-month window and flags the gap. That rule is our suggested default; a tool may use another rule as long as it never counts a missing month as zero.
The team had preferred Tool X after the demo, because its dashboard was faster and its charts clearer. Under the acceptance rule, it does not get signed until the vendor fixes test 6 and the fix passes a re-run. Tool Y passes all four critical tests and fails only test 5, which the team accepts with a written workaround: definition changes are logged by hand until the vendor's next release.
One missing report is easy to spot by eye; with several missing in the same month, blank-as-zero can rewrite the review without anyone noticing. For VC funds and family offices, once founder numbers arrive, Folio's portfolio monitoring module is where they're meant to live, so put it through the same 10 tests. See the portfolio monitoring module in Folio.
Which metrics deserve their own tests?
A standard acceptance test set does not cover every metric's own failure mode. Add a test for each metric below that your portfolio uses.
Ownership belongs here because it should agree with each company's cap table as a single source of truth, and LPs read company metrics next to fund-level LP reporting metrics in the same report.
How do the tests feed LP reporting?
Company KPIs reach LPs through quarter-end LP reporting, so portfolio KPI software must reproduce a past report exactly as it was sent. ILPA is refreshing its Portfolio Company Template for company-level reporting to LPs. Public comment on the draft closed on 16 October 2026, and ILPA plans to publish the final version in January 2027. Ask each vendor how it will map stored metrics to that template, and keep the answer in the order form.
When should you change the test set?
The default test set assumes a fund or family office tracking 10 or more companies, mostly in one reporting currency, with unaudited monthly KPIs. Change it when your portfolio differs from that.
Passing all 10 tests shows the tool handles your data correctly in a trial. It does not show your team will define metrics carefully; that still needs one owner for definitions.
Acceptance test checklist
Before the first demo
During each trial
Before signing
Collecting the same KPIs from every founder, every month? Copy the dataset and the 10 tests above into your next trial. For VC funds and family offices, once founder numbers arrive, Folio's portfolio monitoring module is where they're meant to live. See the portfolio monitoring module.
FAQ
Can we run these tests on our spreadsheet first?
Yes, and it is a useful baseline, especially where manual portfolio data collection feeds the sheet. In our view, a shared spreadsheet usually passes test 2 and fails tests 4 and 9 unless someone has set up version history and locked cells. The failures show what you are buying the software to fix.
What if the vendor will not run our dataset?
Ask for a trial account and run it yourself. If neither is possible, treat every critical test as failed. A tool you cannot test with your own data is a tool you are buying on its demo.
How often should we re-run the tests after buying?
In our view, after every major release and whenever you add a new metric definition. Keep the demo dataset and the expected answers, so a re-run is a comparison, not a new project.
Who should run the tests?
In our view, the person who will own monitoring after you buy, with the analyst who builds LP reports checking the history and currency tests. The vendor can run the demo, but your team should type in the data.
Should the vendor see the expected answers?
Our suggestion is no. Send the demo dataset without the expected-answer column, keep the answers to yourself and compare after each test. A vendor who knows the answers can fix a result by hand during the demo.
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 portfolio monitoring module is where Folio handles founder numbers once they arrive. See how portfolio monitoring works in Folio.
Thresholds, test choices and response times are editorial suggestions, not financial or legal advice. All company figures and rates are illustrative.