Mileage Log Spreadsheet 2026, IRS Rate Tracker, Car Expense Tax Deduction, Mileage Tracker, Business Mileage Log, Excel Google Sheets

Mileage Log Spreadsheet 2026 for Microsoft Excel and Google Sheets, instant digital download. Track every business mile and car expense in one spreadsheet. The mileage deduction is calculated for you, with the 2026 IRS business rate (72.5 cents per mile) pre-filled and editable. ✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition. ★ WHAT'S INCLUDED ★ • Clickable Start Here cover page with quick-start steps and a color key • Dashboard: business miles, total deductible, actual car costs, business use %, better method, trips logged, this month's miles and deduction, average trip, car cost per mile, IRS rate today and records to fix (12 KPI tiles) • Dashboard standard-rate vs actual-expense comparison, action flags (missing trip details, maintenance overdue or due soon, missing odometers), top business purposes, recent trips and 6 charts • Mileage Log (2,000 trips): enter odometer start/end, OR the miles, OR pick a saved route, with a round-trip toggle, tolls and parking, client / project and a record check on every trip • IRS rate table on Setup: each trip uses the rate in effect on its date (2026 rates included: 72.5 cents Jan 1 to Jun 30, 76 cents from Jul 1). Business, medical and moving, and charity rates, all editable • Saved Routes (50): the trips you repeat, with times used, miles and deduction per route • Vehicles (10): miles driven from your odometer, business use %, standard deduction, actual costs, cost per mile, average MPG and the better method per car • Vehicle Expenses (1,000 rows): insurance, repairs, tires, registration, loan interest and more, with business share and a cost-by-category table • Fuel Log (500 fill-ups): automatic MPG, total cost, price per gallon and fuel cost per mile • Maintenance schedule (40 items): next due mileage and date with Overdue / Due soon alerts • Monthly Summary: miles by trip type, deduction, tolls and parking, fuel and other car costs every month, plus business miles by vehicle, with 2 charts • Mileage Calendar: a heat map of every day of the year plus miles by weekday chart • Trip Report: pick dates, vehicle, trip type or client for a printable reimbursement claim with a total to claim and signature lines • Tax Summary: total, business, commuting and other miles per vehicle, standard vs actual method, medical, moving and charity miles, and a record-keeping check • Setup tab: report year, IRS rate table, employer reimbursement rate, maintenance windows, trip purposes, expense categories, payment methods and service intervals • Sample data version + blank ready-to-use version ★ SAVE WITH A BUNDLE ★ Get this template plus 4 more in the Small Business Spreadsheet Bundle and save 50% PLEASE NOTE • DIGITAL download only. No physical item will be shipped. • Record-keeping tool, not tax advice. Confirm rates and rules on irs.gov or with a tax professional.