To avoid these ads, REGISTER NOW!

Spreadsheet for Vehicle Info/Maintenance Log

eville

Member
Joined
Mar 20, 2008
Messages
11
I find myself in a situation where I have a couple of ATVs, two boats, an old car and my young brain is becoming my old brain and things I used to remember I now don't. Most of the toys are a couple of hours away at the lake and I get up there once or twice a month right now.

I wanted to start a spreadsheet with a tab for each vehicle with a bunch of details like tire sizes, oil filter number, oil type, etc so when I'm ready to do a project I can reference my sheet and know what to order.

Does anyone here use a similar spreadsheet? I googled and didn't find what I was looking for but always prefer to see what others are using before I recreate the wheel.

Thanks.
steve
 
To avoid these ads, REGISTER NOW!

engineer2

Well-known member
Joined
Dec 13, 2009
Messages
11,798
Location
Chicago burbs
I do this for the 5 vehicles I maintain. As you said, a separate tab for each vehicle. I color the tab to match the vehicle color.
I keep all this on a keychain flash drive.

Mine isn't highly organized.
List of vehicle info such as:
VIN
Plate number and renewal date
Model
Build Date
Age =(TODAY()-BuildDate)/365
Paint code
Interior color code
Wheel size
Tire size
Gas Tank size
wiper blade sizes
Remote battery type
Battery type
Air filter
Cabin filter
Shop manual link online
Spark plugs
trans filter part number
Drivetrain warranty
Headlight part numbers

I have a few lists
ToDo list for those nagging minor repairs.
Salvage yard shopping list
Torque specs

The maintenance log is simply 3 columns:
Date - Miles - Service Performed
I also try to include upcoming service.

I make a chart to plot out miles driven per year.
I also calculate miles between oil changes since I mostly go by the maintenance reminder rather than miles driven.
 

Speed4Life

Well-known member
Joined
Jan 27, 2014
Messages
234
Not sure if you are an App person but I use one on my phone called Autosist. I think you get one vehicle free and then if you want unlimited it's like a one time fee of 20 bucks. It's pretty comprehensive and works well for me. Spreadsheets are a great way to do it too.
 

MotoCARR

Well-known member
Joined
Mar 5, 2013
Messages
137
Location
IL
Spreadsheet user here with basically the same info as engineer2. Usually I'm buying vehicles on the cheap and I use tabs to track costs to make sure I'm not underwater on them more so than maintenance.
 

rlitman

Well-known member
Joined
Oct 18, 2010
Messages
24,596
Location
Long Island
I use a Google Sheets spreadsheet. That way I can update it on my phone as I work on the vehicle (or when I read the mileage), and can also see it from my computer as I price out parts online.

One sheet per vehicle as a running maintenance log, plus one sheet per vehicle with parts notes. One cheat sheet with the emissions readiness codes I need to check for in each vehicle (required for the annual inspection). One sheet with all the tire sizes, one with all my wiper blade sizes, and finally one with all my oil filter info.
 

LifeLongWNYer

Well-known member
Joined
Oct 23, 2013
Messages
1,231
Location
South of Rochester, NY
I use an Excel spreadsheet, but I have a column for cost of each service, and the mileage at which it was done. I total the costs, and divide by the mileage, and I get a pretty accurate of now much it cost me to drive a mile in each of my vehicles.

It really doesn't mean a lot, but I find it interesting.




.
 

KBigg

Well-known member
Joined
Apr 15, 2019
Messages
474
Location
NE Indiana
I just use the notes in my phone. When i replace a part i write the PN, date, and milage. Im fairly computer illiterate so this works great for me. I also recently started using the carfax thing as well and so far im a fan.
 
Last edited:

velillen01

Well-known member
Joined
May 20, 2015
Messages
481
Location
Wyoming
Nothing to fancy for me. I have a binder that he dividers for each vehicle or trailer or whatever. In it it has the "specifications" pages from the owner manual. You know the pages that tell you how much oil, coolant, spark plugs, ect. For oil changes I have a whiteboard with all the weights of oil I have, how much of that weight of oil I have, and which cars use it. Then I just have a simple lined sheet I write maintence on. Basically like...

Oil change, milages, date
Wiper blades, milage, date

Pretty much just item or service performed, milage it was done at, and the date I did.
 

Hutchinsonkw

Member
Joined
May 15, 2017
Messages
16
Location
Central Maryland
I use a whiteboard and keep track of oil change, trans change, diff change, tire rotation, air filter, cabin filter, brakes.

Next to the board I have a piece of paper with filter numbers oil amounts for my truck and wife’s car.

