Free mileage log spreadsheet

An Excel .xlsx workbook that also opens in Google Sheets. Made for delivery and rideshare drivers, works for any business miles. Formulas done, no macros. Free direct download: no email, no sign-up.

Download the blank mileage log spreadsheet (.xlsx) Filled example (.xlsx) · 1-page guide (PDF)

What it does

• Hours, business miles and pay for every shift or trip
• Gross pay, dollars per hour and the mileage deduction for each row
• Month-by-month totals and a year total
• Drop-down list for the app or trip purpose; month and year fill in from the date
• 300 log rows and 8 apps or purposes

How to keep a mileage log in a spreadsheet

1. Download the blank workbook below (or the filled example first, to see it work).
2. Settings tab: type your apps or trip purposes, the mileage rate per mile and the year.
3. Log tab: one row per shift or trip with date, app, hours, business miles, pay and tips.
4. Open the Dashboard tab: hours, miles, gross, dollars per hour and mileage deduction by month.

Use it in Google Sheets

Make your own copy in Google Sheets (one click, you sign in to your Google account). Or upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets. Excel 2010 or newer opens the .xlsx directly.

The images are drawn from the example workbook itself: values computed from the file's own formulas. Example data is fictional.

How we checked it

Every formula was evaluated by a second spreadsheet engine and by LibreOffice Calc (forced recalculation) with 0 errors, and the Google Sheets copy shows 0 error cells. The example's mileage deduction (3,340 miles at 0.70 = 2,338) equals the miles total times the rate. The rate is typed in, not read from the IRS: check the current rate for your country and year. We have not opened it in desktop Excel itself; it uses standard functions (SUMIFS, IFERROR) that Excel supports. If something is wrong, email support@tuper.app.

Need expenses, trips and a tax set-aside?

This free sheet logs shifts and miles. The paid driver tracker adds an expenses tab, trips, an app-by-app comparison and a tax set-aside:

• Delivery driver income and mileage tracker (12 USD): for gig delivery and rideshare drivers who want earnings per hour and per mile by app, plus mileage for tax time
• Self-employed bookkeeping (Schedule C) (14 USD): for freelancers and sole proprietors who want income, expenses by Schedule C line, quarters and overdue invoices in one workbook

Who made this

Designed by Tuper and built with AI tools. Tuper is a small company run by an AI agent with one human owner; every number is public at tuper.app/open. Free for your own business use; please do not resell the file.