Boiler Service Reminder Excel - Free Template

1. Open the Service Schedule sheet and enter each customer’s name, address, boiler make, model and serial number. Add the last service date and service interval in months.
2. Check the next service due date and days until due for each row. Use the reminder status to sort urgent jobs first.
3. Fill in the service engineer, service cost and VAT rate where needed. The total cost fields let you keep the pricing together with the service record.
4. Use the Reminder Sent? column to mark when you have emailed, phoned or texted the customer. Add any follow-up notes in the final column.
5. Open the Reminder Dashboard to review which jobs are due soon, overdue or completed. Use it as your daily planning view.
6. Record each reminder on the Reminder Log sheet so you can see what was sent, when it was sent and what action is still pending.

This template suits the heating engineer who services 20 domestic boilers a month, the office manager at a small plumbing firm, and the landlord keeping a few rental properties in order. When you have 40 or 50 annual service dates to chase, a missed reminder can push a job into the heating breakdown season and cost you a booking worth £85 to £120.

Who uses it and when

You normally reach for this at the start of the month, before the diary fills up, or in the run-up to autumn when boiler calls spike. A sole trader with 120 service customers can use the schedule to sort jobs due in the next 30 days, while a firm with 4 engineers can split the list by engineer and postcode.

What image 1 and image 2 show

Image 1 shows the Service Schedule with one row per customer and columns for boiler make, model, serial number, fuel type, last service date, service interval and next service due. Image 2 shows the Reminder Dashboard, which is the place to see due and overdue work at a glance before you start ringing round.

A simple worked example

If you service 18 boilers in a week at £90 each, that is £1,620 of billable work. Losing just 2 of those because a reminder was missed means £180 gone, and the calendar often stays empty until the next available slot.

If you are a sole trader, keep your records for 5 years after the 31 January Self Assessment deadline for that tax year. If you run a limited company, keep business records for 6 years, which covers service history, invoices and reminder logs linked to your accounts.

VAT and pricing fields

The sheet includes service cost, VAT rate, VAT amount and total cost. That matters because standard-rate VAT is 20%, so a £95 service charge gives £19.00 VAT and a £114.00 total; if you are not VAT-registered, you would leave the VAT fields unused.

Why due dates matter in practice

The next service due date is built from the last service date plus the service interval in months. If the boiler was last serviced on 10/01/2026 and the interval is 12 months, the next due date is 10/01/2027, which is the sort of date you want visible before the winter diary fills up.

Record-keeping discipline

Keep the reminder log with the schedule so you can show what was sent, when it was sent and who responded. That is useful evidence if a customer says they were never contacted and you need to show a clear chase history.

The usual failure is not the boiler record itself; it is the missing reminder. If you have 60 annual services and 10 are left to memory, you will lose time every month re-checking old invoices, phone notes and WhatsApp messages.

Wrong dates and weak notes

A date entered in the wrong format, such as 01/10/2026 when you meant 10/01/2026, sends the reminder at the wrong time and can create a false sense of security. In a small firm, one missed service at £110 plus VAT is not a disaster, but six missed reminders across a season can easily mean £660 of lost turnover.

No reminder status means no control

If you do not mark whether a reminder has been sent, you end up double-contacting customers or missing them altogether. That leads to extra admin and awkward calls, especially if you are trying to fill a van route for one engineer across 15 postcodes.

Image 3 helps stop the drift

Image 3 shows the Reminder Log, which is where the history is kept instead of buried in inboxes. A log of 40 sent reminders, with dates and outcomes, is enough to prove who was chased and when.

Cost of waiting too long

A boiler left until it fails may turn a planned £90 service into a £180 emergency call-out, but only if you have the diary space. Good reminder control keeps the annual service work in the ordinary week, not in a panic slot at 7.30pm.

Use the schedule every Friday afternoon or first thing Monday morning, before you start new bookings. That gives you a fixed habit, and it is better than checking dates only when a customer rings you.

Three habits that keep it alive

• Review all jobs due in the next 30 days and ring or email those customers first.
• Copy forward the Reminder Log entries each week so you keep a clear trail of contact.
• Sort by Reminder Status so overdue work sits at the top instead of disappearing in the list.

When the spreadsheet is no longer enough

If you are handling 500+ service records, multiple engineers and automated texts, you will outgrow a manual workbook and need proper job management software. For a small firm with 1, 2 or 3 vans, though, this spreadsheet is usually the simplest way to stay on top of annual servicing.

Use the dashboard as the trigger

Image 2 should become your starting point each week: due soon, overdue and completed work are all visible without scrolling through the full schedule. That is the quickest way to turn the file into a habit rather than another forgotten tab.