The Rental Property Mileage Log in Excel That Survives an Audit

You drove to your rental four times last month. A showing, a leaky faucet, a supply run for the leaky faucet, and a drive-by after a storm. Every one of those trips is a business deduction. And unless you wrote them down at the time, none of them count. A rental property mileage log in Excel is not busywork. It is the difference between a deduction the IRS pays out and one it disallows on the spot, because vehicle expenses are one of the few write-offs where "I obviously drove there" is not good enough.

Most landlords fall into one of two traps. They skip the mileage deduction because it feels small and fiddly, or they claim a round number at tax time with no record behind it. Both are expensive. The first leaves real money on the table. The second hands an auditor an easy win. This is how to build a rental property mileage log Excel template that captures every trip, applies the right rate, and holds up when someone asks you to prove it.

Why Mileage Is the One Deduction You Legally Cannot Reconstruct

Here is the part nobody tells you. For most business expenses, if you lose a receipt, a court can still let you estimate the deduction under what is called the Cohan rule. Vehicle expenses are carved out of that mercy. Under Section 274(d) of the tax code, car and truck expenses require strict substantiation. No log, no deduction, even when it is obvious you made the drive. A judge cannot round in your favor. This is why the mileage deduction is the single most common thing landlords lose in an audit, and it is entirely preventable.

The standard mileage rate for 2026 is 70 cents per mile. That number does the heavy lifting, but only against miles you can document with a date, a destination, a business purpose, and the distance. Skip the log and the rate is worthless, because you have nothing to multiply it by that survives scrutiny.

Now the cost of skipping it. Take Dana, who self-manages three units about 15 miles from her house. She never logs anything. Here is what a full year of her driving actually looks like once you count it:

At 70 cents per mile, that is a $1,729 deduction Dana never claims. At a 24% marginal federal rate, she overpays about $415 in tax every year, before state tax. Hold the properties ten years and she has handed the IRS roughly $4,150 for the sole reason that she never opened a spreadsheet. The deduction was always there. She just could not prove it.

The Columns That Turn Miles Into a Deduction the IRS Accepts

A mileage log is not complicated, but it fails on the columns people leave out. The IRS wants four things for every trip: the date, where you went, why (the business purpose), and how far. Build the sheet so those four are non-negotiable and the math takes care of itself.

Put your rate in one place so it is easy to update each year. In a Setup area, cell B1 holds 0.70, and you name that cell Rate so every formula reads clean. Then lay out a Log sheet like this:

Column E and F are formulas, not typing. In E2, you decide whether the trip even qualifies:

=IF(C2="","CHECK",IF(OR(C2="Improvement",C2="Personal"),"No","Yes"))

That formula does one job in plain business terms. If you forgot to write down why you drove, it screams CHECK so you fix it before tax season. If the trip was a capital improvement or a personal errand, it marks it No, because those miles are not a current deduction. Everything else is a Yes. Then F2 applies the rate only to the qualifying trips:

=IF(E2="Yes",D2*Rate,0)

Your annual deductible mileage total is a single sum at the top of column F, or if you prefer to see it two ways, =SUMIF(E:E,"Yes",D:D)*Rate gives you the same number straight from the qualifying miles.

The One Column Landlords Always Forget

The purpose column is what makes the log contemporaneous evidence instead of a list of numbers. "Maple St, 30 miles" proves nothing. "Maple St, turnover inspection between tenants, 30 miles" is a business record. An auditor reading your log should be able to tell, line by line, that you were managing a rental and not driving to your kid's soccer game. Make the purpose specific. "Repair," "Showing," "Rent pickup," "Inspection," "Supply run for unit 2." Vague logs get thrown out. Specific logs get paid.

Separating Deductible Trips From Capital Trips

This is where landlords quietly overstate and set themselves up for trouble. A trip to fix a running toilet is deductible mileage this year. A trip to oversee a new roof or a kitchen remodel is not. Improvement-related travel gets capitalized into the property's cost basis and recovered through depreciation over years, not deducted as mileage now. That is why the "Improvement" purpose returns No in the formula above. To keep the two buckets honest, run a quick tally:

=SUMIFS(D:D,C:C,"Improvement")

That tells you how many improvement miles you drove, so if you ever want to add them to a capital project's basis you have the number ready. It also stops you from accidentally sweeping them into your deductible pile, which is exactly the kind of overreach that turns a routine review into a full audit.

Standard Mileage vs Actual Expenses: Which Column Set to Build

There are two ways to deduct vehicle costs, and you should pick before you build, because they need different tracking. The standard mileage method multiplies your business miles by the IRS rate and ignores what the car actually cost you. The actual expense method adds up gas, insurance, maintenance, registration, and depreciation, then deducts the business-use percentage of that total. Here is the same landlord, same 2,470 business miles, run both ways:

Standard wins here by $282, and it wins for most landlords for a simple reason. Unless you drive an expensive vehicle and put serious business miles on it, the flat rate usually beats a small business-use slice of your real costs, and it needs a fraction of the recordkeeping. You track miles, not every gas receipt.

The business-use percentage is the pivot for the actual method, so if you go that route your log needs a total-miles-driven figure too:

=SUMIF(E:E,"Yes",D:D)/TotalMilesDriven

One rule locks this decision. If you want the option to switch methods later, you must choose the standard mileage rate in the first year the vehicle is available for your rental activity. Start with actual expenses and heavy depreciation, and you can be stuck with actual for that car for as long as you own it. For a leased vehicle, picking standard in year one means standard for the whole lease. When in doubt, most landlords are better served starting with standard mileage and a clean log.

Making the Log Contemporaneous, Where Most Logs Actually Fail

The word that decides audits is "contemporaneous." The IRS wants a record kept at or near the time of the trip, not a heroic reconstruction the night before your return is due. A spreadsheet you update the same week, with real dates in order, reads as contemporaneous. A file where all 102 rows share the same "last modified" date and the miles are suspiciously round does not. Build two habits into the sheet so it stays credible.

First, catch your own gaps before an auditor does. Count the rows where you forgot the purpose:

=COUNTIF(E:E,"CHECK")

If that returns anything above zero in December, you have homework, and you have it while you can still remember the trips. Second, watch each property separately so the totals make sense. A single unit racking up 1,800 miles when it is ten minutes away is a red flag you want to find first:

=SUMIFS(F:F,B:B,"Maple St")

Run that per property and the numbers should track reality. Here is what a clean monthly slice looks like once the habits are in place:

Notice the roof trip on the 22nd sits in the log with a No and a zero. You did not delete it, because the drive still happened and its miles may belong on the property's basis. You just did not let it inflate your current deduction. That kind of discipline is what separates a log that wins from a log that invites a second look.

Turn the Log Into a Number You Actually Claim

Landlords do not lose the mileage deduction because they do not drive. They lose it because the driving never becomes a record. Build the four columns that matter, let the formulas separate deductible trips from capital ones, pick the standard rate in year one, and update the sheet the same week you make the trip. Do that and a $1,700 deduction stops being a rounding error you skip and becomes a documented line that lowers your tax bill and survives an audit at the same time.

If you would rather not wire up the rate cell, the deductible flags, and the per-property tallies from scratch, the SheetCraft Rental Property Analyzer has the mileage log built in, already linked to each property and rolled up into the same workbook that tracks your rent, expenses, and cash flow. Log the trip, and the deduction lands in the right place with the audit trail attached. Your miles are already money. This is how you keep them.