Maintenance KPI Excel - Free Template

1. Open the KPI Data tab and review the 10 populated example rows. Replace the examples with your own work orders, keeping one work order per row.
2. Enter the yellow-shaded input fields, including Work Order ID, asset details, department, maintenance type, priority, dates, assigned technician, planned downtime, labor hours, labor rate, parts cost, status, SLA target, and notes.
3. Use the dropdowns for Maintenance Type, Priority, Status, and Department. The available values come from the Lists & Instructions tab.
4. When a job finishes, update Completion Date, Actual Downtime Hours, Labor Hours, Parts Cost, and Status. The workbook calculates Labor Cost, Total Maintenance Cost, SLA Met?, and downtime savings versus plan.
5. Open the KPI Dashboard to review work-order counts, overdue unfinished work, SLA Compliance Rate, average labor hours, average downtime, total maintenance cost, and mean downtime savings.
6. Review the status and maintenance-type charts, then inspect the monthly cost chart for January through December 2026.
7. When you add work orders beyond the prepared rows, copy the formulas from the existing calculated columns into the new rows. Follow the Lists & Instructions guidance and use MM/DD/YYYY for dates.

A maintenance supervisor at a manufacturing plant can use the KPI Data tab during the daily work-order review. The fields cover the asset, site location, department, maintenance type, priority, assigned technician, planned downtime, actual downtime, and completion status, so the same row follows a job from assignment through closeout.

For example, the populated rows show equipment such as CNC Machine #4, Conveyor Belt B2, and Hydraulic Press across Chicago, Dallas, and Houston locations. A multi-site team can compare preventive, corrective, emergency, inspection, and calibration work without keeping separate paper lists for each facility.

During the Weekly Maintenance Meeting

An office coordinator or maintenance planner can update open and in-progress jobs before the weekly meeting. The dashboard then shows Total Work Orders, Completed Work Orders, Open Work Orders, and Overdue unfinished work orders, giving the team a direct list of workload and unfinished commitments.

Image 1 shows the detailed entry layout on KPI Data. The yellow cells are intended for manual inputs, while Labor Cost, Total Maintenance Cost, SLA Met?, and downtime savings versus plan are calculated fields. This distinction matters when several people enter data: users should update the source measurements rather than overwrite results.

For Cost and Reliability Reviews

A plant manager can use the dashboard after month-end to review Total Maintenance Cost, Average Labor Hours, Average Downtime Hours, and Mean downtime savings versus plan. The maintenance-type chart separates preventive, corrective, emergency, inspection, and calibration work, while the status chart separates completed, open, overdue, and in-progress orders.

The workbook includes ten example rows and formulas prepared in rows 3 through 12. Replace those examples with actual work orders before using the dashboard for an operating review.

The workbook uses direct operational formulas rather than a separate accounting or compliance rule set. In KPI Data, Labor Cost equals Labor Hours multiplied by Labor Rate. Total Maintenance Cost then equals Labor Cost plus Parts Cost, giving you a visible cost build-up for each work order.

SLA compliance is intentionally limited to completed work orders with a valid positive SLA target and valid actual downtime. The dashboard calculates SLA Compliance Rate from the rows marked Yes or No, excluding incomplete records that cannot produce a meaningful result.

Downtime Savings Versus Planned Downtime

The field labeled Downtime savings vs. plan % measures planned downtime against actual downtime. Its formula is 1 minus Actual Downtime Hours divided by Planned Downtime Hours. If planned downtime is 6 hours and actual downtime is 4 hours, the result is approximately 33.3% savings; if actual downtime is 8 hours, the result is approximately -33.3%, meaning an overrun rather than uptime.

Rows with missing or invalid downtime values do not produce a misleading result. That is important because an empty percentage should signal incomplete measurements, not successful performance.

Dashboard Time Coverage

Image 2 shows the dashboard layout with KPI cards, status and maintenance-type summaries, and the monthly cost section. The monthly cost formulas use work-order dates from January through December 2026, while the headline KPIs reference the recorded data range and are not limited to one year.

Use MM/DD/YYYY dates as instructed on Lists & Instructions. The workbook is delivered in XLSX format, and the monthly chart is specifically labeled for 2026; it should not be read as a rolling year chart.

The most damaging error is entering a completion status without the measurements needed to support it. A job marked Completed but missing Actual Downtime Hours, Labor Hours, or Parts Cost can distort cost, average downtime, and SLA analysis even though the work-order count still increases.

Incomplete Closeout Data

Suppose a technician closes a corrective job as Completed but leaves Parts Cost blank and does not enter Actual Downtime Hours. The dashboard may count the order as completed, yet its cost and downtime contribution will not represent the full job. Make closeout data part of the completion step instead of treating it as optional follow-up.

Another frequent problem is confusing planned downtime with actual downtime. The workbook's V result is savings versus plan, not uptime. If actual downtime exceeds the plan, the percentage is negative; changing the label or interpreting a negative value as a formula error would reverse the management decision.

Mixed Categories and Dates

Typing variations such as Corrective, corrective, and Corrective Work can split maintenance-type counts. The built-in dropdowns for Maintenance Type, Priority, Status, and Department reduce that risk, so use them rather than manually inventing category names.

Date mistakes create a separate reporting problem. A date entered in an inconsistent format may prevent a work order from appearing in the intended 2026 monthly cost period. Image 3 shows Lists & Instructions, including the MM/DD/YYYY requirement and the guidance to replace the ten example work orders.

Overwriting Calculated Fields

Do not type over Labor Cost, Total Maintenance Cost, SLA Met?, or downtime savings versus plan. If you extend the prepared rows, copy the formulas into the new rows; otherwise the dashboard can count the new order while its calculated outputs remain blank.

Set one fixed update point before the weekly maintenance meeting. The planner should enter new work orders, while the assigned technician or supervisor updates Completion Date, Actual Downtime Hours, Labor Hours, Parts Cost, and Status when the job closes.

Use a Simple Closeout Sequence

• Confirm the Work Order ID, asset, department, maintenance type, and priority.
• Enter planned and actual downtime in hours, not mixed text such as 4 hrs.
• Enter Labor Hours, Labor Rate, and Parts Cost before setting Status to Completed.
• Check the dashboard for unexplained changes in cost, SLA compliance, or overdue unfinished work.

This sequence protects the calculations because the workbook expects numeric inputs for hours, rates, and costs. It also prevents a completed order from being counted as operationally complete when its cost or downtime record is unfinished.

Review the Dashboard at Month-End

At month-end, compare Total Maintenance Cost with the monthly cost table on KPI Dashboard. The table has one row for each month of 2026, so use it for the 2026 operating review and use the headline KPIs when you need the broader recorded-data view.

Keep the Lists & Instructions tab available for new users. Image 3 identifies the permitted list values and explains that yellow-shaded cells are editable. When you add orders beyond the ten prepared rows, copy the calculated formulas and verify that the new rows feed the dashboard.

Move to a dedicated maintenance system when multiple users need simultaneous editing, asset history, approvals, notifications, or substantially more than the prepared workbook structure can comfortably manage. This XLSX file is best suited to a controlled work-order log and periodic KPI review.