Guide

Mileage Tracking for Real Estate Agents: The Log That Actually Works

Showings, listing appointments, closings, inspections, lockbox runs — an agent's day runs on driving. Every one of those miles that never gets logged is a deduction you paid the gas for and never claimed. Here's why agents lose miles, and what a log needs to actually catch them.

Mileage is one of the largest deductions available to a real estate agent, and it's also the one most commonly under-claimed. Not because agents don't drive enough to matter — the opposite. It's because driving happens constantly, all day, with no natural trigger that tells you to write it down. A client payment shows up as a bank deposit. A software subscription shows up as a card charge. A drive to a showing just... happens, and then you're already in the next thing.

That's the whole problem in one sentence: nothing forces the record to exist. Here's how to build a mileage log that actually keeps up with a busy week, instead of one that quietly falls behind until it's abandoned.

Why agents lose deductible miles

A few patterns account for most of the miles that never make it into a log:

  • No trigger moment. An invoice gets sent, so you remember to log it. A drive just ends — you get out of the car and move on to the next thing, and the moment to record it passes with nothing prompting you.
  • Short drives feel not worth logging. A quick run to check on a lockbox, a five-minute detour past a listing — individually tiny, and dismissed as too small to bother with. Over a year, these short drives add up to real miles.
  • Multi-stop days don't get broken apart. Three showings back to back gets remembered as "showings this afternoon" instead of three separate legs, and the log either captures one vague trip or none at all.
  • Reconstruction from memory or a calendar. A calendar shows a 2pm showing; it doesn't show the lockbox stop before it or the second showing added same-day. Rebuilding mileage at tax time from memory or a calendar systematically undercounts, because you only remember what stood out.
  • No single place to capture it. A notebook in the glovebox that runs out of pages, an app downloaded once and never opened again, a mental note that's gone by evening — mileage logging fails most often not because agents don't care, but because there's no one place it always goes.

None of this is about discipline. It's about friction. The fix isn't trying harder to remember — it's removing the friction between finishing a drive and having it recorded.

What a usable mileage log actually needs

A working log comes down to five things you enter per drive, plus one that calculates itself:

FieldWhy it matters
DateTies the drive to a specific day — needed to place it in the right reporting period.
Purpose / ClientThe field agents skip most, and the one that matters most. "Showing — 482 Maple Street" takes five seconds and makes the drive defensible. A blank purpose column is a list of numbers, not a mileage log.
Start locationWhere the drive began — office, home, a previous stop.
End locationWhere it ended. Start and end together are what a distance figure is actually measuring.
Miles drivenThe distance for that specific leg — not a daily or weekly estimate.
Deductible amountShould never be typed in by hand. It should calculate itself by multiplying miles driven by a rate you set once in one place, so updating the rate updates every row instead of leaving you to redo a year of arithmetic.

Notice what's not on that list: nothing here requires a specific rate, a specific tax form, or knowledge of what's deductible under your local rules. That's deliberate. A mileage log's job is to capture accurate facts about drives as they happen. Deciding what's deductible and at what rate is a separate question for a qualified tax professional who knows your jurisdiction — more on that below.

Start and end locations, or an odometer reading — pick one and stick to it

There are two legitimate ways to capture "how far":

  • Start and end locations with the distance for that route. Fast to log from a phone right after a drive, and it reads naturally later — you can look at a row and immediately picture the trip. Works well for the routine drives that make up most of an agent's week: showings, listing appointments, office-to-property.
  • Odometer readings at the start and end of a drive. Ties the number directly to the vehicle rather than to an estimated route distance, which some agents prefer for trips that mix business and personal stops, or when they want a harder paper trail than a place name provides.

Either is fine. What actually matters is not switching between the two partway through the year — a log with locations for six months and odometer readings for the other six is much harder to trust when you sit down to review it, because the two methods rarely reconcile to the exact same total.

The habit that keeps a log alive

The log itself is the easy part. Keeping it current is where most attempts fail, and it comes down to three habits:

  1. Log right after the drive, not "later." Do it before you start the next task — while you're still in the car, or the moment you're back at a desk. "Later" is where mileage logs go to die; by end of day you've had three more drives competing for the same five seconds of attention.
  2. One entry point. Phone, glovebox notebook, whatever you actually reach for — it doesn't matter which, as long as it's the same one every time. A log split across a notes app, a paper pad, and memory is really three incomplete logs, not one complete one.
  3. A five-minute weekly review. Pick a day — Friday afternoon works for a lot of agents — and scan the week for anything you know happened but didn't get logged. Caught within the week, you can usually still remember the purpose and route accurately. Caught three months later, you're guessing.

That's it. No app, spreadsheet, or system fixes a habit problem on its own — but a log that's easy to reach and takes five seconds per entry removes most of the friction that causes agents to fall behind in the first place.

What actually counts as business mileage

