One of the best ways to save money is to keep track of your expenses. This will keep you from wrecking your budget if and when your expenses get out of hand. One of the biggest expenses in anyone’s budget is the maintenance of your vehicles. The cost of decent transportation probably ranks right at the top of the list, just behind food and shelter. Let’s face facts. A car or truck will eat up a lot of money in a very short time even though good transportation is a real necessity for everyone. Keeping track of your maintenance expenses will let you know right away if things are starting to get out of your control.
I’m offering a simple spreadsheet for anyone to use to help keep track of their vehicle maintenance costs. You simply enter the starting mileage one time and the mileage at the end of each month. The mileage totals will be automatically calculated for you. It will also give you monthly totals for maintenance expenses as well as a yearly total. It also includes an up to date total for maintenance costs per mile. While figuring the fuel costs per mile is pretty easy, figuring your maintenance costs per mile is a little more involved. It includes categories for most vehicle maintenance items and is in the form of a single page printout. It is not password protected and may be modified for your use. You will need to be familiar with using Excel in order to use this spreadsheet. Make sure to save a copy in a different place just in case you accidentally change one of the formulas. Always keep a back-up copy! I included comments to help get you started.
I’ve also included a screenshot of the single page vehicle maintenance record above.
You can preview and download the Vehicle Maintenance Record Spreadsheet (35.0 Kb) here:
http://www.box.net/shared/rfyb6u606q
Staying above the water line!
5 comments:
Cool! Thanks RW.
To: Mayberry
You're welcome. Need help with anything, just let me know.
It's a simple way to track your maintenance costs. It's really pretty simple to use.
RW
I'll second Mayberry's comment.
Cool!
Nice job RW.
Massachusetts Preppers Network
To: Western Mass. Man
Thanks. Save some money by keeping track of your expenses leaves more money for preps.
RW
Thanks for this post, great information! I'd love to share this post on my blog.
Track Measurement System
Post a Comment