Mileage Log Spreadsheet 2026, Business Mileage Tracker Google Sheets and Excel, IRS Rate Deduction Calculator, Self Employed

Mileage Log Spreadsheet 2026 for Google Sheets and Excel. Log a trip in ten seconds and the deduction is worked out for you, even when the IRS changes the rate halfway through the year.

Business miles are one of the easiest deductions to lose. You drive to clients, suppliers and the post office all year, but the log lives on receipts and memory, and by tax time it's a rough guess. Log each trip in a few seconds, and the deduction is worked out at the right standard rate, even when the rate changes mid-year.

★ HOW IT HELPS YOU
• Log a trip with the odometer readings and the miles and deduction appear on the row.
• If there's a gap between one trip's end and the next one's start, the file flags it so you can check for a missed trip.
• Quarterly totals are ready for your estimated tax payments, not just at year end.
• Business use percentage per vehicle is worked out from the odometer, which is the number your tax preparer will ask for.
• Tolls and parking sit alongside the mileage, so they don't get forgotten.

★ WHAT IT DOES
• Trip log: date, vehicle, business or personal, purpose, client, from/to and odometer, or just miles
• Miles and deduction at the standard mileage rate for each trip's year (rates editable in Settings)
• Odometer gap check that flags a possibly missing trip
• Tolls and parking tracked alongside the deduction
• Business-use % per vehicle from the odometer on 1 January and today
• Deduction by quarter for estimated taxes, miles by client and by purpose

★ WHAT'S INSIDE
Tabs: User guide, Dashboard, Trips, Vehicles, Settings

★ HOW YOU'LL USE IT
1. Add your vehicles: Odometer on 1 January and today. And check the rate table for this year.
2. Log each trip: Date, purpose, client and odometer readings. Gaps between trips are flagged.
3. Claim it: Quarterly totals for estimated taxes and a year-end figure ready for your return.

★ IT'S MADE FOR YOU IF
• You're self-employed or a 1099 contractor
• You drive for clients, deliveries or errands
• Your mileage lives on scraps of paper
• You want a log that holds up at tax time
• You'd rather use a finished tool than build a spreadsheet from scratch

It's probably not the right fit if you want automatic GPS tracking. You log trips yourself, which is also what makes the record solid.

★ WHAT YOU GET
• 8 Excel (.xlsx) files, one for each color theme (light, pastel and dark). Every theme has the same features, so pick the one you like looking at
• A PDF with Google Sheets links for every theme. Click the look you want, Google asks you to make a copy, and it's saved in your own Drive
• A one-page User guide inside the file that explains every tab, in all 12 languages
• 12 languages built in, switched in Settings: English, German, French, Spanish, Italian, Dutch, Polish, Portuguese, Japanese, Russian, Turkish and Arabic
• Sample data already filled in, so you can see how it works before you type anything. Clear the white input cells and it's yours

★ WORKS WITH
• Google Sheets in your browser. You only need a free Google account
• Microsoft Excel 2016 or newer, Microsoft 365 and Excel for Mac
• Phone and tablet: open it in the Google Sheets or Excel app to check numbers and make quick updates
• No macros, no add-ons, no subscription. You buy it once and it's yours

★ GOOD TO KNOW
• Which mileage rate does it use? The standard rate for each year, kept in Settings. Check irs.gov and update it when it changes.
• Can I log more than one car? Yes. Add vehicles on Vehicles and filter the dashboard by vehicle.

★ HOW TO GET YOUR FILES
1. Right after you pay, Etsy emails you a download link. You can also find the files any time under You > Purchases and reviews on Etsy.
2. Download the zip file and unzip it (double-click on a Mac, right-click and choose Extract All on Windows).
3. For Excel, open the .xlsx file in the theme you like. For Google Sheets, open the PDF, click a theme and choose Make a copy.

★ PLEASE NOTE
• This is a digital download. Nothing will be shipped to you.
• The names and numbers you see in the photos are sample data, not real people or advice.
• You're welcome to use it for yourself and your own business. Please don't resell, share or upload the files anywhere else.
• It's made for record keeping and isn't tax advice. Check the current IRS rate.
• Because it's a digital file, Etsy doesn't allow returns, but if something doesn't work the way you expected, message me and I'll help you sort it out.

Not sure if it fits the way you work? Send me a message before you buy. I'm happy to answer questions.