Format
Excel
Price
Free
How to use this template
- 1Set your reimbursement rate in the designated cell at the top of the log
- 2After each business trip, log the date, destination, purpose, and odometer readings
- 3The template calculates distance and reimbursement automatically
- 4Use the monthly summary for expense claims
- 5Print or export the annual log for tax records
ExpensesAccess free template
Mileage Log Template
Track business mileage for tax deductions. Auto-calculates reimbursement at the current IRS/HMRC rate.
What's included
- Daily mileage log with date, purpose, start and end odometer readings
- Automatic distance calculation per trip
- Running total mileage and reimbursement amount
- Editable rate per mile/km cell
- Monthly and annual summary totals
- Business vs personal mileage split
- HMRC and IRS compliant format
Who uses this template
- Self-employed professionals claiming mileage for tax deductions
- Employees claiming mileage reimbursement from employers
- Sales staff tracking client visit mileage
- Tradespeople logging travel to job sites
Want to automate this entirely?
Note.now handles expenses automatically - no spreadsheet required. Real-time data, one-click reports, and bank-connected accuracy.
Try free for 7 daysFrequently asked questions
What rate should I use per mile?
In the UK, HMRC's approved mileage rate is 45p/mile for the first 10,000 miles and 25p/mile thereafter. In the US, check the current IRS standard mileage rate for business use.
Do I need to keep physical receipts for mileage?
For mileage claims, a detailed log like this template is the primary evidence. You do not typically need fuel receipts - the mileage rate covers all running costs.