This weekend — through Sunday at 11:59 PM: BUNDLE-NOV21 takes 10% off the Practice in a Box + Everything Vault bundle. VAULT-NOV21 takes 15% off the Everything Vault. WEEKEND15 takes 15% off everything else, and the new Close the Month + Close the Year bundle is $149.
Browse templates →

How to Track Mileage for Taxes (and Keep a Log That Holds Up)

Business mileage is one of the most valuable deductions a freelancer or small business owner can claim — and one of the most commonly lost, because it was never written down. A simple log, kept as you drive, is the whole system.

4 factsper trip: date, destination, purpose, miles
1,200 mileslogged in the worked quarter
Same daylog trips when they happen, not at tax time

Welcome to the numbers workshop

Hi, I'm Max — I run Vickery Finance, and this page is one room in the workshop. Everything here walks the same path: from shoebox-and-guesswork to a clean close you can defend, one honest number at a time. Work through it with your own figures in hand — that's when a guide turns into a result. And when you're ready to do the close instead of just reading about it, start with the Free Month-End Close Checklist: it's page one of the 18-step close my templates run, printable and yours to keep. Know your numbers.

The log is the deduction

Mileage deductions live or die on documentation. Tax rules expect a contemporaneous record — a log made at or near the time of the trip, showing the date, where you went, why the trip was business, and how many miles you drove. A spreadsheet reconstructed in March from credit-card receipts and memory is weaker evidence in every way, and it is also far more work than thirty seconds per trip would have been.

The good news is how little the log needs to hold. Four facts per trip, recorded the same day, plus a way to separate business miles from personal miles and commuting, turns mileage from a scramble into a by-product. Whether you keep it in a spreadsheet, a notebook in the console, or an app, the structure below is what the log needs — this page follows the mileage log template approach: one row per trip, totaled monthly.

How to track mileage for taxes, step by step

Set the log up once; each trip after that takes under a minute.

  1. Create one row per trip with four facts. Date, destination (client name or place), business purpose in a few words, and miles driven. Add starting and ending odometer readings if you want the strongest record — they make the miles self-proving and give you total miles for the year for free.
  2. Log it the same day. End of the drive or end of the day, not end of the month. Contemporaneous is the standard the record is judged by, and it is also the only version that stays accurate.
  3. Never count commuting. Driving from home to your regular workplace is commuting and is not business mileage, however far it is. Trips from your workplace (or home office, if that is your principal place of business) to clients, job sites, suppliers, and business errands are the business miles the log exists to capture.
  4. Record personal miles too, at least in total. Your deduction depends on the business share of driving, so the log should be reconcilable to the vehicle's total miles for the year — odometer readings on January 1 and December 31 make that a two-line check.
  5. Total the log monthly. Sum business miles at each month-end and tie the count to your calendar: every logged trip should match an appointment, invoice, or receipt. Orphan trips and missing trips both surface in this five-minute review.
  6. Apply the rate only at filing time. Multiply total business miles by the standard mileage rate for that tax year when the return is prepared — check the current IRS standard mileage rate before you file rather than hard-coding a rate into the log. (Some taxpayers instead deduct actual vehicle expenses; that is a separate method with its own records, and choosing between them is a tax question for your preparer.)

What a complete trip entry looks like

A strong entry reads like this: 'Mar 12 — Rivera client office, quarterly review meeting — 24 miles (odometer 41,208 to 41,232).' Date, destination, purpose, distance, and odometer span, in one line. Multi-stop days can be one row per leg or one row for the round trip with the stops named — consistency matters more than the choice.

Keep the log with the rest of your tax records, and keep it for as long as you keep the return it supports. This page is educational bookkeeping information, not tax advice: it describes how to keep the record, while what is deductible in your situation follows the tax rules and your preparer's judgment.

A worked quarter: 1,200 business miles, logged trip by trip

A consultant logs every client trip in a spreadsheet, one row per trip, and totals the log monthly. The quarter's driving reconciles cleanly: 1,500 total miles driven, of which 1,200 were business trips and 300 were personal and commuting. Valued at an illustrative 70 cents per mile — check the current IRS standard mileage rate before you file — the quarter's business mileage represents 1,200 × $0.70 = $840 of mileage amount:

MonthBusiness milesRunning total
January400400
February350750
March4501,200
Quarter total1,200
Mileage amount at an illustrative $0.70/mile1,200 × $0.70$840

Habits that keep the log complete

Mileage logs fail by omission, not by math — these habits close the gaps:

  • Put the log where the trip ends: a phone shortcut or a notebook in the car beats a spreadsheet you only open at your desk.
  • Photograph the odometer on January 1 and December 31 — two pictures anchor the whole year's totals.
  • Cross-check monthly against your calendar and invoices; a client meeting with no trip logged is a deduction quietly lost.
  • Log the return trip: most business travel is round-trip, and one-way entries are the most common understatement in self-kept logs.
  • If you drive one vehicle for everything, never estimate the business percentage at year-end — the per-trip log is what replaces the estimate.

Keep mileage inside the same workbook as your income and expenses

The $29 Freelancer Income and Expense Template includes mileage tracking alongside payments, expenses, and a quarterly tax estimate in Excel and Google Sheets — one workbook holds the whole freelance record. Pair it with the year-end checklist so the log, the totals, and the return all agree before filing season starts.

Frequently asked questions

Can I use an app instead of a spreadsheet log?

Yes — what matters is the content of the record (date, destination, purpose, miles, recorded promptly), not the tool that holds it. Many people run both: an app or notebook in the car for the same-day entry, and the spreadsheet as the permanent, totaled record that feeds the return.

What if I forgot to log some trips?

Reconstruct promptly from objective records — calendar appointments, client invoices, receipts, and odometer history — and note that the entries were reconstructed. A log rebuilt the same month from real records is far stronger than one invented at filing time, and inventing trips that did not happen is never an option.

Is driving to a client's site from home deductible mileage?

It depends on where your regular workplace is — trips from a home office that is your principal place of business to a client are generally business trips, while home-to-regular-office driving is commuting. This page is educational information, not tax advice; because the home-office facts drive the answer, it is a question worth putting to your tax preparer once, in writing.

Before you go

1 — Your first win (10 minutes): the Free Month-End Close Checklist — page one of the 18-step close, printable, free.

2 — Do it with the workbook: find your trade's template — every workbook runs this same clean-close ritual, with example data and a guided first step inside.

3 — Keep the rhythm: one practical numbers email a week — Know Your Numbers, free to subscribe.

The way back: start any visit at the Start Here hub, or email a human — [email protected]. I answer.

Know your numbers. — Max

Gear we use

Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you.

Every Airbnb Host's Tax Guide, 7th Edition — Stephen Fishman (Nolo) — taxes for short-term rental hosts, from 14-day rules to depreciation.

HP 12C Platinum Financial Calculator — for loan and lease math in RPN: the Platinum edition of the classic 12C.

Adams Weekly Time Cards, 100-Pack (9616ABF) — weekly time cards for shops still running a time clock.

3M Adjustable Keyboard Tray AKT80LE — an under-desk keyboard tray with gel wrist rest for long entry sessions.

More books and gear live on the Resources page.