Gig Economy Income Tracker in Google Sheets: Track DoorDash, Uber & Instacart Earnings (2026)
Working multiple gig apps is the norm — but getting a clear picture of what you're actually earning, spending, and owing in taxes is surprisingly hard when your income lives across five different apps. This guide shows you how to build a free gig worker income tracker in Google Sheets that consolidates all your platforms, auto-calculates your 1099 tax liability, tracks mileage, and shows which platform is actually worth your time.
Table of Contents
- Why a Spreadsheet Beats the App Dashboards
- What Every Gig Worker Needs to Track
- The 5-Tab Google Sheets Structure
- Tab 1: Earnings Log (All Platforms)
- Tab 2: Expense & Mileage Log
- Tab 3: Tax Estimator
- Tab 4: Platform Comparison Dashboard
- Key Formulas to Copy-Paste
- 1099-NEC Tax Prep Checklist
- Platform-by-Platform Tracking Notes
- 5 Costly Gig Worker Tax Mistakes
- Weekly Tracking Routine (10 Minutes)
Why a Spreadsheet Beats the App Dashboards
DoorDash shows you total earnings. Uber shows you weekly summaries. Instacart breaks it down by batch. But none of them show you your actual profit — because none of them account for your expenses.
The gap between gross earnings and what you actually keep can be enormous. A gig worker earning $1,500/month across three platforms might net less than $900 after mileage costs, vehicle wear, phone expenses, supplies, and taxes. Without a unified tracker, you genuinely cannot answer the question: "Which app is worth my time?"
A Google Sheets tracker solves this in ways the apps never will:
- Consolidated view — all platforms in one place, one number
- Real profit visibility — gross earnings minus real expenses
- Tax liability tracking — know your quarterly tax bill before it hits
- Platform comparison — hourly effective rate per app, not just gross pay
- Mileage deductions — the single biggest tax write-off most gig workers leave on the table
Critical distinction: The apps pay you gross. The IRS taxes you on net self-employment income (after deductions). A DoorDash driver doing $1,200/month in earnings but $400/month in qualifying mileage and expenses has a taxable income of ~$800 — not $1,200. Tracking this difference is the entire game.
What Every Gig Worker Needs to Track
Before building, let's establish what matters. Gig workers are sole proprietors by default. The IRS treats your gig income as self-employment income, reported on Schedule C (Form 1040). That means you file taxes differently than a W-2 employee — and your allowable deductions are much broader.
| Category | What to Track | Schedule C Line |
|---|---|---|
| Gross Earnings | All app payouts (base pay, tips, bonuses) | Line 1 |
| Mileage | Miles driven for deliveries/rides (70¢/mile in 2026) | Line 9 |
| Phone | % of phone bill used for gig work | Line 25 |
| Supplies | Hot bags, phone mounts, car chargers, etc. | Line 22 |
| Platform Fees | Any service fees or rental fees charged by apps | Line 10 |
| Insurance | Rideshare rider policy (beyond standard personal) | Line 15 |
| Vehicle Costs | If using actual expense method instead of mileage | Line 9 / Part IV |
Mileage method vs. actual expenses: Most gig workers do better with the standard mileage rate (70¢/mile in 2026) than tracking actual vehicle costs. You must choose one method at the start of the year and stick with it. This tracker defaults to the standard mileage method.
The 5-Tab Google Sheets Structure
Here's the full tab layout. Each tab serves a specific purpose and feeds data into the others automatically.
| Tab | Name | What Goes Here |
|---|---|---|
| 1 | Earnings Log | Every payout from every platform, by date |
| 2 | Expenses & Miles | All deductible expenses and mileage log |
| 3 | Tax Estimator | Quarterly tax liability, safe harbor check |
| 4 | Platform Dashboard | Side-by-side platform profitability comparison |
| 5 | Settings | Mileage rate, tax year, your platforms list |
Tab 1: Earnings Log (All Platforms)
This is your master ledger. Every payout from every app goes here. The key is capturing enough detail to know what you earned, where, and when — so you can analyze by platform and by month.
Columns for Your Earnings Log
| Column | Header | Notes |
|---|---|---|
| A | Date | Date of the payout or work session |
| B | Platform | DoorDash, Uber Eats, Instacart, TaskRabbit, etc. (use dropdown) |
| C | Type | Delivery, Ride, Grocery, Task, etc. |
| D | Base Pay | Platform-guaranteed pay before tips |
| E | Tips | Customer tips (still taxable income) |
| F | Bonuses | Peak pay, quests, promotions |
| G | Total Payout | =D+E+F (auto-calculated) |
| H | Hours Worked | Active time (not waiting time) |
| I | Effective $/Hr | =G/H (shows your real hourly rate) |
| J | Notes | Anything relevant (weather, promotions, unusual day) |
The Effective $/Hr column (I) is the most important insight in the entire spreadsheet. It reveals that DoorDash paying $18 per hour and Instacart paying $22 per hour aren't equivalent — because Instacart batches require more miles. Once you see the real hourly numbers, you'll make smarter decisions about when to switch apps.
Tab 2: Expense & Mileage Log
This tab is where your tax savings live. Most gig workers massively underreport expenses because they never wrote them down. Every dollar of deductible expense reduces your taxable income — and with a 15.3% self-employment tax on top of income tax, each $100 in legitimate deductions saves you $25–$40 in real money.
Expense Log Columns
| Column | Header | Notes |
|---|---|---|
| A | Date | Date of expense |
| B | Category | Mileage, Phone, Supplies, Insurance, Other (use dropdown) |
| C | Description | "Hot bag - Amazon", "Phone bill - March", etc. |
| D | Amount | Full cost |
| E | Business % | % attributable to gig work (e.g., 80% for phone) |
| F | Deductible Amount | =D*E (auto-calculated) |
| G | Platform | Which platform the expense was for (if applicable) |
Mileage Section (Separate Block on Same Tab)
Mileage is the biggest deduction for delivery and rideshare workers. In 2026, the IRS standard rate is 70 cents per mile. A driver putting in 1,000 miles per month can deduct $700/month — $8,400 per year — from their taxable income.
| Column | Header | Notes |
|---|---|---|
| A | Date | Date of driving |
| B | Platform | Which app you were working |
| C | Start Odometer | Odometer reading at start of shift |
| D | End Odometer | Odometer reading at end of shift |
| E | Business Miles | =D-C (auto-calculated) |
| F | Deduction | =E*0.70 (using 2026 IRS rate from Settings tab) |
What miles count? Miles driven while actively on a delivery or ride, miles from restaurant to customer, miles between deliveries while logged in, and miles to pick up supplies all qualify. Commuting from your home to your first pickup does not. When in doubt, log it and discuss with a tax professional.
Tab 3: Tax Estimator
This is the tab that saves you from a surprise bill. Gig workers don't have taxes withheld — you're responsible for paying quarterly estimated taxes yourself. Missing these payments triggers penalties on top of the taxes you already owe.
Tax Estimator Inputs
| Input | Where to Get It |
|---|---|
| YTD Gross Earnings | Auto-pulled from Earnings Log (SUMIF by year) |
| YTD Total Deductions | Auto-pulled from Expenses tab (SUMIF by year) |
| Other Income (W-2, etc.) | Manual entry — your day job income if applicable |
| Filing Status | Single, Married Filing Jointly, etc. |
| Prior Year Adjusted Gross Income | From last year's tax return (for safe harbor check) |
2026 Quarterly Tax Deadlines
| Quarter | Income Period | Due Date |
|---|---|---|
| Q1 | Jan 1 – Mar 31 | April 15, 2026 |
| Q2 | Apr 1 – May 31 | June 15, 2026 |
| Q3 | Jun 1 – Aug 31 | September 15, 2026 |
| Q4 | Sep 1 – Dec 31 | January 15, 2027 |
Tab 4: Platform Comparison Dashboard
This tab answers the question every multi-app gig worker should be asking: which platform actually makes me the most per hour, after expenses?
Use SUMIF formulas to pull data from the Earnings Log by platform. Then calculate effective profit (not just gross earnings) by allocating proportional mileage costs to each platform.
| Metric | DoorDash | Uber Eats | Instacart |
|---|---|---|---|
| Monthly Gross Earnings | $620 | $410 | $490 |
| Miles Driven | 320 | 195 | 310 |
| Mileage Cost (70¢/mi) | $224 | $137 | $217 |
| Other Expenses (allocated) | $41 | $27 | $32 |
| Net Earnings | $355 | $246 | $241 |
| Hours Worked | 24 | 18 | 20 |
| Effective $/Hr (Net) | $14.79 | $13.67 | $12.05 |
In this example, Instacart looks competitive on gross but loses on effective hourly rate because of higher mileage per dollar earned. Without this view, a gig worker might keep prioritizing Instacart batches — and leaving $2.74/hour on the table versus DoorDash.
Key Formulas to Copy-Paste
Monthly Earnings by Platform
=SUMIFS('Earnings Log'!G:G, 'Earnings Log'!B:B, "DoorDash", 'Earnings Log'!A:A, ">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1), 'Earnings Log'!A:A, "<"&EOMONTH(TODAY(),0)+1)
YTD Total Deductible Expenses
=SUMIFS('Expenses'!F:F, 'Expenses'!A:A, ">="&DATE(2026,1,1), 'Expenses'!A:A, "<="&TODAY())
Estimated SE Tax on Net Income
Net_SE_Income = Gross_Earnings - Total_Deductions
SE_Tax = Net_SE_Income * 0.9235 * 0.153
Income_Tax = (Net_SE_Income - SE_Tax/2) * [bracket rate]
Quarterly_Payment = (SE_Tax + Income_Tax) / 4
Effective Hourly Rate
=(Monthly_Gross - Monthly_Mileage_Cost - Monthly_Other_Expenses) / Monthly_Hours_Worked
1099-NEC Tax Prep Checklist
Annual Tax Prep Checklist for Gig Workers
- Collect all 1099-NEC forms from platforms (issued by Jan 31)
- Reconcile 1099-NEC amounts against your Earnings Log (they should match — platforms report gross, not tips-adjusted)
- Export your Expenses & Mileage tab and total all deductible amounts
- Calculate net self-employment income (gross earnings minus all deductions)
- Complete Schedule C for each platform (or combine if they're all "delivery driver")
- Deduct half of SE tax from gross income (above-the-line deduction)
- Check if you qualify for QBI deduction (20% of qualified business income)
- Confirm you paid sufficient quarterly estimated taxes (safe harbor: 100% of prior year tax)
- File by April 15 or request extension (note: extension to file ≠ extension to pay)
Platforms under-report tips: Some platforms' 1099-NEC forms include tips; others don't. DoorDash includes tips in the 1099. Uber separates them. Always reconcile against your own Earnings Log. If your log shows more income than the 1099, report your log number — the IRS requires you to report all income regardless of whether you receive a form.
Platform-by-Platform Tracking Notes
DoorDash
DoorDash pays weekly via direct deposit. Your Dasher Earnings tab in the app breaks down base pay, tips, and bonuses per delivery. Export the weekly CSV or manually log weekly totals. DoorDash includes tips in your 1099-NEC. Track active miles only — dashes that result in deliveries, not all time logged in.
Uber Eats / Uber
Uber's app provides weekly earnings breakdowns and a downloadable annual tax summary. Note that Uber's 1099-K (if you exceed $600 in transactions) may differ from 1099-NEC. Log both ride and delivery income separately if you do both — they're the same Schedule C but useful for your own analysis.
Instacart
Instacart pays per batch, not per hour. Track per-batch earnings and miles driven per batch. Instacart is grocery-focused, meaning mileage per dollar tends to be higher (longer store-to-customer distances). The platform comparison tab will reveal this quickly.
TaskRabbit
TaskRabbit income is service-based, not delivery-based — meaning mileage is often lower but time per job is higher. Track hourly rate separately. Also track any tools or materials you purchase for jobs (fully deductible if business-only use).
5 Costly Gig Worker Tax Mistakes
1. Not Tracking Mileage at All
The most common and expensive mistake. At 70¢/mile, 800 miles per month = $560 in monthly deductions. Over a year, that's $6,720 in deductions — saving $1,500–$2,500 in actual taxes. If you're not logging miles, you're paying those taxes unnecessarily.
2. Treating All App Income as Pure Profit
Your deposit from DoorDash is not your profit. It's your gross earnings before expenses and taxes. Treat 25–30% of gross as a tax reserve from day one. If you spend everything that hits your account, you'll owe the IRS money you don't have.
3. Missing the Self-Employment Tax
Unlike W-2 employees who pay 7.65% FICA (employer pays the other half), gig workers pay the full 15.3% SE tax on net self-employment income. This catches many first-year gig workers completely off guard. Budget for it explicitly.
4. Only Tracking When Platforms Send 1099s
If you earned less than $600 from a single platform, they're not required to send a 1099-NEC. But you still owe taxes on that income. Your own tracking spreadsheet ensures you don't miss it.
5. Mixing Business and Personal Expenses
Your phone bill is probably 70–80% business (it's your GPS, app, communication tool). Your car insurance might be entirely personal but a rideshare rider policy extension is deductible. Split expenses with a documented business-use percentage. Vague estimates get rejected in audits; documented percentages don't.
Weekly Tracking Routine (10 Minutes)
Every Sunday Evening (10 min)
- Log total earnings from each platform for the week (from app dashboards)
- Add mileage from this week's driving log
- Record any expenses from the week (supplies, phone, etc.)
- Check your tax estimator — are you on track for quarterly payment?
- Update the platform comparison dashboard
Before Each Quarterly Payment Due Date
- Open your Tax Estimator tab
- Confirm YTD gross earnings match platform statements
- Confirm total deductions are current
- Calculate your estimated tax due using the formulas above
- Pay via IRS Direct Pay (free) before the deadline
- Note payment date and amount in your tracker
Want a Done-for-You Financial Dashboard?
The Freelancer Financial Dashboard from SheetStackStudio includes a pre-built income tracker, expense log, and tax estimator — ready to adapt for gig work. No setup, no broken formulas. Instant download.
Get the Template on Etsy — $12.99 →Build This in a Weekend — Then Use It Every Week
The gig economy pays you for your time. This spreadsheet makes sure the IRS takes only what it's legally entitled to — and not a dollar more. It also tells you which app to prioritize, when you're making real money and when you're just staying busy, and whether your hustle is actually worth the mileage.
Build it once, update it in 10 minutes per week, and go into every quarterly tax deadline knowing exactly what you owe. That's the whole game.