AnalystBuilt home Etsy shop

Taxes

Gig Driver Mileage & Earnings Tracker

Net per hour and per mile after car costs, best times, platforms and work miles

from $8.99 on Etsy

Price on Etsy may vary (sales, your currency).

View on Etsy
  • Google Sheets + Excel versions included
  • Instant digital download, nothing is shipped
  • Sample data and a Start Here tab
  • One-time purchase, no subscription

Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer.

See what you really earn behind the wheel. Log each shift with its miles, hours, pay and tips, and this tracker shows your net profit per hour and per mile after fuel, upkeep and wear on your car, the days and times that pay best, which of your apps earns the most, and the work miles you drove this year.

Made for rideshare, food delivery, grocery and courier drivers who work one app or several. You type your own platform names, so it fits any app you drive for.

What's inside

  • Start Here

    Quick guide, your settings (hourly target, weekly goal, minimum pay per mile, mileage rate), your car's costs and your list of platforms

  • Dashboard

    Net per hour, take-home per mile, net after costs, work miles, this week vs your goal, a color map of your best days and times, platforms side by side, where each dollar went and "What needs attention"

  • Shift Log

    One row per shift: platform, start and end time, odometer or trip miles, personal miles, trips, pay, tips, bonuses and platform fees

  • Fuel & Upkeep

    Gas or charging, service, tires, washes, insurance, phone plan, bags and gear, parking and tolls

  • Cost per Mile

    What one mile really costs you: fuel, upkeep, wear (depreciation) and insurance, from your estimate or from your own receipts

  • Offer Check

    Type an offer's pay, miles and minutes and see the net per hour and pay per mile against your own rules, plus a printable minimum-offer card

  • Best Times

    Net per hour by weekday and time of day, hours driven, and a full platform comparison

  • Weekly & Monthly

    Shifts, hours, miles, take-home, car costs and net for every week and month, with your weekly goal

Why you'll like it

  • Net per hour after car costs, not just the number your app shows you
  • A real cost per mile: fuel, upkeep, depreciation and insurance, switching to your own receipts once you have enough miles
  • Spot your money hours: a weekday × time-of-day map shows where you earn above or below your target
  • Compare apps fairly: hours, tips share, take-home per mile and net per hour for each platform
  • Work miles and an estimate at the mileage rate you type in, ready for your records
  • Offer Check and a minimum-offer card to keep in the car
  • Statuses that flag shifts below target and rows that need a fix; sample data included so you can see how it works first
  • Built by a data analyst: every number is a formula you can trace. No subscription, no app, no account linking

How you get it

  1. Download on Etsy

    Buy the template on Etsy, then download START-HERE.pdf and the Excel .zip from your Purchases.

    How to download
  2. Make a copy

    Click MAKE A COPY in the PDF: your own Google Sheet is saved to your Google Drive. Prefer Excel? Open the .xlsx.

    How to make your copy
  3. Start

    Follow the Start Here tab. Type in the cream cells; the gray cells do the math for you.

    Clearing the sample data

You receive:

  • START-HERE.pdf — Google Sheets link + quick guide
  • gig-driver-tracker-excel.zip — Excel version

Good to know

  • You type the numbers in; it does not connect to any app or bank. Weekly summaries from your apps make logging quick.
  • Miles and US dollars. One car per file and one file per year (up to 1,000 shifts and 500 costs).
  • The mileage figure is an estimate for your records. Type the current standard mileage rate yourself; which miles and which method you use is up to you and your tax preparer.
  • Not affiliated with any rideshare or delivery company.
  • Best used on a computer; you can view it in the Google Sheets app on your phone.
  • For personal use. Please do not resell or share the files.
  • Listing images show real screenshots of this template with sample data.

Not tax or financial advice. Not affiliated with the IRS.

Designed by me with the help of AI tools.