UK Mileage Log Spreadsheet 2026/27 (Excel & Google Sheets)

Drive your own car for work? If your employer pays less than HMRC's 55p a mile, you can claim tax back on the difference. This UK mileage log for 2026/27 records every journey the way HMRC asks for it, then works out your claim and roughly how much tax you'll get back. Works in Excel and Google Sheets.

HMRC's rate for cars and vans rose from 45p to 55p a mile on 6 April 2026, so many employers now pay less than the approved rate.

WHO IT'S FOR

• Employees who use their own car, van, motorcycle or bicycle for work: care workers, nurses, sales reps, engineers, tradespeople and more
• Sole traders and self-employed people claiming mileage as a business expense
• Anyone claiming for an earlier year (pick the tax year and the 45p rate is used before 6 April 2026)

WHAT'S INSIDE (8 tabs)

• Start Here: 7 simple steps, set up in about 5 minutes
• Settings: employee or self-employed, tax year, what your employer pays per mile
• Saved Routes: save up to 40 regular trips once, then just pick them
• Journey Log: 1,000 rows, return-trip button, automatic checks for missing postcodes or reasons
• Summary: miles, amount at HMRC rates, what your employer paid, your claim and estimated tax back, month by month
• HMRC Log: a clean copy of every journey with date, reason, start and end postcodes, ready to print or save as PDF
• Claim Guide: plain-English steps for employees (online claim or P87) and the self-employed
• Rates: every rate with its GOV.UK source

WHY THIS ONE

• Built for employees claiming tax back, not just the self-employed
• 55p and 25p worked out for you, including the switch at 10,000 miles
• Motorcycles (24p) and bicycles (20p, employees) included
• Claim for earlier years: 2022/23 to 2026/27 rates built in

YOU'LL RECEIVE

• Blank Excel spreadsheet (.xlsx)
• PDF with your Google Sheets link (click "Make a copy")

WORKS WITH

Microsoft Excel 2016 or newer (Windows and Mac) and Google Sheets with a free Google account. Set up on a computer; after that you can add trips on your phone.

PLEASE NOTE

• Digital download only. No physical item will be sent.
• This spreadsheet keeps your records and works out your figures. It doesn't send anything to HMRC.
• Tax-back figures are estimates and not tax advice. Relief can't be more than the tax you paid. Ordinary commuting doesn't count as business mileage. Check GOV.UK or speak to an accountant if you're unsure.
• Designed by me with the help of AI tools, then checked and tested by hand.
• For your own use only. Please don't share or resell.

Questions or stuck? Use the Contact link at the top of my store and I'll reply within 24 hours.