Side Hustle Income Tracker Spreadsheet

Build a side hustle income tracker with expense, mileage, and tax sinking funds. Track gross vs net per platform, plus e-commerce profitability.

Running a side hustle means income from multiple platforms, overlapping expenses, and a tax bill waiting at year-end. You already know you made money—but do you know how much you actually kept, or what it cost to earn each dollar?

Most side hustlers guess. They eyeball bank deposits, maybe squint at last year's credit card statements come April, and hope they set aside enough for taxes. The smarter ones build a side hustle income tracker.

A solid tracker isn't complicated. It's a single source of truth that shows you:

Gross and net income per platform (Etsy, Fiverr, freelance clients, whatever you run)
Every expense that eats into profit
Mileage and vehicle deductions if you deliver or travel
A quarterly tax sinking fund so April doesn't ambush you
For e-commerce sellers: profitability per listing, so you know which products actually work

This post walks you through what to track, why it matters, and how to build the tracker yourself—or grab a template that does it for you.

TL;DR

Track side hustle income in a spreadsheet with columns for: date, platform, gross revenue, expenses (broken out), mileage, and tax set-asides. Calculate net income per platform each month. Set aside 25-30% of profit for quarterly taxes. For e-commerce, add a column for cost of goods sold (COGS) and list-level profitability so you stop selling losers. Use formulas to auto-calculate taxes and keep the routine weekly so you never scramble to find receipts. Sheetfolk's side hustle template does this automatically.

What Should You Track in Your Side Hustle Income?

Start with: date, platform, gross revenue, and expenses.

If you sell on Etsy and freelance on Fiverr and take direct clients, track each separately. The profit margins are totally different—Etsy takes 6.5% in fees plus processing, Fiverr takes 20%, direct clients take 0%. Lumping them together hides where your money actually goes.

Add columns for expenses and mileage (if applicable). Track the date for every transaction so you can spot patterns and prove deductions to the IRS.

How Do You Calculate Gross vs. Net Income per Platform?

Gross income is what deposits into your account before fees. Net income is what's left after platform fees, payment processing, and your direct costs.

If you sold a $100 item on Etsy:

Gross: $100
Etsy fee (6.5%): -$6.50
Payment processing (~3%): -$3.00
Product cost (COGS): -$25
Net: $65.50

If you had billed a $100 freelance project with no platform fees:

Gross: $100
Payment processing (~2.2%): -$2.20
Software tool (if used): -$5
Net: $92.80

The difference is huge. Your Etsy item made $65 after all costs; your freelance project made $92. By separating them in your tracker, you can see which side hustles are actually profitable to your hands.

Set up a simple formula in your spreadsheet:

Net Income = Gross Revenue - Platform Fees - Payment Processing - Direct Costs

Then calculate this per platform per month. This tells you which revenue streams pull their weight.

What Expenses Count, and How Do You Organize Them?

IRS-deductible business expenses include:

Cost of goods sold (materials, inventory)
Shipping and packaging
Software and tools (design apps, payment processors, scheduling software)
Office supplies
Home office depreciation (if you dedicate a room)
Mileage (for deliveries, client meetings, errands tied to the business)
Internet or phone if it's for the business

Create columns for the big ones: COGS, shipping, software, supplies, mileage. Keep it organized so you can export for tax time and prove deductions if audited.

Pro tip: If you're not sure whether an expense counts, ask a tax pro or search the IRS site. But do track it anyway—you can sort it out later. Under-tracking is worse than over-tracking.

Store receipts digitally (photo them, use a scanner app, or sync them to a folder). Your spreadsheet should link to or reference where you store proof.

For more on organizing deductible expenses, see our guide on Google Sheets budget formulas.

How Much Should You Set Aside for Taxes Each Quarter?

Self-employed income is taxed at roughly 25-30% when you factor in federal, state (if applicable), and self-employment tax. Don't wait until April to find out.

Create a "Tax Sinking Fund" column in your tracker. At the end of each month, calculate:

Monthly Tax Set-Aside = (Net Income × 0.27)

Multiply by 3 and bank that sum for the quarter. This habit turns a $6,000 tax bill from a shock into a scheduled transfer.

Some platforms let you move money to savings automatically. If yours does, set up a transfer on the 1st or 15th of each month. If not, do it manually when you update your tracker.

If you want to go deeper on savings habits tied to income, check out our guide on sinking funds trackers.

How Do You Know Which E-Commerce Listings Are Actually Profitable?

For Etsy sellers or anyone with multiple product SKUs: add a profitability column.

This is where side hustles get smarter. A listing that sells 5 times a month looks busy, but if it costs $20 in materials and you charge $30 (after fees), you're only netting $10 per sale—and that's 50 hours of prep, packaging, and customer service a month.

Add a "Cost of Goods Sold" (COGS) column and a "Sales Count" column for each listing. Then:

Profit Per Sale = (Price - Platform Fee - COGS) × Sales Count / Hours Spent

List products by profit-per-hour, not just by revenue. Kill losers—listing that only made $2/hour has no business taking up shelf space.

Bonus: share which listings are duds with ListingTonic, which helps sellers optimize pricing and product descriptions. Knowing a listing is unprofitable is half the battle; knowing why is the other half.

How Do You Set Up a Side Hustle Income Tracker?

Build in a spreadsheet (Google Sheets is free and shareable), or grab a template.

If you're building your own:

Create a sheet called "Income" with columns: Date, Platform, Gross Revenue, Platform Fees, Payment Processing, Net Revenue
Add a sheet called "Expenses" with columns: Date, Category (COGS / Shipping / Software / Supplies), Amount, Notes
Create a "Mileage" sheet if applicable: Date, Purpose, Miles
Add a "Summary" sheet that pulls totals from the other three using SUMIF formulas
On the Summary, calculate total net income, total expenses, and the monthly tax set-aside

Set a weekly 15-minute routine to update it. Do this every Sunday night or Monday morning, while transactions are fresh. This beats scrambling to reconstruct six months of activity in March.

For help setting up formulas, see Google Sheets budget formulas.

If you'd rather skip the DIY: Sheetfolk's side hustle income tracker template includes all of this pre-built. It has separate tabs for income by platform, expense categories, mileage, and a pre-calculated tax sinking fund that updates as you enter data. Download it and start entering this week.

Keep the Bookkeeping Routine Weekly

Do 15 minutes on Sunday instead of three hours in March. Enter income and expenses the same day you receive or spend them. Use your phone to snap receipt photos. Tools like TaskDrain can automate weekly reminders so you stay on top of it.

The Bottom Line

A side hustle income tracker is not accounting—it's clarity. It's the difference between "I made $5,000 last month" and "I made $5,000 last month but only kept $3,200 after taxes and expenses, which breaks down to $16/hour." When you see the real numbers, you can make real decisions: double down on the profitable platforms, kill the losers, raise prices, or cut costs.

Build yours this week. Make it a Sunday ritual. And when tax season arrives, you'll have proof of everything, zero scramble, and a much clearer picture of whether this side hustle is actually worth your time.

Ready to stop guessing? Grab Sheetfolk's side hustle income tracker template and start tracking today. It's built for freelancers, e-commerce sellers, and anyone juggling multiple income streams.

Disclaimer: This post is informational only and not financial or tax advice. Consult a tax professional or accountant about your specific situation, deduction eligibility, and tax obligations. Side hustle income is self-employment income and is subject to self-employment tax; verify your tax liability with a qualified tax advisor.

Side Hustle Income Tracker Spreadsheet: Track Every Dollar (and What It Cost You)