Gig Driver Tracker Spreadsheet, Mileage Log 2026, Rideshare and Delivery Income Tracker, True Hourly Pay

Instant digital download: gig driver spreadsheet for Excel and Google Sheets. You get 2 .xlsx files (blank and filled-in example) and a quick start guide. Nothing physical ships.

The app says you made $25 an hour. After gas, wear and depreciation, what did you really make? Log each shift once and this spreadsheet shows your true hourly pay by shift, by app, by week and by day and time slot, so you know when and where driving is worth it. It also keeps an IRS-style mileage log and a rough quarterly tax set-aside.

In the example, $21.66 an hour gross works out to $14.89 an hour after car costs.

━━━━━━━━━━━━━━━━━━
WHAT'S INSIDE: 16 TABS
━━━━━━━━━━━━━━━━━━
• START HERE: quick start, how the math works, tax notes
• SETTINGS: your car's real cost per mile (gas price, MPG, maintenance, depreciation, cleaning), monthly costs like phone and insurance, up to 8 apps, tax set-aside rates, IRS mileage rates and quarterly due dates
• SHIFT LOG: up to 500 shifts with date, app, start/end time (overnight OK), odometer or miles, trips, pay, tips, bonus, tolls and business purpose. Hours, gross, car cost, true profit, gross vs true $/hr, $/mile and IRS mileage value calculate (continues on the SHIFT LOG 2, SHIFT LOG 3, SHIFT LOG 4 and SHIFT LOG 5 tabs)
• BEST TIMES: heatmap of true $/hr by day and time block, plus your 5 best and 5 worst slots (continues on the BEST TIMES 2 and BEST TIMES 3 tabs)
• APP COMPARE: each app's gross vs true $/hr, $/mile, tips share and miles per hour, with a chart
• WEEKLY: the last 12 weeks of hours, miles, true profit, $/hr and set-aside, with a chart
• MILEAGE LOG: business miles and IRS value by month and by rate period, plus an odometer business-use %
• TAX SET-ASIDE: rough self-employment and income tax estimate per estimated-tax period, with due dates (continues on the TAX SET-ASIDE 2 tab)
• DASHBOARD: true $/hr for the year and this week, true profit, business miles, IRS mileage value, car cost per mile, set-aside, by-app table, best slots and next tax date

━━━━━━━━━━━━━━━━━━
FEATURES
━━━━━━━━━━━━━━━━━━
• Mileage rates by date range, built in and editable: the 2025 and Jan 1 to Jun 30, 2026 rates are listed to start. Type your own rate for any other dates, and each shift uses the rate for its date.
• Works for rideshare, food delivery, grocery shopping and package delivery apps
• A Blank file plus a filled-in Example (167 shifts across 4 sample apps)
• No macros. Shaded typing cells, dropdowns, and every page prints one page wide

━━━━━━━━━━━━━━━━━━
WHAT YOU'LL RECEIVE (3 files)
━━━━━━━━━━━━━━━━━━
1. Gig-Driver-True-Hourly-Mileage-Log_Blank.xlsx
2. Gig-Driver-True-Hourly-Mileage-Log_Example.xlsx
3. README.txt (quick start)

━━━━━━━━━━━━━━━━━━
INSTANT DOWNLOAD: HOW IT WORKS
━━━━━━━━━━━━━━━━━━
• After you pay, Etsy emails you a download link. You can also find the files under You ▸ Purchases and reviews.
• EXCEL: open the .xlsx file and click "Enable Editing". Excel 2016 or newer, including Microsoft 365 (Windows/Mac).
• GOOGLE SHEETS: go to sheets.google.com ▸ File ▸ Import ▸ Upload ▸ choose the file ▸ "Replace spreadsheet".
• Good to know: in Google Sheets, charts and fonts may look slightly different. Formulas, dropdowns and colors carry over.
• Works best on a computer. Phone and tablet apps are fine for quick entries.

━━━━━━━━━━━━━━━━━━
PLEASE NOTE
━━━━━━━━━━━━━━━━━━
• Manual entry: it doesn't connect to any account or import data automatically.
• Not tax advice. The mileage value and set-aside are rough estimates to help you save. They ignore other income, deductions, credits and state rules. Check IRS.gov or a tax professional.
• Not affiliated with any gig app.
• Formula cells are protected (no password) to prevent accidents; Review ▸ Unprotect Sheet if you want to customize.

━━━━━━━━━━━━━━━━━━
ABOUT THE PHOTOS AND FILE
━━━━━━━━━━━━━━━━━━
PHOTOS: The listing photos are screenshots of the actual file's tabs (Settings, Shift Log, Dashboard, Best Times, App Compare, Mileage Log and Tax Set-Aside), placed in a simple layout with short captions. They are not mockups. The Example file has 167 sample shifts from 4 made-up apps (Jun 1 to Oct 21, 2026).

WORKS IN: Microsoft Excel 2016 or newer, and Google Sheets (File > Import > Upload > Replace spreadsheet; charts may look slightly different). Apple Numbers: not tested. I laid the tabs out narrow for phone screens but have not tested every phone, so a computer is easiest.

THIS IS NOT tax advice, GPS trip tracking or a link to your gig apps. You type each shift. The tax set-aside is a rough estimate. Ask a tax professional about your own return.

━━━━━━━━━━━━━━━━━━
GOOD TO KNOW
━━━━━━━━━━━━━━━━━━
• Digital download: nothing physical ships. You get .xlsx file(s) for Microsoft Excel 2016 or newer, or free Google Sheets.
• Not tax, legal, or accounting advice. Tax rules change, so check IRS.gov or a tax professional.
• Results depend on the numbers you enter. Estimates are estimates.
• License: personal use in one household (or inside your own single business for business templates). Please don't share, resell, or upload the file.
• Problem with your file? Message me on Etsy and I'll fix it within 2 business days or refund you through Etsy.

— Neon

Designed with the help of AI tools, then reviewed and tested by me.