Spreadsheets are not the problem people say they are
A well-kept spreadsheet has run many profitable HVAC companies, and it has real virtues: it costs nothing, it does exactly what its owner wants, and it can be changed in seconds without asking anybody.
The honest case for moving on is not that spreadsheets are unprofessional. It is that they have specific limits, and once a business crosses them the spreadsheet starts producing confident wrong answers rather than failing visibly.
The four signals
Each of these is a structural limit rather than a matter of discipline.
- Two people need to change it at the same time. The moment the schedule has to be edited by a dispatcher and read by the field simultaneously, a file becomes a bottleneck or a set of divergent copies.
- Nobody trusts the schedule. When people start ringing to check what the sheet says, the sheet has stopped being the source of truth and is now a second thing to maintain.
- Finding job history takes minutes, not seconds. 'What did we do on this unit last year' should be instant. When it requires searching several files, the history effectively does not exist.
- Finished work goes unbilled. Not through dishonesty, through the absence of a list. The symptom is usually discovering an unbilled job months later and wondering how many others there were.
What actually breaks first
Almost always scheduling, because it is the thing multiple people need at once. The invoice list tends to be next, because it depends on somebody remembering.
Equipment history is usually the last to be missed and the most expensive to have lost, because it cannot be reconstructed. Years of readings nobody captured are simply gone, and the only remedy is starting now.
Moving without stopping work
The mistake is treating it as a migration project: clean every customer record, enter every asset, then go live. That takes months, the data is never clean enough, and the business loses patience before the benefit arrives.
The approach that works is to start with today's work and let history accumulate. Put new jobs in from day one. Capture each unit properly the next time somebody visits it. Bring customer records across as they come up. Within one maintenance cycle the sites that matter are complete, and nobody stopped working.
The hidden cost of staying
Spreadsheets appear free, and the cost shows up elsewhere: time spent reconstructing what happened, second visits caused by missing information, work completed and never invoiced, and the history that was never captured and now cannot be.
None of those appear as a line item, which is why the comparison usually gets made against a subscription price rather than against what the current approach is actually costing. Count the unbilled jobs from the last quarter before deciding either way.
What to do in the first month
Put every new job in from day one, without exception, because a partially adopted system is worse than either alternative: now there are two places to look and neither is complete.
Capture each piece of equipment properly on its next visit. Move customers across as work comes in for them. Leave the old spreadsheet readable but stop writing to it on an agreed date, and make that date explicit rather than letting it drift, because the drift is where the confusion lives.
What to keep from the spreadsheet way of working
Spreadsheets teach good habits worth carrying over: everything visible on one screen, no hidden state, and the ability to see the whole picture at once.
If new software makes it harder to answer a question you could previously answer by scrolling, that is a real loss and worth raising rather than accepting. The point of the change is more answers, faster, not a more professional-looking way of knowing less.