Every small business has a version of this problem. Someone fills in a spreadsheet. Someone else checks it. Something doesn’t add up. It goes back for corrections. Time passes, confidence erodes, and the people involved learn to work around the gaps rather than fix them. This post is about why that pattern is so common, what it actually costs, and what a business looks like when you remove it.
A promise to parents
I work with an 11+ tuition company that runs mock exams for students preparing for secondary school entrance. It’s a high-stakes environment – parents are invested, children are under pressure, and the company’s reputation rests in part on how quickly and accurately results get back to families.
Their commitment was 48 hours. Results in parents’ hands within two days of the exam.
On paper, the process was straightforward. Students sat the exam. Papers went to the invigilator. The invigilator logged scores into a spreadsheet – overall mark and each individual answer – and sent it to the client. The client checked it, re-entered everything into their main system, and generated the reports.
In practice, it was anything but straightforward.
What mock exam season actually felt like
Mock exams don’t run year-round. They cluster around key preparation periods – often around May, when bank holidays already compress the calendar. For this client, that time of year used to cast a shadow weeks in advance.
The admin load was significant on its own. But what made it genuinely stressful was that the data couldn’t simply be trusted. Invigilators are often temporary or contracted staff. They’re there to run the exam – to welcome students, maintain conditions, collect papers. The spreadsheet was an add-on to that job, and the results reflected it.
Errors crept in regularly. A score transposed. A question skipped. A total that didn’t match the individual answers beneath it. The client had built in their own workaround – asking invigilators to log both the overall score and each individual answer, then cross-checking the two. If the totals didn’t reconcile, something had gone wrong somewhere, and the back-and-forth to find it began.
That process ate time. And time, in a 48-hour window, is the one thing you haven’t got.
Why spreadsheets create this problem
It’s worth being direct about something: spreadsheets aren’t the villain here. They’re genuinely useful, easy to get started with, and most businesses reach for them first for good reason.
The problem is what happens when you hand one to someone and expect consistent, reliable output.
When you give someone a spreadsheet to fill in, you’re quietly taking on a set of responsibilities you might not have signed up for. You need to design it clearly enough that different people interpret it the same way. You need to protect the formulas. You need to anticipate how someone working quickly, under pressure, on an unfamiliar document will interact with it. In a lot of ways you’re doing the work of a software developer – just without the tools, and often without realising it.
And even when the spreadsheet comes back filled in, you can’t fully trust it. There’s no validation, no logic check built in. One of my other clients used to run quotes through a customised spreadsheet they’d built themselves – and still kept a calculator on the desk to check the totals. Because the spreadsheet had let them down enough times that trust in the output was never quite complete.
That’s the real cost of manual data entry. It’s not just the time it takes. It’s the verification work that follows, and the quiet anxiety that something has slipped through.
What the new system changed
The solution for the tuition company was to remove the spreadsheet from the chain entirely.
Invigilators now log into a system with their own username and password. They see only the exams assigned to them, with date, time and location. They click into an exam, see the list of students, and work through each one question by question. The answers are preloaded. They click the right answer – or mark no answer – and move on. One click. Next question.
There’s no spreadsheet to manage. No formatting to get wrong. No totals to calculate or cross-check. The system handles the verification automatically because the logic is built in – it knows what a complete, valid set of results looks like, and it won’t accept anything else.
When the invigilator finishes, the results flow directly into the reporting system. The client doesn’t re-enter anything. The reports generate. Parents hear within 48 hours.
What it meant for the client
This client started with a fairly basic system when we first worked together, and over the years we’ve built a lot of bespoke functionality around how they actually operate. The mock exam tool is one part of that.
What I know is that mock exam season used to be a period they dreaded – weeks of elevated stress, long hours, and constant checking on top of everything else the business demands at that time of year.
Now they occasionally take holidays during it. That’s not a small thing. That’s the difference between a period that owns you and one you simply move through.
The pattern behind the problem
What I’ve described here is specific to one business, but the shape of it appears everywhere.
Any business that relies on someone external – a contractor, a supplier, a temporary member of staff – to return information in a particular format is exposed to this problem. Any business where data moves through more than one pair of hands before it reaches its destination is accumulating risk at each handoff. And any business where the person checking the output has learned, through experience, that they can’t quite trust it – that’s a business carrying a cost that doesn’t show up on any invoice.
The fix is rarely dramatic. It’s usually about removing the steps where human error can enter, building the validation into the system rather than onto the person, and making the input so simple that doing it correctly is easier than doing it wrong.
Custom software is particularly good at this because it can be built around exactly how a specific business works – meeting the client where they are, rather than asking them to adapt to something generic. The result tends to feel intuitive, because it was designed around real people doing a real job.
Is this happening in your business?
If any of this sounds familiar – the spreadsheet that needs managing, the output you can’t quite trust, the workaround you’ve normalised – it’s worth getting a clear picture of where the risk actually sits.
The quiz below takes under two minutes and gives you a starting point for understanding what kind of bottleneck you’re dealing with.
Or if you’d like a proper look at how work flows through your business and where the gaps are, that’s exactly what the Systems Audit is for.
Find out more about the Systems Audit →
Alpha Labs builds bespoke software for businesses that have outgrown their current tools. Based in High Wycombe, working with founders across the UK.