Fleet Maintenance Log Template in Excel: Tracking Several Vehicles in One Workbook

The short answer

A workable Excel fleet maintenance log uses one workbook with three or four linked sheets instead of one tab per vehicle. A Vehicles sheet lists each car or truck once. A Service Log sheet records every completed job as its own row, tagged with a vehicle ID. A Schedule sheet holds each vehicle's service intervals and calculates when each task is next due. An Overview sheet then filters the schedule to show only what is due or coming up across all vehicles. This keeps each vehicle's history separate while giving the whole household or small fleet one shared to-do list.

Two conditions change this answer. First, Excel can highlight overdue work, but it does not send reminders on its own. If you need notifications, you will need an automation add-on or a dedicated maintenance app. Second, the template supplies the structure but not the intervals. Every interval you enter has to come from that specific vehicle's owner's manual or maintenance schedule. Intervals vary by model year, market, powertrain and how the vehicle is used.

Why one long log works better than one tab per vehicle

A common spreadsheet suggestion is one row per vehicle, with each new inspection date entered in the next empty column. That layout is easy to read for a few vehicles and a single task type. It gets awkward once you track oil changes, tire rotations, inspections and registrations across several vehicles, because the data can no longer be filtered or summarized cleanly.

Separate tabs per vehicle have a similar problem. They keep histories apart, but nothing can see across them to show what is due fleet-wide. A single log with a vehicle ID column gives you both views. Filter by ID to see one vehicle's complete history, or let formulas summarize the latest service of every task for every vehicle.

Sheet 1: Vehicles (the register)

Enter each vehicle once. Its ID is the key every other sheet uses, so keep it short and never reuse it, for example V01, V02 or a unit number.

Column | Purpose

Vehicle ID | Unique key used in every other sheet

Year / Make / Model | Identifies which owner's manual schedule applies

Engine or powertrain | Gas, diesel, hybrid and electric vehicles have different service items

VIN | Unambiguous identification for parts and service records

Plate | Quick visual identification

Assigned to | Household member or driver responsible

Current odometer | Latest reading, updated regularly

Odometer reading date | Shows how stale the reading is

Document folder | Name or path of the folder holding this vehicle's records

Sheet 2: Service Log (completed work only)

Each row is one completed job on one vehicle. Format the range as an Excel Table (Insert > Table) so formulas expand automatically as rows are added. Add a Data Validation dropdown on the Vehicle ID column that pulls from the Vehicles sheet. The dropdown prevents typos, which would otherwise split one vehicle's history into two.

Column | Purpose

Date | Date the work was completed

Vehicle ID | Dropdown from the Vehicles sheet

Odometer | Reading at the time of service

Task | Dropdown matching the task names on the Schedule sheet

Performed by | Shop name or the person who did the work

Parts / fluids used | Exactly what the invoice or receipt lists

Cost | Optional, for your own records

Document reference | File name of the invoice, receipt or inspection report

Notes | Anything worth knowing next time

Store scanned invoices and paperwork in one folder per vehicle ID, and name each file with the date, vehicle ID and task. The Document reference column then points to a file you can find in seconds, and each vehicle's paperwork stays as separate as its log entries.

Sheet 3: Schedule (what is due, per vehicle)

Add one row for each vehicle-and-task pair, such as V01 oil change, V01 tire rotation and V02 oil change. Enter the interval in miles, in months, or both, along with where the interval came from. Then let formulas pull the most recent matching entry from the Service Log.

Column | Entered or calculated

Vehicle ID | Entered

Task | Entered (same wording as in the log)

Interval miles | Entered from the vehicle's schedule

Interval months | Entered from the vehicle's schedule

Interval source | Entered, e.g. owner's manual, severe-service schedule

Last done date | Calculated

Last done odometer | Calculated

Next due date | Calculated

Next due odometer | Calculated

Status | Calculated

