Service Contract Tracking: A System for Small Service Businesses

The quietest way to grow a service business isn’t finding new customers — it’s never missing a scheduled maintenance on the ones you have. HVAC, water treatment, elevators, heating: whatever your trade, maintenance contracts are your most predictable revenue. But a notebook that works at 15 customers fails at 60, because one missed filter change costs you both the revenue and the trust. Here are the five parts of a tracking system that actually holds.

Why the notebook breaks

The difficulty isn’t the number of jobs — it’s that every customer runs on their own calendar. One filter is due in March, another in April, a building’s HVAC service in May. A single list can’t carry that because:

• Every unit has its own interval: six months, a year, 3,000 running hours…
• One customer may have several units — you service one and forget the other.
• Visits get pushed: the customer says “not this month,” the date shifts, and if the note isn’t updated your system is lying to you.
• Renewal is a separate calendar: contract expiry is not the same thing as service due date.

The 5 parts

1. Records per unit, not per customer. The unit of tracking has to be the equipment: make, model, serial number, install date, location. One customer with three units means three separate schedules.

2. Interval and threshold. Every unit needs a defined “how often.” Sometimes the calendar is enough; often usage matters too (running hours, flow, mileage) — and the service is due when the first of the two arrives. It’s the same logic as tracking a vehicle by mileage and not just date, which I covered on the vehicle side.

3. Automatic reminders — in two stages. One for you, for planning (two weeks out). One for the customer, for scheduling (a few days out). A single reminder either comes too early to act on or too late to fit in the route.

4. The service record. For every visit: date, work performed, parts replaced, price, technician. That record does three jobs: it computes the next interval correctly, it becomes your evidence in a dispute, and it lets you tell a customer “we replaced that last spring.”

5. Renewal tracking. A warning at least a month before the contract expires. Renewing costs a fraction of winning a new customer — but a lapsed contract goes cold fast.

When a spreadsheet stops being enough

The honest line: a well-built sheet works up to roughly 20 units. Past that, three things break — reminders aren’t automatic (you have to remember to look), you can’t update it from a phone in the field, and history isn’t searchable. If you’ve crossed that point, the sheet is slowing you down.

Duevo is built for exactly this: customers and their equipment recorded separately, each unit tracked by date or by usage, overdue and upcoming jobs on one screen, with service records, pricing and contract renewals in the same place. It updates from a phone in the field, so “who did what” isn’t an evening reconstruction job.

Frequently Asked Questions

Why is a maintenance contract good for the customer? Planned maintenance is cheaper and less disruptive than waiting for a breakdown, and contract customers typically get priority service and better parts terms. That’s also your easiest sales argument: you’re selling predictability, not cost.

How should the system handle a postponed visit? Enter the actual date, and compute the next interval from that date. The most common mistake is servicing in May while the calendar still advances from March — a year later, two visits collide.

How many customers before software becomes necessary? There’s no exact number, but the practical threshold is around 20 units. The real test: if you scan a spreadsheet weekly asking “whose service is due?”, you’re carrying the system instead of the system carrying you.