Preventive Maintenance Templates and Tools Hub

What's on This Page and How to Use It

You came here because something broke — maybe the tab that auto-calculated your next service dates stopped working, maybe a PM slipped during a vacation week, maybe you're starting from a blank page and just need a structure to follow. Whatever the trigger, you need working preventive maintenance templates, not another article that describes what a PM program is without giving you anything to build with.

This hub is organized around the three documents every PM program needs before anything else: an equipment asset register (your list of what you're maintaining), an annual PM schedule (when each task happens), and a maintenance KPI dashboard (whether the program is actually working). You'll find a downloadable template for each one, a companion guide that walks you through filling it in, and a clear path to the next step after the spreadsheet outgrows you.

Work top to bottom. Don't skip to the PM schedule before the asset register is done — the schedule is only as complete as the equipment list feeding it.

---

Template 1: Equipment Asset Register

What it is

The asset register is the foundation. It's a structured list of every piece of equipment you're responsible for maintaining — machine name, asset ID, manufacturer, model number, serial number, location, installation date, and criticality rating. Without it, your PM schedule has no reliable source of truth, and your KPIs have nothing to measure against.

According to Software Advice (via Facility Executive, 2024), 48% of prospective maintenance software buyers are still on manual methods — paper or spreadsheets — when they start looking for something better. The asset register is usually the first document that exposes why: columns drift, rows go missing when someone leaves, and there's no standard field for criticality that the whole team agrees on.

What the template gives you

The Equipment Asset Register Template (~$19, Excel) ships with:

• Pre-built column headers covering every core field: asset ID, name, category, manufacturer, model, serial number, location, install date, and criticality class (A/B/C)
• A criticality scoring tab to help you decide which assets are A-class (failure stops production or creates a safety risk), B-class (failure degrades output), and C-class (failure is a nuisance)
• A filter-ready structure so you can sort by location, category, or criticality in one click
• Blank rows pre-formatted to match, so adding assets doesn't break the layout

How to fill it in

Follow the step-by-step walkthrough in How to Build an Equipment Asset Register. That guide covers how to run a physical walkthrough, how to pull serial numbers from nameplates when records don't exist, and how to set criticality ratings without turning the exercise into a committee debate.

Once the register is complete, move to Template 2.

---

Template 2: Annual Preventive Maintenance Schedule

What it is

The PM schedule is where your asset register becomes a living maintenance plan. Each row is a recurring task — a specific asset, a specific maintenance action (lubricate, inspect, replace, calibrate), a frequency (weekly, monthly, quarterly, annually), and an assigned owner. The annual view lets you see, at a glance, whether March is overloaded, whether the compressor and the hydraulic system are both due in the same week, and whether you have enough people to cover it.

A PM schedule without a structured asset register behind it tends to be incomplete by definition — you can only schedule maintenance for equipment you've listed.

What the template gives you

The Annual Preventive Maintenance Schedule (~$29, Excel) is the most complete of the three tools and the one most planners reach for first:

• 52-week calendar grid — one row per PM task, one column per week, with color-coded status cells (Scheduled / Completed / Overdue / Skipped)
• Task detail fields — asset name and ID, task description, interval, estimated labor hours, assigned technician, and parts required
• Auto-calculated PM compliance % — the template computes completed ÷ scheduled for any date range you select (PM compliance % is the ratio of PMs completed on time to PMs scheduled — the primary health metric for any PM program)
• Built-in interval starting points — 20 equipment categories pre-populated with general starting-point frequencies drawn from our PM interval reference library; each one carries the caveat to confirm against your OEM documentation and duty cycle before adopting
• Summary dashboard tab — overdue count, completion rate by month, and hours-by-technician totals

PM compliance of 90% or higher is the world-class benchmark, with 95%+ expected for critical A-class assets; programs running below 80% are not functioning effectively. — SMRP Best Practices, cited via eWorkOrders, 2026.

How to use it

The companion guide, How to Build a Preventive Maintenance Schedule, walks through: importing your asset register into the schedule, choosing starting intervals for each equipment category, distributing the workload across weeks so no single month is impossible, and the 10% timing rule — industry guidance that a monthly PM completed within roughly three days of its due date counts as on-time (eMaint/Fluke Reliability, 2026).

For the specific interval starting points built into the template, the PM Interval Reference Library Guide explains the logic behind each category and how to adjust for your equipment's actual duty cycle and manufacturer recommendations.

Once the schedule is built and running, move to Template 3.

---

Template 3: Maintenance KPI Dashboard

What it is

A PM schedule tells you what to do. The KPI dashboard tells you whether it's working. The dashboard tracks the metrics that matter most to a maintenance planner at an SMB plant: PM compliance %, planned vs. unplanned work-order ratio, mean time between failures (MTBF — the average operating time between one failure and the next), mean time to repair (MTTR — the average time from failure detected to equipment restored), and maintenance cost as a percentage of replacement asset value (MC/RAV).

Without a dashboard, you're making decisions on feel. With one, you can show a plant manager — in a single chart — whether the PM program is paying off, where the next breakdown is likely to come from, and whether the team is running lean enough to handle it.

What the template gives you

The Maintenance KPI Dashboard (~$29, Excel) includes:

• Input tabs for logging work orders, PM completions, failure events, repair times, and asset replacement values — structured so a technician or admin can enter data in under five minutes per work order
• Auto-calculated metrics: PM compliance %, planned/unplanned ratio, MTBF by asset, MTTR by asset, and MC/RAV for the overall program
• Trend charts that plot each metric over 12 months so you can see whether compliance is improving or drifting
• World-class benchmark callouts — 85%+ OEE (overall equipment effectiveness), 80/20 planned-to-unplanned ratio (90/10 for leading programs), and MC/RAV between 2.0% and 3.0% of replacement asset value annually (Factory AI/SMRP, 2026; Reliamag/SMRP, 2026; Oxmaint, 2026) — displayed alongside your actual numbers so you know where you stand
• Exportable summary table for monthly reporting to management or for an ISO 55000 asset-management review

How to read the numbers

Benchmarks are reference points, not targets to hit on day one. If your PM compliance is 65% when you start, the goal for the first quarter is 75%, not 90% — trajectory matters more than the gap. The dashboard is designed to make that trajectory visible week by week.

---

How the Three Templates Work Together

Each template feeds the next:

1. Asset Register → gives the PM schedule its complete equipment list and criticality ratings
2. PM Schedule → generates the work-order activity that the KPI dashboard measures
3. KPI Dashboard → flags which assets are dragging down MTBF or PM compliance, informing the next round of schedule adjustments

Running all three as separate spreadsheets is a legitimate starting point — and far better than nothing. The practical limit shows up around the 50–75 asset mark: manual status updates across three files start taking longer than the maintenance tasks themselves, version conflicts appear when more than one person edits, and there's no automated alert when a PM comes due.

---

When the Templates Are Enough (and When They're Not)

Spreadsheets work well when

• You have fewer than 50 assets and one person managing the schedule
• You're building your first PM program and need to learn what data you actually have before committing to software
• You're preparing to migrate to a CMMS and need clean, structured data to import

You've outgrown the spreadsheets when

• PMs are slipping because nobody noticed the due date in the shared file
• Two people editing the schedule at the same time creates conflicts and lost data
• You can't tell, without opening four tabs, what's overdue right now
• A new technician hire means rebuilding the workload columns manually

The guide How to Migrate Your Maintenance Spreadsheet to a CMMS covers how to move your existing data — asset register, PM schedule, and KPI history — into a structured system without starting from scratch.

---

Build a PM Program from the Ground Up

If you're starting before any of these documents exist — no asset list, no PM history, no established intervals — the 30-Day PM Program from Scratch guide gives you a sequenced, week-by-week plan: asset discovery in week one, criticality scoring and register completion in week two, initial schedule build in week three, and first compliance measurement in week four.

The templates above map directly onto that plan — each one corresponds to a week's output.

---

From Templates to Software: What Changes

Maintenance Planning Manager is built around the same planning-first logic as these templates: start with the asset register, build the PM schedule, then let the system generate the work-order queue automatically. The difference from a spreadsheet is that the schedule generates rolling work orders on its own, sends notifications when PMs are due, and calculates PM compliance % in real time — without anyone updating a status cell.

Pricing starts at $199/month for up to 100 assets on the Essentials plan — a flat fee that covers every user on your team, with no per-seat charge added as you hire. The pricing page shows the full tier breakdown.

If you want to see the software before committing, the templates are the fastest way to arrive at the free trial with clean data already in hand: import the asset register CSV, and your PM schedule is ready to build on day one.

---

Get the Templates

All three are available individually or as a bundle:

• Annual PM Schedule Template — $29, Excel
• Maintenance KPI Dashboard — $29, Excel
• Equipment Asset Register Template — $19, Excel
• Browse the full template store

Or, if the spreadsheet phase is already behind you: start a 14-day free trial of Maintenance Planning Manager — no credit card required, and the templates import directly.