TallymileGet the appGet

TallymileGuides

Mileage log template: the columns to use and a filled-in example

A copy-ready mileage log template based on the IRS Publication 463 sample, a filled-in example week and tips for keeping it complete.

The template to copy

If you want a free mileage log template, you do not need a special form. The IRS does not issue one. Publication 463 includes a sample worksheet, the Daily Business Mileage and Expense Log, and marks it as not an official IRS form. Its columns are date, destination, business purpose, odometer start and stop, miles for the trip, and the type and amount of any expense, with a weekly total and a year-to-date total at the bottom.

You can rebuild that layout in any spreadsheet or on paper. Here is a version with one extra column for the starting place, which makes each row easier to understand a year later:

DateFromTo (city, town or area)Business purposeOdometer startOdometer endMilesTolls or parking
Weekly total

Add a final row for the year-to-date total. If your spreadsheet has a formula for the Miles column (end minus start), the total will stay correct when you edit a row.

A filled-in example week

The rows below are made up. They show the level of detail that is useful: a specific destination, a purpose that says what happened, and odometer readings that agree with the miles.

DateFromToBusiness purposeStartEndMilesTolls or parking
Mon 6 JulHome officeSmith Dental, Leeds RdInstall new booking software48,21048,22616Parking 4.00
Mon 6 JulSmith DentalOffice supply storeBuy printer toner for client site48,22648,2315
Tue 7 JulHome officeHarbor BakeryQuote for website redesign48,24048,25818Toll 3.50
Thu 9 JulHome officeBank, Main StDeposit client cheques48,30148,3043
Thu 9 JulBank, Main StHome officeReturn from bank48,30448,3073
Weekly total45Parking 4.00, toll 3.50

On the Monday, the first row ends at the client and the second starts there, so the odometer end of one row equals the odometer start of the next. A gap in the readings that you cannot explain is the first thing a reader of the log will question.

Publication 463 also says you can account for several uses of the car that form a single use, such as a round trip or uninterrupted business use, with a single record. If you prefer, the two bank rows above could be one round trip of 6 miles. Pick one habit and keep to it.

How to fill in each column

  • Date: the day you drove. With two rates in 2026 (72.5 cents before July 1 and 76 cents from July 1, per the IRS), the date decides which rate applies.
  • From and to: names a person can recognise, such as the client or the supplier, not just a street. The IRS sample asks for the city, town or area of the destination.
  • Business purpose: what you did, not the word work. Publication 463 says you generally need a written statement of business purpose, though the degree of proof varies and a clear purpose, such as a sales representative on an established route, can need no written explanation.
  • Odometer start and end: read the car's main odometer, not the trip meter. Take a photo at the first and last drive of the year so you can show the year's total miles.
  • Miles: end minus start. Do not round up to be safe; the IRS says you cannot deduct amounts you approximate or estimate.
  • Tolls and parking: write the amount and keep the receipt. Business tolls and parking are separate from the mileage rate, as the standard mileage rate guide explains.

Add the year totals your tax return needs

A self-employed filer who claims the standard mileage rate completes Part IV of Schedule C, which asks for information about the vehicle, including how the miles split between business, commuting and other use. The Schedule C instructions describe commuting as travel between your home and a work location in most cases, with exceptions for temporary work locations.

That is why the odometer columns matter even if the rate is applied to business miles only. With the reading on 1 January (or the date you started using the car for business) and the reading on 31 December, you know the total miles for the year. Your business miles come from the log; commuting and other personal miles are the rest. The commuting guide explains where the line falls.

Paper, spreadsheet or app

MethodStrengthWeakness
Paper log in the gloveboxCheap, nothing to chargeEasy to lose; you must write each trip at or near the time
SpreadsheetTotals by formula; easy to copy and back upTyping every trip, usually from memory at the end of the week
Mileage appRecords trips as you drive; exports the logDepends on permissions and signal, so entries need review

Publication 463 says you generally need a written record, and that a record prepared on a computer is considered adequate. What matters is that it is made at or near the time: the same publication says a log kept on a weekly basis that accounts for the week's use is a timely kept record, and that it has more value than a statement prepared later.

Where Tallymile fits, and where it does not

Tallymile is an iPhone app that fills in the rows for you. It detects drives in the background when you grant the location and motion permissions, or you can start a drive yourself or add a past trip by hand. Each drive keeps the date, start and end places, distance and purpose. You choose Business or Personal, can assign a vehicle, and export a PDF or CSV report for a period you choose, with tolls and parking recorded alongside the drives.

Limits to know: the report does not show an odometer start and stop for each trip, so if your log needs them, record your own readings and keep year-start and year-end photos. Automatic detection is not a guarantee that every trip is recorded, so review the log each week and add anything missing. The built-in rate calculations use miles and US dollars with the IRS table. Tallymile is a record-keeping tool, not tax advice.

Frequently asked questions

Is there an official IRS mileage log template?

No. The IRS does not issue a required form. Publication 463 shows a sample Daily Business Mileage and Expense Log that is marked as not an official IRS form, and you can use any record that holds the same information.

Can I use a spreadsheet instead of paper?

Yes. Publication 463 says a record prepared on a computer is considered an adequate record. Save a copy outside the device you use every day.

Do I need odometer readings for every trip?

The IRS sample has odometer start and stop columns, but what the rules require is that you can prove date, destination, purpose and miles. Odometer readings make the miles easy to check, and the year's start and end readings give your total miles.

How long do I keep the log?

Publication 463 says generally 3 years from the date you file the return that claims the deduction, and some situations need longer.

This guide is general information about record keeping, not tax advice. Rates and rules change and depend on your situation; check the linked official pages or ask a qualified tax professional before you file.

Sources and product details

Keep a log you can review

Tallymile combines automatic tracking with editable records. Review the first trips after setup and inspect exports before sharing.

Download on the App Store