What's inside
- Log: up to 1,000 trips with date, type (Business, Medical, Charity, Personal), from, to, purpose, and odometer start and end or just the miles; each trip's rate, deduction and a check for missing or inconsistent entries
- Rates: IRS rates for 2024, 2025 and both 2026 periods from irs.gov, one row per change; add new rates when they're announced
- Summary: miles and deductions by month for business, medical and charity, personal miles, your business share of all driving, business miles by rate period, and a chart
- Sample file: a freelancer's 2026 with 66 trips: 2,122 business miles = $1,578.45
Checked, not just designed: all 4,180 formulas recalculate with zero errors, and every trip and total was checked against an independent calculation in 6 scenarios.
Works in Excel and Google Sheets. Not tax advice.
Try the free version first
The free online calculator uses the same model for a quick answer. The spreadsheet adds tracking, history and the full views.