InkSheet Studio
Gig Driver Profit Tracker Spreadsheet | True Profit per Hour by App, Mileage Log and Offer Scorecard - Google Sheets
Gig Driver Profit Tracker Spreadsheet | True Profit per Hour by App, Mileage Log and Offer Scorecard - Google Sheets
Couldn't load pickup availability
INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.
DoorDash or Uber tonight?
The apps show you gross pay. Gross pay is not what you earned — not after 40 miles of driving, a tank of gas, and your phone bill. This tracker turns your shifts, miles, and expenses into the one number no app will show you: your true profit per hour, per app. Log the shift, log the miles, and the board does the rest — so Friday-night decisions come from your own numbers, not driver-forum folklore.
Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.
WHAT'S INSIDE — 7 focused tabs:
- Start Here — a plain-English guide, quick-start steps, and the profit-per-hour math explained
- Dashboard — all-time totals, blended profit per hour, your tax set-aside target, and the per-app board at a glance: who grosses most, who keeps most per hour
- Shift Log — one row per shift: date, app, hours, trips, base pay, tips, promos — gross and week-ending fill themselves in
- Profit-Per-Hour Board — the hero: per week, per app — gross, miles, mileage cost at the IRS standard rate, your share of expenses, net profit, and net profit per hour, with the week's best app flagged
- Mileage Log — business miles per shift, costed at the IRS standard mileage rate (an editable cell — check the current rate and make it yours)
- Expenses & Tax Set-Aside — non-vehicle costs by month, a monthly profit summary, and a set-aside target at a percentage you choose
- Offer Scorecard — your own minimum $/mile and $/hour bars, a 10-second check for any offer, and a weekly STRONG / MIXED / BELOW BAR grade for every app-week
HOW IT WORKS
1. After checkout you get a PDF with your private link. Click it and choose "Make a copy" — the tracker is yours.
2. After each shift: one row on the Shift Log, one row on the Mileage Log. Thirty seconds.
3. Every week, read the Board, grade your offers against your bars, and put your hours where your profit actually is.
THE MATH, PLAIN AND SIMPLE
Profit per hour = (gross pay − mileage cost − your share of expenses) ÷ hours worked. Mileage cost uses the IRS standard mileage rate because that rate is meant to cover the whole cost of running the car — fuel, wear, insurance, depreciation — which is also why this tracker tells you NOT to log fuel in expenses: that would count your car twice. Shared costs (phone, gear, tolls) are split across each week's apps by the miles driven for each, because the miles caused the costs.
In the fictional sample weeks, the result surprises most drivers: DoorDash brought in the most gross pay ($698.00) — and kept only $8.25 per hour after 468 miles. Lyft grossed less ($685.50) and kept $14.25 per hour. Instacart ranked third in gross and second in profit per hour. Same driver, same weeks — the miles decided.
THE OFFER CHECK, PLAIN AND SIMPLE
Set two bars once — the samples use $2.00 per mile and $22.00 per hour (gross). When an offer pops up, type its pay, estimated miles, and estimated minutes: the sheet shows $/mile and $/hour and a plain verdict — ACCEPT, MIXED, or SKIP. The sample offer ($12.00 for 9.5 miles and 38 minutes) comes out at $1.26/mile and $18.95/hour: below both bars, SKIP. And every week, the review grades the shifts you actually took, so you can watch your accept quality improve. Across the samples, only $568.50 of $2,460 gross cleared both bars.
WHY THIS ONE
Most gig trackers are expense logs: they tell you what you spent, not what you earned. This one is a decision tool — built around the weekly per-app board, the mileage math the IRS itself uses, and an offer filter you set. It comes loaded with six fictional sample weeks across four apps so you can watch every flag and grade fire before you replace the samples with your own numbers.
PLEASE READ: This is an organization and calculation tool. It is not tax advice or financial advice, and it does not promise what any app pays — pay varies by market, hour, and week, and this sheet only reports the numbers you enter. The IRS standard mileage rate changes over time (the samples use $0.70, the 2025 rate); check the current rate and update the Dashboard cell. Whether every mile is deductible depends on your situation — ask a tax pro. The set-aside percentage (25% in the samples) is a planning estimate, not a tax calculation.
FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.
REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — no Excel needed, and it works in the car, at home, and on your phone.
This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.
Share
