Replacing Spreadsheets and Retyping With One System: What's Involved

What retyping really costs

At Classic Towing, every recovery job produced an invoice and then a formal report for the insurer. The same rates were typed out again, the hours on site applied one by one to every person and every machine, storage worked out afresh on every reissue. Then the whole thing was written up a second time for the report. It was the most tedious work in the business and the most exposed to a slip of the finger.

At The Armstrong Clinic, partner practice bookings used to mean emails, spreadsheets and patient lists retyped by hand. At Loxwood Sports, the same member information was kept in more than one system and checked in both.

The cost is rarely one big failure. It's hours every week, spread across people who'd rather be doing something else, and the occasional mistake that reaches a customer.

"If a number is typed twice, sooner or later it will be typed wrong once."

Step one: find every place information is typed

Replacing spreadsheets starts with mapping them, not with software. Where does each piece of information first enter the business? Where is it copied to, and by whom? Which documents are built from it? The first thing our written plan covers is where the business loses time today, and this is usually where most of it goes. That mapping happens in our free discovery stage, before anything is agreed.

Step two: decide where each fact lives

The aim is that every fact is entered once and lives in one place. At Classic Towing, every rate the company uses, from recovery equipment and certified personnel down to individual absorbent products, is now stored once as a reusable line item. Times are entered once, and the hours on site flow into every charge billed by the hour, so correcting a finish time updates the whole invoice rather than thirty separate figures.

Once facts have one home, everything else can be calculated from them rather than transcribed.

Step three: build the documents from the data

Most retyping exists because a second document needs the same figures as the first. The fix is to generate one from the other. Classic Towing's report writer imports the finished invoices and turns them into the formal report that goes to the carrier. The figures in the report are the figures on the invoice, because they're the same figures.

The same goes for reporting. Loxwood's board now has eighteen reports a few clicks away, all drawn from the same records, so they can't contradict each other.

Step four: connect what already works

Replacing spreadsheets doesn't have to mean replacing every tool. Often the better answer is to connect the systems you already pay for so that information flows between them. The Armstrong Clinic platform writes patient answers straight onto their OxygenRX record instead of anyone copying them across, and takes payments through Stripe.

Step five: keep the spreadsheet where it's useful

Spreadsheets are good at analysis and sharing, so the aim isn't to ban them. It's to make them an output rather than the source. At The Armstrong Clinic, every client and every clinic exports to a spreadsheet on request, which is the governance record a practice or a regulator will ask for. The difference is that nobody maintains it by hand.

What the project looks like

After discovery, we write a plan covering the features, the security model, how people will use it and what it connects to. You sign off the scope before any development starts, and you get a fixed quote with it. A focused web platform typically takes 6 to 10 weeks, and you see the work at staged reviews along the way. More on that on our custom software development page.

The result at Classic Towing was invoicing and insurance reports that took the better part of an afternoon now take minutes. At Loxwood, three systems became one. Neither business changed what it does. They just stopped typing it twice.