This is intentionally general, because the specifics vary by location and this isn't tax advice. As a broad concept: mileage driven for a business purpose during your work — showings, listing appointments, inspections, closings, trips to a supply or sign shop for a listing — is the kind of driving a mileage log exists to capture. Ordinary commuting, like a daily drive from home to a fixed primary office, is commonly treated differently from mileage driven for a specific business errand during the day, though the exact line depends on rules that vary by where you work and how your business is structured.

The practical takeaway: log every drive with an honest purpose, including the ones you're not sure about. It's far easier for a tax professional to exclude a drive that's clearly logged than for you to reconstruct one you left out because you weren't sure it counted at the time.

Common mistakes

  • Only logging "big" drives. A 3-mile lockbox run feels too small to matter. A year of them doesn't.
  • Leaving purpose blank "to fill in later." It almost never gets filled in later, and a mileage total without a purpose per row is much weaker if you ever need to explain it.
  • Mixing distance-capture methods mid-year. Pick locations-and-route-distance or odometer readings, and use the same one for every row.
  • Waiting for a slow week to catch up. There isn't one. A backlog just gets longer until the log gets abandoned.
  • Typing the deductible amount in by hand. Let a formula calculate it from miles and a rate you set once — hand-typed totals are where copy-paste errors and stale rates hide.

Spreadsheet or app?

Both can work. A dedicated mileage app with automatic drive detection is a genuine convenience for agents with very high drive volume, and it removes the "did I remember to log it" step almost entirely. A spreadsheet log has a different advantage: it sits next to the rest of your business records — your commission log and expense tracker — instead of living in a separate tool you have to export from every time you want the full financial picture. If you're already tracking commissions and expenses in a spreadsheet, keeping mileage in the same workbook means one place to check, not three. See our guide on real estate commission splits for the deal side of an agent's numbers, and if you're weighing 1099 versus salaried work in the first place, the contractor rate vs salary calculator covers that comparison.

What good looks like

A mileage log worth trusting has: an entry logged the same day as every drive, a purpose written in plain language, a consistent method for capturing distance, a deductible amount that calculates itself from a rate you control, and a five-minute weekly review that catches what slipped through. None of that requires special software — it requires a place that's easy to reach and a habit of using it before the next thing pulls your attention away.

Frequently asked questions

What information does a real estate agent's mileage log actually need?

Six things per drive: the date, the purpose or client it relates to, a start location, an end location, the miles driven, and a deductible amount that calculates itself from a rate you set once. The purpose field is the one agents skip most often, and it's the field that makes a log defensible later — it's the difference between a mileage log and a list of numbers.

Should I log start and end locations, or actual odometer readings?

Either is fine — what matters is picking one method and sticking to it. Start and end locations (with the miles a map gives you for that route) are faster to log on the go and work well for routine showings and listing appointments. Odometer readings tie the number directly to the vehicle and suit agents who mix personal and business stops in the same trip. Switching between the two mid-year is what makes a log hard to trust when you sit down to review it.

Is driving from home to my main office deductible mileage?

This is a general concept, not tax advice, and the answer depends on rules that vary by location: ordinary commuting between home and a regular place of work is typically treated differently from mileage driven for a specific business purpose during the day. Log every drive with an honest purpose and let a qualified tax professional decide what's deductible under your local rules — don't decide it yourself by leaving ambiguous drives out of the log.

How often should I log my mileage as an agent?

Immediately after each drive, or at the very worst by the end of that day. A showing you can describe in five seconds right after you get back in the car takes real effort to reconstruct a week later, and that effort is exactly what causes mileage logs to get abandoned. A five-minute weekly review to catch anything missed is a reasonable backstop — a once-a-year rebuild from memory is not.

Can I reconstruct my mileage at the end of the year from my calendar?

You can attempt it, but it will understate your actual mileage. A calendar shows you had a showing at 2pm; it doesn't show the detour to drop off a lockbox, the second showing added same-day, or the trip to check on a listing between appointments. Memory and calendars both skew toward the miles you'd remember, not the miles you actually drove — which is why logging as you go, not reconstructing later, is what protects the deduction.

Do I need a mileage-tracking app, or is a spreadsheet enough?

A spreadsheet is enough for logging drives you enter yourself, and it has the advantage of sitting next to your commission and expense records instead of in a separate app you have to export from at tax time. Automatic GPS-based mile detection is a genuine convenience some agents prefer, especially for very high drive volume — but it isn't required to keep an accurate, deduction-ready log.

Want the mileage log already built, next to your commissions and expenses?

The Real Estate Agent Commission & Expense Tracker includes a dedicated Mileage Log with the exact columns above — Date, Purpose/Client, Start Location, End Location, Miles Driven — and a Deductible Amount column that calculates itself from a rate you set once in Settings, so updating it for a new rate updates every row automatically. The Dashboard tab totals your miles and deduction, plus an optional Net Profit Summary where you type in totals from the bundled Commission Tracker and Business Expense Tracker workbooks to see net profit across all three in one place.

One-time purchase. No subscription. It's a set of spreadsheets — not tax software, and not tax advice.

Need a spreadsheet built around your exact business instead? We build custom workbooks to order — $99, delivered in 5 business days.