IRS Mileage Log Spreadsheet: What the IRS Requires

How-to basics · Updated November 21, 2026

No: the IRS does not approve or require a particular mileage log spreadsheet. You can use an Excel spreadsheet, an app, or another reliable recordkeeping method, as long as your records adequately support the mileage deduction or reimbursement you claim and show the relevant trip details.

What the IRS means by a mileage log

A mileage log is a record of vehicle use that helps establish which miles were driven for a potentially deductible purpose. For business use, a useful record identifies when you traveled, where you went, why the trip was business-related, and how many business miles you drove. These details help distinguish work travel from personal driving, which generally does not qualify as business mileage.

The IRS discusses recordkeeping in publications such as Publication 463, which covers travel, gift, and car expenses. Its rules focus on substantiating an expense, not on approving a particular spreadsheet design. A blank template advertised as “IRS approved” is therefore not an official IRS form or a guarantee that a deduction will be accepted.

Records should be credible and sufficiently detailed to support the amounts reported. A mileage log created close to the time of each trip is generally more useful than a reconstruction made much later from memory. Receipts, calendars, appointment records, and work orders can help corroborate the log, but they do not necessarily replace the trip details themselves.

What information to put in the spreadsheet

Use one row for each trip, or for each clearly documented group of trips if your process reliably preserves the information for every journey. A practical spreadsheet can include these columns:

  • Date: The day the trip took place.
  • Starting and ending odometer readings: Useful for checking the distance driven and reconciling annual totals. These readings are helpful supporting details, although a spreadsheet is not made compliant simply by including odometer columns.
  • Trip miles: The distance attributable to the trip, rather than an unexplained monthly total.
  • Starting point and destination: Identify the locations clearly enough to understand the travel.
  • Business purpose: For example, “visit customer about project estimate” rather than just “work.”
  • Trip category: Mark business, medical, charitable, or another applicable purpose separately. Different categories have different tax treatment and rates.
  • Notes or supporting reference: A customer, project, appointment, or calendar reference can make a short purpose description more informative.

For example, “March 12; office to 18 Oak Street, Springfield; 14 miles; inspect customer site for project estimate” is more useful than “March 12; work; 14 miles.” A specific destination and purpose make it easier to understand why the travel occurred.

Keep personal trips out of the deductible business-mile total. If a trip combines business and personal stops, record the business portion in a way that can be explained and supported. Do not classify ordinary commuting between home and a regular workplace as business travel merely because the drive happens on a workday; commuting is generally personal travel, subject to limited rules and exceptions.

How to build a mileage log in Excel

In Excel for Microsoft 365 on Windows, create a blank workbook and add headings in row 1. A straightforward layout is Date in column A, Destination in B, Purpose in C, Start Odometer in D, End Odometer in E, Trip Miles in F, and Category in G. Add any project or notes columns that suit your recordkeeping needs. Format the date column as a date and the odometer and mileage columns as numbers.

With the starting odometer in D2 and ending odometer in E2, enter this formula in F2 to calculate the trip distance:

=E2-D2

For example, if D2 is 12,450 and E2 is 12,468, the formula returns 18 miles. Copy the formula down column F for later trips. Check that the readings are entered in the correct order and that unusual results, such as a negative distance, are investigated rather than silently accepted.

With trip miles in F2:F4 and values of 18, 12, and 35, enter this formula in a total cell to add those recorded trips:

=SUM(F2:F4)

The result is 65 miles. Expand the range as your log grows, or use an Excel table so new rows can be included more conveniently. To create a table, select the data and choose Insert > Table. A table also makes it easier to sort and filter by date, category, or destination. Do not sort only one column; sorting the entire table keeps each trip’s details together.

Excel for the web has similar table and formula features. The exact interface can differ slightly from the Windows desktop app, and Mac menus and ribbon details may also vary, but the formulas above work in current Excel versions. A spreadsheet is only as reliable as the entries and saved records, so make regular backups and preserve prior-year logs.

Turning recorded miles into a deduction

A mileage log documents miles; it does not decide whether those miles qualify for a particular tax treatment. The rules depend on the reason for travel, the taxpayer’s circumstances, the tax year, and the method used to calculate vehicle expenses. For business vehicle use, eligible taxpayers may generally compare the standard mileage method with the actual-expense method, subject to IRS requirements and restrictions. The methods do not simply allow a taxpayer to claim every vehicle cost on top of a mileage-rate deduction.

The standard mileage rate is set for a particular tax year and can change. Do not hard-code a rate from an old template or assume that a rate shown on a website applies to the year in your log. With total eligible miles in F2 and the applicable tax-year rate entered in J2, this formula calculates an illustrative amount:

=F2*$J$2

If F2 contains 65 and J2 contains a hypothetical rate of 0.70 dollars per mile, the result is 45.50 dollars. That example is arithmetic only, not a current IRS rate or a determination that the 65 miles qualify. Enter the correct rate for the relevant year and category only after checking authoritative IRS guidance.

