Folio

How to Pick Portfolio Monitoring Software: An Evaluation Checklist for VC Funds

Cover: Portfolio Monitoring Software: Evaluation Checklist

To evaluate portfolio monitoring software, score each option on seven weighted criteria, run six tests in a trial with your own data, and drop any option that fails on founder data collection or history. Weight the criteria by the part of the routine your fund finds hardest. In our view, for most early-stage funds that is getting numbers out of founders at all. In the worked example below, an equal-weight comparison picks the tool with the best dashboard, not the one that fixes the monthly routine.

This applies when a fund or family office tracks 5 or more private companies and is choosing between keeping spreadsheets, using a general dashboard tool, or buying a dedicated platform.

Summary

  • Score every option 1 to 5 on seven criteria, weighted to 100: collection 25, history 20, validation 15, reporting 15, ownership and valuation 10, security 10, export 5.
  • Treat a score of 1 on collection or history as a knock-out, whatever the total.
  • Run six tests in a trial with your own sample data, including one restated month and one blank field.
  • Set a budget ceiling before the first demo, and drop anything above it instead of scoring price.
  • In the worked example, equal weights put the general dashboard tool first (71 against 69); the weights put the dedicated platform first (71 against 62), and the knock-out rule removes the dashboard tool anyway.
  • Under about 15 to 20 companies with one owner, a spreadsheet and a form can still be the right answer.

What should portfolio monitoring software do?

Portfolio monitoring software collects operating data from portfolio companies on a schedule, keeps a dated history of every figure, checks it against written rules, and feeds valuations and LP reports without anyone re-keying numbers. It replaces the email chasing and copy-paste of manual portfolio data collection, not the judgement of the people reading the numbers.

What it is not

  • Not a cap table tool. A cap table records who owns what. Monitoring records how each company is doing.
  • Not a deal CRM. A CRM tracks deals and relationships before the investment. Monitoring starts after closing.
  • Not fund accounting. Capital accounts, calls and distributions live in the fund's books. Monitoring feeds them evidence.
  • Not a dashboard tool. A dashboard displays data. It does not ask founders for it, chase them or keep restatements.

Which criteria matter, and how much?

Portfolio monitoring software is best judged on seven criteria (our suggested set), weighted by the part of the monthly routine your fund finds hardest. The weights below are our suggested defaults for an early-stage fund with 20 to 40 companies, where collection is the hardest part. Score each criterion 1 (fails) to 5 (does it well) from what you saw in the trial, not from the sales deck.

CriterionWeightTest in the trialPass looks likeCommon error
Collection from founders25Send a real request to two foundersThey submit without your team re-keying anythingJudging the investor dashboard and never seeing the founder side
Data model and history20Restate a past monthBoth values kept, with date, user and reasonAccepting a tool that overwrites the old figure
Validation and flags15Load a month that should flag amberFlag appears with a one-line reasonCounting charts as validation
Reporting output15Build one company summary for an LP reportNo export-and-paste stepSeeing a finished report built by the vendor, not by you
Ownership and valuation record10Enter a new funding roundStake and mark update; the prior values stayTreating the latest mark as the only mark
Security and access10Ask for the latest independent assurance reportReport provided, or a dated plan to get oneAccepting a policy document as assurance
Export and exit5Export everything from the trialFull history, restatements included, in a common file formatFinding out at renewal that only current values export

Weighted score = the sum of (weight × score) ÷ 5, which gives a figure out of 100.

Collection carries the most weight because the rest depends on it. Ask what a founder sees, how many fields the default request has, and how reminders work. If you plan on automating portfolio data collection from multiple startups, test it with founders who are not your most responsive ones.

Reporting matters because monthly data ends up in quarter-end LP reporting. Company figures sit next to the fund-level LP reporting metrics in the same pack, so check the two can be produced from one dataset. Also ask how the tool will map to ILPA's Portfolio Company Template, which ILPA is refreshing: public comment on the draft closed on 16 October 2026, and ILPA plans to publish the final version in January 2027.

