Every freelancer knows the panic. It's April, a client paid you $4,000 in January, and you have no idea what you owe or where it all went.
I spent years cycling through accounting apps, each one promising to fix my money and each one abandoned by March. The problem was never the tool. It was that no tool matched how freelance money actually works: irregular, lumpy, and spread across clients who pay whenever they feel like it.
What finally worked was embarrassingly simple. A spreadsheet with five habits:
Log income the day it lands. Date, client, amount, and whether it's received or still pending. That's it. The pending column is the whole game, because pending money is what freelancers forget.
Log expenses with one extra column: tax deductible? Yes or no. At tax time this single column is worth more than any app subscription. Most freelancers overpay because they never tracked what they could deduct.
Keep invoices in their own tracker. Invoice number, client, sent date, due date, status. Add one formula that flags anything past due. Unpaid invoices go stale fast.
Move 25 to 30 percent of every check into a separate savings account. Do it the day the money lands, before you touch the rest. This one habit eliminates the April surprise completely.
Once a month, look at profit per client. Not revenue. Profit. You'll find that your highest-paying client is often your least profitable once you count the hours.
That's the whole system. No subscriptions, no syncing, no dashboard you never open. A spreadsheet you actually look at beats software you don't.
If you want it pre-built, I turned this into a kit called Freelancer Finance OS: eight tabs (dashboard, income and expense logs, invoice tracker with overdue alerts, tax estimator, budget planner, client overview), all formulas done, works in Excel and Google Sheets. It's $29 at https://payhip.com/b/SFZQY.
But honestly, the habits matter more than the tool. Start with a blank sheet today. Your April self will thank you.
Top comments (1)
The pending column is a great call. One tax wrinkle worth adding to it: most freelancers are on the cash method, so income counts in the year you actually receive it, not when you invoice. A December invoice paid in January is next year's income. Handy at year end, but it means the received column, not the invoice date, is what should drive your estimated payments.
On the 25 to 30 percent: I'd apply it to profit rather than gross if you have real expenses, and sanity check it once. Self-employment tax alone is about 14.1% of net profit before any income tax, so someone in the 22% bracket in a state with income tax can need closer to 35%. Lower earners can often get by with 20 to 25%.
And at year end, tie your income log out to the 1099-NEC and 1099-K forms you receive. Mismatches are what trigger IRS letters, and platforms sometimes report gross before their fees, which you then deduct as an expense.