The 5 numbers every freelancer must track
Most freelancers track one number โ what landed in the bank โ and wonder why tax season is a panic and slow months are a surprise. You need five, and they take minutes a week once the habit exists:
- Gross income โ every invoice paid, per client, per month. This is your revenue truth; everything else derives from it.
- Business expenses โ software, equipment, coworking, subcontractors. Tracked against income, this gives you net profit โ the number tax is actually calculated on.
- Tax set aside โ the running total moved to your tax reserve. If you cannot see this number at a glance, you will spend it.
- Outstanding invoices โ billed but unpaid, with dates. This is your near-future income and your follow-up list in one.
- Buffer balance โ what sits in your reserve account. This number tells you whether you can say yes to a quiet month or need to chase work now.
Notice what is missing: hourly rates, pipeline value, "goals". Those are useful, but they are layer two. The five above are the operating dashboard of your business โ if any one of them is unknown, you are flying partially blind.
Spreadsheet vs app: an honest comparison
There is no universally right answer here โ only the right answer for your volume. Here is the honest trade-off:
Google Sheets or Excel
Free, fully customisable, and yours forever. Works well under roughly 10 transactions a month. The costs are real though: manual data entry, no audit trail, formula mistakes that corrupt totals silently, and reports you must build yourself. It only knows what you type โ skip the weekly review and it goes stale within a month.
App for invoicing, sheet for overview
Use a free invoicing tool for the jobs a sheet cannot do (sending, reminders, payment links) and keep a spreadsheet as your overview: clients, projects, expenses, money owed, and a tax set-aside percentage. Enter each invoice in both places when you send it. You get automation where it matters and a view no single app gives you.
An income tracker built for freelancers
Once you have multiple clients, recurring expenses and tax set-asides to reconcile, manual entry becomes the bottleneck. A dedicated tracker categorises automatically, keeps the five numbers visible at all times, and generates the reports (profit by client, tax reserve, cash flow) that a spreadsheet only gives you after an hour of formula work.
The fanciest tracker in the world fails if you open it once a quarter. Before switching tools, fix the routine below โ a maintained spreadsheet beats an abandoned app every time.
The 15-minute weekly routine
Pick one fixed day and time โ Friday afternoon works for most people. Then:
- Log the week's income (5 min). Every payment received, assigned to its client and invoice.
- Log the week's expenses (5 min). Photograph or file receipts as you go during the week; now just categorise them.
- Move the tax slice (2 min). Transfer your tax percentage on this week's income to the reserve account. Non-negotiable, every week.
- Review outstanding invoices (3 min). Anything unpaid past its terms gets a polite follow-up today, not "next week".
That is the whole system. Fifteen minutes, once a week, and your five numbers are always current. Pair this with the irregular-income budgeting method and you have the complete operating loop: track what comes in, smooth what goes out.
The mistakes that break every system
- Mixing business and personal money. One account for everything makes every number above a reconstruction project. A separate business account is the cheapest upgrade in this entire guide.
- Tracking gross but forgetting tax. Money received is not money available. If the tax slice is not moved the week it arrives, it will not be there in April.
- No invoice follow-up list. Unpaid invoices are not "probably fine" โ they are your most likely next income, and they rot fastest when unwatched.
- Month-end marathons. Batching a month of bookkeeping into one Sunday creates exactly the dread that kills the habit. Weekly is lighter than monthly, not heavier.
Frequently asked questions
What is the best way to track freelance income?
The best method is the one you maintain weekly: a simple spreadsheet works for under roughly 10 transactions a month, while a dedicated tracker app pays off once you have multiple clients, expenses and tax set-asides to reconcile. Either way, record the same five numbers: gross income, expenses, tax set aside, outstanding invoices, and your buffer balance.
Should freelancers use a spreadsheet or an app to track income?
Spreadsheets are free and flexible but need manual entry and discipline; apps automate categorisation and reports but cost a subscription and keep your history in their system. A practical hybrid: use an app for the jobs a sheet cannot do well, and keep a spreadsheet as your overview.
How often should freelancers update their income records?
Weekly, in a fixed 15โ30 minute session. Waiting until month-end lets uncategorised transactions pile up and makes the job feel enormous, which is why most people abandon it.
Do I need to track each client separately?
Yes. Per-client totals are what reveal which work is actually profitable after expenses, which clients pay late, and where your income concentration risk sits. Aggregate-only tracking hides all three.