Five signs your equity management has outgrown spreadsheets

Most companies manage their equity in a spreadsheet for far longer than they probably should.

It makes sense at the start – a simple cap table, a handful of shareholders, nothing too complex. But as the company grows, the limitations begin to reveal themselves. 

We’ve seen how the cracks tend to form at the worst possible time, such as during a funding round, an exit, or a question about ownership that you can’t answer with any reasonable conviction. And that’s far from ideal.

5 signs it's time to modernise your equity management

Let’s discuss five signs that your equity setup has outpaced the tools you're using to manage it, along with what to look for next.

1. No single source of truth for ownership

Most growing companies don't have a cap table so much as a collage of spreadsheets, shared docs, and email attachments containing shreds of ownership information. They might not agree with each other, let alone what's on file at Companies House.

Why this problem compounds 

Every equity decision sits atop the cap table, meaning option grants, dilution modelling, exit planning and investor reporting all depend on the underlying numbers being accurate.

Our own data shows that over half of businesses in funding rounds have cap tables that don't reflect reality. Nine times out of ten, the ones we encounter are broken in some way.

Rounding discrepancies is a good example. A small decimal error might seem trivial in the early days, but across several funding rounds, such mistakes can compound until nothing makes sense.

Rectifying often means engaging lawyers and accountants – an expensive hassle you want to avoid.

What to consider

This needs a proper structural fix so there’s one clean record that updates with share movements and stays aligned with Companies House.

This is exactly what Vestd's cap table is built to do. One source, always up to date, synced omnidirectionally.

2. Compliance is reactive, not embedded 

The Companies Act imposes a surprising number of equity-related obligations, all of which benefit from a strong equity system that backs them up. Some of the key requirements for scaling companies include:

• Cap table management: Maintaining an accurate, up-to-date record of who owns what. All equity decisions from fundraising to exits depend on these numbers being correct.

• Board and shareholder approvals: Formal resolutions are required to issue shares, grant options, and make changes to share structures. Missing approvals can invalidate transactions.

• Audit readiness: Keeping equity records organised and complete so they can withstand scrutiny during financial audits, fundraising, or M&A.

• Exit and transaction prep: Ensuring equity structures, option schemes, and documentation are clean and ready for a sale, merger, or IPO.

• HMRC notifications: Annual ERS returns for all share and option schemes must be submitted by 6 July each year.

These responsibilities affect both the company and its directors, and can carry serious consequences if handled incorrectly. As a result, they depend on reliable, well-maintained records.

Beyond fines and legal action

Anyone conducting due diligence on your company will review its filing history. If that’s an investor or a buyer, gaps or inconsistencies can slow things down or jeopardise deal closures.

As an aside: if you are planning any equity-related transactions, you might find our free compliance checklist helpful.

Inaccurate records could raise questions about fiduciary obligations and the reliability of the share register, option agreements, and related documentation. Over time, this can become a genuine “black mark” that’s tough to remove.

What to consider

Vestd embeds compliance into day-to-day equity management, with built-in HMRC notification workflows, automated email reminders, and integrated Companies House filings.

This benefits the company itself, as well as directors, finance teams, company secretaries, and anyone else responsible for managing equity.

3. No audit trail for equity decisions 

Every equity action – issuing shares, granting options, closing a deal – requires appropriate authorisation under the Companies Act.

These can include board resolutions, shareholder consents, pre-emption waivers, signed agreements, and records of consideration. These are legal requirements that need to be logged and retrieved on demand.

Spreadsheets don’t cut the mustard here because they can't robustly track who changed a figure, when, or why, and they have limited capacity to securely link out to files.

Plus, they offer little effective way to enforce approval workflows or control who has access to sensitive data.

A pattern worth noting

Here’s a particularly common problem we notice: a company files a confirmation statement and assumes that means the share register is current – but they haven’t completed the transfer instruments, e.g., stock transfer forms, that make changes legally effective.

The internal understanding of ownership then diverges from the legal position at Companies House, and the gap only comes to light when a third party starts digging.

With a handful of shareholders and one share class, it might slip under the radar. But with multiple share classes, an active option pool, and more active investor involvement, it can quickly become a material risk.

What to consider

Once your equity setup becomes more active, you need a solid audit trail to back it. It’s not just a compliance thing – it's the peace of mind that comes from knowing your records are accurate and accessible whenever you need them.

Vestd's platform is built around this principle, keeping governance documentation and equity records together in one seamless platform.

4. Equity decisions are running ahead of the information 

As companies scale, equity decisions become more frequent, and the ownership structure becomes more fluid. When that happens, founders, CFOs, and boards need clear, reliable information they can trust.

For example, checking how much option pool remains or modelling dilution from a proposed round is rarely straightforward in a spreadsheet. It's doable but slow, and probably not a task your team members will be queuing up for!

What to consider

Vestd's shareholder dashboards and scenario modelling tools offer a live view of the option pool, vesting schedules, and the potential impact of any dilution. It makes the difference between making equity decisions confidently and crossing your fingers.  

5. Due diligence exposes what's been missed

Due diligence is where the spreadsheet's limitations might hit you at precisely the wrong time.

Whether it's a funding round, an exit, or an acquisition, the due diligence process demands a robust record of ownership backed by supporting documentation.

It's essentially a stress test for your equity records. On the positive side, strong equity records and neat cap tables signal excellent accounting hygiene, which investors and acquirers love, while also reducing the legal cost of putting things right retrospectively.

What to keep an eye on

A common yet unspoken reason investment rounds and exits hit the rocks is that the equity structure doesn't survive formal analysis. Some key issues include:

• Missing filings: Share subdivisions, early share issues, or transfers that were never recorded at Companies House. These create discrepancies between what the company believes it has issued and what the public record shows.

• Unsigned or missing option agreements: Grants that were made but never properly documented, leaving the company exposed if a recipient disputes the terms or an investor questions enforceability.

• Undocumented board resolutions: Equity decisions that were discussed and actioned but never formally minuted, leaving no way to demonstrate that proper governance was followed.

• Rounding errors: As mentioned, errors compounding with investment activity until the share totals no longer add up.

• Dead equity: Former employees or shareholders who no longer contribute but remain on the cap table, sometimes retaining voting or information rights.

What to consider

A clean set of equity records, backed by a proper data room and a cap table reconciled against Companies House, means due diligence becomes a process of sharing what you already have rather than a race to reconstruct it.

If the prospect of a due diligence request makes you uneasy, this is the way to get ahead before it becomes expensive.

See how your equity setup compares 

If a couple of these signs are familiar, that's far from unusual. Most growing companies reach this point, and the anxiety around it is actually a sign of growth.

We built a diagnostic that assesses whether your setup supports growth or has any gaps worth addressing. Start your review here.