Simple Mileage Log Template

Simple Mileage Log TemplateAre you looking for a Free simple mileage log? Our template can be used either in Excel or downloaded as a PDF to print and keep in your vehicle. If it is kept in your vehicle, you can record each journey at the time. It may save you from forgetting any journeys. You can also record your mileage on the Excel template on the go.

Claiming business mileage as an employee means that you are not out of pocket on money paid out. As self-employed, it can help to reduce your tax bill.

Mileage Tracking Apps

Although using mileage logs are a good idea, there is an alternative by using a mileage tracker application. There are several choices available, and it is worth checking the app store.

Some accounting software packages have also included a mileage tracker app as part of their software. The advantage of using them is that the figures are already available within the software, and separate records do not need keeping. Two packages including this feature are FreshBooks and QuickBooks.


Why keep a Mileage Tracking Sheet

In the UK, you can claim back up to 45p per mile for the first 10,000 miles and then 25p per mile. HMRC require you to keep records of all transactions, which includes claims for car use. Business miles for self-employed can also be claimed.

Simple Mileage Log – Information Needed

It is important to keep full details of each trip, the information needed is:

  • Date of journey
  • Reason for travel, this can include customer and job description
  • Miles travelled

There are two different versions of the form simple mileage log Excel and PDF. The version you download will depend on whether you want to keep a paper version in your vehicle. The other option is to download an Excel version and update it on the go or on your return.

Why It’s Important to Keep A Mileage Log

Although when you file your business accounts, a full breakdown of business mileage may not be required. If HMRC does any checks, they may wish to see paperwork relating to business expenses. Having a valid log of all your business trips will help to show them that you try and keep your records complete.

You need to ensure that you only claim for business miles, do not include claims between home and a normal place of work.

Simple Mileage Log Video

Our video includes business mileage rates and instructions on how to complete the mileage log form.

Claiming other business expenses

There may be other business expenses that you need to claim. We have a complete guide on what you can claim and expense templates to record all the information. Other expenses may include meals, stationery, home office and other sundries.

If you prefer to record all your business expenses in one place, look at our expenses templates.

How to use Mileage Log Template

Either download the PDF mileage claim form version and print it out or download the Excel version. Both versions require the same information; enter your name, month, and mileage brought forward from a previous month or sheet. In the main section, enter the travel date, the reason for the journey and either start and end mileage, which will calculate the miles or enter the total miles.

The total mileage will be calculated for you, and you can then make a reclaim.

Self-Employed Mileage Log Example

Below is an example of a completed mileage log.

Simple Mileage Log Example

Download Simple Mileage log template for self-employed

Follow the links below for either version of the template. By downloading the free simple mileage log, you agree to our licence agreement.


Further Reading

Further information is available on the HMRC mileage site.