How to Track Side Hustle Income and Expenses in a Spreadsheet

Side income feels simple until tax season: multiple platforms, mixed cash and card payments, expenses buried in personal accounts. A free side income tracker spreadsheet separates profit by source and shows what you actually earned after costs — not what deposited before you bought supplies.

Log every source separately

Freelance client A, Etsy sales, ride-share payouts, consulting gigs — each gets its own section or tag. Totals by source answer the question “which hustle is worth my time?” faster than one blended number.

For each entry record:

1. Date
2. Source
3. Gross income
4. Expense tied to that income (materials, platform fees, mileage if you track it)
5. Net profit — gross minus expense

Set aside tax money in the sheet

Self-employment income often needs quarterly estimated payments. Add a tax set-aside column — commonly 25–30% of net profit as a starting reserve, adjusted with your tax advisor. Transfer that amount to savings when you log the income, not when the IRS letter arrives.

The weekly habit

Five minutes every Friday: log what paid out that week, attach expenses you already paid, update running totals. Month-end becomes a summary row, not a forensic audit of three apps and two bank accounts.

When a spreadsheet is enough

Until you have employees, inventory, or complex entity structures, a sheet plus a separate business bank account covers most sole proprietors. Software earns its keep when automated imports save you from manual entry — but only if you were actually keeping up with manual entry first.

These templates are operational tools, not tax advice. Work with a qualified tax professional for your filing obligations.