Why VC Portfolio Spreadsheets Break Above 15 Companies

Every emerging fund manager starts with a spreadsheet. It is cheap, familiar, infinitely flexible, and good enough for the first few investments. The problems do not appear when you have five companies. They appear when you have fifteen or twenty, and by then they are expensive to fix. Here is what actually breaks, why it tends to break around the same threshold, and what fund managers do when they outgrow the spreadsheet.

There is nothing wrong with spreadsheets. They are an extraordinary tool. Most of the world’s investment activity, including most early-stage venture capital, still runs on them. For a solo GP with three portfolio companies and an LP base that wants quarterly updates, Excel or Google Sheets is genuinely the right tool.

Then the fund deploys. The portfolio grows. Three companies become eight, eight becomes fifteen, fifteen becomes twenty-five. And without anyone making a conscious decision to keep using spreadsheets, the tool that worked perfectly at the start starts to quietly fail.

The interesting question is not whether spreadsheets eventually break. They do. The interesting question is exactly when, and what specifically goes wrong.

The 15-company threshold

There is a rough consensus in the fund admin space on where this threshold sits. Tamarix has noted that Excel-based tracking “works well for portfolios of up to 10-15 funds but becomes operationally limiting as portfolio complexity grows”. Most emerging managers raising a first fund of $5-12M end up with portfolios in this range, which means the threshold lines up with the typical lifecycle of an emerging fund. Below 15, a well-built spreadsheet is usually fine. Above 15, you start to feel weight you did not feel before.

That number is not magic. It reflects the practical limits of a single human keeping a complex data structure mentally and operationally accurate. Below the threshold, one person can hold every founder, every metric, every milestone in their head and reconcile it against the spreadsheet. Above the threshold, the mental model and the spreadsheet start to diverge, and reconciling them becomes a job in itself.

Spreadsheets do not break because the software is bad. They break because the operational model that worked for five companies stops working for twenty, and the spreadsheet was always a reflection of that model, not a substitute for it.

What actually breaks

There are six failure modes that emerging fund managers consistently report as portfolios grow past the threshold. Most funds hit several of them at the same time, which is partly why the transition feels sudden.

1. The KPI update cycle becomes a job

At five companies, requesting and ingesting monthly KPIs from founders is typically a couple of hours of work. At twenty companies, the same activity routinely consumes several days of GP time each month. Founders submit data in different formats, on different schedules, sometimes via email, sometimes via Notion, sometimes via a shared sheet they edited two weeks ago and forgot to update. The spreadsheet that was supposed to consolidate everything becomes the bottleneck.

The deeper problem is that what looks like a clerical task is actually a quality task. If KPIs are wrong, every downstream metric (fund-level performance, runway calculations, board reports) is wrong. The work scales linearly with portfolio size, but the time available to do it does not.

2. Reconciling cap tables becomes painful

Each portfolio company has its own cap table. Each cap table changes when there is a new round, a SAFE conversion, an option grant, or a secondary transaction. At five companies, the GP knows roughly when each event happens and can update the master spreadsheet manually. At twenty, the GP often only finds out about a SAFE conversion when reading a board pack.

The result is a portfolio model that drifts from reality. Ownership percentages, dilution forecasts, and fund-level return projections all become slightly wrong, and the only way to know how wrong is to re-check every cap table individually. Most GPs do not have time to do that, so they accept a margin of inaccuracy that grows quietly over time.

3. Runway forecasts become unreliable

Runway is one of the most important things a fund manager tracks. It tells you which companies need their next round soon, which need bridge support, and which have time to focus. At five companies, runway is a single column in a spreadsheet that you update with each monthly KPI ingest. At twenty, runway is twenty different conversations about cash position, burn rate, headcount plans, and revenue assumptions, all running in parallel.

The spreadsheet column does not capture any of that nuance. What used to be a useful indicator becomes a number that the GP knows is probably wrong but does not have time to verify. Important calls about who needs help most urgently get made on instinct rather than data.

4. LP reporting becomes a quarterly fire drill

LP reporting is where spreadsheet portfolios most visibly buckle. A quarterly update to LPs requires consolidating company-level performance, fund-level performance (TVPI, DPI, IRR, MOIC), capital account positions, commentary on individual investments, and forward-looking views on the portfolio.

