Mileage Tracker Spreadsheet That Meets IRS Log Rules

Quick Answer: A mileage tracker spreadsheet needs one row per trip with the date, destination, business purpose and miles (or start and end odometer readings), plus the car's total miles for the year. Add a rate table so each trip picks up the IRS standard mileage rate for its date, then total business miles times rate on a summary tab. Fill it in at least weekly; a log rebuilt from memory at tax time is weak evidence.

The IRS lets you deduct business driving at a standard rate per mile, but only for miles you can prove. A spreadsheet log works as that proof if it records each trip's date, destination, business purpose and distance close to the time you drive. Below is a layout for Excel or Google Sheets, the formulas behind it, and the checks that keep commuting out.

What does the IRS require a mileage log to show?

Publication 463 sets out the elements in its Table 5-1. For car expenses you need the mileage for each business use and the total miles for the year, the date of each use, your business destination, and the business purpose. The same chapter says a record prepared on a computer counts as an adequate record, and that a log kept weekly, accounting for the week's use, is a timely kept record.

Two warnings from the publication shape the design. You cannot deduct amounts you approximate or estimate, and a record made at or near the time carries more weight than one prepared later. So the spreadsheet has to be easy enough to fill in every week, and each row has to stand on its own.

The trip log tab, column by column

Name the first tab Log and format it as a table (Insert > Table in Excel) so formulas extend to new rows.

If you prefer to type trip distances from a map, overwrite column I and leave G and H blank. Recording odometer readings at least at the start and end of the year is still worth it, because the log needs total miles driven.

Making the purpose column a dropdown

Free text in the purpose column produces "client mtg", "Client meeting" and "mtg w/ client", which breaks the totals. Put the allowed purposes in a list on a Lists tab and restrict column E to it. In Excel, Microsoft's data validation guide shows choosing Data > Data Validation and allowing a List. In Google Sheets, Google's help page on creating an in-cell dropdown covers the same thing.

Include "Commute" and "Personal" in the list on purpose. Logging those trips, rather than skipping them, means total miles reconcile with the odometer and the business-use share is honest.

The rate table and the 2026 mid-year change

Create a Rates tab with two columns: the date a rate starts, and the rate in dollars. The IRS standard mileage rates page, read on 27 October 2026, lists two business rates for 2026: 72.5 cents a mile for January 1 to June 30, and 76 cents a mile for July 1 to December 31 (IR-2026-29). Rates change, sometimes mid-year as here, so check that page before you file and add a row whenever it changes.

In the log's Rate column, look up the most recent start date on or before the trip date:

• Excel 365 or Google Sheets: =XLOOKUP(A2,Rates!A:A,Rates!B:B,,-1) (the -1 match mode returns the next smaller date).
• Older Excel: =VLOOKUP(A2,Rates!$A$2:$B$20,2,TRUE), with the rate table sorted by date.

A single fixed rate cell would overstate or understate a 2026 deduction, depending on which one you typed.

A summary tab that gives the number for your return

On a Summary tab, total by half-year or by month with SUMIFS:

• Business miles, January–June: =SUMIFS(Log!I:I,Log!J:J,"Yes",Log!A:A,">="&DATE(2026,1,1),Log!A:A,"<"&DATE(2026,7,1))
• The same for July–December, changing the dates.
• Deduction: =SUM(Log!L:L)
• Parking and tolls: =SUM(Log!M:M)
• Total miles: =OdometerDec31-OdometerJan1, from two cells where you type the readings.
• Business-use percentage: business miles divided by total miles.

Worked example. Say the log shows 4,200 business miles from January to June and 3,900 from July to December, out of 14,500 total miles on the odometer.

Business use is 8,100 ÷ 14,500, about 56%. Business parking and tolls go on top of the $6,009; gas, insurance and repairs do not, because the standard rate stands in for them.

How do you keep commuting out of the log?

Publication 463 treats driving between your home and your main or regular place of work as personal commuting. It also lists exceptions, for example trips from a home that is your principal place of business to another work location in the same business, and trips to a temporary work location in some situations. Read that section for your own setup before you decide what counts.

Add a check column that flags rows for a second look: =IF(AND(C2="Home",D2=Lists!$B$1),"Check: commute?",""), where Lists!B1 holds your regular office's name. A conditional format that shades flagged rows makes them hard to miss in the weekly review. When a trip mixes errands, the publication says a minor personal stop, such as lunch between two business stops, does not interrupt the business use.

Can bank statements fill gaps in a mileage log?

Sometimes, partly. If you missed a few weeks, your calendar, client invoices and the fuel, toll and parking charges on your bank and card statements can show where you were on which day. Convert the statements to rows (QuickBankConvert reads statement PDFs into Google Sheets-ready CSV or Excel), filter for fuel stations, toll operators and parking, and use the dates and locations to rebuild those trips, with a note in the row saying the entry was reconstructed and from what.

Be clear-eyed about what that evidence is. Under "What if I have incomplete records?" Publication 463 asks for your own specific statement plus other supporting evidence for each element, and a fuel charge shows you bought gas somewhere, not where you drove or why. The publication also describes sampling: a log kept for representative periods, such as the first week of each month, can support the business-use rate for the year if other evidence shows the rest of the year was similar. Treat reconstruction as a repair, not a method.

Vehicle costs on statements also matter if you are weighing the actual-expense method instead; that comparison is in mileage deduction and bank statement tracking.

A routine that keeps the log usable

1. Every Friday, enter the week's trips from your calendar while you remember them.
2. Check that each business row has a destination and a purpose a stranger would understand.
3. Clear any commute flags.
4. On January 1 (or the day you start using a car for business) and December 31, photograph the odometer and type the readings into the summary.
5. Keep the file and its supporting receipts at least three years after you file; Publication 463 gives that as the general rule and points to longer periods for depreciation records.

For rideshare and delivery drivers, the Uber driver tax prep guide covers how platform mileage summaries fit with your own log. The totals from this sheet then feed the car line of a self-employed tax spreadsheet.

Related guides

• Mileage deduction and bank statement tracking
• 1099 deductions calculator in a spreadsheet
• Self-employed tax spreadsheet