E•ENGINEERING
DESK TOOLS
All guides
Maintenance7 min readUpdated 7 October 2026

Preventive maintenance schedule in Excel: free PM planner template

Build an asset task schedule, enter completion dates and use formula-driven due dates and overdue alerts in the blank PM workbook.

How to create a preventive maintenance schedule

A preventive maintenance schedule (PM schedule) lists every recurring maintenance task, the asset it applies to, how often it is done and when it is next due. A simple, complete schedule in Excel is enough for many small plants and workshops.

  1. List your assets. Give each one an ID, a location and a criticality rating.
  2. Collect the tasks. Start with the manufacturer's manual, then add statutory inspections and tasks learned from past failures.
  3. Set a frequency for each task. Use calendar intervals (weekly, monthly) or run-hours where the manual specifies them.
  4. Enter the last completion date. The planner then calculates the next due date.
  5. Assign an owner and estimated time, so the weekly workload is realistic.
  6. Review overdue tasks every week and track PM compliance on the dashboard.

Download the free PM planner (.xlsx)

Example PM schedule for a centrifugal pump set

TaskFrequencyTask type
Check for leaks, noise and abnormal vibrationDailyInspection
Check mechanical seal and gland areaWeeklyInspection
Grease motor and pump bearingsMonthly or per manualLubrication
Measure vibration and bearing temperatureMonthlyTesting
Check coupling alignment and guardQuarterlyInspection
Measure motor insulation resistanceAnnualTesting
Calibrate discharge pressure transmitterAnnualCalibration

Intervals depend on duty, environment and the manufacturer's instructions. Treat the list as an example, not a recommendation for your equipment.

Preventive maintenance checklist

  • Isolate and lock out the equipment before work starts.
  • Inspect for leaks, damage, loose fixings and corrosion.
  • Lubricate with the specified grade and quantity.
  • Clean filters, coolers and ventilation openings.
  • Measure and record vibration, temperature, current or pressure.
  • Check guards, safety devices and labels.
  • Record findings, parts used and the actual completion date.
  • Raise a corrective work order for any defect found.

The equipment inspection checklist template records Pass, Fail or N/A for each check and tracks the follow-up actions.

What the planner does and what to set first

The preventive maintenance planner is a blank Excel workbook with a Records sheet, a Dashboard and a Lists sheet. Each row is one recurring task on one asset. You enter the planned date; the workbook works out the interval, the next due date, a due status and whether the last completion was on time. It is a calendar scheduler, so it suits tasks that repeat every so many days. It does not read run-hours or condition data.

Start on the Lists sheet. Two settings drive the alerts: the due-soon window (default 7 days) and the grace days for on-time completion (default 3 days). The dropdown lists for frequency, task type, priority and status can be edited there. Task type starts with Inspection, Lubrication, Cleaning, Testing, Replacement, Calibration, Safety and Statutory. Status offers Planned, In progress, Completed, Deferred and Cancelled.

On the Records sheet the entry columns run from Asset ID to Findings / notes, plus an optional Interval override in days. Interval, Next due date, Due status, Days overdue, Timeliness and a rank key are formulas; do not type over them.

Frequency, interval and the override

The Frequency dropdown is linked to a day count on the Lists sheet. These are calendar approximations, so a monthly task is 30 days and not a calendar month.

FrequencyInterval (days)
Daily1
Weekly7
Fortnightly14
Monthly30
Every 2 months61
Quarterly91
Every 4 months122
Semi-annual182
Annual365
Every 2 years730
Every 5 years1826

The Interval column uses the override if one is entered (a whole number of at least 1), otherwise the days for the chosen frequency, otherwise it stays blank. Use the override for a manufacturer interval that has no matching entry, such as 45 days. A task with neither a frequency nor an override has no interval, so the workbook cannot move it forward after completion.

Choose the interval from the equipment manual and your approved strategy. The workbook records the decision but does not test it.

How the next due date is calculated

The rule has three branches. Next due date = planned date while no actual date is entered. Once an actual completion date exists, next due date = actual completion date + interval. If the planned date is blank, or the asset ID is blank, no due date is produced.

As a formula: duenext = dateactual + interval (days).

Worked example 1. A monthly lubrication task (interval 30 days) is planned for 20-Aug-2026 and completed on 24-Aug-2026. The next due date is 24-Aug-2026 + 30 days = 23-Sep-2026. A fixed calendar based on the plan would have given 20-Aug-2026 + 30 days = 19-Sep-2026, so the completion-based rule has moved the schedule four days later.

Worked example 2. A quarterly filter change (91 days) is planned for 15-Jul-2026 and completed on 16-Jul-2026. The next due date is 15-Oct-2026. An extraction fan with an override of 45 days and a planned date of 10-Oct-2026 is due on 10-Oct-2026 until it is done; if it is completed that day, the next due date becomes 24-Nov-2026.

