Mileage Log




This is a common mileage log used by many companies to track their vehicle trip or car operational expenses. I create this template as a basic tutorial template for my nephew who worked in General Affairs Department and wants to learn how to create template in excel that could be useful for him in his company.

This mileage log is actually the same with other mileage log you could find in several internet sites, because it is only record the mileage and calculate the total mileage of the car within some period of time. You can fill the average cost per mile if you want to calculate the expenses of that car. In US, it is usually used for calculating tax deduction where the mileage rate is the official rate publish by IRS.

Mileage Log

As you can see in the picture, all you have to do just fill the white color parts and leave the blue color parts to calculate the number for you.

You can download the file here.

You can download the open office version here.

If you are looking for an advanced version where it can be used to calculate and generate for more than 1 car in a single excel template, you might try and download a new version below. It can be used to record other information instead of just recording mileage distance for tax deduction only. You can record any daily activities of your car, for example, its expenses (service, toll, parking etc), you can monitor and assign drivers, you can monitor specific car when it has to go for a general service and many more. You can read more about it in Car Fleet Management post. If you want to use the lite version directly, you can download it below.

  Car Fleet Management Lite - V2.3 (785.1 KiB, 2,682 hits)

  Car Fleet Management Lite - V2.3 - with Samples (790.9 KiB, 2,683 hits)




4 Comments