How to Build a Google Sheets Side Hustle Tracker (All Income Streams, One Sheet)

Running one income stream is complicated enough. Running two or three — with different clients, different hours, different expense profiles, and different tax implications — is genuinely hard to track without a system. Most side hustlers end up with a rough idea of what they're making and a vague dread about what they owe at tax time.

A dedicated Google Sheets side hustle tracker fixes that. Not because the formulas are magic, but because having everything in one place forces clarity: which projects are actually profitable, how much you're paying in taxes, and whether your side hustle is worth the hours you're putting in.

Here's how to build a 5-tab tracker that answers all three questions.

Tab 1: Income Log

Every payment goes here the day it arrives. Columns:

| Column | Type | Notes | |--------|------|-------| | Date | Date | When payment was received | | Client / Project | Text | Specific enough to filter by | | Description | Text | What the payment was for | | Amount | Currency | Gross payment amount | | Payment Method | Text | PayPal, bank transfer, check, etc. | | Invoiced? | Checkbox | Did you send a formal invoice? | | Paid? | Checkbox | Confirmed receipt in your account |

Sort by Date descending. The Invoiced / Paid checkboxes catch the gap between sending an invoice and actually receiving money — a common side hustle cash-flow problem.

Tab 2: Hours Tracker

Revenue without hours is meaningless. Track every hour here:

| Column | Type | Notes | |--------|------|-------| | Date | Date | | | Project | Text | Match Income Log names exactly | | Task | Text | Brief description of what you did | | Hours | Number | | | Hourly Rate | Currency | Your target rate for this project | | Earnings | Formula | =D2*E2 |

The Earnings column multiplies Hours × Hourly Rate to show what you should have earned — useful for spotting scope creep. If a project's logged earnings (at your target rate) exceed what the client actually paid, you've identified a scope problem or a pricing problem.

Tab 3: Expenses

Deductible expenses reduce both income tax and self-employment tax — they're worth tracking precisely. Columns:

| Column | Type | Notes | |--------|------|-------| | Date | Date | | | Category | Dropdown | Tools / Ads / Contractors / Equipment / Other | | Description | Text | What you bought and why | | Amount | Currency | | | Tax Deductible? | Checkbox | Check for legitimate business expenses |

Keep receipts in a linked Google Drive folder. The Category dropdown matters for the Tax Summary tab — different categories have different documentation requirements.

Tab 4: Project P&L

This is the tab that changes how you think about your side hustles. Use SUMIF formulas to aggregate by project:

=SUMIF(IncomeLog!B:B, A2, IncomeLog!D:D)

Where column A contains your project names. Do the same for hours (from the Hours Tracker tab) and expenses (from the Expenses tab).

Then add these calculated columns:

• Net Profit = Total Income − Total Expenses
• Total Hours = SUMIF from Hours Tracker
• Effective Hourly Rate = Net Profit / Total Hours

That last formula — Effective Hourly Rate — is the most important number in the spreadsheet. It's the only metric that accounts for income, expenses, and time invested. A side hustle paying $500/month with 5 hours of work ($100/hr) is fundamentally different from one paying $800/month with 40 hours ($20/hr). Without this column, you might keep prioritizing the lower-rate project because the revenue looks bigger.

---

If your side hustle is growing, you need more than a tracker — you need a full financial picture. The Personal Finance Tracker (Google Sheets) connects your side income to your overall budget so nothing falls through the cracks. Get it for $19 →

---

Tab 5: Tax Summary

Self-employment tax is 15.3% on net earnings (12.4% Social Security + 2.9% Medicare). Add income tax on top, and a side hustle that looks profitable can feel much smaller by April. Track it throughout the year so you're never surprised.

Key cells in the Tax Summary tab:

| Field | Formula | |-------|---------| | Total Income | =SUM(IncomeLog!D:D) | | Total Deductible Expenses | =SUMIF(Expenses!E:E, TRUE, Expenses!D:D) | | Taxable Income | =Total Income − Total Deductible Expenses | | SE Tax (15.3%) | =Taxable Income * 0.153 | | Quarterly Payment | =SE Tax / 4 | | Next Payment Due | Manual cell — update each quarter |

The IRS quarterly deadlines for 2026 are: April 15, June 16, September 15, and January 15, 2027. Add a reminder in the Next Payment Due cell and check it monthly. A missed quarterly payment results in an underpayment penalty — avoidable with a single cell update four times a year.

5 Practical Tips

1. Log immediately after each transaction. The longer you wait, the more context you lose. Keep the tracker bookmarked on your phone and log income and expenses the same day they happen. Batch logging at month-end guarantees missing data.

2. Use a separate bank account for side hustle income. A dedicated account means your Income Log balance can be verified against your bank statement — no guessing which deposits came from which project. It also simplifies tax documentation: one account, one income source, clear paper trail.

3. Track effective hourly rate, not just revenue. This bears repeating: revenue is vanity, effective hourly rate is sanity. Once you start tracking it, you'll naturally deprioritize low-rate projects and raise prices on the ones consuming the most time.

4. Review monthly, not just at tax time. A 15-minute monthly review keeps the numbers accurate and helps you spot trends early — a project's expenses creeping up, a client whose payments are consistently late, a category of work where your effective rate is improving. Monthly visibility beats annual surprises every time.

5. Build a "parking lot" row at the bottom of each tab. For income you haven't categorized yet, expenses without receipts, or hours you can't assign to a specific project — add a running row at the bottom with a yellow highlight. Nothing falls off the tracker; you just park it until you can resolve it. Review and clear the parking lot in each monthly review.

A Google Sheets side hustle tracker isn't about complexity. It's about having one place where every dollar in, every hour spent, and every deductible expense is recorded — so when quarterly taxes come due or you're deciding whether to drop a client, the numbers are already there to guide the decision.