Free Mileage & Vehicle Expense Log (Excel)

Vehicle use for business is one of the most commonly claimed — and most commonly under-documented — deductions. This free log tracks every business trip with date, purpose, and mileage, and calculates your deduction automatically using the standard mileage rate.

Download Free — XLSX See the Full Library

No email required · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Self-employed individuals and small business owners who drive for business
Sales reps and consultants regularly visiting clients
Anyone who has estimated mileage at tax time instead of tracking it
Businesses wanting clean documentation to support a vehicle deduction

What's included

Trip log with date, purpose, and miles driven
Automatic deduction calculation at the standard mileage rate
Space to note the current year’s applicable rate
Built-in AI prompt to review for gaps in your documentation

Why use a template instead of starting from scratch?

Estimating annual business mileage from memory at tax time is exactly the kind of number that doesn’t hold up well if ever questioned — and it usually understates the real deduction, since forgotten trips add up. A contemporaneous log, kept trip by trip, gives you both an accurate number and solid documentation.

How to Use This Template

Download and open in Excel or Google Sheets

Works identically in either — no macros or add-ins needed.

Log each business trip as it happens

Date, purpose, and starting/ending odometer or total miles for that trip.

Set the current year’s standard mileage rate

This rate changes periodically — confirm the current year’s rate before relying on the calculation.

Review the automatic deduction calculation

This multiplies your logged business miles by the applicable rate.

Run the built-in AI prompt to check for gaps

Attach the saved file to ChatGPT or Claude and ask if your log looks complete enough to support the deduction if questioned.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on whether your mileage log looks complete and well-documented enough to support the deduction if it were ever questioned, no accounting background required.

Common Mistakes to Avoid

Estimating mileage after the fact instead of logging trips

A reconstructed, estimated log is far weaker documentation than one kept trip by trip — log it as you drive.

Not recording the business purpose of each trip

Purpose is part of what makes a trip a legitimate business deduction — always note it, not just the mileage.

Using an outdated mileage rate

The standard mileage rate changes, sometimes even mid-year — confirm the current applicable rate rather than assuming last year’s figure still applies.

Mixing personal and business mileage without separating them

Only the business portion of mileage is deductible — commuting from home to a regular workplace generally doesn’t count, for example, so be precise about what qualifies.

Frequently Asked Questions

What counts as deductible business mileage?

Generally, trips for business purposes beyond your regular commute — client visits, business errands, travel between work sites. Regular commuting from home to a fixed workplace typically doesn’t qualify — check current IRS rules for specifics.

What is the standard mileage rate?

It’s a per-mile rate the IRS sets, updated periodically (sometimes mid-year), that you can use to calculate a vehicle deduction instead of tracking actual vehicle expenses — check the current year’s rate before relying on any calculation.

Should I use the standard mileage rate or track actual expenses?

This is a choice with real tradeoffs depending on your specific vehicle costs and usage — a tax professional can help you determine which method results in a larger, defensible deduction for your situation.

Is this template really free?

Yes, completely free, no email required. iLuvAccounting also has a Canada-specific Kilometre & Vehicle Expense Log if you’re calculating a Canadian deduction.

What documentation do I need to support a mileage deduction?

A contemporaneous log with date, business purpose, and miles for each trip is generally what’s expected — an estimate reconstructed at year-end is much weaker if ever questioned.

Can I switch between the standard mileage rate and actual expense method?

There are specific IRS rules about switching methods between years — check current guidance or consult a tax professional before changing your approach.

Does this log work for multiple vehicles?

Yes — just note which vehicle each trip was made in if you use more than one for business purposes.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club