Skip to content
Vehicle Maintenance Log cover: a sample sheet with vehicles tracked, services logged and total spent and a column chart, beside the Dashboard and Vehicles tabs

Vehicle Maintenance Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

Households with two or three cars, couples who share a vehicle and small businesses with a van or pickup can keep a service history here. The Dashboard shows vehicles tracked, services logged, total spent and average visit cost, plus charts of spending by vehicle and by type of service. The Vehicles tab lists each car with its year, latest odometer reading, last service date and money spent, and the Service log tab records every visit with its date, mileage, cost and the shop that did the work.

Update the odometer on the Vehicles tab whenever you log a visit, so the reading stays current. Use the same service names every time, such as Oil and filter, because the breakdown counts depend on an exact match. Check the owner's manual for the mileage each job is due, since this sheet shows what was done and does not calculate when the next visit falls.

Useful for

  • Keep a record of oil changes and tyre rotations
  • Compare what each vehicle has cost to run
  • Prepare a service history before selling a car

What's included

  • 4 tabs: Dashboard, Vehicles, Service log, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Vehicles: a table
  • Service log: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Vehicles tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How can I tell that an oil change is coming up?

Look up the interval for each job in the owner's manual, such as miles between oil changes, then add it to the last odometer reading yourself. The sheet records each visit but does not hold a schedule, so it will not send reminders on its own.

Can the log hold the family car and the work van together?

Yes. Add each vehicle as a row on the Vehicles tab, then pick its name from the Vehicle list on the Service log tab. Duplicate a line in the Spend by vehicle breakdown, then rename it, so the new vehicle's totals show up on the Dashboard.

Should I log jobs I did myself?

Yes. Write Owner in the Done by column and enter the parts cost in the Cost column. The totals then show what the vehicle has really needed, and the notes column reminds you which parts you bought and where.

  • #tracker
  • #vehicle-maintenance-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 15

Also in Business operations

All business operations templates
Get this template

Preparing your template…