Playbooks
Spreadsheets aren’t the problem, retyping is: start where the same detail gets keyed twice
Spreadsheets get the blame, but the real cost is typing the same detail into more than one place. Every retype takes time and invites mistakes. Find where it happens in your business and start there: it’s the cheapest fix with the clearest payback.
By Seb Lawson · 26 October 2026 · 4 min read
What slows most growing businesses down is retyping: the same customer name, address, price or job reference keyed into two, three or four different places. Every retype costs a few minutes and carries a chance of a mistake, and the copies drift apart over time. Find where it happens in your business and start fixing there. It’s usually the cheapest place to start and the place you’ll notice the difference soonest.
Spreadsheets get blamed for a problem they didn’t cause
A spreadsheet is a good tool. It’s flexible, everyone knows how to use one, and your team probably built theirs to fill a gap the official software left.
The trouble starts when the spreadsheet is one of several places the same information lives. The client is in the CRM, in the job tracker, in Xero and in an email thread, and each copy was typed in by hand. Swapping the spreadsheet for another piece of software doesn’t fix that. You just end up retyping into something more expensive.
Every retype costs time and adds a chance to get it wrong
The time is the obvious cost. As a worked example: if an office manager spends 10 minutes copying each new job from the quote into the job sheet and then into Xero, and the firm does 25 jobs a week, that’s over four hours a week, roughly half a working day, spent typing things that were already typed.
The mistakes cost more. A digit wrong in a phone number, a postcode copied from the wrong line, a price from last year’s list. Most get caught. The ones that don’t send an engineer to the wrong address, or bring an invoice back disputed, or turn a profitable quote into a loss.
Then there’s drift. Change a client’s address in one place and the other three copies are now wrong. Nobody’s quite sure which version is right, so people check. They ring the office, scroll back through emails, open the spreadsheet to confirm what the CRM says. That checking is part of the cost of retyping too, and it adds up quietly.
How to spot where the same detail gets keyed twice
You don’t need outside help to find it. Pick one ordinary piece of work, such as a job, a new client or an order, and follow it from first contact to payment. At each step, ask:
- Where did this information come from? If the answer is “I typed it in from that other screen”, you’ve found a retype.
- Is this already written down somewhere else? Names, addresses, prices, dates and reference numbers are the usual suspects.
- What gets copied across at the end of the week or month? Timesheets into payroll, jobs into invoices, sales figures into a report for the owner.
- Which spreadsheet is updated from another system? If someone exports, pastes and tidies, that’s retyping with extra steps.
Write each one down with a rough count of how often it happens. You’ve probably found a big one if there’s a person whose job is mostly copying, a regular afternoon set aside for “admin”, or a spreadsheet column headed “entered in Xero?”.
Start with the retype that happens most and touches money
Once you have the list, start with the retype that happens most often and has money attached. That’s typically the hand-off from quote to job, or from job to invoice. Fixing it means the details are typed once, where they first arrive, and then flow to everywhere they’re needed.
There are good reasons to start here instead of with a bigger idea:
- It’s small and clearly defined. You know exactly what fixed looks like: nobody types this again.
- The payback is easy to see. The hours come back and the mistakes stop.
- It builds trust. When the team sees one tedious task disappear, they start pointing out the next one.
- It lays the groundwork. Joining up quotes and jobs means the customer record is clean, which makes every later piece easier.
Joining up keeps your tools and removes the copying
Fixing retyping rarely means replacing the tools you use. Your Xero stays. Your Microsoft 365 or Google Workspace stays. Often the spreadsheet can stay too, if the team likes it, as long as it reads from the same source instead of being typed into by hand. What changes is that your tools share one record of each customer and each job, so a detail entered once shows up wherever it’s needed.
That’s the heart of what a joined-up system does. We follow two jobs through one, end to end, in what one system changes. And if you’re wondering whether to fix this with a product you can buy, build or buy covers how to decide.
Our recommendation: spend half an hour hunting retypes this week
Follow one job through your business this week and list every retype you find. Rank them by how often they happen and whether money is involved. Start with the one at the top, and leave the rest until that one is fixed.
If you’d like a hand, book a review. Bring your list, or just describe one job, and in 30 minutes we’ll show you where the retyping is and what fixing the worst of it would involve. You can also build your system to show us the tools you use now.