Home

About Us

How We Help

Our Charges

Wills & Trusts

Blog

FAQ

Documents & Policies

Contact

The curious case of the phantom spreadsheet

by | Sep 9, 2025

Somewhere in the forgotten corners of the financial universe, just beyond the reach of logic or mercy, lies the Phantom Spreadsheet...

You may have met one yourself. It usually has a name like “Plan2020_v2_FINAL_USETHIS”, though it’s rarely final, seldom usable, and never—ever—simple. It has fourteen tabs, of which eleven are hidden. Every formula refers to a cell on another sheet that, in turn, refers to something called “Old Drive (Z:)”. No one knows what Z drive is, let alone where it went. Possibly Devon.

Opening one of these spreadsheets feels like unearthing an ancient manuscript. Numbers appear, disappear, and reappear depending on whether you have macros enabled and the moon is in Virgo. It calculates a pension forecast for 2056, an ISA allowance for 2009, and your state pension age if you were born as a sea turtle.

And yet… it persists.

 

We’ve All Been There

If you’re nodding along, you’re not alone. Many of our clients come to us with financial spreadsheets they’ve built (or inherited) over the years. Some are masterpieces—meticulously labelled, colour-coded, and capable of calculating marginal tax rates in seconds. Others are held together with duct tape, good intentions, and the fervent hope that “dragging the formula down” hasn’t broken the whole thing.

We admire the effort. Truly. These spreadsheets are the product of people who’ve taken their finances seriously, who’ve tried to make sense of a complex world, who’ve thought deeply about the future. And they’ve probably been at it since interest rates were still above 1%.

But here’s the thing: there comes a time when the spreadsheet has done its job, and it’s time to move on.

 

Spreadsheets Are Great… Until They’re Not

To be clear, spreadsheets aren’t the enemy. They’re brilliant. Excel is the Swiss Army knife of the office world—infinitely flexible, endlessly capable, and almost always misused.

But when it comes to retirement planning, investment forecasting, or making decisions about intergenerational wealth, Excel begins to show its age.

It can’t model real-time tax legislation.
It doesn’t update market returns automatically.
And it definitely doesn’t warn you when the cell that says “net worth” is actually showing your electricity bill from 2016.

Most importantly, a spreadsheet doesn’t give advice. It doesn’t say, “Have you considered what would happen if inflation stayed at 3% for five more years?” or “Is your income plan still on track if you stop working at 63 instead of 65?” It just calculates what it’s told—accurately, yes, but without judgement or context.

 

Where GSI Comes In

That’s where we come in.

At GSI, we’ve replaced the Phantom Spreadsheet with planning tools that are accurate, flexible, and—importantly—understandable. Tools that model income and expenditure over decades, show the effect of market changes, and help you visualise your goals with clarity, not confusion.

We don’t just build models—we build plans.
We don’t just forecast growth—we help manage risk.
And we definitely don’t rely on Z drive.

Your financial plan shouldn’t live in a file you’re afraid to open. It should live in conversations, in regular reviews, and in clear, actionable steps. It should reflect your real life—not a tangle of outdated assumptions and formula errors.

 

The Emotional Weight of Spreadsheets

Let’s also acknowledge something rarely said: for many people, spreadsheets are emotional. They represent control. They represent work done, time spent, care taken. They hold not just numbers, but stories—of careers built, families supported, futures dreamed about.

So when we suggest retiring your spreadsheet, we don’t mean discarding it like an expired receipt. We mean honouring what it’s done for you—and letting it rest, like a well-worn garden spade, while we take things forward with tools that are designed for the job ahead.

 

The Moral of the Story

If your financial plan still lives inside a labyrinthine Excel file titled “Plan (maybe) – version 5 – WORKING COPY”, it might be time for a conversation.

We’re not here to mock the spreadsheet. We’ve all used one. (We’ve got a few buried in the GSI archives that we won’t talk about publicly.)

But your financial life deserves more than a spreadsheet. It deserves clarity, confidence, and a plan that evolves as you do.

So bring us your Phantom Spreadsheet. We’ll have a cup of tea, translate it together, and build you something better. Something that doesn’t rely on a forgotten formula in cell BA276 or a hyperlink to your old workplace pension portal from 2003.

Because when it comes to your future, you shouldn’t need to press F9 and hope for the best.

 

Disclaimer

This content is for general information only and does not constitute financial, legal, tax, or investment advice. The value of investments can fall as well as rise, and you may not get back what you invest. Tax treatment depends on individual circumstances and may change.

GSI Wealth Management has been appointed as a distributor of services offered by Mitchell & Mitchell Asset Management Ltd, which is authorised and regulated by the Financial Conduct Authority (FCA no: 992402). GSI does not act as an authorised representative of Mitchell & Mitchell. All views reflect GSI’s opinion at the time of writing. No personal liability is assumed by any contributor. We take care to ensure accuracy but accept no responsibility for loss from reliance on this material.

Data is managed in line with UK GDPR and the Data Protection Act 2018.

 

Shares
Share This

Add an admin note