Why You Need a Preventive Maintenance Schedule
Most maintenance teams know they should be doing more preventive work. The problem is never awareness — it's execution. Without a concrete schedule that tells every technician exactly what needs to happen, when, and on which asset, preventive maintenance stays an aspiration instead of a practice.
The economics make the case clearly. Industry consensus, supported by data from organizations like the U.S. Department of Energy and various reliability engineering studies, puts the cost of reactive (run-to-failure) maintenance at 3 to 5 times more per incident than the same work done preventively. The reasons compound: emergency labor rates, expedited parts shipping, cascading damage to adjacent components, and the production losses from unplanned downtime.
A preventive maintenance schedule shifts your team from "fix it when it breaks" to "maintain it before it fails." That shift doesn't require expensive sensors, AI, or a six-figure software budget. At its most basic level, a PM schedule is a calendar that answers three questions for every asset: what maintenance tasks need to happen, how often, and who is responsible.
Even a simple spreadsheet-based PM schedule — consistently followed — will reduce unplanned breakdowns. The template below gives you a practical starting point. You can use it in Excel, Google Sheets, or import the tasks into a CMMS platform if you want automated reminders and tracking.
What's in the Template
The PM schedule template is organized into columns that cover everything you need to track a maintenance task from assignment through completion. Here's what each field does and how to fill it in:
| Column | Purpose | Example |
|---|---|---|
| Asset Name / ID | Identifies the specific piece of equipment. Use a consistent naming convention. | AHU-03 (Rooftop Unit) |
| Task Description | The specific maintenance action. Be precise enough that any technician can execute it. | Replace air filters, check belt tension |
| Frequency | How often the task should be performed. | Monthly / Quarterly / 500 hours |
| Last Completed | Date the task was last done. Essential for calculating when it's next due. | 2026-01-15 |
| Next Due | Calculated from last completed + frequency. This is what triggers the work. | 2026-02-15 |
| Assigned To | The technician or team responsible. Unassigned tasks don't get done. | Mike R. / HVAC Team |
| Priority | Helps technicians triage when multiple tasks are due. Tie to asset criticality. | Critical / High / Medium / Low |
| Est. Duration | Time estimate so supervisors can plan workloads accurately. | 45 min |
| Notes / Parts Required | Any special instructions, safety precautions, or parts to have on hand. | 2x filter 20x25x4, need ladder |
Customize it for your operation
This is a starting template, not a rigid format. Add columns that matter to your team: cost tracking, permit requirements, lockout/tagout steps, or links to OEM manuals. Remove columns you won't use — a template that's too complex won't get filled out. The best PM schedule is the one your team actually follows.
PM Tasks by Frequency
Below are common preventive maintenance tasks organized by how often they should be performed. These are real tasks that maintenance teams perform across industries — use them to populate your PM schedule template. Always cross-reference with your specific equipment's OEM manual for exact intervals.
Daily Tasks
Quick checks performed at the start or end of each shift
- Walk-around visual inspections of all critical equipment
- Check fluid levels (oil, coolant, hydraulic fluid)
- Verify safety equipment is present and functional
- Check for leaks, unusual noises, or abnormal vibrations
- Clean filters and air intakes in dusty environments
- Confirm gauges and indicators are within normal ranges
- Log equipment operating hours or meter readings
Weekly Tasks
Scheduled for a specific day each week, typically during lower production periods
- Lubricate moving parts per manufacturer specifications
- Test emergency stops and safety interlocks
- Check belt tension and condition for signs of wear
- Inspect electrical connections for corrosion or loose terminals
- Clean equipment exteriors and surrounding work areas
- Test battery charge levels on backup and portable equipment
- Verify calibration on frequently used instruments
Monthly Tasks
Deeper inspections and component replacements, often requiring partial shutdown
- Replace air filters (or per OEM-specified intervals)
- Calibrate instruments and gauges
- Test backup power systems under load
- Inspect fire extinguishers (tag, pressure, accessibility)
- Review and update maintenance logs for completeness
- Check door hardware, hinges, and closers
- Inspect plumbing for slow leaks or drips
Quarterly Tasks
Comprehensive assessments that often involve testing, analysis, and inventory review
- Perform full equipment condition assessments
- Submit oil or fluid samples for analysis (critical equipment)
- Test all alarms, detectors, and warning systems
- Review spare parts inventory and reorder as needed
- Check alignment on rotating equipment (motors, pumps, fans)
- Inspect roof drains, gutters, and exterior drainage
- Review PM completion data and adjust frequencies
Annual Tasks
Major inspections, certifications, and overhauls — often coordinated with planned shutdowns
- Major overhaul inspections per OEM schedule
- Renew certifications (pressure vessels, lifting equipment, elevators)
- Conduct electrical system thermographic survey
- Complete calibration of all instruments and sensors
- Review and update the entire PM schedule based on past year's data
- Test all fire suppression and life safety systems
- Update asset register with any additions, disposals, or changes
These are general guidelines, not universal rules
Every facility is different. A compressor in a clean office building has different maintenance needs than the same compressor in a cement plant. Always start with your OEM manual, factor in your operating environment, and adjust frequencies based on what your own inspection data tells you over time. The goal is to find the sweet spot between under-maintaining (risking failures) and over-maintaining (wasting labor and parts).
Ready to digitize your inspections?
Join teams worldwide using QAI to streamline inspections and maintain compliance.
Industry-Specific PM Schedules
Different industries have different critical assets and regulatory requirements. Here are the PM priorities for four common sectors — use these to customize the template for your specific operation.
Facilities & Buildings
- HVAC filter changes and coil cleaning (monthly/quarterly)
- Roof inspections and drainage checks (semi-annual)
- Elevator and escalator certifications (annual per code)
- Fire alarm and sprinkler system testing (monthly/annual)
Manufacturing
- CNC machine spindle lubrication and alignment checks (weekly/monthly)
- Conveyor belt tension, tracking, and roller inspections (weekly)
- Compressor oil changes and air dryer maintenance (quarterly)
- Vibration analysis on motors and rotating equipment (quarterly)
Fleet & Vehicles
- Oil and filter changes based on mileage or engine hours
- Tire rotation, pressure checks, and tread depth measurement
- DOT annual inspections and pre-trip/post-trip checks (daily)
- Brake pad inspection and fluid replacement (per manufacturer)
Construction Equipment
- Hydraulic system fluid level checks and hose inspections (daily/weekly)
- Track or tire condition assessment and tension adjustment
- Boom, arm, and bucket pin inspections for wear (monthly)
- Engine air filter and coolant system service (per operating hours)
How to Set Up Your PM Schedule (Step by Step)
Having a template is step one. Setting it up correctly so your team actually uses it is what separates PM programs that stick from ones that get abandoned after a month. Follow these six steps:
List all assets that need maintenance
Create a complete inventory of every piece of equipment, vehicle, building system, and infrastructure asset your team is responsible for. Include the asset name, location, manufacturer, model number, serial number, and installation date. You don't need to put everything on a PM schedule right away, but you need to know what you have. Start with the assets where a failure would have the biggest impact on safety, production, or compliance.
Gather OEM maintenance manuals
For every asset going on the PM schedule, pull the manufacturer's recommended maintenance intervals. These are your baseline. The OEM manual will tell you what needs to be serviced, how often, what parts are required, and what specifications to check against. If you can't find the manual, check the manufacturer's website, contact their support team, or search for the model number online. Many OEMs publish maintenance guides as free PDFs.
Assign frequencies based on OEM specs and your conditions
Use the OEM recommendation as your starting point, then adjust for your reality. A forklift in a refrigerated warehouse needs different intervals than one in a dry, clean environment. Equipment running two shifts needs more frequent attention than single-shift equipment. When in doubt, start with the OEM interval and track results — you can always adjust later based on actual failure patterns and inspection findings.
Assign responsible technicians
Every PM task needs a name on it. Unassigned tasks are tasks that won't get done. Consider each technician's skills, certifications, and workload when making assignments. Distribute tasks so no single person is overloaded during any given week. If a technician is sick or on vacation, have a clear backup assignment process. Some teams assign by asset type (electricians handle all electrical PM), while others assign by area or zone.
Set up reminders and notifications
This is where most spreadsheet-based PM programs fall apart. If the schedule depends on someone remembering to check a spreadsheet, it will fail. At minimum, set up calendar reminders for every recurring task. Better yet, use a CMMS or maintenance app that sends automatic push notifications to the assigned technician when a task is due and escalates overdue items to supervisors. Even basic phone alarms are better than relying on memory.
Track completion and adjust based on results
After the first month, review your data. Which tasks were completed on time? Which were missed and why? Were any tasks found to be unnecessary — no issues discovered during inspection? Were there any failures that your current PM schedule didn't catch? Use this data to refine your frequencies. A PM schedule should be a living document that gets smarter over time, not a static list created once and forgotten.
Free: Inspection Software Buyer's Guide
Get our comprehensive checklist for evaluating inspection platforms.
Spreadsheet vs Software: Which Should You Use?
The honest answer: it depends on your team size, asset count, and how much accountability you need. Both can work — but they work best in different situations.
Spreadsheet Works When...
Best for getting started or simple operations
- You have fewer than 20 assets on the PM schedule
- One or two people manage all maintenance tasks
- Simple schedules with standard frequencies
- No regulatory requirement for audit trails
- You're just starting PM and want to test the process
Software Is Better When...
Necessary for teams, mobile access, and compliance
- Multiple technicians need task assignments and notifications
- You need mobile access for field or floor technicians
- Automatic reminders are critical (tasks can't be missed)
- You need audit trails with timestamps and photo evidence
- Your asset count is growing and spreadsheets feel chaotic
There's no shame in starting with a spreadsheet. Many successful PM programs began in Excel or Google Sheets. The danger is staying on spreadsheets too long — once you have more than 20 assets, multiple technicians, or any compliance requirements, the lack of automated reminders, mobile access, and audit trails will start costing you. Tasks get missed, data gets lost, and nobody can prove what was actually done.
If you're ready to move beyond spreadsheets, look for maintenance scheduling software that lets you import your existing PM data, offers a free tier to get started, and provides mobile apps for technicians. The transition should feel like an upgrade, not a rip-and-replace.
How QAI handles PM scheduling
QAI is a CMMS that includes PM scheduling as a core feature. You can create recurring maintenance tasks per asset, set frequencies (daily, weekly, monthly, or by meter reading), and assign them to specific technicians. When a task is due, the assigned technician gets a push notification on their phone. Completed tasks are timestamped with optional photo evidence. The dashboard shows your PM completion rate, overdue tasks, and asset history. It's free for up to 2 users, so you can test it without a budget approval process.
Frequently Asked Questions
How do I determine the right PM frequency for each asset?
Start with the manufacturer's recommended maintenance intervals from the OEM manual. Then adjust based on three factors: your operating environment (dusty, humid, or extreme temperatures shorten intervals), usage intensity (a machine running 24/7 needs more frequent service than one running 8 hours a day), and your own failure history (if an asset keeps failing between scheduled PMs, shorten the interval; if it never shows issues at inspection time, you may be over-maintaining). Track results for 6-12 months before making major frequency changes.
What's the difference between time-based and usage-based PM schedules?
Time-based scheduling triggers maintenance at fixed calendar intervals (e.g., every 30 days, every quarter). Usage-based scheduling triggers maintenance based on actual operating metrics like run hours, miles driven, or production cycles. Usage-based scheduling is more efficient because it ties maintenance to actual wear, but it requires metering or tracking systems. Most teams start with time-based scheduling and shift critical assets to usage-based as they install meters or adopt CMMS software with meter tracking.
How many PM tasks should I start with?
Start small. Pick your 10-20 most critical assets — the ones where a failure would cause safety hazards, production shutdowns, or regulatory violations. Create 3-5 PM tasks per asset based on the manufacturer's top recommendations. This gives you 30-100 total tasks, which is manageable for most small teams. Once your completion rate is consistently above 90%, expand to the next tier of assets. Trying to schedule everything at once is the number one reason PM programs fail in the first 90 days.
What if I don't have the manufacturer's maintenance manual?
Check the manufacturer's website first — many OEMs publish maintenance guides as downloadable PDFs. If that fails, search for your asset model number plus "maintenance manual" or "service schedule." You can also contact the manufacturer or distributor directly. For older equipment with no documentation available, use industry-standard maintenance intervals for that equipment class as a starting point, then refine based on inspection findings and failure patterns over time.
How do I measure if my PM schedule is working?
Track four metrics. First, PM completion rate: what percentage of scheduled tasks are completed on time (target 90%+). Second, the ratio of planned vs. unplanned work orders — a healthy PM program should push this above 80% planned. Third, mean time between failures (MTBF) for key assets — this should increase over time. Fourth, total maintenance cost per asset — this should decrease as reactive emergency repairs decline. Review these monthly and adjust your schedule quarterly based on the data.
Can I use Google Sheets instead of Excel?
Yes. Google Sheets works just as well as Excel for a basic PM schedule, and it has the advantage of being cloud-based so multiple people can access it simultaneously. The main limitation of any spreadsheet — Google Sheets or Excel — is that it won't send automatic reminders, can't track completion with timestamps and photos, and becomes unwieldy past 20-30 assets. For small teams just getting started, a spreadsheet is perfectly fine. When you outgrow it, migrate to a CMMS that can import your data.