Vehicle Maintenance Log
This vehicle maintenance log template was created based on a user's request for a template to keep track of auto repairs and upkeep. It has all the requested features, including columns for the date of service, work performed, mileage at service, and cost. After creating it I discovered another very handy use. In addition to recording actual vehicle maintenance work, you can use the log to create a vehicle maintenance schedule. Now, before I take the car in for servicing, I'll print out my log with the recommended schedule so that I can tell whether I really need that "flush and replace every fluid in the entire vehicle" service.
Where can I find a recommended maintenance schedule? If you don't have the original service schedule that came with your vehicle, then you can do what I did and go to Edmund.com's Car Maintenance Guide to get the Manufacturer's Recommended Maintenance Schedule. I added a link to that page within the spreadsheet plus some fields at the top of the worksheet for recording some of the information you'll need (like the Make, Model, Year, Engine).
Vehicle Maintenance Log
for Excel and Google Sheets
Download
⤓ Excel (.xlsx)License: Private Use (not for distribution or resale)
"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer
Description
Very little spreadsheet experience is required to use this template. The few tips you may need to know are listed in spreadsheet (such as using Alt+Enter to add a new line within a cell). The main calculation is the SUM() formula used to display the total cost.
Thanks to Ryan for suggesting this template via Vertex42's Facebook page.
Update 1/28/2022: I made some cosmetic changes, added an invoice column for recording an invoice or receipt #, and the new fleet inventory worksheet mentioned below.
New Fleet Inventory Worksheet
I added a new fleet inventory worksheet to this template for companies that are using it to track maintenance of multiple vehicles. I also added a "Fleet ID" field to the maintenance log for easily identifying specific vehicles by nickname or number.
New worksheet added to the Vehicle Maintenance Log template!
You can create a separate vehicle log worksheet by right-clicking on the tab for the log and selecting "Move or Copy..." Then rename the new worksheet to "Vehicle 2" or use some other convenient naming scheme. Within the fleet inventory worksheet, you can use a simple formula to reference the Fleet ID and the Total Cost within each log worksheet.
Related Templates
- Mileage Log - Track your mileage to calculate your vehicle's average MPG.
- Auto Loan Calculator - Have your financing figured out before going to the dealership.
- Home Budget - Use this spreadsheet or one of our many other budget templates for handling variable expenses like vehicle maintenance.
