From the makers of Equipment Maintenance Log — a maintenance log you keep by voice

Preventive Maintenance Schedule Template

November 17, 2026 · 4 min read

A preventive maintenance (PM) schedule template needs seven columns: machine, task, interval, last done, reading at last service, next due and who owns it. Copy the table below into Excel or Google Sheets, fill in your machines, and add one formula for "next due". That is enough for a small fleet; the hard part is keeping it current, not building it.

The columns that matter

Most templates fail because they have either too few columns (no "last done") or too many (nobody fills them in). Start with these:

Column Example Why it is there
Machine Excavator 2 One row per machine and task
Task Engine oil and filter One task per row, not "all services"
Interval 250 hours Hours, miles or months
Last done (date) Sep 12 Needed for calendar limits
Reading at last service 4,820 h The anchor for the next one
Next due 5,070 h Last reading plus interval
Owner Mike One name, not "shop"

A ready table to copy

Machine Task Interval Last done Reading at last Next due Owner
Excavator 2 Engine oil + filter 250 h Sep 12 4,820 h 5,070 h Mike
Excavator 2 Hydraulic filter 500 h Jun 3 4,500 h 5,000 h Mike
Dump truck 4 Engine oil + filter 10,000 mi Oct 1 88,400 mi 98,400 mi Dan
Dump truck 4 Brake inspection 6 months Aug 20 n/a Feb 20 Dan
Generator 1 Oil + filter 150 h or 12 months Mar 2 1,180 h 1,330 h Mike

Intervals above are examples. Take the real ones from each machine's operator's manual, and shorten them for dusty, hot or heavy-duty work. For typical ranges, see our engine hours maintenance schedule.

The formulas

  • Next due (hours or miles): =E2 + C2 where E is the reading at last service and C is the interval as a number.
  • Hours remaining: =F2 - current reading. Keep current readings on a second sheet, one line per machine.
  • Flag it: conditional formatting, red when hours remaining is below 25 (or 500 miles).

For calendar items (annual inspection, six-month brake check), use =EDATE(D2, 6) for the next date.

How to keep it updated

A template that depends on someone remembering to open it will go stale in a month. Three habits help:

  1. Update the reading weekly, not at service time. A schedule is only as good as the current hours in it.
  2. Close the loop at service: when the job is done, change "last done" and "reading at last" that same day.
  3. One owner per row. Rows owned by "the shop" are owned by nobody.

When a spreadsheet stops working

Excel is fine for 3-5 machines and one person. Watch for these signs that it is time to move on:

  • Two people edit two copies of the file.
  • Mechanics write down hours on paper or text them, and the sheet is updated days later.
  • You find out about an overdue service from a breakdown.
  • You cannot see a machine's history without scrolling through years of rows.

We cover the trade-offs in Excel vs a maintenance app.

Doing the same thing without typing

Equipment Maintenance Log replaces the spreadsheet upkeep with a chat per machine. A mechanic says "Excavator 2, changed oil and filter, 4,820 hours" and the AI assistant records the service, reading and date. Reminders for the next oil change are based on the hours you log, and everyone on the team sees the same history. AI can make mistakes, so each entry can be reviewed and corrected.

FAQ

What should a preventive maintenance schedule include?

Machine, task, interval, date and reading at last service, next due and an owner. Add a notes column for parts used if you want to track costs.

Is there a free PM schedule template for Excel?

The table on this page is a free starting point: copy it into a sheet and add the formula for next due. Keep it to the columns you will actually fill in.

How often should I update the schedule?

Update current readings at least weekly and the service rows the same day work is done. A schedule updated monthly will miss intervals on busy machines.

Should I schedule by hours or by calendar?

Both. Use hours or miles as the main trigger and a calendar limit as a backstop, for example oil every 250 hours or once a year, whichever comes first.

Read next

Log your next repair by voice

Free on iPhone and Android. Sign in with Apple, Google or email. Say it — it is logged.