Managing maintenance contracts in a small trades business

Answer

A maintenance contract ties one customer’s assets to a recurring service interval, and the job of managing it is keeping three things in sync: which assets are covered, when the next service on each falls due, and when the contract itself has to be renewed or can be cancelled. The moment a business runs more than a few dozen of these, a spreadsheet stops telling you what is due next — because a spreadsheet does not calculate a due date and does not remind anyone. Managing contracts well means recording them once, letting the interval drive the next date, and getting a warning before every deadline.

What a maintenance contract actually holds

Strip a maintenance contract back to what you have to track and it is short:

The customer and their contact — the property manager, owner or caretaker you deal with.
The covered assets — the specific heating system, heat pump, ventilation unit or lift the contract applies to. One contract can cover several assets on one site.
The maintenance interval — how often each asset is serviced (for example every 12 months). This is the number the whole schedule hangs on.
The term — start date, and either an end date or “open-ended”.
The cancellation deadline — the notice period, so the contract does not renew silently or lapse unnoticed.
Commercial conditions — the agreed price or scope, kept as a plain note.

Everything else is history: the services already carried out and the reports that prove them.

From the contract to the due date

The interval is worth nothing on its own — it becomes useful the moment it produces a date. The rule is simple: last completed service + interval = next due date. Service a boiler on 15 January with a 12-month interval and the next service is due the following 15 January. When you document that service, the clock rolls forward on its own and the next date appears.

This is the single mechanic that a manual list cannot reproduce. In a spreadsheet you type a date, and it sits there. Nothing recalculates when you finish a job, nothing moves the next entry forward, and nothing warns you as the date approaches. You have to remember to look — for every asset, every month.

Don’t forget the contract’s own deadlines

Most missed obligations are not the service itself but the paperwork around the contract. A fixed-term agreement with a three-month notice period will renew automatically if nobody acts in time. Treat the cancellation deadline and the contract end the same way you treat a service date: as a deadline with a lead time, so you get a reminder before it matters rather than a surprise after.

The same applies to statutory checks. A lift or a fire-protection system carries a legal inspection deadline that is independent of any maintenance contract — see Legal inspection deadlines. Track those separately, on the asset, not buried in a contract note.

Where a spreadsheet stops working

A spreadsheet is a fine start and a poor system. As the portfolio grows it fails in predictable ways:

No calculation. Due dates are typed, not derived — so they are only as current as the last person who edited the row.
No reminder. The list is silent; you find out something was due when the customer calls.
No history per asset. You can see the current row, not “what was done to this heat pump over the last five years”.
One editor at a time. Two people, two versions, and the discipline breaks the week someone is on holiday.

None of this is a criticism of the person keeping the list. It is the tool asking a human to be the reminder engine.

Moving your contracts across, step by step

You do not have to re-type years of records to get out of the spreadsheet:

Export your existing customer and asset list from Excel or your current tool to CSV.
Import it — customers and their assets in one pass — and let the intervals map across.
Set the “last service” date on each asset so the first due date is calculated correctly from real history.
Add any inspection deadlines (lift, extinguisher, smoke alarm) as their own tracked dates.
Turn on reminders with a lead time that fits your planning — typically 30 days before due.

From there the schedule maintains itself: you document a service, the next date rolls forward, and the reminder arrives in good time.

How Gewerkly helps

Gewerkly is built around exactly this loop. You record a customer, their assets and a maintenance contract with an interval; it calculates the next due date, warns you before it arrives, and — when you document the completed work as a maintenance report — rolls the date forward and generates a PDF you can hand or email to the customer. Contract end and cancellation deadlines are watched the same way. It manages the maintenance; it does not do invoicing, quoting or a customer portal. See what it covers on the features page.

FAQ

Do I need a separate contract for each asset?

No. One maintenance contract can cover several of a customer’s assets on the same site, each with its own interval if they differ. The contract groups the agreement; the schedule still runs per asset.

What happens to the schedule when a contract is paused or ended?

Pausing a contract stops new due dates and reminders for its assets until you resume it; ending it stops new dates but keeps the full history. Nothing you have already documented is lost.

Can an asset be tracked without a contract?

Yes. An asset can carry its own maintenance interval and be watched — with a due date and reminder — even if there is no formal contract behind it. The contract is optional; the interval is what drives the schedule.

How do I move off my current spreadsheet?

Export your customers and assets to CSV and import them in one pass, then set each asset’s last-service date so the first due date is correct. You keep your history without re-typing it.

Sources

Gewerkly product documentation — maintenance contracts, intervals, reminders, import/export and reports.
General maintenance-management practice for recurring service agreements in the building-services trades.

Boilerplate

Gewerkly is the maintenance software for small SHK and building-services trades that keeps any of their customers’ maintenance contracts from slipping through. Contracts, assets and deadlines live in one place and every due date is flagged in good time. Try it free for 14 days, no credit card — see pricing.