At five companies, this can be done in a couple of days. At twenty, it can take two weeks of focused work, and the result is often a static PDF that is out of date the day after it is sent. LPs increasingly expect more frequent, more interactive reporting. The spreadsheet model cannot service that expectation.

5. The single-point-of-failure problem

Most emerging fund spreadsheets are owned by one person. Usually the founding GP. When that person is on holiday, ill, raising the next fund, or hiring an analyst who needs to be onboarded, the entire portfolio knowledge base is locked in a tool only they fully understand.

This is a real continuity risk that LPs increasingly ask about. The bigger your portfolio, the more institutional knowledge sits inside undocumented spreadsheet logic, and the more fragile your operation becomes.

6. AI flags and pattern recognition are impossible

This one is newer. The most useful thing a portfolio management system can do for an emerging fund manager is surface patterns the manager cannot see manually. Which companies are slowing down? Which are tracking ahead of their last update? Which have changes in headcount or revenue that warrant a check-in?

A spreadsheet cannot do this. It can hold the data, but it cannot tell you what to look at first. At fifteen plus companies, prioritisation becomes the GP’s biggest constraint, and the spreadsheet offers no help with it.

What fund managers actually do about it

There are three realistic paths once the spreadsheet stops working. Most emerging managers will end up somewhere between options two and three.

Path 1: Rebuild the spreadsheet properly. Some managers respond to the pain by hiring a specialist (an Excel consultant, an analyst with strong sheet-building skills) and rebuilding the model with proper versioning, named ranges, separate input and output sheets, and clear documentation. This works for a while. It typically extends the useful life of the spreadsheet by 12 to 18 months, after which the underlying problems return.

Path 2: Adopt a portfolio management tool. A growing set of tools exists specifically for this problem. Visible.vc, Rundit, Carta, Allvue, Tactyc, and several others all offer some combination of KPI tracking, fund modelling, LP reporting, and portfolio dashboards. Pricing varies widely, from a few hundred pounds a month for emerging-manager-focused tools to enterprise-grade platforms priced in the tens of thousands per year. The right choice depends on fund size, portfolio complexity, and which problem hurts most. Our piece on the hidden cost of VC portfolio management goes deeper into how to think about this trade-off. UK fund managers may also find the BVCA (British Private Equity & Venture Capital Association) a useful source of benchmarks and operational guidance specific to the UK market.

The category is more competitive than it was even three years ago, and that is good for buyers. A wave of newer entrants has pushed pricing down, reduced setup friction, and started to address things that the incumbent tools quietly accepted as fixed: enterprise-grade pricing for sub-£50M funds, slow migration from existing spreadsheets, dated user interfaces, and the absence of any real intelligence layer on top of the data.

What to actually look for in a portfolio tool

The market is mature enough now that fund managers should not have to compromise on the basics. The questions worth asking before choosing any tool:

The honest read is that the incumbents in this space have priced and packaged for funds at the upper end of the emerging manager range and above. That said, they have earned their position. Tools like Visible.vc and Carta have multi-year track records, established ecosystem integrations, and the operational maturity that comes from serving thousands of funds. For some funds, that incumbency is the deciding factor.

Where the trade-off shifts is for the £5M-£50M emerging manager segment specifically. Newer entrants are designed around the operational reality of running a small fund, and tend to win on price, migration friction, and the depth of AI-driven workflows. The category is changing fast enough that decisions made even two years ago are worth revisiting. Nire, the platform behind this blog, is one of the newer entrants built specifically for this segment, but it is one option among several worth evaluating depending on what matters most for your fund.

Looking for an alternative to Visible.vc, Carta, or Allvue?

Many emerging managers come to this question already evaluating one of the incumbents. Visible.vc is the most common starting point for funds in the £5M-£50M range. Carta is often considered because of brand familiarity from the cap table side. Allvue tends to come up when an LP suggests it, although its pricing typically rules it out for emerging funds.

