Mileage claims are small one at a time, which is exactly why nobody checks them.
Check each mileage claim for a business purpose, a start and end point, a reasonable distance, the correct rate per mile and no ordinary commuting. Compare claimed miles with a route planner, look for the same journey claimed twice, and make sure nobody claims mileage and fuel for the same trip. Track business miles per employee across the tax year.
Every journey line should give you enough to check it without asking the claimant:
Claims that say only "client visits, 340 miles" for a month cannot be checked and should be returned.
Lay the log out with A employee, B date, C from, D to, E miles claimed, F route-planner miles, G rate claimed and H amount claimed. Put the policy rate in a cell named Rate and your tolerance in Tol (for example 0.1 for ten per cent).
Amount check
=IF(ROUND(E2*Rate,2)<>ROUND(H2,2),"Amount differs","")
Distance check
=IF(E2>F2*(1+Tol),"Over route distance","")
Same journey claimed more than once
=IF(COUNTIFS($A:$A,A2,$B:$B,B2,$D:$D,D2)>1,"Possible duplicate","")
Cumulative business miles in the tax year (tax year start in a cell named TYStart)
=SUMIFS($E:$E,$A:$A,A2,$B:$B,">="&TYStart,$B:$B,"<="&B2)
Some regimes apply a different approved rate once an employee passes a cumulative mileage band in the tax year. The running total lets you apply the right rate and spot a claimant whose miles climb much faster than colleagues in the same role.
The expense claim audit checklist covers the wider review, and the expense policy essentials set out what the policy should say.
UK claims are usually checked against HMRC's approved mileage allowance payments, and the claim form uses postcodes. US claims are usually checked against the IRS standard mileage rate under an accountable plan, using ZIP codes or addresses. Both authorities change their rates from time to time: check the current figures before each tax year.
Score a payment request against the warning signs of fraud. Free to use online.
The Expense Claims & Corporate Card Audit System tests for exact duplicates, duplicates across employees and split purchases, flags approval problems, missing receipts, late submissions and blocked merchants, and matches card claims to the card statement, with an Expense Audit Playbook (PDF). Excel, no macros, one-time price.
It depends on the policy and the tax rules. Ordinary commuting to the normal workplace is generally not business travel, so many policies only pay the miles above the normal commute when a business trip starts from home.
Compare claimed miles with a route planner for the stated start and end points, and compare totals with colleagues in similar roles. A small tolerance for detours is normal.
Mileage is paid per mile, so there is usually no receipt for the journey itself. Many tax authorities and policies still expect fuel receipts or a mileage log, so check what yours requires.
Last updated 11 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.