Guides

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:

Expense categories that keep it simple

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:

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

  1. Pull up your platform payouts (eBay, PayPal, Cash App, whatever you use) and add each one as an Income row.
  2. Go through your bank or card for the week and add every business purchase as an Expense row.
  3. Snap photos of any paper receipts and mark the Receipt column.
  4. Add the week's business miles from your mileage log.
  5. 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