SPREADSHEET GUIDE · TAXES AND EXPENSES

A mileage log that holds up at tax time.

Business miles add up quickly, but only if you can show where you went and why. Log each trip when it happens and let the spreadsheet total the miles and the deduction.

What to record for each trip

Date of the trip.
Starting point and destination.
Business purpose, in a few specific words.
Miles driven, from odometer readings or a map.
A rate cell for the current IRS standard mileage rate, so the total updates when the rate changes.

The IRS asks for timely records of mileage, dates, places and business purpose. Its standard mileage rate changes each year; look it up on irs.gov.

Example request to start with

“Create an Excel mileage log with date, start, destination, business purpose, odometer start and end, miles calculated automatically, a cell for the IRS rate, a monthly summary and a yearly total.”

This is a record-keeping aid, not tax advice. Ask a tax professional how the deduction applies to you.

Create a mileage log ↗

Need something different?

Describe your goal in plain language. The builder can ask follow-up questions instead of making up missing information. You can review an excerpt before choosing a paid download.

Try the free document finder · Browse all templates · View pricing