Employees · directors · self-employed

Mileage log in Excel with civil service rates and a monthly claim form

Revenue allows mileage and subsistence to be paid tax-free when the claim is backed by proper records. The log keeps every journey with the details Revenue looks for, applies the civil service motor rate bands and prints a monthly claim per person.

  • 20 people, 25 vehicles, 1,200 journeys
  • Civil service rate bands by engine size
  • 600 expense lines for tolls and parking
  • Monthly A4 claim form with home address
Add to basket
Mileage & Expenses Log – Dashboard

What each journey records

FieldWhy it matters
Date and purposeLinks the trip to the work
Start, destination and finishShows the route and the home address rule
KilometresDrives the rate band
Person and vehicleSets the rate category

The rates were checked against the civil service circulars on 22 October 2026 and are editable.

Bands that reset each year

Civil service motor rates drop as the kilometres in the year add up. The log counts kilometres per person through the tax year and moves each journey into the right band, splitting a journey across bands when it straddles the threshold. ANNUAL SUMMARY shows the kilometres, the amount paid and the maximum at civil service rates.

Questions people ask

Can I claim from home to a client's site?
Often yes, but it depends on where your normal place of work is and the distances involved. The log stores the home address and normal workplace so the claim can be checked.
Can a self-employed person use it?
Yes. People are set up as employee, director or self-employed; for self-employed people the log is a record of business motoring rather than a tax-free payment.
Can my company use a flat rate instead?
SETTINGS lets you choose civil service rates or a flat company rate per kilometre.

Inside the workbook

The file in numbers

  • START
  • SETTINGS
  • PEOPLE
  • VEHICLES
  • TRIP LOG
  • EXPENSES
  • CLAIM FORM
  • ANNUAL SUMMARY
  • DASHBOARD
File format
.xlsx
Tabs
9
Capacity
20 people · 25 vehicles · 1,200 journeys · 600 expense lines
Requires
Excel 2016+ / Microsoft 365
Macros
None

Expenses beside mileage

EXPENSES has 600 lines for parking, the M50 and other tolls, buses, Luas, trains and taxis. They appear on the monthly claim with the journeys, so one form covers the month.

A mileage claim that stands up to questions

Add the mileage log to your basket and continue to payment.

Add to basket