HMRC Mileage Log and Simplified Expenses Calculator 2026/27

HMRC Mileage Log and Simplified Expenses Calculator 2026/27 is an Excel and Google Sheets workbook for UK sole traders. Log each business trip and the sheet works out the claim: 55p a mile for the first 10,000 car and van miles in the tax year, 25p after that, and 24p for motorcycles. The trip that crosses 10,000 miles is split between the two rates.

It also keeps a running total, adds up the year-to-date figures for each Making Tax Digital update (7 Aug, 7 Nov, 7 Feb, 7 May), works out the use of home flat rates from your monthly hours (£10, £18 or £26), and shows the total to claim. A Reminder sheet explains that you cannot also claim fuel or car costs for a vehicle on the mileage rate.

Includes a year of example trips and a blank copy. One .xlsx download, no macros, no password. Rates were read on gov.uk on 6 November 2026. There is no bicycle or passenger rate because gov.uk lists none for simplified expenses.

It does not connect to HMRC. You type the totals into HMRC-recognised software or a bridging tool. Figures are estimates for planning. They are not tax advice.