2026 Mileage Tracker Spreadsheet for Excel and Google Sheets with Printable Logs
Track business trips and prepare a mileage summary for your tax preparer. This 2026 mileage tracker includes an Excel/Google Sheets spreadsheet and 21-page printable logs. For 2027, enter the published rates yourself when available.
SPREADSHEET (Google Sheets & Excel)
• Trip log: date, vehicle, purpose, business reason, from/to, odometer OR trip miles, round-trip option
• IRS standard mileage rates built in and editable — including both 2026 business rates (72.5¢ Jan–Jun, 76¢ from Jul 1) plus medical, charity and military-moving rates. The rate is picked from each trip's date
• 2027-ready: type in the 2027 rates when the IRS announces them; 2027 trips show "Rate not set" until you do
• Business expense tracker with business-use %, receipt check and categories
• Summary: miles & deduction by purpose, business-use % per vehicle, expenses by category, monthly chart, estimated total
• 2 colors: Teal & Coral, Charcoal & Amber
PRINTABLE LOG (21 pages, US Letter + A4, 2 colors)
How to keep a solid log + rate reference · vehicle & odometer record · 12 monthly trip logs · yearly summary · expense log · deduction summary
Works in Google Sheets (free) and Excel; it also calculated correctly when tested in LibreOffice. Rate sources (IRS notices) are listed on the Rates & Settings tab.
LICENSE
For your personal or single-business use. Please don't resell, share or redistribute the files.
Not tax advice — confirm your deductions with a tax professional or irs.gov. Digital download, nothing ships.
DOWNLOAD ACCESS
You'll receive a download link after purchase. Extract any ZIP folders before opening the files.
Designed by The Tidy Blueprint with the help of AI tools.