Are you looking for a Free simple mileage log? Our template can be used in Excel and Google Sheets 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 business mileage. You can also record your mileage on the Excel template on the go.
Claiming business mileage as an employee means you are not out of pocket for money paid out. As a self-employed individual, it can help to reduce your tax bill.
What is a Mileage Log?
Generally, mileage logs are used by businesses in the UK to record business mileage claimed for tax purposes.
Disclosure: This content may contain affiliate links, which means if you click on them, I may get a commission (without any extra cost to you).
When businesses claim mileage expenses, they must be able to provide evidence of the mileage driven. This includes the date, mileage driven and details of the journey.
What are the Mileage Rates?
Businesses can reimburse for mileage driven on business up to certain limits. HM Revenue & Customs (HMRC) usually supervises these mileage allowances. The current mileage allowance payment (MAP) rates are 45p per mile for the first 10,000 miles, then 25p per mile thereafter. The mileage rate is for all petrol, diesel, hybrid and electric vehicles. Other than parking, you can not claim any other expenses related to the vehicle.
With the rising costs of petrol and car running costs, some companies might be tempted to reimburse more than 45p per mile. Employers who pay more than the allowance must report this on form P11D and add any additional amounts to the employee’s pay. Tax is then deducted as usual from the total pay.
Mileage Tracking Apps
Although using mileage logs is a good idea, an alternative is a mileage-tracking app. Several choices are available, and it is worth checking the app store.
Some accounting software packages have also included a mileage tracker app. The advantage of using them is that the figures are already available within the software, and separate records do not need to be kept. Two packages that include mileage tracking are FreshBooks and QuickBooks.
Below is an illustrative example of how to track mileage using the QuickBooks app. With this user-friendly app, you can choose whether you want to record all your mileage or track individual trips. This feature lets you accurately monitor your mileage and conveniently manage your travel expenses. Stay organised and in control with QuickBooks!
Expense Management Software
Several good options are available if you are looking for an all-in-one expense management software.
Expense software will track your mileage and offer a payment card and photo receipts to upload into accounting software and provide expense reports.
Why keep a Mileage Tracking Sheet
In the UK, you can claim back up to 45p per mile for the first 10,000 miles, then 25p per mile thereafter. HMRC requires you to keep records of all transactions, including car use claims. Business miles for self-employed can also be claimed.
Simple Mileage Log – Information Needed
It is vital to keep full details of each trip; the information needed is:
- Date of the journey
- Reasons for travel can include customer and job description
- Miles travelled
There are two different versions of the form: a simple mileage log Excel and a PDF. The download version depends on whether you want to keep a paper copy in your vehicle. The other option is to download an Excel version and update it on the go or when you return.
Why It’s Important to Keep A Mileage Log
However, 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 to keep your records complete.
You need to ensure that you only claim for the miles of a business trip and do not include claims between home and a regular place of work.
Simple Mileage Log Video
Our video includes business mileage rates and instructions on completing 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. Additional 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 the Excel Mileage Log Template
Download the PDF mileage claim form 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 and the reason for the journey, then either enter the start and end mileage to 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.
Alternatives to using a Mileage Log Template
A Mileage log template is one option for keeping a record of business trips and mileage. Alternatives for mileage tracking include using a mileage logbook.
A mileage book is ideal for keeping all business miles recorded in one place. Some are available on Amazon or other good retailers if you prefer to keep a mileage record book.
Download Simple FREE Mileage Log Template for Self-Employed and Employed
By downloading the Balance Sheet template, you agree to our licence agreement, allowing you to use the templates for your own personal or business use only. You may not share, distribute, or resell the templates to anyone else in any way.
Mileage Log FAQ
What do I need to record in a mileage log for HMRC?
HMRC requires you to record the date of each journey, the start and end location, the purpose of the trip, and the number of miles travelled. You should also keep the log alongside any relevant receipts (petrol or diesel) or business records. The log forms the basis of your mileage claim on your Self Assessment tax return or expense claim.
What is the HMRC mileage rate for 2026/27?
For cars and vans, HMRC allows 45p per mile for the first 10,000 business miles in a tax year and 25p per mile after that. For motorcycles, the rate is 24p per mile, and for bicycles, it is 20p per mile. Always check GOV.UK for the current approved mileage rates as these can change.
Is the mileage log template free?
Yes, the mileage log template is free to download in both Excel and PDF formats. No sign-up is required. The Excel version automatically calculates your total mileage and the reimbursement amount based on the HMRC rate.
Can I use a mileage log for both employed and self-employed mileage claims?
Yes. The template works for both. If you are employed, you submit the log to your employer to claim reimbursement. If you are self-employed, you use the totals from your mileage log to complete your Self Assessment tax return under allowable business expenses.
Other Useful Templates
Business Expense – claim all business expenses in one place
Cash Book – Record income and expenses for 1 year
Conclusion for Mileage Log Form
Mileage tracking is an important part of any business, as it can help you save money on taxes. Our simple mileage log template makes it easy to keep track of your business miles, and our video tutorial shows you how to use the form.
If you have any questions, check out our comprehensive guide to claiming other business expenses.
Further Reading
Further information is available on the HMRC mileage site.
Last update: March 2026
