Updated November 2026

Mileage log template (UK)

A free mileage log with every column HMRC asks for — including the start and end postcodes that employee claims have needed since October 2024 — and the 2026/27 rate of 55p a mile built in.

Download the template (CSV)

Opens in Excel, Numbers or Google Sheets (File → Import). Free, no sign-up.

What HMRC requires in a mileage log

ColumnWhy it is there
DatePuts the trip in the right tax year, and tells you which side of 6 April 2026 (45p or 55p) it falls.
Start and end postcodeRequired for every journey in a PAYE (P87) claim.
Reason for journeyRequired — and the thing that separates business travel from commuting.
Business milesThe number the claim is built on.
PassengersEmployers can pay 5p a mile per passenger on business trips.
Running totalThe rate drops to 25p after 10,000 miles in the tax year, so you need to know when you cross it.

Example: a filled-in mileage log

DateFromToReasonMilesClaim
2026-04-07Leeds office (LS1 4AP)Client site, Bradford (BD1 1HY)Quarterly audit at client11.2£6.16
2026-04-07Client site, Bradford (BD1 1HY)Leeds office (LS1 4AP)Return from client audit11.4£6.27
2026-04-09Home (LS6 2AB)Temporary site, Harrogate (HG1 1AA)Site survey (temporary workplace)16.8£9.24

Note the third row: home to a temporary workplace counts as business travel. Home to your normal office would not, however far it is.

How to keep a mileage log HMRC will accept

Then total it with the mileage calculator, and claim through the P87 or your Self Assessment return.

Claiming in Australia instead? The ATO's rules are different — see what an ATO logbook needs.

Mileage log for employees vs the self-employed

Employee (PAYE claim)Self-employed
Where the total goesP87 / HMRC online claim, or the Employment pages of Self AssessmentSelf-employment pages of Self Assessment (simplified expenses)
Do you send the log?Yes — HMRC asks for copies with a PAYE claimNot with the return; keep it in case HMRC asks
Start and end postcodesRequired for every journeyNot specifically required, but the easiest way to show where you went
Rate in the log55p a mile for the first 10,000 business miles from 6 April 2026, then 25p (45p for earlier years)

Mileage log book, spreadsheet or app?

HMRC doesn't prescribe a format, so pick the one you'll actually keep up:

Stop reconstructing your mileage from memory

Odo logs your drives automatically in the background, you swipe each one business or personal, and it totals your claim at the 2026/27 rates — with a CSV export of every trip: date, reason, distance and the start and end postcodes HMRC asks for in a PAYE claim.

Get Odo for iPhone