From the makers of Equipment Maintenance Log — a maintenance log you keep by voice
Preventive Maintenance Schedule Template
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 + C2where 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:
- Update the reading weekly, not at service time. A schedule is only as good as the current hours in it.
- Close the loop at service: when the job is done, change "last done" and "reading at last" that same day.
- 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.
