Free Mileage Log Template

What a Mileage Log Template Is and Who Needs One

A mileage log template is a record of every business trip you take in a vehicle, including the date, starting and ending odometer readings, the origin and destination, and the business purpose. The IRS requires this level of detail to support a vehicle expense deduction, and most employers require similar documentation for mileage reimbursement programs.

Without a contemporaneous mileage log, estimated or reconstructed mileage records are difficult to defend in an audit. The IRS standard mileage rate method requires you to track business miles separately from personal miles and apply the applicable rate for the tax year. The actual expense method also requires a mileage log to establish the business-use percentage of total miles driven. Keeping a mileage log in Google Sheets, Excel, or a printed template makes it straightforward to calculate your deduction at year end.

Note: tax rules change annually. Always verify the current IRS standard mileage rate at IRS.gov and consult a tax professional for guidance specific to your situation. This template is a recordkeeping tool, not tax advice.

• Self-employed individuals and freelancers deducting business vehicle expenses on Schedule C
• Employees seeking reimbursement from an employer for business driving
• Real estate agents, sales representatives, and field service workers with high annual business mileage
• Small business owners with a company or personal vehicle used for both business and personal trips
• Delivery drivers and rideshare workers tracking business miles for deduction purposes
• Anyone who uses a personal vehicle for client visits, site inspections, or business errands

What to Include in a Mileage Log Template

A mileage log template must capture enough detail to satisfy IRS documentation requirements. The IRS specifies that adequate records include the amount of mileage for each business use, the date, the destination, and the business purpose. A generic entry like 'client meeting' is less defensible than 'meeting with Acme Corp at 123 Main St re: Q3 contract renewal.' The more specific the purpose, the stronger the record.

If you use the same vehicle for both personal and business travel, the separation of miles is critical. Keep a personal miles column and record those separately so your annual business-use percentage is easy to calculate and audit-ready. The total miles from January 1 to December 31 (odometer delta) should equal business miles plus personal miles in your log, with no unexplained gap.

• Date of each trip
• Starting location and destination, specific enough to verify the distance
• Business purpose: the specific reason for the trip and who or what it relates to
• Odometer reading at the start and end of each trip, or total miles for the trip
• Whether the miles are business or personal, since mixed-use trips are common
• Annual odometer readings at January 1 and December 31 to establish total annual mileage
• Vehicle information: make, model, year, and license plate for identification
• Monthly and annual summary totals of business miles and the calculated deduction or reimbursement amount

How to Keep a Mileage Log Step by Step

The hardest part of a mileage log is consistency. Logging trips at the time they happen takes about 30 seconds. Reconstructing a year of driving from memory takes hours and produces records that are harder to defend. The setup below takes about 20 minutes and produces a log you can update from your phone or computer after each trip.

1. Set up your mileage log template in Google Sheets at the start of the tax year. Record your odometer reading on January 1 in the designated field. Take a photo of the odometer as a backup record.
2. Add your vehicle information at the top of the sheet: make, model, year, and license plate number.
3. After each business trip, log the date, origin, destination, purpose, and miles driven. Enter odometer readings if your employer or recordkeeping preference requires them, or simply enter the trip miles.
4. Be specific about the business purpose. Write 'client site visit at [client name], [address]' rather than 'client meeting.' This level of detail matters in an audit.
5. For trips that mix business and personal driving, log the business portion only in the business miles column. Document the reason any personal miles were included in the same trip in the notes column.
6. Reconcile your log monthly. Add up the business miles, multiply by the applicable rate, and record the monthly reimbursement or deduction amount in the monthly summary section.
7. At year end, record your December 31 odometer reading. Total your business miles for the year and calculate the full year deduction at the IRS standard mileage rate. Retain the log and supporting records for at least 3 years.

Mileage Log Variations: Call Log, Contact List, and Assignment Tracker

A mileage log template is primarily a tracking and recordkeeping tool. Related tracking formats serve similar organizational functions in different contexts. A call log template records outbound and inbound calls by date, contact, duration, and outcome, giving sales teams or field reps a record of every customer interaction. A contact list template is a simple directory of names, phone numbers, emails, and notes, used alongside a call log to keep customer data organized. An assignment tracker template helps individuals or teams track tasks, deadlines, and completion status, sharing the same row-per-item structure as a mileage log but applied to work tasks rather than trips.

For field sales reps or service technicians, a combined sheet that tracks calls made, contacts visited, and miles driven per day can be more efficient than three separate logs. Google Sheets supports this with multiple tabs or a combined daily entry format.

• Mileage log template: driving records for tax deduction or employer reimbursement
• Call log template: record of calls made or received, with date, contact, duration, and outcome
• Call sheet template: pre-trip or pre-call planning sheet listing who to contact and what to discuss
• Contact list template: directory of names, numbers, emails, and relationship notes
• Assignment tracker template: task-by-task record of assignments, due dates, and completion status

Mileage Log Tips and Common Mistakes to Avoid

Mileage logs fail in audit for predictable reasons. The most common problems are lack of contemporaneous records, vague business purpose descriptions, and missing odometer readings for the start and end of the year. A few habits prevent these issues.

The most practical habit is logging immediately after each trip, not batching at the end of the week. Friday reconstructions are consistently less accurate than same-day entries. If you drive 3 to 5 business days per week, a same-day logging habit takes about 3 minutes total per week and produces a log that can withstand scrutiny.

• Log trips at the time they happen, not at the end of the week. Reconstructed logs are weaker in audits than contemporaneous records
• Always record a specific business purpose. 'Client visit' or 'business' is not sufficient. Name the client, the project, or the specific task
• Record January 1 and December 31 odometer readings to establish total annual mileage. Take a photo as backup
• Commuting miles from home to your regular office are not deductible. Business miles begin at your first business stop, not at your front door
• For a Google Sheets mileage log, use a locked header row and protected cells in the rate and formula columns to prevent accidental edits
• Keep the mileage log for at least 3 years after the tax return it supports. The IRS has 3 years to audit a return in most situations