Home › Excel Programs › Mileage Log

IRS Mileage Log & Tax Deduction Tracker

Track every business, medical, and charity mile with correct 2026 IRS rates. Multiple vehicles, odometer tracking, standard vs. actual expense comparison, employer reimbursement reports, and Schedule C / Form 4562-ready Excel export. All data stays in your browser.

2026 IRS Rates (Split-Year)
72.5¢/mi Jan–Jun, 76¢/mi Jul–Dec. Medical 20.5¢/23.5¢. Charity 14¢. Date-based lookup — each trip gets the correct rate automatically.
Multiple Vehicles
Track year-start and year-end odometer readings per vehicle. Business-use percentage calculated automatically for Form 4562 Part V.
Standard vs. Actual
Enter actual expenses (gas, repairs, insurance, depreciation) and see which deduction method saves you more. First-year rule guidance included.
7-Sheet Excel Export
Rates, Vehicles, Trip Log, Expenses, Summary (SUMIF formulas), Reimbursement Report (signature lines), and IRS Pub 463 log format. All with live formulas.
Reimbursement Reports
Generate employer mileage reimbursement reports by date range with trips, miles, rate, amount, parking, tolls, and signature lines.
CSV Import
Import trips from a mileage-tracking app export or any spreadsheet. Automatic column mapping with manual override. Switch apps without losing miles.

Loading...

Frequently Asked Questions

What are the 2026 IRS standard mileage rates?

Business: 72.5¢/mi (Jan 1 – Jun 30) and 76¢/mi (Jul 1 – Dec 31), per IRS Notice 2026-10 and Announcement 2026-11. Medical/moving: 20.5¢ (H1) / 23.5¢ (H2). Charity: 14¢ all year (set by statute). Prior years: 2025 = 70¢/21¢/14¢; 2024 = 67¢/21¢/14¢.

What records does the IRS require for mileage deductions?

Per IRS Pub 463 Ch. 5, you need a contemporaneous log with: date, destination/place, business purpose, miles driven, and odometer readings at least at start and end of each year. Parking and tolls are recorded separately. This program captures all required fields.

Standard mileage rate vs. actual expenses: which is better?

It depends on your situation. Standard mileage is simpler and better for high-mileage, low-cost vehicles. Actual expenses (gas + repairs + insurance + depreciation x business-use %) may be better for expensive vehicles with high costs. Important: choosing actual expenses in Year 1 generally locks you into that method for the vehicle's life. The Expenses tab compares both side by side.

Where do I enter mileage on my tax return?

Self-employed: Schedule C, Line 9 (Car and truck expenses). If you claim depreciation, also complete Form 4562 Part V. The Reports tab generates both summaries with the correct line numbers and vehicle information.

Can I import trips from another mileage app?

Yes (Pro feature). Export a CSV from your mileage-tracking app or any spreadsheet with date and miles columns. The import wizard maps common column names automatically, and you can adjust the mapping by hand.

What is included in the Excel export?

7 sheets: Rates (IRS rate table), Vehicles (odometer, business-use %), Trip Log (all trips with Miles x Rate deduction formulas), Expenses (actual costs), Summary (SUMIF by category and month), Reimbursement Report (business trips with signature lines), and IRS Mileage Log (Pub 463 format). All formulas are live — change a number and totals recalculate.

Are parking fees and tolls deductible?

Yes. Parking fees and tolls related to business travel are deductible separately under both the standard mileage rate and actual expense methods. They are tracked per trip and included in your Schedule C deduction total.