For a fixed-calendar policy, add a new row per cycle with the next planned date typed in.

Due status, days overdue and timeliness

Due status compares the next due date with today's date, which Excel recalculates every time the file is opened. The result is one of six values:

  • Overdue: next due date is before today.
  • Due soon: next due date is today or within the due-soon window.
  • Scheduled: due later than the window.
  • Missing schedule: no planned date and no actual date.
  • Completed - no interval: an actual date exists but no interval can be found.
  • Cancelled: the Status dropdown is set to Cancelled.

Only Cancelled changes the logic. Completed, Deferred and In progress do not; the dates drive the result.

Worked example 3. Take today as 5-Oct-2026 and the default 7-day window. The pump task from example 1 is due 23-Sep-2026, which is 12 days before today, so it shows Overdue with 12 days overdue. A generator load test planned for 5-Oct-2026 with no actual date is due today, so it is not overdue; it is Due soon, as is anything due up to and including 12-Oct-2026.

Timeliness is separate. It compares the actual date with the planned date on the same row: Late if actual − planned is greater than the grace days, otherwise On time. The pump task finished 4 days after plan, which is more than 3 grace days, so it is Late. Had it been finished on 23-Aug-2026 (3 days after plan) it would count as On time.

Dashboard tiles and the compliance figure

The Dashboard has four tiles: Active tasks (excluding Cancelled and blank), Overdue, Due soon and Completed on time. It also charts tasks by status, frequency and type, and lists the ten most overdue tasks.

Completed on time = On time rows ÷ (On time + Late rows). It only includes tasks that have an actual date.

Worked example 4. Suppose a month has 12 tasks with actual dates, 9 On time and 3 Late. The tile reads 9 ÷ 12 = 75%. Now suppose the same month had 48 tasks scheduled, of which 41 were completed on time. The maintenance KPI calculator gives PM compliance = 41 ÷ 48 × 100 = 85.4%. With 310 planned hours out of 420 total hours, planned work is 310 ÷ 420 × 100 = 73.8%, and 110 hours were reactive. An open backlog of 260 labour hours against 160 planned hours per week is 260 ÷ 160 = 1.6 weeks (1.625).

These two percentages answer different questions because the denominators differ. The tile excludes tasks with no completion; the calculator divides by everything scheduled. State which one you report. For breakdown history see the MTBF, MTTR and availability calculator and the MTBF guide.

Common mistakes

  • Writing vague tasks such as 'service pump' with no defined scope.
  • Typing over a formula column.
  • Overwriting the actual date next cycle. The Timeliness column then compares the new actual date with the old planned date and will usually report Late. Add a new row per cycle if you want an honest history.
  • Leaving the actual date in place and expecting the row to reset. The next due date stays at the old actual date plus the interval, and the row becomes Overdue when that passes.
  • Assuming Status = Completed clears an overdue flag; only an actual date does.
  • Using the 30-day monthly interval for a task tied to a calendar month, such as a statutory inspection.
  • Comparing the tile percentage with a KPI figure that has a different denominator.

Checks before you trust the result

  • Confirm the computer's date is correct; every status depends on it.
  • Filter for Missing schedule; those rows have no planned date and never become overdue until fixed.
  • Spot-check three rows by hand: actual date plus interval should equal the Next due date shown.
  • Match the due-soon window to your planning cycle; a monthly meeting needs more than 7 days.
  • Look for old planned dates with no actual date; cancel or re-plan them.
  • Remember the dashboard measures scheduling, not whether the work was done correctly.

Frequently asked questions

Does the planner schedule by run-hours?

No. It uses days only. Keep meter-based or condition-based tasks in a system that tracks the meter or condition, and enter a calendar check here if you want a reminder.

Can a late job pull the next one forward?

Not automatically. The workbook adds the interval to the actual date, so a late job delays the next one. Use a new row with a typed planned date for fixed-calendar work.

How do I stop a decommissioned asset counting as overdue?

Set Status to Cancelled. The row stays on record but is excluded from Active tasks and from the overdue count.

Why does a task show Missing schedule?

The row has an Asset ID but no planned date. A row with an actual date but no frequency or override shows Completed - no interval instead.

Recording the data and using the template

Enter one row per task, assign an owner, and record findings and any follow-up request number when the work is finished. Keep work orders and approvals in your maintenance system; this workbook is the planning view. The free PM planner template is blank apart from fictional example rows you can clear.

At each planning cycle review Overdue first, then Due soon, then Missing schedule. Save a dated copy each month if you need compliance history, because the tiles show only the current state.

Try it with the calculators

Free Excel templatePreventive maintenance planner: blank records, dropdowns and a live dashboard.
Download .xlsx

Browse all Excel templates and dashboard previews

References