How to Check Whether Overdue Maintenance Was Done or Rescheduled
Last Friday the preventive maintenance review showed eight overdue work orders. This Friday’s open-overdue queue shows three. Two were completed and three got new due dates. The site manager needs both numbers before deciding how much work next week can take.
Compare two saved work-order snapshots by work order ID. Keep original or prior due dates, current due dates, completion timestamps and status so the overdue roll-forward explains what changed.
What happened to last Friday’s eight overdue items?
This example tracks the original eight orders as a cohort in an open-work backlog. Check newly overdue orders separately. This is a spreadsheet roll-forward, not a reproduction of MaintainX’s On Time vs. Overdue total: that report also includes work completed after its due date as Done Overdue. Filter and label open and completed work explicitly.
| Friday-to-Friday outcome | Orders |
|---|---|
| Completed | 2 |
| Still open, now due in the future | 3 |
| Still overdue | 3 |
| Starting cohort | 8 |
Five left the starting overdue list, and two were completed. The three rescheduled orders still need room on the maintenance calendar.
Keep a snapshot before dates move
Save the weekly CMMS work-order list with ID, asset, due date, completion, current status and owner. Use change history for original due dates if available. A fresh export alone usually shows the latest due date.
Classify using status and timestamps together
Separate completed, rescheduled, canceled, still overdue and unknown outcomes. Add newly overdue items as a separate line to reconcile the full current backlog. Preserve any due-date change reason that the system records.
Bring the rescheduled work back into the plan
Add the due-date change reasons and estimated labor requirements, if tracked, to the two snapshots.
Which previously overdue PM work orders were completed, rescheduled, canceled, or still overdue? Show old and new dates, completion evidence and source rows.
Check the workload on the new due dates. Three jobs moving off last week’s list can still make one day next week too full.
MaintainX overdue reporting · MaintainX work-order status reporting
The figures and identifiers in this example are synthetic. The displayed arithmetic was checked independently. A live Jolene.pro result could not be verified.
Try this with your own spreadsheet at Jolene.pro. Follow Jolene.pro on LinkedIn for more spreadsheet guides.
For more checked examples, see Jolene.pro Workbook Studies.
Related checks: How to Find Fleet Service Reminders Based on Stale Odometer Readings.