Free Fleet Maintenance Schedule Template (Excel)

Free Fleet Maintenance Schedule Template (Excel)

Fleet maintenance is different from facility maintenance in one important way: the stakes of a missed service interval are immediate and visible. A missed HVAC filter change is an efficiency problem. A missed MOT means the vehicle is off road. A missed DVSA inspection means you're facing an O-licence risk.

Most fleet operators I've spoken to run some version of the same system: a shared spreadsheet with registration numbers, MOT dates, and service dates. It works until it doesn't. The failure mode is usually one of two things — the spreadsheet isn't getting updated, or someone's on leave and nobody else knows what's due this week.

This template gives you a tighter structure that makes the upcoming schedule obvious without relying on one person to track it manually.

Download the Template

What Fleet Maintenance Tracking Needs to Cover

Fleet tracking has two distinct layers:

Statutory compliance — the dates you legally cannot miss:

• MOT expiry
• Tachograph calibration (every 2 years for analogue, every 2 years for digital)
• Driver CPC training (35 hours per 5-year period)
• LOLER inspections (if your vehicles carry lifting equipment)
• Annual DVSA safety inspection (for HGVs under an O-licence)

Planned maintenance — the intervals set by manufacturer or policy:

• Engine oil and filter
• Brake inspection
• Tyre condition and depth check
• Coolant, transmission fluid, air filter
• Full service at mileage or calendar intervals

Both layers need to be in the schedule. The mistake most operators make is tracking statutory dates in one place and service intervals in another — you end up with two partial systems instead of one complete one.

Building the Schedule

Core structure

Calculating next due dates

For calendar-based tasks:

=IFERROR(
  IF(F2="Annual", E2+365,
  IF(F2="6 Monthly", E2+182,
  IF(F2="Quarterly", E2+91,
  IF(F2="Monthly", E2+30,
  IF(F2="2 Yearly", E2+730, "")
  )))), ""
)

MOT dates are fixed (set by the test result) — enter the expiry date directly rather than calculating from last completed.

Colour-coded status

Add three conditional formatting rules to your Next Due (Date) column:

Overdue: Formula =AND(G2<TODAY(), G2<>"") → Red fill

Due within 14 days: Formula =AND(G2>=TODAY(), G2<=TODAY()+14) → Amber fill

Due within 30 days: Formula =AND(G2>TODAY()+14, G2<=TODAY()+30) → Yellow fill

14 days gives you enough lead time to book vehicles in without disrupting operations. 30 days is your planning horizon.

MOT Tracking Specifically

MOT management is where most fleet spreadsheets fall over, because the consequences of missing it are immediate: the vehicle can't legally be driven until it passes.

A few rules that make it less likely to happen:

Track the expiry date, not the test date. The expiry date is the one that matters. Enter it directly and calculate reminders from it.

Treat the 14-day warning seriously. Booking a vehicle in for an MOT two days before it expires is how you end up with a failed vehicle and no replacement. 14 days gives you time to rebook if it fails first time.

Note the test station. If a vehicle fails, you want to know which station it's at and who to call. Keep this in the Notes column.

Annual DVSA inspections are not the same as MOTs. HGV operators need annual safety inspections under their O-licence. These are separate from MOTs. Both need to be in your schedule.

Tachograph Calibration

For operators running digital tachographs:

• Calibration interval: Every 2 years from the calibration date (not the approval date)
• Where to get it done: Must be carried out by an DVSA-approved tachograph centre
• What to track: Last calibration date, calibration centre, next due date, vehicle unit number

Add a separate section or sheet for tachograph records. The calibration certificate should be kept with the vehicle — your spreadsheet is the tracking layer, not the certificate itself.

Defect Reporting

The template is for scheduled maintenance. But fleet operators also need a defect reporting process — drivers checking vehicles before use and reporting faults immediately.

This is a separate process from the maintenance schedule. What connects them is the vehicle registration. When a defect is reported on REG-123, a work order gets created for REG-123, and the maintenance log for REG-123 gets an entry.

If you're building a complete system, see the full CMMS Excel template which gives you work orders and a maintenance log alongside the schedule.

When This Outgrows Excel

Fleet maintenance spreadsheets have a specific failure mode: the person managing the file.

When they go on leave, are sick, or leave the company, the schedule knowledge goes with them. Whoever inherits it doesn't know which vehicles are due what, can't read the formulas, and doesn't have the context.

A system that depends on one person's familiarity isn't a system — it's a single point of failure.

The other common issue is drivers. Getting drivers to report defects and service reminders back to a spreadsheet is hard. It requires them to have access, remember to update it, and do it before the fault becomes a breakdown.

If this is where you're at, the 5 signs you've outgrown spreadsheets covers the transition.

Related Templates

• Full CMMS Excel Template — the complete system for any maintained asset, including vehicles
• Work Order Template — reactive jobs alongside the planned schedule
• Maintenance Log Template — the audit trail of everything done on each vehicle