Report this item to Etsy

UK Mileage Log Spreadsheet 2026/27, HMRC Mileage Tracker, Claim Tax Back on Work Miles, Excel & Google Sheets

Price:$6.93

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by TaxReadySheets
  • Digital download
  • Digital file type(s): 1 PDF, 2 other files

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 + an example file)
• 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
• Formula cells protected, so nothing breaks by accident
• Example file with a year of sample journeys

YOU'LL RECEIVE
• Blank Excel spreadsheet (.xlsx)
• Example Excel spreadsheet with sample journeys
• 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? Send me a message, I reply within 24 hours.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Mileage Tracker Spreadsheet

Sole Trader Tracker

Small Business Mileage Log

Listed on Oct 15, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates