ZorantaGuides
DriveLedger

DriveLedger › Guides

Mileage Log Template for Taxes: Columns, Formulas, Example

A usable mileage log template needs one row per trip with the date, start point, destination, business purpose, miles and category, plus a place for the odometer reading at the start and end of the year. Those columns cover what IRS Publication 463 asks a car log to show.

Below is the layout, a filled-in example, the formulas for Excel or Google Sheets, and a summary block for the end of the year.

A car dashboard with an odometer and an open highway ahead

Mileage log template: the columns

ColumnWhat goes in itRequired?
DateDay of the tripYes
StartWhere the trip beganStrongly recommended
DestinationBusiness destinationYes
PurposeClient, job, delivery or reason for the tripYes
Odometer startReading when you set offOptional
Odometer endReading when you arriveOptional
MilesDistance drivenYes
CategoryBusiness, personal, medical, charity or movingRecommended
VehicleWhich car, if you have more than oneIf more than one car
Parking and tollsBusiness parking and toll costsRecommended

The IRS does not require odometer readings for every trip; it asks for the miles. Readings per trip are still a handy way to get the miles right. The readings that matter most are the first and last of the tax year, because they give total miles and the business-use percentage.

DriveLedger

DriveLedger keeps the same fields as this template for every trip and adds them up into monthly summaries and category charts on your phone. Get it on Google Play

Example: one week filled in

DateStartDestinationPurposeMilesCategoryParking/tolls
Mon 3Home officeHarbor DentalInstall network printer11.2Business4.00
Mon 3Harbor DentalOffice supply storeBuy cables for job3.6Business
Mon 3Office supply storeHome officeReturn8.9Business
Wed 5HomeGrocery storeErrand4.1Personal
Thu 6Home officeLee & CoQuarterly maintenance22.5Business6.50
Thu 6Lee & CoHome officeReturn22.5Business
Sat 8HomeFood bankVolunteer delivery7.0Charity

Business miles that week: 11.2 + 3.6 + 8.9 + 22.5 + 22.5 = 68.7. The return trips are business here because the person works from a qualifying home office. Without one, the first and last legs of the day would usually be commuting; see is commuting mileage deductible.

Mileage log template for Excel and Google Sheets

Put the headers in row 1 in this order: A Date, B Start, C Destination, D Purpose, E Odometer start, F Odometer end, G Miles, H Category, I Vehicle, J Parking/tolls. Then add these formulas. They work the same way in Excel and Google Sheets.

WhatWhereFormula
Miles from odometer readingsG2, then fill down=IF(F2="","",F2-E2)
Total business milesSummary cell=SUMIF(H:H,"Business",G:G)
Total personal milesSummary cell=SUMIF(H:H,"Personal",G:G)
Business miles for one month (dates in column A)Summary cell=SUMIFS(G:G,H:H,"Business",A:A,">="&DATE(Y,M,1),A:A,"<"&EDATE(DATE(Y,M,1),1))
Business parking and tollsSummary cell=SUMIF(H:H,"Business",J:J)

In the monthly formula, replace Y and M with the year and month, or point them at cells that hold them. Use data validation (a dropdown list) on the Category column so "Business" is always spelled the same way; a typo drops that row out of the SUMIF total.

Estimated deduction

Add a cell with the IRS business rate for your tax year and multiply it by total business miles. Take the rate from the IRS standard mileage rates page. If the IRS changes the rate during a year, split the total into the miles before and after the change date and use the matching rate for each.

Printable mileage log

If you prefer paper in the glovebox, print the template in landscape with about 25 rows per page, and keep the same columns. A few habits make a paper log hold up:

Year-end summary block

LineExample
Odometer at start of year41,250
Odometer at end of year56,880
Total miles15,630
Business miles9,140
Commuting miles1,980
Other personal, medical, charity miles4,510
Business-use percentage9,140 ÷ 15,630 = 58.5%
Business parking and tolls$612.50

These lines match what Schedule C asks about your vehicle: business, commuting and other miles. The full list of what a log must show is in IRS mileage log requirements.

General information only, not tax advice. Check IRS Publication 463 or a tax professional for how the rules apply to you.
DriveLedger

Skip the spreadsheet formulas

DriveLedger records each trip with date, start, destination, distance, purpose and vehicle, and favorite routes fill a repeat trip with one tap.

Get it on Google Play

iPhone version coming soon

More guides

All guides

Sources

Published by Zoranta, the developer of DriveLedger.