If you drive for business, every mile is deductible — and 2026 is the year a lot of mileage logs are going to be wrong.
The IRS raised the standard business rate part-way through the year. Anyone using a single rate across all twelve months will produce an incorrect figure. This guide covers what the IRS actually requires in a log, and how to build one in Google Sheets that handles the split for you.
The 2026 Rates — There Are Two
Per IRS standard mileage rates:
| Purpose | Jan 1 – Jun 30, 2026 | Jul 1 – Dec 31, 2026 |
|---|---|---|
| Business | 72.5¢ per mile | 76¢ per mile |
| Medical / qualified moving | 20.5¢ per mile | 23.5¢ per mile |
| Charitable | 14¢ per mile — fixed by statute, unchanged | |
A mid-year change is unusual, and it means the arithmetic is not "miles × one rate". Ten thousand business miles spread evenly across 2026 works out at 5,000 × $0.725 plus 5,000 × $0.76 — $7,425, not the $7,000 a single-rate calculation at last year's figure would give you.
You can check any given split with our free mileage calculator, which has buttons for both periods.
What the IRS Requires in a Log
Publication 463 asks for a contemporaneous record covering, for every business trip:
| Field | What to record | Example |
|---|---|---|
| Date | The date of the trip | 15 July 2026 |
| Destination | Where you went | Client office, 123 Main St |
| Business purpose | Why you went | Quarterly review meeting |
| Odometer start | Reading at departure | 47,832 |
| Odometer end | Reading on arrival | 47,891 |
| Miles | The difference | 59 |
Contemporaneous is the word that matters. It means recorded at or near the time of travel — not assembled from memory in April. Reconstructed logs are markedly weaker, and long gaps or suspiciously round numbers are exactly what draws attention to a vehicle deduction.
Building the Template
Set up these columns in a new Google Sheet:
| Column | Contents |
|---|---|
| A | Date |
| B | Starting location |
| C | Destination |
| D | Business purpose |
| E | Odometer start |
| F | Odometer end |
| G | Miles — =F2-E2 |
| H | Deduction — see below |
| I | Notes — parking, tolls, passengers |
Column H is where most templates go wrong this year. Rather than multiplying by a single rate, have the sheet pick the right one from the trip date:
=IF(A2<DATE(2026,7,1), G2*0.725, G2*0.76)
Copy that down the column and every trip is valued at the rate in force on the day you drove it. Then add a summary row:
- Total business miles —
=SUM(G2:G1000) - Total deduction —
=SUM(H2:H1000)
That gives you a running deduction figure that stays correct across the July boundary without you thinking about it.
Keeping It Accurate
- Log the same day. Keep the sheet on your phone and add the entry before you drive off. This is what "contemporaneous" means in practice.
- Record your odometer on 1 January and 31 December. Total annual mileage is how business-use percentage gets sanity-checked.
- Do not log personal trips. If you drive home to a client and then to the shops, only the first leg counts.
- Commuting is not deductible under any method — home to your regular workplace is personal.
- Keep something that corroborates the trip. A calendar entry, an email, an invoice from that day. The log is the primary record; corroboration is what makes it convincing.
Which Method Should You Use?
The standard mileage rate is one of two ways to deduct vehicle costs; the other is actual expenses, where you track fuel, insurance, repairs, depreciation and the rest, and deduct the business-use share. There are lock-in rules about which you can choose in the first year for a given vehicle, and the better option depends on what your vehicle actually costs to run.
We compare both in detail — including the lock-in rules and worked examples — in our Schedule C vehicle deduction guide. This post assumes you have chosen the standard rate.
Don't Forget Parking and Tolls
Business parking and tolls are deductible in addition to the standard mileage rate. They are easy to overlook because each one is small, and they are almost always paid at a machine that issues a thermal receipt which will not survive to April.
ReceiptSync captures those the moment you get them — merchant, date, and amount extracted automatically, image kept alongside — so the parking and toll side of your vehicle deduction is documented as well as the mileage. For what the IRS expects from receipts generally, see IRS receipt requirements.
The Bottom Line
The mileage deduction is among the largest available to self-employed people and among the most commonly disallowed, because most logs are built in April rather than as the year goes. Set the sheet up today, use the date-aware formula so the July rate change handles itself, and log each trip the day you take it.