Free Driver Revenue & P&L Tracker

Built by a multi-app driver.

Tracks revenue, miles, hours & P&L across every app you drive — Lyft, Uber, DoorDash, Walmart Spark, Grubhub, Uber Eats, Expedite, whoever's paying best that day. For one driver or two. It's Free.

What's Inside

5 tabs. Everything calculated for you.

Enter your daily numbers in the pale teal cells. Totals, ratios, monthly stats, and weekday averages calculate automatically — 1,207 formulas already wired up.

👋

Start Here

Quickstart guide, tab walkthrough, and tips on customizing it for your platforms.

📊

Tracker

The main monthly grid. Two drivers, 6 platforms each, dynamic dates, heat-mapped daily totals.

🎯

Sample Month

A filled-in example month so you can see realistic data and what every formula produces.

💸

Expenses

Gas, maintenance, phone (business %), insurance, tolls, supplies. With IRS guidance baked in.

📈

P&L Summary

Auto-pulled net profit, standard mileage deduction, effective hourly rate, Schedule C estimate.

Who It's For

Built for self-employed professionals who drive for business.

If you run a one-person business out of your vehicle, this spreadsheet tracks the income and miles you'll need to report at tax time.

Gig Workers

Rideshare, food delivery, grocery, multi-app drivers tracking platform-by-platform revenue.

Contractors

Tradespeople driving to job sites, hauling tools, billing clients across multiple projects.

Real Estate Agents

Showings, open houses, client meetings — every mile counts on Schedule C.

Small Business Owners

Service businesses, route-based work, delivery operations run out of one vehicle.

The Story

Why this spreadsheet exists.

I drive gig. Lyft, Uber, DoorDash, Walmart Spark, Uber Eats, Grubhub, Expedite — whoever's paying best that day. A few years back I built this spreadsheet to figure out what was actually working: which days, which platforms, which hours.

It started simple. Then I added tip tracking. Then a second driver column when my partner started driving too. Then weekday averages so I could see whether Wednesdays were really worth driving (they weren't — Fridays are king).

Eventually the spreadsheet got so detailed that typing into it after every shift took longer than counting my cash. So I built TrakMiles Pro to do this automatically — auto-tracks mileage, time, revenue, expenses, P&L, and exports a Schedule C-ready report.

But the spreadsheet still works. If you're just starting out tracking your gig income — or you're a multi-app driver who wants to see which platforms are actually worth your time — this is a great place to begin. Free, yours to keep, and you can use it forever without ever opening the app.

— Henry, TrakMiles Pro

Common Questions

FAQ

Does it work in Excel? Google Sheets? Numbers?

Yes to all three. It's a standard .xlsx file. Open it in Excel (Windows/Mac), upload it to Google Sheets (File → Open → Upload), or open it in Apple Numbers. All formulas, conditional formatting, and dynamic dates work in any of them.

What if I drive solo? Do I have to use the second driver column?

No. The Driver 2 section just sits at zero and doesn't affect any of the calculations. If you want it gone, hide those rows or delete them — the spreadsheet works perfectly with one driver.

What if I don't drive for the platforms listed?

Rename any platform row to whatever you do drive for — Instacart, Grubhub, Amazon Flex, Roadie, anything. The formulas don't care about the name; they just sum the row.

How is this different from your app?

This spreadsheet is manual entry — you type in your numbers after each shift. TrakMiles Pro is automatic: it tracks your mileage in the background, logs your hours, captures revenue, scans receipts, and generates Schedule C reports without you typing anything. The spreadsheet is free; the app has a 14-day free trial, then $4.99/mo or $34.99/yr.

What's in the Sunday newsletter?

Tax tips for self-employed drivers, mileage tricks that save money on Schedule C, real earnings analysis (often using my own Lyft numbers), and the occasional new tool or template. One email a week, Sunday morning. Unsubscribe anytime.

Do you spam? Sell my email?

No. The newsletter is sent through MailerLite (one email a week max). Your email isn't shared with anyone. There's an unsubscribe link in every email and it works instantly.

Will the spreadsheet work on my phone?

Yes, but it's better on a tablet or laptop. The Tracker tab is 42 columns wide (one per day across 5 weeks plus subtotals), which means a lot of horizontal scrolling on a phone screen. Most subscribers fill it in at the end of each shift on a tablet, or batch a week of shifts on a laptop on Sundays.