Medical and charitable mileage are not interchangeable with business mileage. Their rules and rates can differ, and charitable travel has its own requirements. Keep categories separate in the log rather than applying one rate to every mile. A tax professional or current IRS instructions can help determine which rule applies to a particular trip and taxpayer.

Contemporaneous records and supporting evidence

Make entries as you travel or as soon as practical afterward. A log that is consistently updated is easier to verify than a year-end estimate. If you miss an entry, use reliable records—such as appointment calendars, customer invoices, work schedules, or odometer records—to reconstruct the facts, and label the entry as reconstructed rather than presenting a guess as a contemporaneous note.

Keep supporting documents that explain the business connection where appropriate. A calendar invitation may show that a meeting occurred, while an invoice or project record may clarify its purpose. Those records complement a mileage log; they do not automatically show the distance driven or prove that every mile was business-related.

Record total annual vehicle mileage as well as the mileage by purpose when it is relevant to your situation. Beginning- and end-of-year odometer readings, service records, and inspection documents can help check whether the sum of logged business, personal, and other miles is plausible. The figures should reconcile reasonably: a log totaling more miles than the vehicle actually traveled is an obvious warning sign.

Choosing a spreadsheet, app, or paper log

There is no single best format for everyone. Choose a method you will keep current and can retain, review, and produce if needed. An Excel spreadsheet offers flexibility and easy totals, but it depends on accurate manual entry. A mileage-tracking app may record routes automatically, but you still need to review trips, label their purpose, correct errors, and keep accessible records. A paper log can work if it is legible, complete, and stored safely.

When comparing options, consider whether the tool lets you:

  • Record the date, destination, mileage, and purpose of each trip.
  • Separate business, personal, medical, and charitable travel.
  • Export or back up records in a durable, readable format.
  • Correct mistakes while retaining enough context to explain changes.
  • Protect sensitive location and customer information.

Automatic GPS tracking can create a privacy concern because it may capture personal locations as well as work trips. Review what an app stores, who can access the data, and how long records remain available. A tracking feature does not make a trip deductible; classification and the underlying tax rules still matter.

Common mileage-log mistakes

One frequent problem is recording only a monthly mileage total. A number such as “900 business miles in April” usually gives little information about dates, destinations, or business purposes. Another is using vague descriptions such as “meeting” without identifying who or what the meeting concerned. Add enough context to make the trip understandable later.

Other avoidable errors include mixing personal and business miles, applying the wrong year’s rate, counting a commute as business travel without checking the rules, and failing to update odometer readings. Duplicate entries can also inflate a total, especially when importing records from both an app and a spreadsheet. Reconcile totals periodically and investigate unusually long trips or repeated destinations.

Do not assume that a polished template proves a deduction. The format cannot cure missing, inaccurate, or unsupported entries. Conversely, an ordinary spreadsheet is not disqualified merely because it lacks an official IRS seal; the quality of the underlying records is what matters.

Frequently Asked Questions

Does the IRS have an official mileage log spreadsheet?
No. The IRS does not prescribe or approve one spreadsheet template. A taxpayer may use a spreadsheet, an app, or another recordkeeping system if it adequately documents the relevant mileage and supports the claim.

What should an IRS mileage log include?
For business trips, record the date, destination, business purpose, and miles driven. Odometer readings and supporting references can strengthen the record and help reconcile vehicle use, even though no particular spreadsheet layout is mandated.

Can I create my mileage log at the end of the year?
You can use reliable evidence to reconstruct missing details, but a log made long after trips is generally harder to support than entries recorded at or near the time. Keep calendars, work records, receipts, and odometer information that can substantiate any reconstruction.

Are commuting miles deductible as business mileage?
Ordinary travel between home and a regular workplace is generally commuting and personal, not business mileage. Special circumstances can affect the analysis, so check current IRS guidance or ask a qualified tax professional about your facts.

Can an app replace an Excel mileage log?
An app can serve as a recordkeeping method if it preserves usable trip details and allows you to identify the purpose and category of each trip. Review its entries and keep accessible copies; GPS data alone does not establish that a trip qualifies.

Does a mileage log guarantee a tax deduction?
No. A log supports the mileage facts but does not establish that the travel qualifies or that a particular deduction method is available. Eligibility and calculation depend on the applicable tax rules and the taxpayer’s circumstances.

Keeping a useful record year after year

Set up a simple log before the first trip, use consistent categories, and enter details promptly. Review totals monthly, compare them with odometer or service records when available, and save a separate copy outside the working file. Before filing, verify the tax year’s rules and rates and make sure the mileage claimed matches the supporting entries. A clear, complete record—not a claim that a template is “IRS approved”—is the practical foundation of a defensible mileage log.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.