Spreadsheets · Free download
Free Mileage Log Template (UK)
A business mileage log for UK sole traders, employees and small companies who claim for using their own car. Enter each trip with the date, where you went and why, and the amount to claim works itself out using HMRC approved mileage rates. It applies 45p a mile for the first 10,000 business miles in the tax year and 25p after that, and it even splits the single trip that takes you past 10,000 so the rate change is handled for you. A running total keeps your year to date in view, so there are no surprises at the year end and your records stand up if HMRC ever asks. Keep it as you go and the claim is ready when you need it. It is free to download and reuse each year.
What's included
- Per-trip entry: date, from, to, purpose and miles
- HMRC approved rates applied automatically (45p then 25p)
- Automatic split of the trip that crosses 10,000 miles
- A running mileage total and a total to claim
How to use it
- Enter the tax year and check the rate cells at the top.
- Add each business trip as you make it.
- The amount to claim, and the running total, work themselves out.
- Use the total to claim on your expenses or Self Assessment.
Rates current for the 2025/26 tax year (HMRC approved mileage allowance payments: 45p per mile to 10,000 miles, then 25p). Check the current HMRC rates each year and update the cells at the top.
Questions
What mileage rate does it use?
The HMRC approved mileage rates for cars: 45p per mile for the first 10,000 business miles in the tax year, then 25p per mile.
Does it handle crossing 10,000 miles mid-trip?
Yes. It splits the journey that takes you past 10,000 miles so the right rate is applied to each part.
Free and provided as-is. It is a head start, not professional advice, so always check anything you rely on is correct for your own situation. See the resource terms.