Settings

Open in SheetsFree, with no account. What you type stays in this browser. Saves as Excel, OpenDocument or CSV.

Mileage log open in Sheets, in the light themeMileage log open in Sheets, in the dark theme

What is in it

Each business journey with its date, route, purpose and miles, and what it comes to at your rate per mile. The figures are examples to type over.

Mileage log
Vehicle[Make, model and registration]
Rate per mile0.45Set this to the rate you claim at, and check it is the current one.
DateFromToPurpose of the journeyMilesAmount
2026-09-01OfficeClient site, LeedsQuarterly review with the client42=IF(E6="","",E6*$B$3)
2026-09-01Client site, LeedsOfficeReturn42=IF(E7="","",E7*$B$3)
=IF(E8="","",E8*$B$3)
=IF(E9="","",E9*$B$3)
=IF(E10="","",E10*$B$3)
=IF(E11="","",E11*$B$3)
=IF(E12="","",E12*$B$3)
=IF(E13="","",E13*$B$3)
=IF(E14="","",E14*$B$3)
=IF(E15="","",E15*$B$3)
=IF(E16="","",E16*$B$3)
=IF(E17="","",E17*$B$3)
=IF(E18="","",E18*$B$3)

Worked out for you

These cells are formulas, so they follow whatever you type. Each is shown as written in its first row.

Amount
=IF(E6="","",E6*$B$3)
Total: Miles
=SUM(E6:E25)
Total: Amount
=SUM(F6:F25)

Filling it in

  • Write the purpose of every journey. HMRC asks for it, and “meeting” is not enough: say with whom and why.
  • HMRC’s approved rate for a car has long been 45p a mile for the first 10,000 business miles in a tax year and 25p after that. Check the current figure before you claim.
  • Ordinary commuting between home and a permanent workplace is not business mileage.
  • Fill it in on the day. Logs reconstructed at the end of the year are the ones that are questioned.

The next step

More templates

All 32 templates