Mileage Tracker Spreadsheet

Mileage Tracker Spreadsheet

Price:Perfectly Free!
File Type(s):Excel Spreadsheet Template (.xlt)
File Size:137kb (.ZIP file)
Last Update:2008-03-23
Current Version:       2.0
Macros:None.

For some reason, in 2005 I decided to track the mileage of our two household vehicles. There were no business-expense implications; it simply seemed like a neat use of Excel, as well as a good idea.

And it became a habit.

This isn't the exact spreadsheet I use these days — this one's much more well-suited for public consumption — but it's close.

Mileage Tracker Spreadsheet

I've set up the spreadsheets to download as a ZIP file. Inside the ZIP file are are two versions of the Mileage Tracker: One uses the standard measurement system I'm so familiar with (miles and gallons), and the other uses the metric system (kilometres and litres). You can grab the file below:

Download Spreadsheet!

Own More than Two Vehicles?
Need More Worksheets?

The spreadsheet comes with two blank Mileage Tracker worksheets — one worksheet for each vehicle, if you own two. If you have more than two vehicles to track (it happens!), you'll want to expand the spreadsheet and make multiple copies of a blank worksheet.

Not sure how to make copies of the blank worksheet? It's easy!

  1. Right-click a blank worksheet.
  2. Select "Move or Copy."
  3. Account Receivable Spreadsheet
  4. Highlight "(move to end)" and place a checkmark in "Create a copy."
  5. Account Receivable Spreadsheet
  6. Click OK.

That should do it. You now have another blank worksheet!

Entering Transactions

I'm hoping that data entry in this spreadsheet is self-explanatory.

  • DATE: Enter the date you filled up the tank.
  • START ODOMETER: Enter the mileage at which you began tracking.
  • END ODOMETER: Enter the mileage at which you fueled up.
  • GALLONS (LITRES): Enter the total amount of fuel installed.
  • TOTAL PRICE: Enter the total cost of fuel installed.
  • COST PER GALLON (LITRE): Self-explanatory.
  • NOTES: Just a place to enter notes, if necessary.

Questions? Comments? Contact Me!

Got a question or issue? Don't hesitate — drop me a line. I'll get back to you as soon as possible!




RSS Feed

Want to know when I add to and update my spreadsheets? Subscribe to IYM's feed!

Add to Google Reader or Homepage
Add to My Yahoo!
Subscribe with Bloglines



Make a Donation
If you're a user of my Excel spreadsheets and feel that they're worthy of a small donation ... well, that's extremely cool. And I'm truly honored that you'd think so.

The following button will allow you to make a donation (any amount) via Paypal. I would ask, though, that if you're someone who's in substantial debt, and working like crazy to get out, that you please refrain from making a donation to IYM.

Instead, use your intended donation amount as an extra contribution toward your highest-interest debt ... and then drop me an email to tell about how my site or my spreadsheets have helped in some way.

That, I assure you, is payment enough for me.

As always, I am truly grateful for your kindness and continued support!