Excel spreadsheet

Business Mileage Log (HMRC Rates)

Log business journeys and see what you can claim

Record each business journey and the claim works itself out at HMRC approved mileage rates: 45p a mile for the first 10,000 miles in the tax year by car or van, then 25p, with motorcycle and bicycle rates too.

Freefree account needed · no card
Sign up & download free

Create a free account on our client portal (or sign in) to download. No card details needed. How it works

  • Excel .xlsx
  • Google Sheets
  • Numbers
  • LibreOffice

In the download (15 KB zip)

  • Business-Mileage-Log.xlsx

What's included

  • Journey log: date, from, to, purpose, miles and vehicle
  • Claim at HMRC rates: 45p then 25p after 10,000 miles (car / van), 24p motorcycle, 20p bicycle
  • Tax year setting (6 April to 5 April)
  • Monthly summary of miles and claim
  • Room for 500 journeys
  • How-to sheet

Perfect for

  • Sole traders and the self-employed
  • Employees claiming mileage
  • Tradespeople
  • Anyone filing Self Assessment

Questions

Is it really free?

Yes. You need a free account on our client portal to download it, and that's all. No card details, no subscription.

Why do I need an account?

The account is where your downloads live, so you can download the file again at any time, and it's the same account you'd use for any of our paid templates.

Can I use it in my business?

Yes, for your own business or organisation. Please don't share or resell the blank template. See the licence for details.

How do I get the file?

Press Sign up & download free, create a free account on our client portal (or sign in) and complete the free checkout. No card is needed. The download appears under My downloads straight away.

Want more?

Our full spreadsheets and document packs go further, from £1.69.

Get Business Mileage Log · Free

You might also like

Excel spreadsheetFree

Simple Monthly Budget

A one-page budget: what you plan to earn and spend, what actually happened, and what's left over. Overspends turn red, and a chart compares budget…

Excel spreadsheetFree

Weekly Timesheet

Enter start and finish times and unpaid breaks for each day. Hours, overtime after your chosen limit and an estimated gross pay figure work…

Excel spreadsheetFree

12-Month Cash Flow Forecast

Enter the money you expect in and out each month and the forecast shows net cash flow and the closing bank balance for the next 12 months. Any month…