Mileage log template: the columns
| Column | What goes in it | Required? |
|---|---|---|
| Date | Day of the trip | Yes |
| Start | Where the trip began | Strongly recommended |
| Destination | Business destination | Yes |
| Purpose | Client, job, delivery or reason for the trip | Yes |
| Odometer start | Reading when you set off | Optional |
| Odometer end | Reading when you arrive | Optional |
| Miles | Distance driven | Yes |
| Category | Business, personal, medical, charity or moving | Recommended |
| Vehicle | Which car, if you have more than one | If more than one car |
| Parking and tolls | Business parking and toll costs | Recommended |
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 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
| Date | Start | Destination | Purpose | Miles | Category | Parking/tolls |
|---|---|---|---|---|---|---|
| Mon 3 | Home office | Harbor Dental | Install network printer | 11.2 | Business | 4.00 |
| Mon 3 | Harbor Dental | Office supply store | Buy cables for job | 3.6 | Business | |
| Mon 3 | Office supply store | Home office | Return | 8.9 | Business | |
| Wed 5 | Home | Grocery store | Errand | 4.1 | Personal | |
| Thu 6 | Home office | Lee & Co | Quarterly maintenance | 22.5 | Business | 6.50 |
| Thu 6 | Lee & Co | Home office | Return | 22.5 | Business | |
| Sat 8 | Home | Food bank | Volunteer delivery | 7.0 | Charity |
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.
| What | Where | Formula |
|---|---|---|
| Miles from odometer readings | G2, then fill down | =IF(F2="","",F2-E2) |
| Total business miles | Summary cell | =SUMIF(H:H,"Business",G:G) |
| Total personal miles | Summary 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 tolls | Summary 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:
- Start a fresh page each month and write the month at the top.
- Fill in the row before you drive off, or the same day.
- Write the odometer reading on the first page of January and the last page of December.
- Total each page at the bottom so the year-end sum is quick.
- Clip parking and toll receipts to the page for that month.
Year-end summary block
| Line | Example |
|---|---|
| Odometer at start of year | 41,250 |
| Odometer at end of year | 56,880 |
| Total miles | 15,630 |
| Business miles | 9,140 |
| Commuting miles | 1,980 |
| Other personal, medical, charity miles | 4,510 |
| Business-use percentage | 9,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.
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 PlayiPhone version coming soon
More guides
- IRS Mileage Log Requirements: What Each Trip Must ShowWhat the IRS expects in a mileage log: date, destination, purpose and miles for each trip, plus total miles for the year, timely records and how long to keep them.
- How to Track Mileage for Taxes, Step by StepHow to track mileage for taxes as a freelancer or gig driver: what to record per trip, paper vs spreadsheet vs app, gig platform mileage, and fixing a missed log.
- Is Commuting Mileage Deductible? Rules for the Self-EmployedDriving between home and a regular workplace is personal under IRS rules, even if self-employed. Exceptions: a home office, temporary work sites and trips between jobs.
- Standard Mileage vs Actual Expenses: How to ChooseCompare the standard mileage rate and the actual expense method with worked examples, the first-year rule, switching limits, leases and what you can add to each.
Published by Zoranta, the developer of DriveLedger.