Mileage Reimbursement Log (2026)

1Tell us where to send it
Your name and work email — nothing more.
2Check your inbox
Your log arrives in seconds, not days.
3Use it with your team
Editable and ready to share — make it your own.

A peek inside

See exactly what you're getting

Free Excel template

Spotsaas · 2026

Mileage Reimbursement Log

✓ Instructions

✓ Mileage Log

✓ Summary

Get the log →

What it is

The Mileage Reimbursement Log is an IRS-compliant spreadsheet that turns a list of business trips into a defensible, reimbursable total. You enter each trip's date, the from/to locations, the business purpose, and the miles (typed directly or computed from odometer start and end readings), and the log multiplies your miles by the current IRS standard mileage rate, sums your reimbursement, and grades whether your records meet the substantiation rules. It's the cents-per-mile method made operational, built so the numbers it produces will stand up to an accountable-plan review.

The workbook has three tabs that do distinct jobs. The Instructions tab explains the cents-per-mile method and the substantiation IRS rules expect. The Mileage Log tab is where the work happens: you set the IRS rate once in a highlighted input cell (the template ships with $0.70/mile), then add one row per trip, with the sheet computing Miles (or pulling it from odometer readings) and Reimbursement = miles × rate, and totaling both columns. The Summary tab rolls up total business miles, the rate applied, total reimbursement, the number of trips, and average miles per trip, and includes a record-keeping self-check that flags whether your log meets the IRS substantiation basics.

What distinguishes this from a scribbled list of drives is that it's structured to satisfy the substantiation requirements that make mileage reimbursement non-taxable under an accountable plan: contemporaneous records of date, business purpose, and distance. The self-check on the Summary tab nudges you toward honest, complete records rather than reconstructed-after-the-fact estimates, which are exactly what gets disallowed. Because the rate is a single editable cell, you keep the log current the moment the IRS publishes a new standard rate.

What it's used for

Employees and finance teams use the Mileage Reimbursement Log to capture business driving in a form that calculates the reimbursement automatically and survives an audit. It's the bridge between 'I drove a lot for work' and a clean, substantiated number on an expense report.

✓ Logging each business trip with the four things substantiation requires, date, from/to, business purpose, and miles, so the record is contemporaneous and specific rather than reconstructed.
✓ Computing reimbursement automatically by setting the IRS standard mileage rate once and letting the sheet apply miles × rate to every trip and total it, so there's no manual arithmetic to get wrong.
✓ Deriving miles from odometer readings when you have them, by entering odometer start and end so the sheet calculates the distance, which is harder to dispute than a typed-in figure.
✓ Rolling up a trip log into a single reimbursable total plus useful context, total miles, trips logged, and average miles per trip, ready to attach to an expense report.
✓ Self-checking your records against IRS substantiation basics via the Summary tab's record-keeping check, so you catch a missing business purpose or vague record before finance or an auditor does.
✓ Keeping the rate current by editing one cell whenever the IRS updates the standard mileage rate, so reimbursements always use the right number.
✓ Feeding a clean mileage figure into your expense tool or reimbursement run, and supporting the policy rule that mileage is reimbursed in lieu of, not in addition to, fuel.

Who uses it

Anyone who drives a personal vehicle for work and the finance people who reimburse them rely on a proper mileage log. It's most important where personal-car business travel is routine, sales, field service, multi-site roles, and where IRS substantiation has to hold up.

Field sales and service employeesDrive their own cars between client sites and need a contemporaneous log to get reimbursed accurately and prove the miles were business, not personal.

Finance / accounts payableProcesses mileage claims and needs records that meet substantiation rules so the reimbursement stays non-taxable and survives an audit.

Controller / Finance leadSets the reimbursement rate (typically the IRS standard rate) and owns the accountable-plan treatment that the log is designed to support.

Managers approving expense reportsReview mileage lines for reasonableness against point-to-point distance, and the log gives them a clear, calculated figure to approve rather than a guess.

Contractors and remote employeesTrack occasional business driving in a single place so an irregular mile here and there still ends up as a clean, substantiated claim.

Context & good to know

Mileage is deceptively risky for finance. The amounts per trip are small, but the substantiation rules are strict, and reconstructed mileage, the kind people estimate at month-end from memory, is one of the first things an auditor distrusts. The IRS expects a contemporaneous record of the date, the business purpose, and the distance for each trip, kept at or near the time of travel. A spreadsheet built around those fields turns a vague 'I drove a lot' into the specific, dated records that keep mileage reimbursement non-taxable under an accountable plan.

