The Free Spreadsheet I Built to Track Revenue Across Every App I Drove For

Most drivers don't know what they're actually making.

The platforms show you weekly totals. The bank shows you deposits. But the numbers that actually matter — what you made per platform, per hour, per day of the week, after mileage deductions and expenses — those numbers don't exist anywhere by default. Nobody tracks them for you.

So a few years back, I built a spreadsheet to track them myself.

That spreadsheet is now free. It's the same one I used while juggling Lyft, Uber, DoorDash, Walmart Spark, Grubhub, Uber Eats, and Expedite — whoever was paying best that day. Two driver columns, six platforms each, dynamic dates, weekday averages, monthly P&L, Schedule C-ready. 1,207 formulas already wired up.

Below: what's inside, who it's for, why this matters more than any platform dashboard ever will.

What this spreadsheet actually is

It's not a product. It's not a teaser for the app. It's a real working artifact I used for years before I built TrakMiles Pro, polished up and rebranded so anyone can grab it.

The first version was for one driver, one platform, four weeks. I added tip tracking after I realized I was undercounting cash. I added a second driver column when my partner started driving. I added weekday averages so I could finally answer the question: is it actually worth driving on Wednesdays? (It wasn't. Fridays are king.)

Eventually it got detailed enough that typing into it after every shift took longer than counting my cash. That's when I built the app. But the spreadsheet still works. It's free, yours to keep, and you can use it forever without ever opening TrakMiles Pro.

What's inside the spreadsheet

Five tabs, designed to be filled in as you drive:

• Start Here. A quick walkthrough of every other tab. Read this first — it'll take you two minutes and save you twenty.
• Tracker. The main grid. Two drivers, six platforms each, five weeks of daily entries. Heat-mapped daily totals so good days jump out visually. Dynamic dates recalculate from one Start Date input — change one yellow cell, every date and day-of-week label updates.
• Sample Month. A filled-in example month so you can see what realistic data looks like and what every formula calculates without having to enter anything yourself.
• Expenses. Gas, maintenance, phone (business %), insurance, tolls, supplies — with IRS guidance baked in for what counts as deductible and what doesn't.
• P&L Summary. Auto-pulled net profit, standard mileage deduction estimate, effective hourly rate, Schedule C-ready totals. The numbers your accountant will actually ask you for.

Open it in Excel, upload to Google Sheets, or open in Apple Numbers. Works in all three with all formulas intact.

Why this matters more than your platform dashboard

Every gig app has a dashboard. They all show you the same three numbers: this week, last week, lifetime. They all hide the numbers that would actually let you make a business decision:

• Per-platform revenue. Lyft vs Uber vs DoorDash — which one is actually paying you more per hour right now? You can't compare without combining them.
• Per-hour revenue. $400 looks great until you realize it took 15 hours. The spreadsheet does the math.
• Per-mile revenue. The 2026 IRS standard mileage rate is 72.5¢ per business mile. If you're earning less than 72.5¢ per mile driven, you're losing money on the deduction alone. The tracker flags this for you.
• Day-of-week breakdown. Some days pay double. Some days aren't worth the gas. $/mile is the only number that tells you the truth, and the spreadsheet computes it weekly.
• Net P&L. Revenue minus expenses minus the standard mileage deduction. The number that actually goes on Schedule C at tax time.

This spreadsheet does all of that. Your platform dashboard does none of it.

Who this spreadsheet is for

I built it for gig drivers, but the structure works for anyone who runs a one-person business out of their vehicle:

• Gig workers. Lyft, Uber, DoorDash, Walmart Spark, Grubhub, Uber Eats, Instacart, Amazon Flex. Rename a row to match your apps. The formulas don't care about the names — they just sum the row. (Also see tracking miles across multiple gig apps.)
• Independent contractors. Plumbers, electricians, HVAC, landscapers, trades. Track miles between job sites alongside revenue per client.
• Real estate agents. Showings, open houses, client meetings. Every mile counts on Schedule C — and most agents are losing thousands to forgotten open-house trips.
• Small business owners. Service businesses, delivery routes, route-based work, anything where a vehicle drives the revenue.

If you're tracking income the IRS treats as self-employed earnings, and you're driving for business, the spreadsheet works.

How to set it up

Three steps. Maybe two minutes total:

1. Open it. Excel (Windows or Mac), Google Sheets (File → Open → Upload), or Apple Numbers. All three work.
2. Set your Start Date. One yellow cell at the top of the Tracker tab. Every date and day-of-week label fills in automatically — change one cell, the whole grid updates.
3. Start entering. Pale teal cells are inputs. White cells calculate for you — don't type into those or you'll break a formula.

Driving solo? Ignore the Driver 2 columns; they stay at zero and don't affect anything. Don't drive for the platforms listed? Rename the rows.

What it doesn't do (being honest)

I want to be straight about what this spreadsheet won't do for you:

• It won't track miles automatically. You enter them after each shift.
• It won't pull revenue from your apps. You copy the numbers in at end of day.
• It won't scan receipts. Take a photo, store it in your phone gallery; the spreadsheet just records the amount.
• It won't sync across devices. It's a file — wherever you save it is wherever it lives.

If those automations sound like the actual hard part — and they are, for most drivers — that's what I built TrakMiles Pro for. The app does all of this in the background while you drive: auto-mileage tracking, auto-time clock, revenue logging, receipt OCR, Schedule C export. 14-day free trial, no credit card, $4.99/mo or $34.99/yr after.

But if you're just starting out — or if you'd rather sit down on Sundays and enter the week's numbers by hand — the spreadsheet covers the same ground for free. Your call.

What you get when you sign up

• The spreadsheet. Instant download after you enter your email.
• A Sunday-morning newsletter. Tax tips, mileage tricks, real earnings analysis, occasional new tools and templates. One email a week, unsubscribe anytime.

No spam. No upsell flood. One email a week because that's what I'd want as a subscriber.

Disclaimer: This article is for informational purposes only and does not constitute tax advice. Consult a qualified tax professional for guidance specific to your situation. IRS standard mileage rate referenced is for the 2026 tax year.

Back to Blog