UK Mileage Log Spreadsheet 2026/27 | 55p HMRC Simplified Expenses | Excel & Google Sheets
NowPrice:$9.83
Original Price: $12.29
20% off
Sale ends on December 20
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
A business mileage log for the 2026/27 UK tax year, with the simplified expenses rates that apply from 6 April 2026.
From 6 April 2026 HMRC’s simplified rate for cars and goods vehicles is 55p for the first 10,000 business miles and 25p after that (it was 45p before this tax year). Motorcycles are 24p on all business miles. This workbook applies those rates to your tax-year total, so the 10,000-mile split does not depend on the order you type the trips.
What you get
• A SAMPLE workbook (fictional mobile locksmith, with van mileage above 10,000 so you can see both rates in action)
• A BLANK workbook with 400 journey rows for your own records
• Instructions, Dashboard, Settings, Journey log, Monthly summary, Rates and dropdown lists
• Working formulas, drop-down vehicle types, date checks, locked formula cells (Excel protection has no password)
• A monthly summary that follows HMRC tax months (the 6th to the 5th)
• Official rates and GOV.UK source links, checked on 17 November 2026
How to use it
1. Open the BLANK file and enter your name and vehicle descriptions on the Settings sheet.
2. Log each business trip — or a weekly total — in the cream cells. Choose ‘Car or goods vehicle’ or ‘Motorcycle’.
3. The Dashboard shows miles in each band and the estimated claim. Keep your own notes or receipts as you normally would.
Google Sheets: use File → Import → Upload. After importing, add a test trip and confirm the Dashboard updates. Re-apply protection in Sheets if you want it there.
Please note: do not also claim actual running costs (fuel, insurance, repairs) for the same vehicle if you use these simplified rates, and do not use them if you have already claimed capital allowances on that vehicle. This log is for business miles only. Check GOV.UK if you are unsure what counts.
Disclaimer: This is a record-keeping and planning tool. Figures are estimates based on the amounts you enter and on HMRC rates published on GOV.UK as at 17 November 2026. It is not official HMRC or GOV.UK software, not tax, legal or financial advice, and not a substitute for a qualified accountant or for filing your Self Assessment return with HMRC. You are responsible for checking that rates, thresholds, dates and your own figures are current and correct. April Sixth is a trading name, not a government body.
Source (checked 17 November 2026): https://www.gov.uk/simpler-income-tax-simplified-expenses/vehicles
AI-assistance disclosure: This listing text and the spreadsheet were produced with assistance from AI tools, then reviewed, edited and tested by a person. Official rates and dates were checked against GOV.UK (17 November 2026) and the formulas were recalculated independently. This is not official HMRC software and is not tax advice.
File format: Microsoft Excel .xlsx (two files — SAMPLE and BLANK). Instant digital download. No physical item will be sent.
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
More from this shop
Visit shop-
Digital download
UK Employed Plus Side Hustle Tax Tracker Spreadsheet 2026/27 | Self Assessment
Sale Price $16.40
Original Price $20.50
-
Digital download
UK CIS Tax Spreadsheet for Subcontractors 2026/27 | Trades CIS Deduction & Tax Estimator
Sale Price $20.77
Original Price $25.97
-
Digital download
UK Landlord Rental Income Spreadsheet 2026/27 | Finance-Cost Tax Reducer
Sale Price $20.77
Original Price $25.97
-
Digital download
UK Tradesperson Job and Tax Bundle 2026/27 | CIS, Mileage and Invoice Log
Sale Price $27.34
Original Price $34.17