Ownership needs the round history as well as today's stake, and it should agree with the company's cap table kept as a single source of truth.

Security, in our view, is easier to judge with an independent report than a questionnaire. The AICPA's SOC suite includes SOC 2 reports on controls relevant to security, availability, processing integrity, confidentiality or privacy.

Price is not a criterion here. Set a budget ceiling before the first demo and drop anything above it or negotiate for better terms, so a cheaper tool cannot outscore a better one by costing less.

If your portfolio already lives in a different spreadsheet for every fund, the collection and history tests are where that shows first. For VC funds and family offices, Folio's portfolio monitoring module is where Folio handles this part of fund operations. See portfolio monitoring in Folio.

What should you test in a trial?

Test every shortlisted portfolio monitoring tool with the same small sample of your own data, prepared before the first demo. Three companies with three months each is enough, as long as the sample includes one restatement, one blank field, one new funding round and one company that should be flagged.

TestWhat to doPassFail sign
1. Founder requestSend the standard request to two founders who agree to helpBoth submit; your team re-keys nothingFounders email a spreadsheet back
2. Runway ruleEnter cash of $3.0M and net burn of $380k, $410k and $460k for three monthsRunway shows 7.2 months on a 3-month average and flags amber (under 12 months) with a one-line reasonRunway shows 6.5 months on the last month alone, with no flag
3. RestatementChange August revenue from $96k to $90k with a reasonBoth values kept, with date, user and reasonOld value gone
4. Blank fieldLeave headcount blank for one companyShown as missing, left out of averagesShown as 0
5. LP summaryBuild one company summary for a quarterly LP reportProduced from the tool's data, no pastingExported to a spreadsheet first
6. ExportExport the full trial datasetAll months, restatements and notes includedCurrent values only

The Business Development Bank of Canada defines runway as cash balance divided by burn rate, the net cash outflow, typically monthly, and notes that a longer period gives a more stable burn figure. The 3-month average and the 12-month amber line in test 2 are our suggested defaults: $3.0M ÷ $417k = 7.2 months, against $3.0M ÷ $460k = 6.5 months on the last month alone. Ownership and security are scored outside the six tests: enter the funding round in the sample, and ask for the assurance report.

How do you score the options and decide?

Score each portfolio monitoring software option on collection, history, validation, reporting, ownership and valuation, security and export, apply the weights, then apply our suggested knock-out rule: a 1 on collection or history removes the option, whatever its total. In the illustrative example below, a fund with 40 companies, two partners and one associate scored three types of tool after a one-month trial.

CriterionWeightGeneral dashboard toolFund admin portal add-onDedicated monitoring platform
Collection from founders25124
Data model and history20234
Validation and flags15523
Reporting output15543
Ownership and valuation record10343
Security and access10454
Export and exit5533
Equal weights (out of 100) 716669
Weighted score (out of 100)100626171

With equal weights, the dashboard tool wins on 25 points out of 35, mostly from validation and reporting, where it scores well on data someone else has already collected. With the weights, the dedicated platform wins: (25×4 + 20×4 + 15×3 + 15×3 + 10×3 + 10×4 + 5×3) ÷ 5 = 71, against 62 for the dashboard tool. The dashboard tool also scores 1 on collection, so the knock-out rule removes it before the totals are compared. The fund shortlists the dedicated platform and negotiates on the four criteria where it scored 3: validation, reporting, ownership and export.

If every demo looks polished and the portfolio still lives in a different spreadsheet for every fund, the scores are what separate the tools. For VC funds and family offices, Folio's portfolio monitoring module is where Folio handles this part of fund operations, so run it through the same six tests as everything else. How portfolio monitoring works in Folio.

How does the choice change with portfolio size?

