Every VC partner has a story about the portfolio company that looked great on paper until they dug into the details. Revenue was growing, but churn was quietly eating the base. Headcount was expanding, but output per employee was declining. The headline numbers told one story while the underlying KPIs told another.
The challenge for most funds is not understanding which KPIs matter. It is building a system that collects, normalizes, and presents those KPIs across an entire portfolio in a way that is actually useful. When you have 20 or 30 companies across different stages, sectors, and business models, creating an apples-to-apples view requires intentional design.
This guide walks through a practical framework for portfolio-wide KPI tracking that scales with your fund.
Why Portfolio-Wide KPI Tracking Is So Hard
Before jumping into the framework, it is worth understanding why this problem is harder than it looks.
Different business models, different metrics. A B2B SaaS company and a consumer marketplace have almost nothing in common when it comes to key metrics. MRR and NRR matter for one. GMV, take rate, and order frequency matter for the other. A framework that forces every company into the same metric template will produce meaningless data.
Stage differences. A pre-revenue company and a Series B company with $10M ARR are playing different games. Tracking the same KPIs for both creates noise rather than signal.
Founder reporting inconsistency. Some founders send beautifully formatted monthly reports unprompted. Others need three follow-up emails to share basic revenue numbers. The quality and timeliness of data varies wildly.
Definition disagreements. Ask five SaaS founders to define "churn rate" and you will get five different answers. Is it logo churn or revenue churn? Gross or net? Monthly or annualized? Without standardized definitions, your portfolio data is unreliable.
Building Your KPI Framework
Step 1: Define Universal Metrics
Start with a small set of metrics that apply to every company regardless of business model. These are your universal metrics, the ones you track for every single portfolio company.
Cash on hand. Non-negotiable. Every company has a bank balance.
Monthly burn rate. Net cash consumed per month. Simple and universally applicable.
Runway in months. Cash divided by burn. The single most important risk metric in your portfolio.
Revenue. However the company defines it. For pre-revenue companies, this is zero, and that is fine.
Headcount. Total full-time employees. A simple proxy for organizational complexity and cost structure.
These five metrics take less than two minutes for any founder to report and give you a meaningful baseline view of your entire portfolio.
Step 2: Define Business Model Tiers
Beyond universal metrics, create metric sets for each major business model in your portfolio. Most venture portfolios fall into a few categories.
SaaS / Subscription Businesses:
- Monthly Recurring Revenue (MRR)
- Annual Recurring Revenue (ARR)
- Net Revenue Retention (NRR)
- Gross Revenue Retention (GRR)
- CAC and CAC Payback Period
- LTV:CAC Ratio
- Gross Margin
Marketplace / Platform Businesses:
- Gross Merchandise Volume (GMV)
- Take Rate
- Buyer and Seller Growth
- Repeat Purchase Rate
- Supply-Side and Demand-Side Unit Economics
Consumer / Usage-Based Businesses:
- Monthly Active Users (MAU) or Daily Active Users (DAU)
- DAU/MAU Ratio (stickiness)
- Revenue Per User (ARPU)
- Cohort Retention Curves
- Engagement Metrics (sessions, time in app)
Fintech / Lending:
- Loan Volume or Transaction Volume
- Net Interest Margin or Revenue Margin
- Default Rate
- Unit Economics Per Transaction
- Regulatory Capital Ratios
When onboarding a new portfolio company, assign it to the appropriate tier. The company reports universal metrics plus its tier-specific metrics.
Step 3: Standardize Definitions
This is the step most funds skip, and it is the one that makes everything else fall apart. You need a definitions document that specifies exactly how each metric should be calculated.
For example, your MRR definition should specify:
- Include contracted recurring revenue only (no one-time fees)
- Include expansion revenue from existing customers
- Exclude professional services revenue
- Use the last day of the month as the measurement date
Share this definitions document with every portfolio company. Include it in your onboarding materials. Reference it when founders submit numbers that do not look right. Consistency here is what makes portfolio-wide comparisons meaningful.
Step 4: Set Reporting Cadence and Deadlines
Monthly reporting works best for most funds. Quarterly is too infrequent to catch problems early. Weekly is too burdensome for founders and creates more noise than signal.
Set a specific deadline. "Monthly financials due by the 10th of the following month" is clear and reasonable. It gives founders time to close their books while ensuring you have current data.
Build a tracking system for compliance. Know which companies reported on time, which were late, and which did not report at all. Persistent non-reporters need a direct conversation.
Collecting Data Without Losing Your Mind
The Reporting Template
Design your data collection form to be as frictionless as possible. A founder should be able to complete it in under 15 minutes.
Structure it in three sections:
Section 1: Universal Metrics (required for all) Five fields, all numerical. Cash, burn, runway, revenue, headcount.
Section 2: Business Model Metrics (required for tier) Five to eight fields specific to the company's business model. Pre-populated with last month's values so founders can see trends and catch errors.
Section 3: Qualitative Update (optional but encouraged) Three prompts: biggest win this month, biggest challenge, anything you need from us. Keep it to bullet points, not essays.
Automation and Integration
For funds with more than 15 portfolio companies, manual collection becomes unsustainable. There are a few ways to reduce the friction.
Accounting integrations. Some portfolio monitoring tools can pull financial data directly from QuickBooks, Xero, or other accounting platforms. This eliminates the most common source of late or inaccurate reporting.
Pre-populated forms. Send each company a form that already contains last month's data. The founder only needs to update the numbers that changed. This reduces the effort from "fill out a spreadsheet" to "verify and adjust five numbers."
Automated reminders. Set up automated email or Slack reminders as the deadline approaches. A gentle nudge on the 8th, a firmer reminder on the 11th, and a personal follow-up on the 15th if the data is still missing.
Handling Late and Missing Data
You will never achieve 100% compliance. Accept that, but do not accept less than 80%. Here is a practical approach.
Track a "reporting score" for each company. On-time submission earns full marks. Late submission within one week gets partial credit. Missing data gets zero. Share this score with founders periodically. Nobody wants to be the worst reporter in the portfolio.
For persistently late reporters, have a direct conversation. Sometimes the issue is operational (they do not have a controller who closes books monthly). Sometimes it is cultural (the founder does not prioritize investor communication). Both are addressable, but through different approaches.
Normalizing Data for Comparison
Raw numbers across companies are hard to compare. A company with $500K MRR growing 8% month-over-month is in a fundamentally different position than one with $50K MRR growing 30% month-over-month. Normalization makes comparisons meaningful.
Growth Rate as the Great Equalizer
Converting absolute numbers to growth rates enables comparison across stages. Month-over-month revenue growth, quarterly burn rate changes, and headcount growth percentages let you see which companies are accelerating and which are stalling, regardless of their absolute scale.
Benchmarking Against Stage-Appropriate Standards
Build benchmark tables for each stage and business model. For example, a Series A SaaS company should have:
- MRR growth of 10-15% month-over-month
- Gross margins above 70%
- NRR above 110%
- Burn multiple below 2x
When you plot a company's actual metrics against these benchmarks, outliers become immediately visible. A company performing in the top quartile across most metrics is a strong follow-on candidate. One consistently below median might need intervention.
Cohort Analysis Across the Portfolio
Group your portfolio companies by vintage (investment year), stage, or sector. Then compare performance within cohorts. This reveals patterns that are invisible when looking at companies individually.
Are your 2024 investments performing better or worse than your 2023 investments at the same point in their lifecycle? Are your fintech investments outperforming your SaaS investments? Cohort analysis turns your portfolio data into strategic intelligence.
Presenting KPIs to LPs
Your LPs care about fund-level performance, but they also want to understand portfolio health. Good KPI tracking makes LP reporting dramatically easier and more compelling.
The Portfolio Summary View
Create a one-page summary that shows every company with a health indicator, current stage, key metrics, and recent trajectory. LPs love this view because it gives them the full picture in seconds.
Aggregated Portfolio Metrics
Roll up individual company metrics into portfolio-level statistics:
- Weighted average revenue growth across the portfolio
- Median months of runway
- Percentage of companies above/below plan
- Total portfolio revenue and headcount
These aggregate views demonstrate that you have a systematic approach to portfolio management, which builds LP confidence.
Narrative Context
Numbers without context are just numbers. Pair your KPI dashboards with brief narratives explaining the story behind the data. "Company X's burn increased 40% this quarter because they hired a sales team, which has already generated $200K in new pipeline" is far more useful than a red flag on a dashboard.
Tools and Systems
You can track portfolio KPIs in a spreadsheet when you have five companies. By the time you reach fifteen, you need purpose-built tools.
A VC-specific platform like Roulette is designed for exactly this workflow. It handles data collection from portfolio companies, normalizes metrics across different business models, and provides the dashboards and comparison views that make portfolio-wide KPI tracking practical. Instead of wrestling with spreadsheets and chasing email updates, you get a centralized system where portfolio data lives, updates, and presents itself clearly.
Whatever tool you choose, the key requirements are:
- Customizable metric templates per business model
- Automated data collection and reminders
- Trend visualization over time
- Benchmarking and comparison views
- LP-ready reporting outputs
The Compound Value of Consistent Tracking
The real power of portfolio KPI tracking emerges over time. After 12 months of consistent data collection, you can identify patterns. After 24 months, you can build predictive models. After multiple fund cycles, your data becomes a genuine competitive advantage.
Funds that track KPIs systematically make better follow-on decisions because they have quantitative evidence, not just gut feeling. They provide better support to founders because they spot problems earlier. They raise subsequent funds more easily because they can demonstrate rigorous portfolio management to LPs.
Start simple, be consistent, and let the data compound.