Mileage Claim Excel - Free Template

1. Open the Mileage Claims sheet and enter each journey on a new row. Use one line per trip so the totals stay clear.
2. Check the HMRC Rates sheet first. If the rate changes, update it there once rather than editing every claim.
3. Fill in the claimant, client, start and end locations, purpose, vehicle type and miles driven. Keep the purpose specific, such as site visit or customer meeting.
4. Add parking or tolls where relevant. These sit outside the mileage rate and should not be mixed into the miles field.
5. Review the Approval Status and enter the manager name and approved date once checked. That gives you a proper payment trail.
6. Use the Summary Dashboard to see total claim value and volume. If you are handling several hundred claims a year, this is the quickest control check.

This template suits the office manager in a plumbing firm, the bookkeeper in a small Ltd, or the sole trader who drives between jobs. If four engineers each submit 12 journeys a month, you are already checking nearly 600 claim lines a year, so a structured sheet saves time fast.

The Mileage Claims sheet (image 1) is laid out for day-to-day entry: Claim ID, date, claimant, department, client, start and end location, purpose, vehicle type, mileage band, miles driven, HMRC rate, claim amount, parking or tolls, total claim, approval status, manager and approved date. That is the sort of format you need when journeys are being claimed weekly, not just once a year.

When you actually use it

You normally reach for this spreadsheet after a site visit, client meeting or deliveries run. A rep doing 18 business trips in a week, or a builder covering three jobs in one day, needs one place to record the numbers before memory fades.

What the dashboard shows

Image 3 shows the Summary Dashboard, which gives a quick view of total claims and processing activity. That is useful at month end, when you want to know whether you are looking at £240 of mileage for a freelancer or £1,800 across a small team.

For 2026, the approved mileage allowance payment is 45p per mile for the first 10,000 business miles in the tax year and 25p per mile after that. If someone drives 8,400 miles, the claim at 45p is £3,780; at 12,000 miles the first 10,000 miles give £4,500 and the remaining 2,000 miles give £500.

That is why the HMRC Rates sheet (image 2) matters. It keeps the rate visible, so you can check the amount before payment and avoid overpaying or underpaying a claim.

What HMRC expects in practice

For mileage claims, you need the date, start and end points, purpose of the trip and the miles claimed. If you are a sole trader, keep the records with your Self Assessment paperwork; for a company, retain them with the accounting records for 6 years.

Why the rate band matters

The first 10,000 miles are the important threshold because they are paid at the higher rate. A salesperson doing 14,000 miles a year is not on a simple flat total; the extra 4,000 miles should be checked at 25p, not 45p.

The biggest mistake is claiming without enough detail. A row that only says London to Birmingham is weak; if HMRC ever asks, you want the purpose, date, client and actual mileage, not a vague note that costs you £30 to £100 in lost relief or reimbursement.

Another common error is mixing parking, tolls and mileage together. If you put £12 of parking into the miles field, the claim becomes distorted and the rate check is no longer reliable.

Broken approval trails

If manager approval is missing, payment gets held up. In a small office that can mean two or three chase emails, a delayed BACS run and extra time on payroll or expenses review.

Wrong rate, wrong total

A 300-mile claim at 45p should total £135 before parking. If the rate is entered as 54p by mistake, that one line overstates the claim by £27, and if that happens across 20 claims the error is £540.

Make mileage entry part of the same routine as expenses approval or the weekly payroll check. If you do it every Friday at 4 pm, you are far less likely to lose the details than if you leave it until month end.

Simple habits that keep it moving

• Enter trips the same day, while the destination and purpose are still fresh.
• Copy last week’s rows if you have repeated site visits, then update the miles and date.
• Use the Approval Status column before payment so nothing is overlooked.
• Review the Summary Dashboard at the end of the month to spot unusual spikes in claims.

Once you have more than a few hundred claim rows a year, the spreadsheet still works, but you may want an expenses system with mileage capture, manager workflow and direct export to accounts. Until then, this workbook gives you a clean, low-cost control sheet.