Business mileage log spreadsheet template (UK)
A working Excel mileage log for UK business journeys. Enter the date, the journey and the miles; the sheet prices each journey at the flat rate for its date and vehicle, drops to the lower rate after 10,000 car or van miles in the tax year, and totals each tax year. It already knows that the car and van rate rose from 45p to 55p a mile on 6 April 2026. Free, no sign-up and no email address.
What is in it
| Sheet | One row per | What it does for you |
|---|---|---|
| Journeys | Journey | Date, from, to, business purpose, vehicle and miles. It works out which tax year the journey falls in, keeps a running count of car and van miles for that year, and calculates the amount, splitting the journey that crosses 10,000 miles between the two rates. |
| Rates | Date a rate started | The flat rates per mile: car or van (first 10,000 miles and after), motorcycle and bicycle. Each journey looks up the rate in force on its date, so a rate change is one edit here and old journeys keep their old rate. |
| Tax year summary | Vehicle | Miles and amount per vehicle type for the tax year you choose, 6 April to 5 April, with a total. Change the year and the sheet follows. |
The rates it uses
For cars and vans: 55p a mile for the first 10,000 business miles in the tax year and 25p a mile after that, for journeys from 6 April 2026. Journeys before that date are priced at 45p for the first 10,000 miles. Motorcycles are 24p a mile and bicycles 20p, with no 10,000-mile step. These are the rates published on GOV.UK, checked on 18 November 2026.
The same figures serve two different rules. An employer can pay an employee up to these rates free of tax for business miles in the employee's own vehicle. A self-employed person can use the car, van and motorcycle rates as simplified expenses in place of working out actual vehicle costs. The bicycle rate is part of the employee scheme only.
Why the 10,000 miles needs a running count
The lower rate starts at 10,000 miles in a tax year, not on any one journey. A log that multiplies every row by the same rate overstates the claim from the moment you pass that figure. This template counts car and van miles for the tax year as it goes, so the journey that takes you from 9,980 to 10,020 miles is charged 20 miles at the higher rate and 20 at the lower. Enter journeys in date order for that count to be right.
What a mileage record should show
The date, where you went from and to, why the journey was for business, and the miles. A commute between home and a permanent workplace is not a business journey. The template records and prices journeys; whether a journey counts, and whether flat rates suit your vehicle, are questions for HMRC's guidance or your accountant. Once you use flat rates for a vehicle you must keep using them for as long as that vehicle is used in the business.
The other half of the paperwork
Mileage covers the vehicle. Everything else you spend still arrives as invoices and receipts. Invoices to Spreadsheets turns a folder of those, PDFs, scans or phone photos, into one checked table you can export to Excel. Try one invoice free, without an account.
Is the mileage log template free?
Yes. Download it, use it, change it. No account, no email address, no card.
What is the UK mileage rate for a car in 2026 to 2027?
For business journeys from 6 April 2026 the rate for cars and vans is 55p a mile for the first 10,000 miles in the tax year and 25p a mile after that. Before 6 April 2026 the first 10,000 miles were 45p. Motorcycles are 24p a mile and bicycles 20p.
Does it handle journeys before and after the rate changed?
Yes. Each journey is priced at the rate in force on its date, so a log that runs across 6 April 2026 uses 45p before and 55p after for the first 10,000 miles of each tax year.
Can I use it for more than one vehicle?
Yes for different vehicle types: choose car or van, motorcycle or bicycle on each row. The 10,000-mile count is kept across all car and van journeys together, which is how the limit works for one person. If two people share the file, give each their own copy so their miles are not counted together.
Does it work out my tax?
No. It totals miles and the flat-rate amount per tax year. Whether a journey is a business journey, and whether to use flat rates or actual costs, depend on your circumstances; use HMRC’s guidance or an accountant for that.
Does it work in Google Sheets or Numbers?
Yes. It is a standard .xlsx file using SUMIFS, INDEX, MATCH, MIN and MAX. Set your locale to United Kingdom before importing so dates are read day first.
7 days · 50 documents · No card needed
All free tools and templates · Self-employed income and expenses template · Invoice tracker template