I am thinking about using google docs so I can do it from my phone, as suggested above.
 

yeldogt

Well-known member
Joined
Jan 2, 2012
Messages
18,184
Cars don't really need all that much today .... I manage a fleet of cars (business and personal) Most need oil at 10k .. some of the older ones are 7.5 K the flex service vehicles typically go off at 12k. I do the rotation at the same time .. nothing to remember. If the car has 28k and it's a 10k car I know it due in 2k.

For everything else I use a brother P-touch label maker. 4 new tires = 4xTires 54k 5/19. I put all of them in the engine compartment or the inside of the hood. Brake fluid refresh -- date goes near the tank. I can see everything when I check the oil -- or if I hear something with an older one I can easily check to see what's been done. I do the same with air and cabin filters. All of my smaller equipment gets a sticker when I change oil/ filter or new plug. New tires on the tractor or cart -- gets a sticker.

For all of my equipment I just have a simple document with a list -- all the vital information. Today with the "cloud" I can pull the document up on any device.

I still have a file for the cars -- but it's just for receipts.

years ago when oil was 3500miles and air filters 5k -- it came up quick. The programs take too much time and it's easier to have the info on the item.
 
To avoid these ads, REGISTER NOW!

TriumphFan

Well-known member
Joined
Feb 4, 2019
Messages
584
Location
North Georgia
I use a binder where I handwrite everything done to each vehicle including part numbers, mileage, any notes. I have a 8 vehicles, 10 motorcycles, boat, farm equipment, etc. to keep track of and it really helps. I've thought about transferring it to an excel spreadsheet but I can't justify the time to do it. plus, I've been a victim of a crashed hard drive and would hate to lose all the information.
 

yeldogt

Well-known member
Joined
Jan 2, 2012
Messages
18,184
I use a binder where I handwrite everything done to each vehicle including part numbers, mileage, any notes. I have a 8 vehicles, 10 motorcycles, boat, farm equipment, etc. to keep track of and it really helps. I've thought about transferring it to an excel spreadsheet but I can't justify the time to do it. plus, I've been a victim of a crashed hard drive and would hate to lose all the information.


Used to do this ... also, had at one time various "programs". I guess for me it's easier to have the sticker on the equipment/boat/ car .. whatever vs having to look in a book. And, I have more than one residence.
 

rburke65

Well-known member
Joined
Nov 10, 2007
Messages
12,349
Location
Canfield, Ohio
My ZTR mower at least in the Fall if not more often. The back hoe/ tractor and UTV don’t get used that much. Can’t imagine having so many ya can’t keep track.
 

SGKent

Banned
Joined
Feb 12, 2010
Messages
1,959
Location
Citrus Heights CA
I have such a spreadsheet. Depending on how **** you want to be you can do anything from add a tab for each car, with a column for date, mileage, and comments to writing when you washed it or checked the tires. It is up to you how much you want to keep. I keep a separate spreadsheet for smog test results so I can compare. On the air cooled VW sheet I also have columns for valve clearances so I can keep track what they are doing. Each year I have a tax/expenditure spreadsheet. As I spend money and file the receipts they get entered onto the spreadsheet. Tax items go in their own columns so they can be quickly summed and the receipts are kept that go with them. On that yearly spreadsheet there is a tab for each car whether it is taxable or not. There is a column for gas amount bought, when, where, and a quick formula for calculating mpg. There are also columns for parts bought for that car. This is separate than the maintenance sheet. Also most cars have an owners book and maintenance book or pages. You can use those books if you don't want to mess with a spread sheet. Dome used to (and still does) make a nice little glove box book that did/does the same.
 

Angelfire

Well-known member
Joined
Mar 22, 2012
Messages
1,367
Location
New Mexico and Ireland
I use OneNote with a linked spreadsheet. Multiple tabs with things like General (ie. purchase date, VIN, etc...), Maintenance, Repairs, Mods (I Jeep so lots of mods to list out), etc.... With my OneNote, I have it linked to my cloud account and can access it wherever I am on whatever device I have. Nice to be able to do this when at the parts store and you remember you forgot to write down the VIN :)
Cheers.
 

skulldrinker

Well-known member
Joined
Dec 25, 2011
Messages
1,171
Location
Bolingbrook, IL
I use Excel. Just the basics. Date, name, phone, vin, work done. Ive added milage recently. Any more and i prob would blow it off.15696129202ef794cdd51851ed4629b0.jpg

Sent from my SM-N960U using Tapatalk
 

