How I tracked my freelance income

For two years I tracked my freelance income in a single Google Sheet with one tab per client. It was fine — until two things happened at once: I landed a third gig, and the second one started paying net-30 instead of on delivery. The column totals kept lying to me. The "paid" column meant three different things. The "pending" column was a graveyard of $200 invoices that had already been forgotten. By the time April rolled around, the spreadsheet could not tell me what I'd actually earned.

The thing spreadsheets can't do

Side-hustle income is irregular by design. A spreadsheet is good at adding columns; it is terrible at teaching you what each row is. Was the $450 from last week gross, or was that already after Upwork's 20% cut? Did the $120 refund happen before or after the client signed off? Is the $300 from Printful truly mine, or did I forget to subtract shipping and a failed re-order? These are not accounting questions. They're context questions, and context requires more than a row.

The change that fixed it wasn't a new app. It was treating every payout as a story: gross, fees, refunds, tax set-aside, status. Five columns, always five, no matter what the gig was. Once every entry answered the same five questions in the same order, the totals started meaning something.

What changed for me

Within a month, my "what do I actually owe" anxiety was gone — because the answer was sitting on the ledger, not in my head. I stopped chasing $150 logo gigs that turned into $0 net after two rounds of revisions, because the refund rate was now visible. The next surprise came six weeks later: I'd quietly earned my first $1,000 net month across side gigs, and the ledger showed it without me needing to brag.

If you're running more than one gig and still doing it in a generic spreadsheet, the problem isn't discipline — it's that the tool wasn't built for you. A side-hustle ledger should know the difference between a platform fee and a tax set-aside, and it should quietly keep both visible without you having to remember.