Preventive Maintenance Schedule Template (Excel): Set Up, Track and Measure

A preventive maintenance schedule template is a spreadsheet that lists every machine you depend on, the maintenance tasks each one needs, how often each task must be done, when it was last done and when it is due next — with overdue tasks highlighted automatically. For a small manufacturer, bakery, print shop or workshop with a handful to a few dozen pieces of equipment, a well-built Excel or Google Sheets template replaces memory and sticky notes, cuts surprise breakdowns and gives you the data to decide when a machine is worth repairing or replacing. The template works best with three linked tabs: an equipment register, a task schedule and a maintenance log.

This guide belongs to our Small-Scale Manufacturing section. Below you’ll find the tab structure, the formulas, a worked example for a small food production kitchen and the metrics that show whether the schedule is working.

Why a schedule beats “fix it when it breaks”

Run-to-failure looks cheap until a key machine stops on your busiest day. Preventive maintenance trades small, planned tasks — lubricating, cleaning, inspecting, replacing wear parts — for fewer unplanned stops. It does not mean maintaining everything as often as possible; it means doing the right tasks at the right interval on the equipment that matters most.

The three tabs of the template

1. Equipment register

• Asset ID (EQ-01, EQ-02…), name, make, model, serial number, location
• In-service date, supplier and service contact
• Criticality: A = stops production, B = slows production, C = minor impact
• Manual location (link to the PDF) and any external inspection due date

2. PM schedule

• Asset ID and looked-up asset name
• Task description, interval (days or run hours), estimated time
• Assigned to, last done, next due, days left, status
• Parts or supplies needed

3. Maintenance log

• Date, asset ID, type (preventive or corrective), what was done
• Downtime hours, labor hours, parts used, cost, technician

Keeping the log separate from the schedule is what makes the template useful long term: the schedule tells you what to do next; the log tells you what actually happened and what it cost.

Formulas that run the schedule

Next due date

With the interval in days in D2 and the last-done date in F2: =F2+D2. When a technician enters the new completion date, the next due date updates itself.

Days left and status

• Days left: =G2-TODAY()
• Status: =IF(G2<TODAY(),"Overdue",IF(G2=TODAY(),"Due today",IF(G2-TODAY()<=7,"Due this week","Scheduled")))

Add conditional formatting — red for Overdue, orange for Due today, yellow for Due this week — and sort by next due date.

Usage-based tasks

For equipment maintained by run hours, add three columns: hours at last service (J), interval in hours (K) and current hour meter reading (L), updated weekly. Hours remaining: =J2+K2-L2. Flag it when the result is 0 or less: =IF(J2+K2-L2<=0,"Due",""). If a task has both a calendar and an hours limit (“every 500 hours or 6 months, whichever comes first”), set the status to due when either test is true.

Look up asset names

=XLOOKUP(A2,Equipment!A:A,Equipment!B:B,"Unknown ID"). In older Excel versions use =IFERROR(VLOOKUP(A2,Equipment!A:B,2,FALSE),"Unknown ID").

Weekly workload

To see how many maintenance hours fall in a given week (week start in N1): =SUMIFS(E:E,G:G,">="&N1,G:G,"<"&N1+7), where E is estimated time and G is next due. If one week is overloaded, move a non-critical task forward.

Worked example: a small food production kitchen

A bakery producing for wholesale customers maintains a spiral mixer, a deck oven, a walk-in cooler, a band sealer for packaging and an air compressor. The sheet was checked on November 6, 2026.

The production manager sees immediately that the oven thermostat check slipped by five days — on a criticality-A machine that drives product quality — and that two small tasks are due today. The intervals here are illustrative; for your own template, start from each manufacturer’s manual and adjust based on how hard the equipment works.

Metrics that show whether the schedule works

In Excel, PM compliance for October can come straight from the log: count preventive entries completed on or before their due date with COUNTIFS, then divide by the number of tasks that were due that month. If planned maintenance stays low and unplanned downtime keeps rising on one machine, either the task list is wrong or the machine is near the end of its useful life.

Setting up the template in six steps

1. Walk the floor and list every asset with its ID, location and criticality.
2. Collect the manuals and write down recommended tasks and intervals. For older equipment without documentation, ask the supplier or start conservatively and adjust.
3. Build the schedule: one row per task, with time estimate and owner.
4. Enter real last-done dates, not guesses, so the next due dates are trustworthy.
5. Stock the parts: filters, belts, gaskets and lubricants need a minimum quantity in your inventory template, and replenishment can go through a purchase order template.
6. Review monthly: overdue tasks, breakdowns, costs and whether any interval should change.

Inspections required by law or insurers

Some equipment — such as boilers, pressure vessels, lifting equipment and forklifts — can be subject to inspection or examination requirements set by regulators, local codes or your insurer. Those inspections are separate from your own preventive tasks. Add their due dates to the equipment register so the template reminds you, and confirm the exact requirements for your location and equipment with the relevant authority, your insurer or a qualified inspector.

Common mistakes

• Too many tasks: a schedule nobody can complete gets ignored. Start with criticality-A equipment.
• No corrective entries in the log: without breakdown data you can’t tell whether preventive work is paying off.
• Last-done dates not updated: assign one person to update the sheet at the end of each shift.
• Overwritten formulas: lock the calculated columns — see how to protect formulas in Excel.
• Ignoring cost: record parts and labor so maintenance shows up in your business expense tracker and budgeting.

Spreadsheet or CMMS?

A spreadsheet works well while one or two people handle maintenance, the asset list is manageable and work requests come through a single channel. A CMMS (computerized maintenance management system) starts to pay off when several technicians work in parallel, you need mobile work orders, barcode asset tags, parts reservations or detailed audit trails. The asset IDs, task lists and log you build in the template import cleanly into most systems later.

FAQ

How often should preventive maintenance be done?

Follow the manufacturer’s recommended intervals first, then adjust: shorten intervals for equipment that fails between services or runs in harsh conditions, and lengthen them only when the log shows consistently good condition.

Can I use this template in Google Sheets?

Yes. TODAY, IF, XLOOKUP, SUMIFS, COUNTIFS and conditional formatting all work in Google Sheets, and a shared sheet lets technicians update tasks from a phone on the shop floor.

What is a good PM compliance rate?

Many teams aim for 90% or higher, but the trend matters more than a single month. If compliance drops, check whether the schedule is overloaded or tasks are being skipped during busy production periods.

How do I schedule maintenance without stopping production?

Use the weekly workload view to place longer tasks in planned downtime — before the first shift, on a slow day or during changeovers — and coordinate with your employee schedule.

Next step: create the equipment register for your criticality-A machines this week, add their tasks with real last-done dates, and let the formulas calculate what’s due. For more templates by industry, visit Tools by Industry.