How to Track Side-Hustle Income and Expenses (Simple Spreadsheet Setup)
Most side hustles don't fail because the work is bad. They fail because nobody knows if they're actually making money. Flipping, mobile repair work and gig driving all have costs that hide: fees, parts, gas, supplies. One plain spreadsheet, updated once a week, fixes that and makes tax time painless.
The columns you need
Use one row per money event, in or out. Keep it to these columns:
- Date
- Type: Income or Expense
- Hustle: flipping, repair work, driving (only if you run more than one)
- Category (see below)
- Description: what it was, like "sold Carhartt jacket" or "brake pads, Civic job"
- Amount
- Paid with / paid to: which account or app, so you can match it to statements
- Receipt?: Y or N, so you know what's missing
Expense categories that keep it simple
- Inventory or parts: what you buy to resell or install
- Platform and payment fees: eBay, Poshmark, Mercari, card processing
- Shipping and supplies: labels, boxes, tape, shop rags
- Tools and equipment
- Phone and software: the business share only
- Mileage: tracked separately in a mileage log, not as gas receipts, if you use the standard mileage rate
Fewer categories means you'll actually fill it in. You can always split one later.
Three formulas worth adding
Put a small summary block at the top of the sheet:
- Income this month:
=SUMIFS(F:F,B:B,"Income",A:A,">="&DATE(2026,10,1)) - Expenses this month: the same formula with "Expense"
- Profit: income minus expenses, then minus your mileage deduction if you track miles
Change the date in the formula each month, or point it at a cell that holds the first day of the month.
The 10-minute weekly routine
- Pull up your platform payouts (eBay, PayPal, Cash App, whatever you use) and add each one as an Income row.
- Go through your bank or card for the week and add every business purchase as an Expense row.
- Snap photos of any paper receipts and mark the Receipt column.
- Add the week's business miles from your mileage log.
- Look at profit for the month so far. If it's thin, find the category eating it.
Turn profit into a tax set-aside
Once you know your real profit, set part of it aside for taxes every month instead of getting surprised in April. Our guide on how much to set aside for side-hustle taxes walks through it, and the free tax set-aside calculator and quarterly estimated tax calculator do the math. This is general information, not tax advice, so check with a tax pro for your situation.
A quick worked example
Say in October you sold $640 of flips, paid $92 in platform fees, $210 for inventory, $38 in shipping supplies, and drove 120 business miles. Expenses are $340, so profit before mileage is $300. At the 2025 IRS standard rate of 70 cents a mile, 120 miles is an $84 deduction, which brings taxable profit to about $216. That's the number your set-aside should come from, not the $640 that hit your account. (Check the IRS site for the current year's mileage rate.)
Flipping? Get exact per-item profit with the free reseller profit calculator and see how inventory tracking works in our inventory spreadsheet guide. Doing repair work? See how to price mobile mechanic jobs.
Want this already built?
The Side-Hustle Numbers Kit bundles the Flip Profit Tracker, Auto Repair Forms and the Mileage & Tax Tracker for $19.99 instead of $26.97 bought separately. Income, expenses, miles and tax set-aside are already set up with formulas. Works in Excel or Google Sheets.
See the Side-Hustle Numbers Kit