In our view, portfolio size and holding type should change portfolio monitoring software weights more than anything else: small portfolios can stay on a spreadsheet, mid-size ones should use the default weights, and larger or multi-fund portfolios should move weight to reporting.

PortfolioRaise the weight onStarting point
Under about 15 to 20 companies, one ownerCollectionA spreadsheet and a form can work; revisit when either number grows
20 to 40 companies, one fundCollection and historyUse the default weights above
Over 40 companies or several fundsReportingMove 5 points from validation to reporting; test with two funds' data
Family offices holding direct positions and fund stakesOwnership and valuation recordMove 5 points from validation to ownership and valuation; add a test that rolls holdings up by entity
In India
If companies report in INR and LPs read USD, test both in the trial. Enter one company's figures in lakh or crore, check the conversion rate is stated next to the converted figure, and include companies with different financial year-ends.

When should you adapt this checklist?

Adapt this portfolio monitoring software checklist when founder data collection is not the hardest part of the routine.

SituationWhat to do instead
Most companies are Series B+ and send a board packLower collection to 15 and raise reporting to 25
You co-invest behind a lead that already collects dataAdd a test for importing the lead's figures
No information rights in most holdingsLower collection to 10, raise reporting to 25 and ownership to 15. ILPA's glossary describes information rights as access to company information such as the books and financial statements; without them, in our view, collection relies on goodwill
Your administrator already holds the fund's booksAdd a test that fund figures and company figures agree on one date
Pre-revenue deep tech portfolioIn test 3, restate a milestone date instead of revenue

A high score says the tool did well in your trial. It does not say your team will run the monthly routine; that still needs one named owner.

Portfolio monitoring software checklist

Before any demo

  • Write down the hardest part of your routine and set the weights (defaults: collection 25, history 20, validation 15, reporting 15, ownership and valuation 10, security 10, export 5)
  • Set the budget ceiling
  • Prepare the sample: three companies, three months, one restatement, one blank field, one funding round, one company that should flag

During the trial

  • Run all six tests on every shortlisted tool
  • Enter the funding round from the sample and check the stake and mark update while the prior values stay
  • Score the seven criteria 1 to 5 from what you saw
  • Ask for the latest independent assurance report

Deciding

  • Remove any option scoring 1 on collection or history
  • Compare weighted scores; negotiate on any criterion scored 3 or below
  • Name the owner of the monthly routine before signing

Choosing a portfolio monitoring tool? Copy the scorecard and the six tests above and run them in every trial. For VC funds and family offices, Folio's portfolio monitoring module is where Folio handles this part of fund operations. See portfolio monitoring in Folio.

FAQ

How long should a trial run?

Our suggested default is one full monthly cycle with real founders, so the request, reminders, validation and a report all happen once. A trial that only uses vendor sample data cannot test collection.

Can we keep the spreadsheet running alongside?

For one cycle, yes, to compare the two line by line. After that, retire it. In our view, two live copies of the same numbers drift apart, and nobody knows which one the LP report used.

What if every option fails the knock-out rule?

In our view, keep the current routine and widen the shortlist. Don't buy the option with the highest total. An option that scores 1 on collection or history leaves the hardest part of the routine unsolved. Run the next round with the same weights and the same six tests.

What if two options finish only a few points apart?

In our view, a small gap is not a reason to choose, because the scores come from one short trial. Prefer the option that scored higher on collection and history, the two criteria with the most weight. If they are level there too, run test 1 again with two founders who were not in the first trial.

Who should score the options?

Our suggestion is three people: the person who will own the monthly routine, a deal partner and whoever builds the LP report. Each scores alone first, then you average the scores, so one strong opinion does not set the result. If anyone gives a 1 on collection or history, talk it through before averaging, because that score decides the knock-out rule.

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 the monthly routine this checklist tests. Explore portfolio monitoring in Folio.

Weights, thresholds and scores are editorial suggestions, not financial or legal advice. All figures are illustrative.