A vehicle maintenance log records, for each vehicle, what was serviced, when, at what mileage, by whom and what it cost, and it tells you when the next service is due. The fastest way to get one that keeps itself up to date is Fixeets Maintenance: it is free to start, it creates the log as a Google Sheet in your own Drive, and it schedules each service by date or by odometer reading so oil changes, tire rotations and inspections come up on time.
Prefer to start from a plain spreadsheet? Further down you will find the columns and formulas for a do-it-yourself vehicle maintenance log in Google Sheets or Excel.
Key takeaways
- A useful vehicle log does two jobs: it keeps the service history and it tells you what is due next, by date or by miles.
- Fixeets Maintenance creates the log in your own Google Drive and schedules services by date or by meter reading (miles, kilometers, engine hours).
- The free plan covers 1 user, 10 vehicles or other equipment and 10 service reports a month. The paid plan is a flat rate, not per vehicle or per user.
What goes in a vehicle maintenance log
Whether you use paper, a spreadsheet or an app, the same information makes a log useful when you need it, at resale, after a breakdown or when an inspector asks:
- Vehicle details: unit number or plate, make, model, year, VIN, in-service date.
- Each service: date, odometer reading, work done, parts used, cost, and who did it (in-house technician or outside shop).
- What is due next: the next date or mileage for each recurring service.
- Problems reported: breakdowns and driver reports, and when they were fixed.
The last two are where most paper logs and simple spreadsheets fall short. They record the past well, but nobody gets reminded that van 4 passed its oil-change mileage two weeks ago.
The Fixeets vehicle maintenance log, tab by tab
When you create your file, Fixeets Maintenance sets up these tabs in your Google Sheet. Each vehicle is one row of equipment.
| Tab | What it holds for a fleet | Main columns |
|---|---|---|
| Equipment | One row per vehicle | Equipment ID, Equipment Name, Category, Brand, Sector, Commissioning Date |
| Technicians | Your mechanics or the shops you use | Technician, Email Address, Company, Hourly Cost |
| Preventive Interventions | Recurring services and when they are next due | Equipment ID, Intervention Type, Tasks to Perform, Next Maintenance, Frequency, Frequency Unit, Technician |
| Incidents | Breakdowns and problems reported by drivers | Incident Date, Equipment ID, Incident Type, Equipment Availability, Priority |
| Intervention report | The service history: every job done | Equipment ID, Intervention Type, Intervention Report, Intervention End Date, Items Used, Additional Cost, Photo / Document |
You do not fill these tabs by hand. You add vehicles, plans and reports from the web app, the Google Sheets add-on or the iPhone and Android apps, and Fixeets writes the rows. The Intervention report tab in particular is filled by the app when a job is marked done, which is what keeps the history trustworthy.
Services due by date or by mileage
Each recurring service is a preventive plan on a vehicle, with one of two triggers:
- By date: "Annual DOT inspection, every 12 months" or "Brake check, every 3 months".
- By meter reading: "Oil change every 5,000 miles" or "Hydraulic service every 500 engine hours". The unit is yours to set: mi, km, h or cycles.
For mileage plans, someone enters the odometer reading from time to time, from the phone app for example. As soon as a vehicle passes its target, the service shows as due. When the job is done, the technician completes it with the mileage, parts used and notes, and Fixeets moves the next due point forward (from 25,000 to 30,000 miles, say). You never edit a due date by hand.
Example. A plumbing company in Phoenix runs six service vans. Each van has three plans: oil change every 5,000 miles, tire rotation every 7,500 miles, and a brake inspection every 6 months. Drivers enter their odometer on Fridays from their phones. On Monday the office opens the list of what is due, books two vans for the shop, and the history of each van builds up on its own.
Get the template in your Google Drive
- Open the Fixeets Maintenance web app, or install the add-on from the Google Workspace Marketplace and open it from a blank Google Sheets file.
- Sign in with Google and create your maintenance file.
- Add your vehicles as equipment, then add one preventive plan per recurring service.
- Log work as it happens: complete a planned service, or report a breakdown as an incident and close it with a report.
Build your own vehicle maintenance log in Google Sheets
If you want a plain spreadsheet, two tabs are enough for a small fleet.
Tab 1, Vehicles. Columns: Unit (A), Plate (B), Make and model (C), Current odometer (D), Last oil change at (E), Oil change interval (F), Next oil change at (G), Status (H).
Tab 2, Service log. Columns: Date (A), Unit (B), Odometer (C), Service (D), Parts (E), Cost (F), Done by (G), Notes (H). Add one row per job and never overwrite an old one.
Last oil change mileage. In Vehicles, cell E2:
=MAXIFS('Service log'!C:C, 'Service log'!B:B, A2, 'Service log'!D:D, "Oil change")
Next oil change. In G2: =E2+F2
Status. In H2:
=IF(D2>=G2, "Due", IF(G2-D2<=500, "Due soon", "OK"))
Add a dropdown on the Service column so the same job is always written the same way, otherwise "oil change" and "Oil Chg" will not match. Repeat columns E to H for each recurring service you want to follow, or keep it to the one or two that matter most.
This works for a handful of vehicles and one person keeping it up. Once several drivers or technicians are involved, or you want reminders without opening the file, a maintenance management app on top of the same Google Sheet is less work. See also how to build a maintenance history log that people actually use.
What the free plan includes
| Free (Standard) | Enterprise | |
|---|---|---|
| Users | 1 | Multiple users with permissions |
| Vehicles and other equipment | 10 | Unlimited |
| Preventive plans and incidents | Unlimited | Unlimited |
| Service reports | 10 a month | Unlimited |
| Phone apps (iPhone, Android) | Yes | Yes |
| Price | Free | Flat monthly rate, see pricing |
For fleets, see also our page on fleet maintenance and vehicle service tracking.
FAQ
Is there a free vehicle maintenance log template for Google Sheets?
Yes. Fixeets Maintenance creates a free vehicle maintenance log in your own Google Drive, with tabs for vehicles, recurring services, breakdowns and the service history. The free plan covers 1 user, 10 vehicles and 10 service reports a month, and preventive plans are unlimited.
Can I schedule maintenance by mileage instead of by date?
Yes. Each recurring service can be set by date or by meter reading, in miles, kilometers, engine hours or another unit you choose. Enter the odometer reading from the phone app and the service shows as due once the vehicle passes its target.
What should a vehicle maintenance log include?
At minimum: the vehicle, the date, the odometer reading, the work done, parts used, cost and who did it. A good log also shows the next due date or mileage for each recurring service and keeps breakdowns on record next to planned work.
Can drivers or mechanics log work from a phone?
Yes. Fixeets Maintenance has iPhone and Android apps. A mechanic can complete a service with the mileage, notes and a photo, and a driver can report a problem as an incident. Everything lands in the same Google Sheet. Several users with their own permissions need the paid plan.
Does it track parts used on each service?
Yes. Each service report records the items used and any additional cost. If you also use Fixeets Inventory for your parts stock, the parts used can be taken out of that inventory.
Can I ask Claude to log a service?
Yes. With the Fixeets Maintenance connector for Claude, you can write "oil change done on van 3 at 48,200 miles" and Claude records the report and moves the next due point. See connect Fixeets to Claude.