The formulas below assume the log is a Table named Log, the register is a Table named Vehicles, and the schedule is a Table with the column names above. MAXIFS requires Excel 2019 or Microsoft 365, and Google Sheets supports it as well. Taking the highest odometer value as the last reading assumes readings only increase, so correct any entry mistakes in the log.

Last done date:
=MAXIFS(Log[Date], Log[Vehicle ID], [@[Vehicle ID]], Log[Task], [@Task])

Last done odometer:
=MAXIFS(Log[Odometer], Log[Vehicle ID], [@[Vehicle ID]], Log[Task], [@Task])

Next due date:
=IF([@[Interval months]]="", "", EDATE([@[Last done date]], [@[Interval months]]))

Next due odometer:
=IF([@[Interval miles]]="", "", [@[Last done odometer]] + [@[Interval miles]])

Current odometer (helper column):
=XLOOKUP([@[Vehicle ID]], Vehicles[Vehicle ID], Vehicles[Current odometer])

Status:
=IF(OR(AND([@[Next due date]]<>"", TODAY()>=[@[Next due date]]),
       AND([@[Next due odometer]]<>"", [@[Current odometer]]>=[@[Next due odometer]])),
   "Due", "OK")

The Status formula treats a task as due when either limit is reached, which matches the "whichever comes first" wording many schedules use. If a task has never been logged, MAXIFS returns zero and the task shows as due immediately. Treat that as a prompt to record the last known service, or to schedule the work. XLOOKUP also needs Excel 2021 or Microsoft 365; in older versions, use INDEX and MATCH instead.

Sheet 4: Overview (the shared to-do list)

The Overview sheet is where everyone checks what needs doing. In Microsoft 365 you can build it with a single dynamic formula that lists only rows marked Due, sorted by due date:

=SORT(FILTER(Schedule[[Vehicle ID]:[Status]], Schedule[Status]="Due", "Nothing due"), 8, 1)

The 8 in that formula refers to the Next due date column, counting from Vehicle ID. Adjust it if your columns are in a different order. In older Excel versions, apply an AutoFilter or a PivotTable to the Schedule sheet instead. Add conditional formatting to color Due rows. To show work coming up soon, add a third status such as "Soon" for tasks within a set number of days or miles of their limit.

Keeping the workbook accurate

• Update each vehicle's current odometer on a regular rhythm; mileage-based due status is only as current as the latest reading.
• Log work as soon as it is completed, with the document reference filled in.
• Use dropdowns for Vehicle ID and Task so formulas match entries exactly.
• When a vehicle is sold, mark it inactive in the register rather than deleting it, so its history stays intact.
• Keep the workbook in one shared location so only one current copy exists.

PDF, free templates and apps

For a printable PDF version, filter the Service Log to one vehicle and use File > Export or Print to PDF. This gives you a per-vehicle history to keep with the car or hand to a buyer. A PDF is a snapshot, so the Excel workbook stays the working record.

Many free downloadable vehicle maintenance log templates are built around a single vehicle. Before adopting one for several vehicles, check that it has a vehicle ID column, or that you can add one. A template without it reproduces the one-tab-per-vehicle problem described above. Building the four sheets yourself is free and needs only the formulas shown here.

Some maintenance apps advertise multi-vehicle dashboards, service history, upcoming-task lists and reminders, and larger fleets often use dedicated fleet maintenance software. An app becomes the better choice when push reminders, phone-based entry or photo capture of receipts matter more than the flexibility of a spreadsheet. This guide has not verified any app's current features, pricing or data-export options. Confirm those directly before moving records into one, and check that you can export your history if you later switch tools.

What this guide does not cover

This template organizes records and due dates. It does not supply service intervals, fluid specifications or parts compatibility for any vehicle; take those from each vehicle's owner's manual or a qualified technician. It also does not address regulatory recordkeeping requirements for commercial fleets, which depend on jurisdiction and vehicle class and should be checked against the applicable authority's rules.