Freelancers
Gig Income and Mileage Tracker
See real earnings per hour after tips, and track every business mile for the IRS mileage deduction.
- Delivery
- Instant download
- Purchase
- One-time payment
- Format
- Google Sheets
- Excel
- Updated
- September 2026
What this spreadsheet does
Gig workers on Uber, Lyft, DoorDash and similar platforms rarely track mileage consistently, which means giving up a real tax deduction at filing time.
What you can do with it
- See real hourly earnings after tips
- Track every business mile as it happens
- Calculate the year's mileage deduction automatically
What's included
Sheet tabs
- Instructions
- Income Log
- Mileage Log
- Summary
Features
- Income log by shift with hours, earnings and tips
- Mileage log with automatic deduction at the current IRS rate
- Monthly summary of earnings and miles
How it works
- 1Open the file and read the Instructions tab once.
- 2Work directly in the tabs listed above — blue cells are yours to edit, black cells calculate automatically.
Who it's for
Rideshare, delivery and other gig-economy workers.
Frequently asked questions
What formats does this come in?
Google Sheets and Microsoft Excel 2016+. Open the Google Sheets link and use File > Make a copy, or download and open directly in Excel.
Is this a one-time purchase?
Yes. One payment, yours to keep and reuse.
Complete the setup
The rest of the tools this one was built to sit beside.
Freelance Hourly Rate Calculator
Find the hourly rate that supports the income you actually want.
- Google Sheets
- Excel
Invoice and Late Payment Tracker
Track invoices, lateness, and what chasing them actually costs you.
- Google Sheets
- Excel
Freelancer Quarterly Estimated Tax Tracker
See the smaller, IRS-safe quarterly payment between two tax methods, from your client income log.
- Google Sheets
- Excel
Similar tools
The same kind of tool, for a different job.
Wedding Guest List & RSVP Tracker
Track invitations, RSVPs, meal choices and seating in one list.
- Google Sheets
- Excel
Wedding Payment Tracker
Track deposits, balances and due dates for every vendor.
- Google Sheets
- Excel
Subscription Audit
Find how much of your recurring spend belongs to things you stopped using.
- Google Sheets
- Excel
52 Week Savings Challenge Tracker
Save a set amount each week and watch your total grow automatically.
- Google Sheets
- Excel
Airbnb Income & Expense Tracker
Log every booking and expense to see real monthly performance.
- Google Sheets
- Excel