When a Spreadsheet Stops Being Enough

Every business we audit has a spreadsheet doing something important. Units on the lot. Jobs this week. Who has paid. Which trailers need inspection. It is usually one file, usually on one person's laptop, and it usually works — right up until it does not.

In defense of the spreadsheet

Software people are snobby about spreadsheets and they are wrong to be. A spreadsheet is instant, free, requires no training, and can be reshaped in thirty seconds when the business changes. For a huge number of jobs that is a better fit than any product you could buy. If yours is working, leave it alone. Replacing a working spreadsheet with software is how businesses spend $5,000 to be slightly more annoyed.

The signs it has stopped working

There are a handful of specific failures that mean the tool has been outgrown, as opposed to just being untidy:

• Two people cannot use it at once without somebody overwriting somebody else, or a "final_v3_USE THIS ONE" copy appearing.
• It only lives in one place. The person in the field cannot see it, so they call the office to ask, and the office reads it out loud.
• The same fact lives in three files and they disagree. Now nobody trusts any of them.
• It needs a human to happen. Somebody types Sunday evening so Monday morning is accurate, and if they get sick the business goes blind.
• You cannot answer a simple question quickly. "What have we got that has been sitting over ninety days" takes twenty minutes of filtering.
• Mistakes cost real money. A mistyped stock number is one thing; a mistyped price on a quote is another.

One of these is normal. Four of them means the spreadsheet is now a liability rather than a tool.

Buy before you build

Before commissioning anything custom, go looking for a product. There are good, cheap tools for scheduling, inventory, invoicing, and job tracking, and if one of them fits, it will be cheaper and better supported than anything built for you alone. We say this to clients regularly and it costs us work, which is rather the point — a business that buys the right $40-a-month product and is happy is worth more to us than one that bought a build they did not need.

The honest test is whether the product fits your process or you would have to change your process to fit the product. Changing how you work to suit software is sometimes fine and sometimes ruinous, and only you can tell which.

When building is the right answer

Custom starts making sense in a few specific situations:

• The job is specific enough to your trade that nobody sells software for it.
• Every product you have tried does ten times what you need and charges per seat for the nine you do not use.
• The thing that makes your business work is exactly the part the product handles worst.
• You need two systems you already run to talk to each other, and neither vendor cares.

That is the territory custom business software is actually for — inventory that matches how your lot really works, quoting built on your real price sheet, a customer portal so people stop calling to ask for status.

Starting small on purpose

The way these projects go wrong is scope. Somebody decides that since they are building something, it should handle inventory and scheduling and invoicing and payroll. That build takes a year, costs a fortune, and gets abandoned.

The version that works picks one list — one core thing the business tracks — and does that properly. Trailers, or jobs, or quotes. Get it live, use it for a month, then decide what the second thing is. A tool that does one job right gets used every day. A tool that half-does five gets abandoned by March.