Mileage report template

Track work trips so reimbursements are accurate and easy to review.

How to use itEmployees fill in one row per trip. Managers review and approve before the reimbursement is processed.

Per trip, record

At the end of the period

Tips for using this template well

  1. Set the rate and period in your policy.
  2. Record trips the same day.
  3. Check that totals add up.
  4. Keep records as your policy and local rules require.

A worked reimbursement

Suppose your policy pays $0.60 a mile, which is a made-up rate. An employee drives from the office to two client sites and back: 14 miles, 22 miles and 19 miles. That is 55 miles, and the reimbursement is 55 × $0.60 = $33.00. If the first trip was a commute from home rather than a work trip, it would not be included, so record where each trip started.

Commuting versus business travel

Travel from home to the regular workplace is a commute and is not reimbursed as business mileage. A trip from the office to a client, or from home straight to a client site when that is not the regular workplace, can qualify. The IRS publishes a standard mileage rate each year for tax purposes. Many employers use it as the policy rate, but it is not required, so check the current figure.

How it shows up in payroll

Reimbursements are usually paid with payroll but kept separate from wages on the stub. Mark the line as an expense reimbursement and total it per employee. If an employee’s wages are close to the minimum, check that unreimbursed vehicle costs do not push real pay below the minimum wage.

Common mistakes

What the IRS expects a log to show

IRS Publication 463 lists four elements for each business trip: the amount, meaning the miles; the time, meaning the date; the place, meaning the destination; and the business purpose. A log kept at or near the time of the trip carries much more weight than one rebuilt later. Under an accountable plan, the employee should hand in the log within a reasonable time, and the IRS safe harbor treats 60 days after the trip as reasonable. Any advance above the approved amount should be returned within 120 days.

A completed week

Sample log for a field technician (fictional)
Date From and to Purpose Odometer Miles
Mon 3/2 Shop to Ridge Apartments Boiler service, job 4410 41,220 to 41,238 18
Mon 3/2 Ridge Apartments to supplier Pick up valve for job 4410 41,238 to 41,247 9
Mon 3/2 Supplier to shop Return 41,247 to 41,261 14
Wed 3/4 Shop to Oak Clinic Inspection, job 4418 41,402 to 41,433 31
Wed 3/4 Oak Clinic to shop Return 41,433 to 41,464 31
Week 103

At a made-up policy rate of $0.65 a mile, the week comes to $66.95. The odometer jump from 41,261 to 41,402 is personal driving and is left out, which the log makes visible.

Reviewing a report as a manager

  1. Compare the dates and jobs with the schedule or job list.
  2. Check that odometer readings run in order with no overlap.
  3. Make sure the first trip of each day starts at the regular workplace or a job site.
  4. Approve and send to payroll as a reimbursement, not wages.

EZTime can tag hours to jobs and clients, which makes it easier to match each trip with the job it served.

What people ask about the mileage report

What rate should I use?

Use the rate in your policy and check current official guidance.

Can I use an app?

Yes, if the records are complete.

Do I need an odometer reading?

A start and end reading is the clearest record. A mapping app’s distance with the route saved also works if your policy accepts it.

How long should I keep mileage logs?

Keep them as long as your payroll or tax records, and ask your accountant for the period that applies to you.

Can I reimburse a flat monthly amount?

Some employers do. A flat amount should still reflect real travel, and may be treated differently for tax.

Do I need receipts for tolls and parking?

Keep receipts or statements where possible. Tolls and parking for business trips are usually reimbursed at cost in addition to the mileage rate.

Can the log be kept on a phone?

Yes, as long as it records the same four elements and can be exported for the reimbursement file.

Where to go next

Keep reading

Keep your team on schedule

Templates help with consistency. A time and attendance system helps you see who worked when. Book a demo to see how EZTime handles it.

Disclaimer: This template is general information to adapt to your own business. It is not legal, safety or compliance advice, and it does not replace requirements set by law or your insurer. Check local rules with a qualified professional.