Mileage Log 2026/27 UK – New 55p Rate Mileage Claim Calculator (uses HMRC rates)

From the 2026/27 tax year HMRC raised the approved mileage rate for cars and vans from 45p to 55p a mile — the first rise since 2011. Most templates still use 45p. This one is up to date.

WHAT'S INCLUDED

• Mileage Log — 600 rows: date, from, to, business purpose, client/job, vehicle, miles
• Return-trip column — type Y and the miles double automatically
• Auto tier switch — 55p for the first 10,000 car/van miles, then 25p
• Motorcycle (24p) flat rate; bicycles are not covered by simplified expenses
• Dashboard — total claim, business miles, 55p miles left, month-by-month table + chart
• '45p vs 55p' box — see how much extra the new rate gives you
• Editable rates and tax-year start, so it works for future years

FORMAT

Instant download (.xlsx). Works in Excel, Google Sheets and Apple Numbers.

PLEASE NOTE

An organiser/estimator, not tax advice. Rates from gov.uk. Commuting to a permanent workplace isn't business travel. Not affiliated with HMRC.

Instant digital download: by buying you agree to immediate supply and lose the 14-day cancellation right for digital content. SoleTraderSheetsUK is a trading name of EXTRACT API LTD (company number 17469044), registered office 66 Paul Street, London EC2A 4NA.