12/21/2011 8:12 PM
We use a sheet I made in Word using the Jacobsen service sheet as an example for each peice. The top has the machine, model, serial, price, year and then OEM and Napa filter numbers. Most of the sheet is lines for recording regular service and replacement parts used.
We use Excel to create a 2 page sheet showing the equipment name, engine, fluids, Napa filter numbers, tire pressure and spark plugs for easy lookup to order filters when we plan to change them.
We also use Excel to create a list of filter numbers, (one each for oil, air, hydro and fuel) and another for tires by size. To the right of the item I list what pieces of equipment use that particular number and use the sort function to list the filter or part numbers in order for easy inventorying. We usually have one of each filter and one of each tire size in stock, but by looking at the sheet I can see I need 7 Napa 1064's to do the greensking fleet and I also use the 1064 in two of the sand trap rakes.
It works for us to keep inventory at just the right number.