Free template: maintenance schedule for buildings, building systems and machinery – with automatic calculation of the next due date and a traffic-light status for overdue maintenance.
What belongs in a maintenance schedule?
A maintenance schedule is a list of all assets that require maintenance, with the tasks and intervals needed for each. At a minimum, it should include the following:
- Asset with a unique name (for example "Ventilation unit, Hall 2")
- Location – building, floor, room
- Manufacturer, model and serial number
- Maintenance task – what exactly needs to be done
- Interval – in days, months or years, or by operating hours
- Last and next maintenance
- Responsibility – an internal person or a contractor
- Legal basis – is the inspection legally required?
- Record – where is the report stored?
How to create a maintenance schedule in 7 steps
- Capture the assets. Walk through the building room by room and note every technical system: heating, ventilation, air conditioning, elevators, gates, fire protection systems, electrical panels, pumps, machinery. Photograph every nameplate.
- Clarify obligations. For each asset, check whether a legal inspection requirement applies (for example under national workplace-safety and equipment regulations, accident-prevention rules, building codes or fire-protection requirements) and mark those rows.
- Adopt manufacturer specifications. Intervals and tasks are listed in the operating manual. If it is missing, ask the manufacturer or the service contractor.
- Set the intervals. Use the shorter of the legal interval and the manufacturer's interval. For heavily used assets, a meter reading (operating hours) can make more sense than a calendar interval.
- Assign responsibilities. Every row gets exactly one responsible person – even if a contractor performs the work. "Everyone" means "no one" in practice.
- Enter the last maintenance. Work it out from invoices and reports. The template uses it to calculate the next due date automatically.
- Review regularly. Set a fixed time (for example every Monday) to check the list for overdue and soon-to-be-due maintenance.
How to use the Excel template
The template already contains sample rows for typical building systems. Enter your assets; the Next maintenance (Nächste Wartung) column is calculated from Last maintenance (Letzte Wartung) and Interval (months) (Intervall (Monate)). The Status column shows "overdue," "due in 30 days" or "ok." With the filter in the header row, you can see at a glance what is coming up next.
Example: maintenance schedule for an office building
| Asset | Task | Interval | Required |
|---|---|---|---|
| Gas condensing boiler | Service and flue gas measurement | 12 months | yes |
| Ventilation unit | Filter replacement, visual inspection | 6 months | no |
| Fire extinguishers | Inspection by a qualified person | 24 months | yes |
| Fire doors | Function test | 12 months | yes |
| Smoke detectors | Function test | 12 months | yes |
| Roll-up door, underground garage | Service and safety inspection | 12 months | yes |
| Sewage lift station | Service | 6 months | no |
The intervals are examples. What counts is the manufacturer's specifications, regulations and your own risk assessment.
Maintenance schedule for machinery
For machinery, a pure calendar rhythm is often imprecise: a machine running three shifts wears out faster than one that only runs occasionally. Here, maintenance by operating hours or unit counts pays off. In the Excel template, you enter the meter reading instead of months; in software such as Maintably, the maintenance falls due automatically as soon as the meter reaches the threshold.
From an Excel schedule to software
The template is enough as long as one person looks after a manageable number of assets. Once several people are involved, photos and reports come into play or deadlines become liability-relevant, a digital maintenance planner is safer: it sends reminders by itself, escalates when work is late and stores the records automatically. Your Excel list is the ideal starting point, because the template's columns correspond to the fields in Maintably.