Templates/Vehicle Mileage Log Template
Tax

Vehicle Mileage Log Template

IRS-compliant mileage log for tax deductions.

What's Included:

  • IRS-compliant fields including date, destination, purpose, and odometer readings
  • Business vs. personal trip toggle with automatic mileage categorization
  • Current-year IRS standard mileage rate applied to all business trips
  • Monthly and annual mileage summaries with business-use percentage

Available Formats:

ExcelGoogle SheetsPDF

Download Free Template

Enter your email to download this template instantly. We'll also send you tips on financial management.

By downloading, you agree to receive occasional emails from FiscalInsights. Unsubscribe anytime.

Vehicle mileage is one of the largest overlooked deductions for business owners who drive regularly. The IRS requires a contemporaneous log—meaning you must record trips at or near the time they occur, not reconstruct them months later. This template makes logging quick so you stay compliant without effort.

The business-use percentage calculation is critical if you use the same vehicle for personal and business driving. The template tracks both and calculates the percentage automatically, which you need for either the standard mileage deduction or the actual expense method.

How to Use This Template

1

Log Each Trip

Before each business trip, note your starting odometer reading. At arrival, record the ending reading, destination, and business purpose.

2

Categorize Business vs. Personal

Toggle each trip as business or personal. The template calculates your business-use percentage based on total miles driven.

3

Export Annual Summary

At year-end, export the summary showing total business miles, IRS rate applied, and your total mileage deduction for Schedule C or Form 2106.

Frequently Asked Questions

What qualifies as a deductible business trip for mileage?

Trips between your office and client locations, bank visits, supply store runs, and travel to business meetings all qualify. Your daily commute from home to a regular office does not. If you work from a home office, all business-related trips from home qualify.

What is the current IRS standard mileage rate?

The rate changes annually—check IRS.gov for the current year. This template is updated with the latest rate and applies it automatically to all logged business miles to calculate your deduction.

Tired of manual spreadsheets?

FiscalInsights automates everything this template does—plus cash flow forecasting, expense categorization, and real-time insights.

Try FiscalInsights Free