Mileage Log Template
IRS-compliant mileage log template for tracking business vehicle use.
What's Included:
- IRS-compliant format with date, destination, purpose, and odometer readings
- Automatic business miles calculation using starting and ending odometer
- Current-year IRS mileage rate applied to calculate deduction amount
- Monthly and annual mileage summaries with business-use percentage
Available Formats:
Download Free Template
Enter your email to download this template instantly. We'll also send you tips on financial management.
The IRS requires a contemporaneous written record of business mileage to claim the standard mileage deduction. That means logging each trip at or near the time it happens—not reconstructing your mileage at year-end. This template makes daily logging fast and painless while capturing every field the IRS requires.
Many small business owners significantly underestimate their deductible mileage simply because they do not track it consistently. At the current IRS rate, a consultant who drives 15,000 business miles per year saves over $10,000 in taxable income. The few seconds it takes to log each trip are well worth the tax savings.
How to Use This Template
Record Each Business Trip
Before and after each business trip, note the odometer reading. Enter the date, starting point, destination, business purpose, and both odometer readings.
Let the Template Calculate
The template automatically calculates miles driven, applies the current IRS rate, and computes your deduction. It also tracks your running total for the year.
Review Monthly Summary
Each month, check the summary tab to see total business miles, personal miles, and your business-use percentage. This is the number your accountant needs at tax time.
Frequently Asked Questions
What does the IRS require in a mileage log?
The IRS requires the date, destination, business purpose, and miles driven for each trip. Odometer readings at the start and end of the year are also required to calculate your business-use percentage. This template captures all required fields.
Can I use the standard mileage rate if I also claim actual vehicle expenses?
No—you must choose one method or the other for each vehicle. The standard mileage rate is simpler and often results in a higher deduction for vehicles with lower operating costs. This template calculates your deduction using the standard mileage rate.
Related Financial Resources
Tired of manual spreadsheets?
FiscalInsights automates everything this template does—plus cash flow forecasting, expense categorization, and real-time insights.
Try FiscalInsights Free