Free Google Sheets Mileage Log
For anyone who drives between jobs and wants a clean mileage record for reimbursement or tax time, with odometer checks.
Open the template · Make a copy · Google Sheet, free, no sign-up
What is inside
| Tab | What it holds |
|---|---|
| Dashboard | Totals and views built from Trips, no typing needed. |
| Monthly Log | Totals and views built from Trips, no typing needed. |
| Trips | Columns Trip ID, Date, Driver, Vehicle, Start location, End location, Purpose, Customer or job, Start odometer and 7 more. |
| Settings | Your own dropdown lists (drivers, vehicles and business or personal), so the choices match how you work. |
How to fill it in
- Add drivers and vehicles on Settings.
- Log each trip on Trips with start and end location, purpose and odometer readings.
- Mark business or personal and round trips.
- Read Monthly Log and Dashboard for business miles and reimbursement owed.
A tip from the field
Odometer gaps get flagged, so a trip missing between two readings shows up while you still remember it.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
- Trips (6 sample rows)
Related templates
- Free Expense Report Template
- Free Google Sheets Expense Tracker
- Free Google Sheets Dispatch Schedule
When you outgrow it
Smarfle plans each technician’s route for the day with drive times between stops. See how it works on smarfle.com.