How to track freelance income without accounting software
You don't need a $30-a-month accounting app to know what you're owed. For most freelancers, a well-built spreadsheet is faster, clearer, and free of subscriptions. Here's a simple system that takes five minutes to set up and keeps you in control.
Track three things, not thirty
The whole game comes down to three lists: your clients, your projects, and your invoices. Everything else — profit, outstanding balance, monthly income — is just math on top of those three. If you capture them consistently, the numbers take care of themselves.
1. A client list
Name, contact, country, and a status: active, lead, or inactive. This is your pipeline at a glance. When someone asks “how many active clients do you have?”, you should be able to answer in one second.
2. A project list
Every engagement with its fee, start and due dates, and a status (not started, in progress, completed). This is where you see what's actually on your plate and what it's worth. Sort by due date and your week plans itself.
3. An invoice log
The most important list. For each invoice: amount, issue date, due date, and status — paid, unpaid, or overdue. Add a “paid date” when the money lands. That single column unlocks everything: total invoiced, total collected, what's still outstanding, and how much came in each month.
Let the dashboard do the thinking
Once those three lists exist, a few formulas turn them into a live dashboard: SUMIFS adds up paid vs unpaid invoices, COUNTIF counts active clients and in-progress projects, and a simple chart shows income by month. You never calculate anything by hand — you type in reality and the sheet reflects it.
The one habit that makes it work
Update it the moment something happens: a new project signed, an invoice sent, a payment received. Two minutes, in the moment, beats an hour of reconstruction at tax time. A tracker only lies to you when it's out of date.
Whether you build it yourself or grab the template, the principle is the same: track three lists, keep them current, and let the math surface the truth about your business.