Commerce

Old Records, One System: What Small Service Firms Weigh When They Consolidate Decades of Files

For water treatment, HVAC and roofing businesses, handwritten cards, spreadsheets and phone photos hold the company's memory, and moving them into one place takes planning.

The American Intelligencer standing plate
From the pages of The American Intelligencer.

Ask the owner of a long-running water treatment, HVAC or roofing company where the business is kept, and the honest answer is often scattered. Some of it sits on handwritten service cards in a truck or a binder. Some is in a customer list exported from accounting software. Some is in a filing cabinet of warranty paperwork, and a good deal of it is in the camera rolls of technicians' phones. The company runs on that information, but no one can see all of it at once.

The question of how fragile older systems can be has been in the news. ABC News reported that President Trump blamed a ground stop on old technology that had a "heart attack," and that Friday's ground stop resulted in thousands of cancelled flights. A national aviation system and a ten-employee roofing firm are very different operations, and nothing in that report speaks to small businesses. But the general lesson carries over: aging systems can be tolerated for years, and the cost of relying on them shows up all at once when they fail.

Why the old records matter

For a service company, the customer file is the product's memory. Three uses stand out.

Repeat maintenance. Water treatment and HVAC work often depends on recurring visits. Knowing which customers are due for a filter change, a seasonal tune-up or a system check depends on knowing what was installed, when, and what the technician noted last time. If that lives on a card in a binder, the schedule depends on whoever remembers to flip through it.

Warranty claims. A manufacturer's warranty usually turns on documentation: the model, the installation date, the serial number, and proof the equipment was serviced as required. A roofing contractor may face a question years after a job about what materials were used and who did the work. A claim can stall when the paper cannot be found, and the customer relationship can suffer with it.

The value of the company. Owners who think about selling, or about handing the firm to a family member or key employee, tend to learn that a buyer wants to see the customer base, the recurring work and the history behind it. A business whose records are incomplete or live in one person's head is harder to value and harder to transfer. That is an observation about how buyers generally evaluate businesses, not a prediction about any particular sale.

What the move usually involves

Consolidation tends to follow a rough sequence, though every firm's version differs.

The first step is an inventory: listing every place customer and job information lives, including the informal ones such as text threads and personal phones. The second is deciding what the single system must do. A firm that mainly needs scheduled maintenance reminders has different requirements than one that needs to attach photos and warranty documents to each job. Some owners choose off-the-shelf software, and others look at custom-built CRM software for owner-led firms when their workflow does not fit a standard template. Either route calls for the same discipline about what goes in.

The third step is cleanup. Duplicate customers, misspelled addresses, and the same household listed under two names all need to be reconciled before records are moved, because errors carried over become errors in the new system. The fourth is the transfer itself, which may mean data imports for spreadsheets and manual entry or scanning for paper. Scanned cards are searchable only if someone also enters the key fields, such as equipment type, install date and service interval. Finally comes a period of running old and new side by side, so that gaps surface before the old records are put away.

Common mistakes

Several errors recur when owners describe these projects.

Trying to move everything. Not every old card deserves digitizing. Many firms do better to bring over active customers and equipment still under warranty first, then work backward as time allows.

Skipping the field staff. If technicians find the new system slow or awkward, they will keep using notes and personal phone photos, and the company ends up with two systems instead of one. Asking the people who do the work what they need is cheaper than retraining habits later.

Leaving photos behind. Job photos on personal phones are easy to forget, and they often serve as the best evidence of how work was done. Deciding in advance where photos go, and how they are tied to a customer and a job, matters more than the tool.

No single owner of the project. Consolidation stalls when it is everyone's side task. Someone needs to be responsible for the schedule, the cleanup rules and the decision about what counts as done.

Discarding originals too soon. Warranty and contract paperwork may carry legal or contractual weight. Owners with questions about what they must keep, and for how long, should ask their attorney or accountant rather than guess.

Neglecting backups and access. A single system is a single point of failure if no one has planned for backups, and for who can log in when the person who set it up is away. The point of consolidating is to reduce the risk of the old arrangement, not to swap it for a new one.

A slow job worth doing

None of this is glamorous, and it rarely feels urgent until a warranty claim cannot be documented or a prospective buyer asks for the history. Owners who start by inventorying what they have, choosing what the system must do and cleaning before they move tend to find that the records they already hold are worth more than they assumed. The work is mostly patience.