SnapBooksDownload the mileage log
- HMRC mileage log 2026-27Excel (.xlsx) · works in Google Sheets
- Printable mileage logPDF · A4, landscape
To use it in Google Sheets, upload the file to Google Drive and open it with Google Sheets; the formulas and totals carry over. It also opens in Excel, Numbers and LibreOffice.
What’s in the workbook
- Mileage log: one row per journey, with the date, start, destination, business purpose and odometer readings. Miles are worked out for you, or you can type them in.
- HMRC rates built in, with the 10,000-mile split: 55p a mile up to 10,000 business miles in the tax year, 25p after that.
- Year summary: business miles for each month of the tax year, from 6 April to 5 April, and your total claim.
- For employees: enter what your employer paid you and see the shortfall you can claim Mileage Allowance Relief on.
HMRC approved mileage rates for 2026-27
| Vehicle | First 10,000 business miles | Above 10,000 miles |
|---|---|---|
| Cars and vans | 55p | 25p |
| Motorcycles | 24p | 24p |
| Bicycles | 20p | 20p |
The rate for cars and vans rose from 45p to 55p a mile on 6 April 2026, the first change since 2011.
What to record for each journey
- The date.
- Where you started and where you went.
- The business purpose, for example “site visit, 14 High Street”.
- The miles.
Record journeys as you make them. If you’re self-employed, keep your records for at least 5 years after the 31 January submission deadline for the tax year.
Who can claim, and how
- Self-employed: claim these flat rates as simplified expenses instead of your actual vehicle costs. Once you use the flat rate for a vehicle, you must keep using it for as long as you use that vehicle in your business. Business parking and tolls are claimed separately.
- Employees: if your employer pays less than these rates, or nothing, you can claim Mileage Allowance Relief from HMRC on the difference.
- Not ordinary commuting: journeys between home and your permanent workplace don’t count. Journeys to a temporary workplace usually do.
General information, not tax advice. Check GOV.UK or an accountant for your situation.
Mileage logs for other countries
Frequently asked questions
Did HMRC change the mileage rate in 2026?
Yes. From 6 April 2026, the approved rate for cars and vans is 55p a mile for the first 10,000 business miles, up from 45p. Above 10,000 miles it stays 25p.
Does the 10,000-mile threshold reset each year?
Yes. It applies to your business miles in each tax year, from 6 April to 5 April.
Can I claim parking and tolls on top?
Yes. The mileage rate covers the cost of running the vehicle; business parking and tolls are separate. Keep the receipts.
Does it work in Google Sheets?
Yes. Upload the Excel file to Google Drive and open it with Google Sheets; the formulas and totals carry over.