Mileage Tracker Spreadsheet, Business Mileage Log for Self Employed, Gig Driver and Delivery Mileage, Excel and Google Sheets

Log a business trip in seconds and let the sheet do the rest: business miles, the mileage amount at the IRS rate, monthly totals, and a one-page year-end summary for your tax preparer.

WHAT'S INSIDE
• 8 tabs in all: Start Here (tax year, IRS rate, vehicles), Trip Log, Vehicles, Parking & Tolls, Monthly Summary, Year-End Summary, Lists (dropdown choices) and Sources (every IRS figure with its irs.gov link)
• Trip Log (600 rows): date, vehicle, from, to, business purpose, client. Type one-way miles and mark Round trip to double them, or type odometer start and end
• Vehicles: up to 5 vehicles with Jan 1 and Dec 31 odometer, total miles, business use % and other miles
• Parking & Tolls: added to the mileage amount, as the IRS Schedule C instructions describe
• Monthly Summary: trips, miles and mileage amount for each month and each vehicle
• Year-End Summary: totals plus the vehicle questions on Schedule C Part IV (date placed in service; business, commuting and other miles)
• Built-in checks flag a missing purpose or vehicle, a date outside the tax year, or odometer readings that don't match the miles
• A filled EXAMPLE copy (made-up trips) and a 3-page Quick Start PDF

THE IRS RATE
The rate cell is prefilled with the latest IRS business standard mileage rate published when this file was made ($0.76 per mile, July 1 – Dec 31, 2026). The IRS usually announces the next year's rate in late December; type the 2027 rate in one cell and every trip updates. A second-rate cell covers a mid-year change like the one in July 2026. Every IRS figure is listed with its irs.gov source in the Sources tab.

WHO IT'S FOR
Freelancers, 1099 contractors, small business owners, realtors, delivery and rideshare drivers, and anyone who drives for work and files a Schedule C. US federal (Schedule C) wording.

HOW TO USE IT
1. Start Here: tax year, the IRS rate and your vehicles (about 5 minutes)
2. Trip Log: one row per trip, as you go
3. In January, print or export the Year-End Summary for your preparer

FAQ
Q: Does it work in Google Sheets?
A: Yes. It's a real .xlsx file with live formulas and no macros. Open it in Excel, or in Google Sheets use File → Import → Upload.
Q: Does it work on my phone?
A: You can log trips in the Google Sheets app once the file is imported. Editing is easiest on a computer.
Q: Is the 2027 rate filled in?
A: Not yet; the IRS hadn't published it when this file was made. The latest published rate is prefilled and the Start Here check reminds you to update it.
Q: Can I use it for 2028?
A: Yes. Change the tax year on Start Here and enter that year's rate.
Q: How do I get the files?
A: Right after purchase, from Etsy → You → Purchases and reviews, or the download link in your Etsy confirmation email.

WHAT YOU GET
2 Excel files (blank + example) and 1 PDF. This is a digital download; nothing is shipped.

OUR PROMISE
If a file won't open, or isn't what you expected, message us within 14 days of purchase and we'll fix it or refund you.

HOW IT'S MADE
Designed by Orvian Market with the help of AI tools for drafting and layout. Every formula, page and file was checked and tested before listing.

LICENSE
For your own use and your own business. Please don't resell, share or re-upload the files.

Record-keeping tool only, not tax, legal or financial advice. It doesn't decide whether a trip is deductible or file anything. Orvian Market isn't affiliated with the IRS. Microsoft Excel and Google Sheets are trademarks of their respective owners; Orvian Market isn't affiliated with or endorsed by them.