Field service · Free template

Preventive maintenance schedule template in Excel

A PM schedule answers three questions: what is due, when, and what has already been missed. Below: what to put in it, how to choose the trigger for each piece of equipment, a sample, and a free Excel template that works out due dates and flags what is overdue.

  • Calendar and run-hours triggers in one list
  • Overdue, Due soon and OK status by itself
  • 12-month plan of the months each PM falls due
  • PM log that updates the last-done date
Preventive maintenance schedule: equipment list with trigger, interval, next due date and Overdue, Due soon or OK status, and a 12-month plan

What is a preventive maintenance schedule?

A preventive maintenance (PM) schedule is a list of the equipment you look after, how often each item needs servicing, when it was last done and when it is next due. Servicing on a schedule is meant to catch wear before it becomes a breakdown, so a visit is planned instead of an emergency.

It is not the same as the PM checklist. The schedule says when a piece of equipment is serviced; the checklist says what the technician checks on that visit. You need both, and each type of equipment needs its own checklist. See equipment maintenance checklists.

Preventive maintenance schedule: what to include

1. Which equipment

Asset ID, name, location and category. Give every item one ID and never reuse it. The ID is what links a visit in the log to the schedule.

2. The trigger

Calendar (every N months) or run-hours (every N hours of running). Pick the one that matches how the equipment wears. More on this below.

3. The interval

Months or hours between services. Take it from the manufacturer's manual and your own experience; this template does not recommend intervals.

4. Last done

Date of the last PM and, for run-hours equipment, the meter reading then. Without it the next due date cannot be worked out.

5. Next due and status

Calculated: next due date or hours left, then Overdue, Due soon or OK. This is the column you read every morning.

6. Who

The person or team responsible, so an overdue item has a name beside it.

Calendar, run-hours or event: choosing the trigger

  • Calendar.Service every N months, whatever the use. Suits equipment that ages with time or that must be checked on a fixed date: air conditioners, UPS batteries, fire extinguishers.
  • Run-hours.Service every N hours of running, read from the meter. Suits equipment that wears with use: generator sets, compressors, pumps.
  • Event.Service or re-check after something happens, such as a major repair or a move. A spreadsheet can only remind you of these if you log the event yourself, so the template covers calendar and run-hours; event rules are easier in software (see below).

Sample

Invented equipment and intervals, to show how the sheet reads. Use your own manuals for real intervals.

Asset IDEquipmentTriggerIntervalLast PMNext due
AC-001Split AC 1.5 tonCalendar3 months25 Oct 202625 Jan 2027
UPS-001UPS 10 kVACalendar6 months25 May 202625 Nov 2026
GEN-001Genset 125 kVARun-hours500 hoursat 1,200 hoursat 1,700 hours (meter now 1,640: 60 left)

Example only. Names, dates and intervals are invented.

What is in the free Excel template

  • Equipment list.Room for 200 items. Drop-downs for the trigger. Next due date (or hours left) and the Overdue, Due soon or OK status are worked out for you and coloured.
  • PM log.One row per PM done, with technician, checklist done, findings, parts used and follow-up. Room for 500 rows. The last-done date on the equipment list picks up the latest log date for that asset by itself.
  • Year plan.A 12-month grid showing which months each calendar item falls due, and how many PMs fall in each month, so you can spread the workload.
  • Settings.The first month of the plan and how early Due soon should warn you, in days and in hours.
  • How to use.A short sheet explaining each column. The file opens in Excel and Google Sheets. Five invented example rows are included: overwrite or delete them.

Five habits that keep a PM schedule alive

  • Log every PM the day it is done.A schedule only works if the last-done date is true. Late logging makes a serviced machine look overdue.
  • Read the meters on a fixed day.Run-hours equipment is only as current as its last reading. Pick a day each week or month and write the readings down.
  • Open the Overdue list every morning.Sort or filter the Status column. A list nobody opens is only a record of what already went wrong.
  • Use the year plan to even out the load.If one month shows most of your PMs, move some baselines so the work is spread.
  • Keep findings, not just ticks.The same fault turning up at consecutive PMs is the reason to change the interval or repair for good. See installed base tracking.

When a spreadsheet stops being enough

A spreadsheet is a sound start for a few dozen items and one person who reads it. It strains when the list grows, when several people edit it, and when the reminder only works if someone remembers to open the file.

In scheduled maintenance tickets the schedule is a rule, set once against a product category by calendar, run-hours or event. When a ticket is closed the next one is created, and technicians see it on their phones with the checklist for that equipment. Preventive maintenance scheduling is on Premium: ₹500 per user per month, or ₹5,000 per user per year if paid annually; Starter is free for up to 10 users. If the PM schedule belongs to a wider contract, see AMC management software, and for the whole picture field service management software.

PM schedule template: frequently asked questions

What is a preventive maintenance schedule?

A list of the equipment you maintain, how often each item needs servicing, when it was last done and when it is next due. It turns servicing into planned visits instead of reactions to breakdowns.

How do I make a preventive maintenance schedule in Excel?

List each piece of equipment with an ID, choose a trigger (calendar or run-hours) and an interval, record the last service, and calculate the next due date as last service plus the interval. Then add a status that shows Overdue, Due soon or OK. The free template on this page does all of that.

What is the difference between a PM schedule and a PM checklist?

The schedule says when each item is serviced. The checklist says what the technician checks on that visit. Each type of equipment needs its own checklist.

Should I schedule by calendar or by run-hours?

Use run-hours for equipment that wears with use, such as generator sets and pumps, and the calendar for equipment that ages with time or must be checked by a fixed date. Where the manufacturer gives both, follow whichever comes first.

What interval should I use?

Start with the manufacturer's manual for each item, then adjust with your own experience of faults and conditions. This template does not suggest intervals because they differ by equipment and use.

Is there a free PM schedule template in Excel?

Yes. Download it from this page. It has an equipment list with due dates and status, a PM log, a 12-month plan and a settings sheet. It also opens in Google Sheets.

When should I move from a spreadsheet to maintenance software?

When the list is too long for one person to scan, when several people need to edit it, or when reminders fail because nobody opened the file. Software creates the next scheduled job when one closes and shows it on the technician's phone.

Related reading

Let the next PM create itself.

Free Starter plan for up to 10 users, no credit card. Scheduling rules are on Premium.

Start free