How I Track Mileage and Travel Costs for Property Visits

Last year I put just over 6,200 kilometers on my work van driving between my 9 rental properties, and when tax season came around I was able to deduct roughly 186,000 yen in vehicle-related expenses because every single trip was logged. Before I started tracking mileage seriously about seven years ago, I left that money on the table every year simply because I could not prove where I had driven or why.

If you self-manage even two or three properties, travel costs pile up faster than most landlords expect. Between inspections, tenant move-outs, hardware store runs, and the occasional emergency repair, I average around 15 property-related drives a month, and each one is a small deduction I would otherwise lose.

Why I Bother Tracking Every Trip

Fuel is the obvious cost, but it is not the biggest one. Between fuel, oil changes, tires, and depreciation on the van, I calculate my actual per-kilometer cost at about 38 yen. Multiply that by 6,200 km and you get real money, not pocket change. On top of that, a clean mileage log is the single piece of paperwork a tax office reviewer asks for first if your vehicle expense claim looks unusually high, so keeping one protects me as much as it saves me.

The Log Book I Keep in Every Vehicle

I keep a small notebook clipped to the sun visor in the van, and a second one in my personal car for the times I use it to grab materials on the way home from my day job. Every entry takes maybe 20 seconds: date, starting odometer reading, ending odometer reading, property address or unit number, and a one-line reason for the trip. I do this the moment I park, never later that night from memory, because I have tried reconstructing a week of drives from memory before and gotten the distances wrong by 15 to 20 percent almost every time.

What Counts as a Deductible Trip and What Does Not

Not every drive near a rental property qualifies, and getting this wrong is an easy way to invite trouble. Here is roughly how I sort trips:

• Property inspections and scheduled maintenance visits u2014 always counted
• Trips to the hardware store or lumber yard for a specific repair job u2014 counted, with the receipt attached to the same log entry
• Meeting a tenant, contractor, or the management company on-site u2014 counted
• Driving past a property on the way to somewhere unrelated, with no stop u2014 not counted
• Any personal errand combined with a property stop u2014 only the incremental distance for the property portion is counted

That last rule trips people up. If I drive 12 km to a property and the grocery store I also wanted to visit is only 1 km further down the same road, I only claim the 12 km, not the full round trip with the detour folded in.

My Simple Spreadsheet System

Once a month, usually on the first Sunday, I transfer both notebooks into a spreadsheet with six columns: date, property, purpose, distance, calculated cost at 38 yen per km, and a receipt reference number if fuel or parking was involved. This takes about 25 minutes for a typical month of 15 trips. I keep three years of these spreadsheets in a single folder, because in Japan you generally need to retain the underlying records for that long in case of a tax inquiry. I do not use a fancy accounting package for this part u2014 a plain spreadsheet has survived every software change I have gone through in 15 years of doing this, while at least two paid apps I tried were discontinued within a couple of years.

Mistakes That Cost Me Money Early On

In my first two or three years as a landlord, I estimated mileage instead of logging it, rounding every property visit to a flat 10 km round trip because that felt close enough. When I finally cross-checked against actual odometer readings, I found I had been undercounting by close to 30 percent on my two furthest properties, which are each over 25 km from my house. That is real deducted expense I simply never claimed. I also used to forget to log short trips, the ones where I just swing by to check a mailbox or drop off a spare key, because they felt too minor to bother writing down. Over a year those short trips added up to nearly 40 forgotten entries.

The Checklist I Run Before Every Tax Season

By the time January comes around, I want the whole year already reconciled rather than scrambling through 12 months of notebooks at once. My pre-filing checklist looks like this:

• Confirm every monthly spreadsheet total matches the sum of notebook entries for that month
• Match fuel receipts to specific trips wherever a receipt exists
• Flag and review any single trip logged over 60 km, since those get the closest scrutiny
• Recalculate the year-end total at the current per-kilometer cost rate
• Print or save a digital backup of both notebooks alongside the spreadsheet

The whole process now takes under two hours for a full year across all 9 properties, compared to the better part of a weekend I used to lose trying to reconstruct everything from memory and scattered receipts. That is the approach I use across all of my properties, and it is one of the few pieces of landlord paperwork I actually look forward to doing each month.

同じカテゴリの記事を読む

8棟自主管理の経験から書いた関連記事 — まとめて読むと理解が深まります

▸ English

Choosing the Right Impact Socket Set for Property Work

▸ English

Kitchen2 Vol.11: Single-Handle Faucet Removal

▸ English

Replacing Cabinet Doors on Existing Frames

▸ Cost & Finance

How I Decide When Refinancing Is Actually Worth It

▸ English

Living Room Renovation Vol.11: Wall Patching & Repair

▸ English

Adding a Bench or Storage Seat to a Small Genkan