Attachments

  • 15696129202ef794cdd51851ed4629b0.jpg
    15696129202ef794cdd51851ed4629b0.jpg
    12.9 KB · Views: 0

claymont

Well-known member
Joined
Oct 26, 2010
Messages
434
Location
CLAYMONT, DE
Something on this site might fit your needs:



Re: Spreadsheet for Vehicle Info/Maintenance Log



I find myself in a situation where I have a couple of ATVs, two boats, an old car and my young brain is becoming my old brain and things I used to remember I now don't. Most of the toys are a couple of hours away at the lake and I get up there once or twice a month right now.

I wanted to start a spreadsheet with a tab for each vehicle with a bunch of details like tire sizes, oil filter number, oil type, etc so when I'm ready to do a project I can reference my sheet and know what to order.

Does anyone here use a similar spreadsheet? I googled and didn't find what I was looking for but always prefer to see what others are using before I recreate the wheel.

Thanks.
steve
 

ransil

Well-known member
Joined
Jul 22, 2018
Messages
313
Location
pa
I use acar app on my phone, dont forget to backup , i lost lots of data being lazy

Sent from my SM-G920V using Tapatalk
 

Slupie

Well-known member
Joined
Dec 19, 2010
Messages
162
Location
Bartlett, IL
What's it doing for you ?

Depending on the reminder set, either time or mileage it pops up a reminder on my phone when the services are due; oil changes, brake fluid and coolant flushes, tire rotation, etc. When I enter the mileage, fuel cost and gallons it also calculates the average MPG between fill ups. I keep track of all of the fill-ups and repairs that way and have done it since the app was called ACar. I have all of the records back till our van was bought brand new in 2012 and my car all the way back to 2011.
 
OP
E

eville

Member
Joined
Mar 20, 2008
Messages
11
thanks everyone. Lot's of good information here.
I think I'll do a spreadsheet.With quads, boats, cars, etc everything has it's own set of details. Probably expand it to include House projects too, filter sizes, etc.
Could be valuable to the kids one day too.
 

wildbill23c

Well-known member
Joined
Jun 6, 2014
Messages
1,360
Location
Idaho
I've made several spreadsheets over the years for various needs, and vehicle service records is one. Pretty easy to do, and can be as detailed or vague as you want.

Mine I do the following:

Besides just the following information on its own sheet, I create another sheet that gives the vehicle's VIN, build sheet (Jeeps are easy to get build sheets for), date the vehicle was purchased, mileage at purchase, purchase price, tire size, general vehicle features

Date, mileage, description of service, shop, or who performed the service, and the cost of the service

On another sheet I list the common air filter part numbers, oil filter part numbers, quarts of oil required, transmission fluid requirements, spark plug part numbers, etc.

So for me within 1 excel document I typically have 3-4 and sometimes more sheets. I have a 1988 Ford Bronco 2 which has the above sheets plus a sheet for keeping track of things I want to look for at pick a part yards, mods I want to do, things I need to fix, etc.

On my lawn & garden equipment I made a little service tag which gives the date, service performed, hours, etc. on it, the tags are laminated and a hole punched in them, and I use a little piece of string and attach it to a handlebar or other location out of the way but easy to see to keep track of services on them...I just write on the tag with a sharpie and when I service it next time I just rip the tag off and fill out a new one, kind of like that sticker on your windshield for oil changes. Another thing you can do is like on my lawn tractor I also write the date and hours of the last oil change on the oil filter as its extremely easy to see, just use a silver sharpie if the oil filter is black.

So many things you can put in the spreadsheet, and of course you can add more sheets to an excel and many other spreadsheet type applications so you have 1 file with multiple sheets for each vehicle, or heck throw them all in one file with the tabs at the bottom for each sheet labeled for each vehicle or piece of equipment.

I keep a folder/binder of all stuff done to each of my vehicles, as well as an electronic folder on my computer with copies of everything as well, so I can easily access records regardless. Its amazing the number of people that get excited when you sell them a vehicle and you hand them a binder or folder full of every repair or maintenance done to the vehicle...and in the case of one vehicle I sold, the buyer bought my truck over another with a couple thousand less miles because I had every single document for the vehicle from the day it was bought till the day it was sold, every single service and repair was documented with receipts even tire replacements, camper shell install, fuel log, it was all in a binder for the buyer and ultimately got me the full asking price for a vehicle that had a couple thousand more miles and a couple thousand dollars more than another of the same vehicle with less miles and cheaper price, all because I had all the documentation on the vehicle's service and repair history.
 
To avoid these ads, REGISTER NOW!
Top Bottom