The two methods for vehicle costs, standard mileage (cents-per-mile) and actual expenses, shouldn't be mixed, and this log implements the standard method cleanly. The cents-per-mile rate already bundles fuel, maintenance, insurance, and depreciation, which is why the policy rule is that mileage is reimbursed in lieu of, not in addition to, fuel. Logging odometer start and end where possible makes the distance objective, and the sheet's automatic miles × rate calculation removes the arithmetic errors that creep into hand-totaled logs. Setting the rate in a single cell means a mid-year IRS rate change is a one-edit update rather than a rebuild.

The Summary tab's record-keeping self-check is the part that separates a real log from a liability. It prompts honest answers about whether each trip has a business purpose, whether records were kept contemporaneously, and whether the distances are reasonable, the exact things that get mileage disallowed when they're missing. Catching a vague or incomplete record before it reaches finance or an auditor is far cheaper than defending it after the fact. It also trains the habit of logging the trip when it happens, which is what 'contemporaneous' really means.

In practice, the log is the substantiation layer behind whatever expense tool you run. Many platforms can calculate mileage, and some derive distance from mapped start and end points, but the underlying requirement is the same: dated, purposed, distance-specific records. Whether you keep the log in this spreadsheet and attach the total to a report, or enter trips directly into your tool, the discipline the workbook enforces, set the rate once, log every trip with its purpose, never double-claim fuel, is what makes the reimbursement both accurate and audit-proof.

✓ Independent · vendors can't pay to rank

Built on verified data, not vendor spin

Every Spotsaas resource draws on the Spotsaas Score — a blend of verified review ratings, review volume, and feature depth across 113 expense management software tools. Refreshed regularly; data as of June 2026.

FAQ

Questions, answered

What mileage rate should I use in the log?

Use the current IRS standard mileage rate for business driving, which the template pre-fills at $0.70/mile (the 2025 figure) in a single editable cell. The IRS updates this rate at least annually, and sometimes mid-year, so check the current rate and update the cell when it changes. Using the standard rate keeps your reimbursement aligned with accountable-plan rules so it stays non-taxable to the employee.

Can I claim mileage and fuel for the same trip?

No. The standard mileage rate already accounts for fuel, maintenance, insurance, and depreciation, so reimbursing fuel on top would be double-counting. The policy rule is that mileage is reimbursed in lieu of, not in addition to, fuel. Pick the cents-per-mile method (which this log implements) and log the miles; don't also submit gas receipts for the same vehicle use.

What records does the IRS require for mileage?

Contemporaneous records of the date, the business purpose, and the distance for each trip, kept at or near the time you drove. The log captures exactly these fields, and the Summary tab's record-keeping check helps you verify your records meet the basics. Reconstructed, end-of-quarter estimates are the kind of records that get disallowed, so log trips as they happen.

Should I use odometer readings or just type in the miles?

Either works, but odometer start and end readings are more defensible because the distance is derived rather than asserted. The log lets you enter odometer start and end and computes the miles for you, or you can enter miles directly when you don't have readings (for example, a known point-to-point distance). For audit-sensitive logs, odometer-based entries are the stronger record.

What's the difference between the standard mileage method and actual expenses?

The standard mileage method reimburses a flat cents-per-mile rate that bundles all vehicle costs; the actual-expense method reimburses the real, receipted costs of operating the vehicle apportioned to business use. This log implements the standard method, which is simpler and is what most reimbursement policies use. Don't mix the two, pick one method and apply it consistently.

How does the log calculate my reimbursement?

It applies Reimbursement = miles × rate to each trip and totals the column. You set the IRS rate once on the Mileage Log tab, enter (or compute from odometer) the miles per trip, and the sheet sums total miles and total reimbursement, then carries those to the Summary tab along with trip count and average miles per trip. There's no manual math, which removes a common source of error.

Is Expensify (or my expense tool) able to track mileage automatically?

Many expense tools, including Expensify and Concur, offer mileage tracking, and some derive distance from mapped start and end addresses or GPS. Those features are convenient, but they still rely on the same substantiation, date, business purpose, and distance, that this log enforces. Use this spreadsheet when you want a standalone, auditable record, or to understand exactly what your tool needs to capture; the underlying IRS requirements are identical either way.

Does the average-miles-per-trip figure matter?

It's a sanity check. A sudden jump in average miles per trip, or trips that are consistently rounded to suspiciously even numbers, are the kinds of patterns an approver or auditor notices. The Summary tab surfaces average miles per trip so you (and your reviewer) can spot an outlier before it becomes a question. It's not a rule, just a quick reasonableness signal.

How does mileage tie into our broader expense policy?

Mileage is one line in your T&E policy, and the policy should state the rate (usually the IRS standard rate), that it's reimbursed in lieu of fuel, and what substantiation is required. The log operationalizes those rules: it applies the policy's rate, enforces the no-double-claiming principle by design, and produces the substantiated record the policy requires. Keep the log's rate in sync with the rate published in your policy.

Keep exploring