The Free Mileage Log Template, No Signup Required

What's in the free file

The free template is three sheets, built to have you logging a real drive within about five minutes:

• Start Here. A short setup guide, a Settings block for your currency symbol, your rate per mile/km, and your distance unit (mi or km), and a plain-language rundown of what the paid Real Estate Agent Commission & Expense Tracker adds if you outgrow this one.
• Mileage Log. 200 pre-formatted rows -- Date, Purpose (a dropdown: Client visit, Showing, Meeting, Errand, or Other -- editable via the reference list next to it), From, To, and Distance. Reimbursement is a sixth column that calculates itself from Distance times your rate. Six example rows show the pattern before you type your own.
• Summary. Four live tiles -- total distance, total reimbursement, this-month distance, and this-month reimbursement, keyed off today's date. Below that, a "By purpose" table totals distance and reimbursement for each of the five purposes, so you can see at a glance where most of your driving goes.

That's genuinely everything -- no hidden fourth tab, no locked cells waiting for a paid unlock. One thing it deliberately doesn't have: odometer start/end reading columns. That's a design choice, not an oversight -- see "what a defensible log usually needs" below.

How to use it in Excel

1. Download the file and open it in Excel.
2. On Start Here, set your currency symbol, your rate per mile/km, and your distance unit if the defaults don't match your situation.
3. On the Mileage Log tab, replace the six example rows with your own, or keep them as a reference and add rows underneath.
4. For each drive, pick a purpose from the dropdown, then fill in the date, From, To, and Distance.
5. Check the Summary tab any time -- total distance, total reimbursement, this month's numbers, and the by-purpose breakdown all recalculate automatically.

How to use it in Google Sheets

The file isn't a native Google Sheet, but importing it takes under a minute:

1. Open Google Sheets and go to File > Import.
2. Choose Upload and select the .xlsx file you downloaded.
3. Choose Insert new sheet(s) (or "Create new spreadsheet") and confirm.
4. All three tabs come in together, with the Purpose dropdown and every formula intact -- nothing needs rebuilding.
5. From there, the Google Sheets phone app is the real payoff: log a drive in a few taps right after you make it, instead of reconstructing a week of driving from memory later.

What a defensible mileage log usually needs

Regardless of what you're logging mileage for, a log that holds up tends to have the same handful of fields: the date of the drive, its purpose, from and to, and the distance covered. That's exactly what this template asks for, in that order, on every row.

What it deliberately does not do is tell you what rate to use. Mileage rates and rules vary by country, by employer or brokerage, and by tax year -- this template has no idea which of those apply to you, so it doesn't guess. You look up (or already know) the rate that applies to your situation, type it into the Rate per mile/km setting once, and every row and every Summary tile uses it from then on. If you're not sure what rate applies to you, that's a question for whoever sets your reimbursement policy or your tax advisor, not for a spreadsheet.

The same logic is why there are no odometer start/end columns here. Some situations call for them -- if yours does, insert two extra columns and carry the running total yourself. For most people, From/To plus a Distance figure is enough detail without turning every drive into a two-minute data-entry chore.

What the free version leaves out

This is meant to be honest, not a teaser with the good parts hidden: the free template is a genuinely smaller product, not a crippled version of a bigger one. Specifically, it leaves out:

• A Dashboard with a chart. The paid Mileage & Net Profit Tracker workbook has its own Dashboard tab with live tiles for Total Miles/KM Logged and Total Mileage Deduction, plus a bar chart.
• A Net Profit Summary. The paid workbook combines your mileage deduction with totals from its two sibling workbooks -- a Commission Log and a Business Expense Tracker -- into one Net Profit figure with negative-red conditional formatting.
• Start/End Location fields built for real estate work. The paid Mileage Log is a 150-row log with separate Start Location and End Location columns and a Purpose/Client field, purpose-built around showings and closings, rather than this free version's generic 5-option purpose list.
• Two sibling workbooks. The full Real Estate Agent Commission & Expense Tracker on Etsy is three workbooks -- Commission Log, Business Expense Tracker, and Mileage & Net Profit Tracker -- so mileage sits alongside commission and expense tracking instead of standing alone.

If you're a real estate agent, the guide to mileage tracking for real estate agents covers why a consistent log matters, and real estate agent expense categories covers the broader expense side. Not an agent? The free income & expense tracker is the same "genuinely free, no signup" idea built around a flat transaction log instead.

Need something built around your exact numbers instead?

Neither this free log nor the paid tracker fits every situation -- both are built around a generic set of fields. If your mileage tracking needs to plug into something specific (a particular reimbursement policy, a multi-vehicle fleet, a category structure unique to your business), the custom spreadsheet service builds a workbook around your actual numbers instead of asking you to adapt to a template.