Preventive Maintenance Excel - Free Template

1. Open the PM Schedule sheet and review the columns before you enter data. The first row is set up for asset details, service timing, and status.
2. Add each asset one line at a time. Include the frequency in days, the last service date, and the technician so the next due date stays readable.
3. Update the status after each service. Mark items as completed, due soon, or overdue so the list reflects the current week.
4. Enter the service cost when you know the actual amount. That gives you a quick maintenance spend view for month-end or quarter-end review.
5. Check the Dashboard sheet after updates. Use it to see which assets need attention first and where the PM workload is concentrated.
6. Follow the Instructions sheet if you want a clean setup for a new site, a new department, or a fresh annual cycle.

This workbook fits the people who actually keep assets running: a facilities coordinator watching 12 rooftop units, a warehouse lead managing 4 forklifts, or a contractor with a few service vans and shop tools. The PM Schedule sheet gives you one line per asset, with columns for frequency, last service date, next due date, days until due, technician, status, and cost.

Image 1 shows the PM Schedule layout. You enter assets like an air handler every 90 days or a forklift every 60 days, then scan the list for work due this week instead of digging through emails or sticky notes.

When the list becomes operational

Use this when a site has enough equipment that one missed inspection can create real cost. If a compressor service runs $250 and two units slip a month, that is $500 in preventable spend before you count downtime or emergency callout fees.

Who benefits most from the structure

A bookkeeper at an LLC can use the cost column for month-end review, while an office manager can see who owns each task before the week starts. For a smaller shop with 20 assets, this beats a whiteboard; for a larger shop with 200 assets, it becomes the basic control sheet that keeps the work visible.

Maintenance logs matter because service records support deductible repairs, depreciation decisions, and asset history. For tax and bookkeeping purposes, keep invoices, work orders, and PM logs for at least 3 years, and longer when the record supports property basis, a casualty loss, or a fixed asset that is still on the books.

The cost per service field helps you separate routine maintenance from capital improvements. A $180 belt-and-filter change on an HVAC unit is usually a repair expense, while a $4,800 compressor replacement may need depreciation treatment or Section 179 review depending on the facts.

Why the date fields matter

The date columns are there for control, not decoration. If you service a machine on 04/10/2026 and the cycle is 90 days, the next review point is 07/09/2026; without that math on the sheet, the task tends to disappear until someone complains.

Why a spreadsheet still works here

For a small operation, a spreadsheet is the right level of control before you move to a CMMS. If you are tracking 30 to 80 assets and updating them once a week, an Excel file is usually faster and cheaper than software that needs a full setup and a subscription.

The biggest failure is simple: someone enters the asset once and never comes back to it. That is how a $120 lubrication task turns into a $1,500 bearing failure or an HVAC unit misses filter service and starts pulling higher power for weeks.

Another common problem is date drift. If the last service date is wrong by even 30 days on a 60-day cycle, the next due date is wrong by the same amount, and the schedule quietly turns into a guess.

What missed upkeep looks like in dollars

Say you manage 4 forklifts and each one needs a $120 monthly service. If two services are missed for a quarter, that is $720 in direct maintenance plus the risk of a breakdown during a busy shipping week, which usually costs far more in labor and delay.

Why messy status fields cause trouble

If one person writes “done,” another writes “complete,” and a third leaves the cell blank, the dashboard stops telling the truth. Clean status choices matter because the whole point is to see what is overdue, what is due soon, and what is already closed.

The spreadsheet works best when it lives next to a fixed routine, not as a separate chore. Tie the update to payroll Friday, the Monday morning production meeting, or the last day of the month so the list gets touched on a schedule you already follow.

If you manage 25 assets, spend 10 minutes each week updating the last service date and cost entries. That small habit prevents a month-end scramble where you are trying to reconstruct 8 work orders from memory and old emails.

Simple habits that keep the file useful

• Copy the prior month’s review cadence and update only the changed rows.
• Use data validation for status choices so “due,” “overdue,” and “completed” stay consistent.
• Sort by next due date every week so the oldest items rise to the top.
• Use conditional formatting to flag overdue assets in red before they get missed again.

When to move beyond Excel

If you are tracking work orders, spare parts, labor hours, and approval workflows for hundreds of assets, a CMMS is the better tool. For a smaller team, though, this workbook is usually enough to keep the PM cycle organized without buying software you do not need yet.

For a smaller team, though, this workbook is usually enough to keep the PM cycle organized without buying software you do not need yet, while a maintenance KPI dashboard can summarize overdue work and completion rates at a glance.