Free Excel Download
Mileage & Travel Log Sheet 2026/27
Track business mileage with automatic HMRC-approved rate calculation — 45p for the first 10,000 miles, 25p after.
What’s Included
- Automatic rate switching — the sheet applies 45p/mile for your first 10,000 business miles in the tax year, then automatically drops to 25p/mile after that, based on a running total formula.
- 60 pre-formatted journey rows — date, purpose, start/end postcode, miles driven, and an automatically calculated claimable amount.
- Built-in totals — total miles and total claimable amount calculate automatically as you fill in the sheet.
- Guidance notes — a summary of the HMRC AMAP rules included directly in the spreadsheet.
HMRC Mileage Rates 2026/27
- Cars and vans: 45p/mile for the first 10,000 business miles in the tax year, then 25p/mile after.
- Motorcycles: 24p/mile flat rate, no threshold.
- Bicycles: 20p/mile flat rate, no threshold.
- These are HMRC Approved Mileage Allowance Payment (AMAP) rates — the maximum you can claim tax-free without needing to keep fuel receipts.
- Only genuine business mileage counts. Ordinary commuting to a permanent workplace does not qualify.
Frequently Asked Questions
Journeys for work purposes other than your normal commute to a permanent workplace — for example, travelling to client sites, between different work locations, or for business errands. Commuting to a fixed, permanent workplace does not qualify.
No. The AMAP mileage rate is designed to cover fuel, wear and tear, insurance and running costs combined, so you do not need to keep individual fuel receipts if you use this method. You do need to keep a mileage log showing dates, journeys and distances, which is exactly what this template is for.
You can claim Mileage Allowance Relief on the difference via Self Assessment. For example, if your employer pays 30p/mile and you drove 5,000 business miles, you could claim relief on the 15p/mile shortfall.
Yes, completely free with no email signup required.
Sources
- Mileage rates from GOV.UK — Business mileage rates (checked 2026)
- Mileage Allowance Relief from GOV.UK — Vehicles you use for work