A simple Excel Mileage Claim tool.

If you do a lot of travelling for your work, you probably need to keep track of your mileage for the taxman or the Accounts department. This simple Excel spreadsheet will record your mileage and calculate your claim per journey and an overall total. All you need to do is input your mileage allowance and the number of miles per journey.

To start recording your mileage data straight away, download the free, and fully functional, download the Mileage Claim tool.

Alternatively, if you would like to see how the tool is constructed, and learn to make your own, follow the tutorial below.

Using Excel's arithmetic functions and a clear layout, we can generate a time-saving and accurate Mileage Claim Tool.

Spreadsheet Data 1 shows the initial layout.
For this example, I have put in an allowance of 40p per mile, entered as £0.40, in cell C6.

Spreadsheet Data 1

In row 11 we enter the first line of mileage data, as in Spreadsheet Data 2. To calculate the mileage claim for that row, in cell D11, we type

=C11*$C$6

You will notice that the reference to cell C6 where we entered the the mileage allowance has two $ signs in it. This allows us to drag the formula down for the next rows of data without changing the reference to C6. Copy this formula down for all the rows you want to use. Look in the cells to see how the reference to the cell containing the distance changes with each row, but the reference to the cell containing the mileage allowance (C6) remains the same.

There is one more formula to add, the Total Claim as in Spreadsheet Data 2.
In cell C8 we enter

=SUM(D11:D21)

Spreadsheet Data 2

You can make the equation in cell C8, the Total Claim, cover as long a list of rows as you want. I have put in ten rows here just as an example. See Spreadsheet Data 3.

Spreadsheet Data 3

The Mileage Claim tool is available as a free download if you prefer. Remember to always virus scan any file you download from the internet.

..back to top