The case for looking at alternatives in 2026 is mostly about three things: total cost of ownership over a five-year period, time to operational value (migration speed), and whether the tool has actually modernised the user experience in the last five years. Incumbents have advantages on track record and ecosystem integrations. Newer entrants tend to have advantages on price, migration friction, and the depth of AI-driven workflows. The right answer depends entirely on what matters most for the fund you are running.

Path 3: Build something custom. A small number of larger emerging funds end up building their own internal tooling, usually on top of Airtable, Notion, or a custom-built dashboard. This works if the fund has technical capacity in-house. It usually does not, and managers who go this route often regret the maintenance burden within two years.

The spreadsheet is rarely the problem. The data model underneath it is. Whatever tool replaces the spreadsheet will fail in the same way if the underlying way of tracking the portfolio does not improve.

The deeper question: what are you actually tracking?

The most useful exercise for emerging managers is not “should we switch tools” but “what would we track if the tool was perfect?”. Most emerging funds carry spreadsheet structures inherited from a previous job or a template downloaded years ago. They track what is easy to track, not what is most useful.

Before changing tools, it is worth asking:

• What three metrics actually drive my decisions about which companies need attention?
• What information would I want from a portfolio company every month if there was no friction in collecting it?
• What do my LPs ask about most often, and is my current reporting answering those questions or burying them?
• Which decisions am I making with intuition that I would rather make with data?

Answering these questions tends to clarify what kind of tool you actually need. Funds that change tools without changing their data model usually find themselves in the same position 18 months later, just with a bigger software bill.

When to make the change

The clearest signal that a fund has outgrown spreadsheets is when the GP starts dreading the operational rhythm of the fund. Monthly KPI ingest becomes a chore. Quarterly LP reporting becomes a fire drill. Board prep takes longer than the board meeting itself. These are not productivity problems. They are signals that the underlying tool is no longer fit for purpose.

Emerging managers who make the change at 12 to 15 companies, before the pain becomes acute, tend to find the transition smooth. Those who wait until 25 or 30 companies often find themselves trying to migrate under operational pressure, which is the worst time to do it. The spreadsheet does not get easier to leave behind as the portfolio grows. It gets harder.

The honest answer for most emerging funds is that the spreadsheet was always meant to be a starting point. The question was never whether to leave it. It was when.

Frequently asked questions

When should I move off spreadsheets for portfolio management?

The clearest signal is operational pain rather than portfolio size. If KPI collection takes more than a day per month, if you have lost track of an option grant or SAFE conversion in the last year, or if quarterly LP reporting takes more than three working days to assemble, you have outgrown the spreadsheet. Most emerging managers hit this point between 12 and 20 portfolio companies.

Do I need a portfolio management tool if I have under 10 companies?

Probably not yet. A well-built spreadsheet with proper structure, clear naming, and disciplined KPI collection can serve a fund through its first 8-10 investments without serious issues. The exception is if you are deploying quickly and expect to be at 15-plus within 12 months, in which case it is worth migrating early rather than under pressure.

How long does migration from a spreadsheet to a portfolio tool actually take?

It varies dramatically. Enterprise tools like Allvue or Carta typically involve a 4-8 week implementation with a customer success manager. Modern emerging-manager tools should let you import a spreadsheet and be operational the same week. Migration time is a useful proxy for whether the tool was built for the fund stage you are at.

What are the main alternatives to Visible.vc?

The closest direct alternatives for emerging fund managers include Rundit, Tactyc (more focused on fund modelling), Carta (more focused on cap table) and newer entrants like Nire. Allvue and similar enterprise platforms tend to be priced for larger funds. The right choice depends on whether your priority is KPI tracking, LP reporting, fund modelling, deal flow management, or a combination of all of them.

Can I just stay on spreadsheets longer if my fund is small?

Yes, and many do. The cost of staying on spreadsheets is operational time and the accuracy of decisions you make from the data. If your fund deploys slowly, your portfolio is concentrated, and your LP base is light-touch, spreadsheets can serve you well into a second fund. The cost rises sharply when you start deploying faster, taking on more LPs, or trying to scale the team.

This article is general guidance, not operational or financial advice. Fund management decisions depend on the specifics of your fund structure, LP base, and operational model. The tools and thresholds referenced are illustrative, not prescriptive.