Every practice I’ve come across has one. It’s usually called something like “Client List FINAL v7 (use this one).” It’s colour-coded in a way only its creator understands. And somewhere at the bottom there’s a tab called “OLD – don’t delete” that nobody has dared to open in years.
Let me be clear: I like spreadsheets. Most firms were started on one. If you’ve got thirty clients and two people in the office, there’s no reason to change. The trouble is that spreadsheets don’t fail loudly. They just get slower and messier, one extra column at a time. You only notice how much you’ve been relying on them when something goes wrong in the middle of January.
So let’s go through the signs. I’ve put them roughly in the order most firms notice them. Annoyingly, that’s also the order in which they get more expensive.
1. Only one person really understands the file
This one creeps up on you. Someone builds the tracker and adds their own shortcuts. Over a couple of years, they become the only person who can read it properly, and everyone else just asks them.
That’s fine until they’re off sick for a week in January and nobody can tell which returns are still waiting for client sign-off. If you’ve ever had to ring a colleague on holiday to ask what “amber with a dot” means, you’re already here.
2. Clients are telling you about deadlines
When the knowledge lives in one person’s head, deadlines are the next thing to go. You usually find out the worst way possible: a client calls asking why HMRC has written to them about a £100 late filing penalty.
Plenty of practices quietly pay that penalty themselves to keep the client happy. I understand why. But if it’s happened more than once this year, the spreadsheet is costing you real money.
It’s also about to get busier. With Making Tax Digital for Income Tax, a sole trader or landlord who used to have one deadline a year now has four quarterly updates and a final return. A “due date” column can’t nudge anybody. It only works if someone remembers to check it, on the right day, for every client.
3. Your inbox has become the filing cabinet
Deadlines slip partly because the information you need is so hard to find. Most practices I talk to tell the same story. A client sends bank statements as six attachments over three emails. Someone needs the March statement, finds two slightly different versions, and has to email the client to check. Meanwhile, three drafts of the accounts are in circulation, and nobody is completely sure which one was signed.
That’s annoying, but I’d worry more about the data protection side. Bank statements, payslips and passport copies are exactly the kind of personal data UK GDPR expects you to look after carefully. Spread across personal inboxes, downloads folders and a shared drive anyone can open, they’re one lost laptop away from a very awkward conversation with your clients, and possibly with the ICO.
4. Half the team meeting is people asking for updates
When documents are scattered, so is everyone’s sense of where the work is. You can hear it in the Monday catch-up: “Has Smith & Co sent their records?” “Did anyone chase the Patels?” “Who’s got the Jones VAT return?” Twenty minutes later, everyone knows what’s happening, but nobody has done any of it.
What worries me more is what the spreadsheet doesn’t show. It won’t tell you that one person has twice as many open jobs as everyone else. Partners tend to discover that when the person is burnt out or handing in their notice.
5. Onboarding means typing the same details again and again
New clients should feel like good news. In a spreadsheet-run practice, they also mean a fair bit of retyping. The name, address and UTR go into the client list. Then they go into the engagement letter, then the AML and ID records the Money Laundering Regulations require you to keep, then the billing sheet, and finally the tax software.
Each time, there’s a chance of a wrong digit or an old address, and none of it is billable. Honestly, I’d call this the most underestimated cost of running on spreadsheets, because nobody times it. It’s ten minutes here, fifteen there. Over fifty new clients a year, that adds up to several days of qualified staff copying and pasting.
6. You’re saying no to work you actually want
All of that adds up to the sign that tends to hurt the most. A good referral comes in last February, and you hear yourself saying, “We’d love to, but not until after the busy season.” Or you start drafting a job advert and realise the new hire would mostly be updating trackers and chasing paperwork.
At that point, the spreadsheet is deciding how big your practice can get. That’s a strange thing to let a file decide.
So what do firms switch to?
Here’s the encouraging part. The practices I’ve seen make the move weren’t after anything clever. They wanted every client’s details in one place, entered once. They wanted reminders and document requests to go out on schedule, and clients to upload files through a secure portal instead of sending them to whichever inbox they last used. Most of all, they wanted to open a screen on Monday morning and see where every job stands without asking anyone.
Most of that is what practice management software for UK accountants is built for. TaxDome, for instance, keeps client records, reminders, the client portal and job workflows in one place, instead of spread across five different files.
Spreadsheets don’t vanish, by the way. You’ll still want them for cash flow forecasts, quick calculations and checking a set of figures. They just stop being the thing holding the whole practice together.
Where I’d start
Don’t try to fix all six at once. Firms that attempt a big-bang switch in the run-up to January usually give up halfway. Look back over the last year and be honest about which sign cost you the most: a missed deadline, a lost document or a referral you had to turn down. Start there, ideally in the quieter months after the January rush. Then move the rest across once the team has seen it working.
