How to Track Freelance Income and Expenses Without Accounting Software

A complete system for tracking what you earn, what you spend and what you owe in tax — built in a spreadsheet, and enough for most sole traders.

Published 2026-07-27 · 4 min read

Accounting software is excellent and most freelancers do not need it in year one. What you need is to know three things at any moment: what you earned, what you spent, and how much of that money is not actually yours because the tax office wants it.

A spreadsheet does all three. Here is how to build it and, importantly, when to stop relying on it.

One thing before we start: this is a guide to keeping organised records, not tax advice. Rules differ by country and by how you are registered. A qualified accountant for one hour a year is money well spent, and good records make that hour far cheaper.

The three things you actually track

Income. Every payment received — when, from whom, for what, how much, and whether tax applies.

Expenses. Every business cost — when, to whom, what category, how much, and whether it is deductible.

Tax set-aside. A running figure of what you should be holding back. This is the one freelancers skip and the one that ruins Januaries.

Sheet one: income

One row per payment received. Not per invoice — per payment. Invoices get part-paid and paid late, and tracking promises rather than money is how people end up believing they are richer than they are.

Columns: Date received, Client, Invoice reference, Description, Amount, Tax collected if applicable, Net amount, Payment method.

Enter payments on the day the money lands. Not when invoiced, not when promised.

Sheet two: expenses

One row per expense. Columns: Date, Supplier, Category, Description, Amount, Tax paid if applicable, Deductible yes or no, Receipt held yes or no.

That last column matters more than it looks. An expense without a receipt is often not an expense as far as the tax office is concerned. Tracking whether you have it tells you what to chase before the deadline rather than after.

Keep categories few and consistent. Software and subscriptions, equipment, travel, professional fees, marketing, office costs, training. Make it a dropdown so spelling never varies — the same discipline that makes reporting possible later.

Sheet three: the summary

This is the sheet you actually look at.

Income this month:

=SUMIFS(Income!E:E,Income!A:A,">="&EOMONTH(TODAY(),-1)+1,Income!A:A,"<="&EOMONTH(TODAY(),0))

Expenses this month: same formula against the expenses sheet.

Profit this month: income minus expenses.

Year to date for each of the above, using the start of your tax year rather than January if they differ.

Tax set-aside: profit multiplied by your estimated rate. If you do not know your rate, ask an accountant once and reuse the number. Guessing low here is the expensive mistake.

The habit that makes it work

Every system fails the same way — you stop entering things, then face four months of receipts and give up.

Enter income the day it arrives. Takes thirty seconds and the number in your summary stays true.

Photograph receipts immediately and file them in a folder named by month. Enter them weekly in one sitting.

Reconcile against your bank monthly. Open the statement, tick off every business transaction. Anything unticked is missing from your sheet. This catches errors while you still remember the context.

Fifteen minutes a week. Less than the time you will spend on one panicked reconstruction.

Set the tax money aside properly

Calculating what you owe and leaving it in your current account does not work. You will spend it.

Open a separate savings account. Every time you record income, move the tax portion across the same day. Treat that account as not yours, because it is not.

Freelancers who do this find tax deadlines uneventful. Freelancers who do not find them terrifying. The system is identical — the difference is whether the money is physically somewhere else.

Invoicing alongside this

Keep a fourth sheet for invoices sent, tracking: date sent, client, reference, amount, due date, date paid, days overdue.

Overdue is the one to watch:

=IF(AND(G2="",F2<TODAY()),TODAY()-F2,"")

Where G is date paid and F is due date. Conditional-format anything above thirty in red and chase it that morning.

Unpaid invoices are the most common cash flow problem in freelancing and almost always the least addressed.

When this stops being enough

Move to proper accounting software when any of these becomes true.

You register for VAT or sales tax. The filing requirements make software worth it immediately.

You take on employees or subcontractors. Payroll is not a spreadsheet job.

Your accountant asks for it. Some will not work from spreadsheets, and an accountant who works efficiently costs you less overall.

You cross roughly a hundred transactions a month. Manual entry stops being viable and errors creep in.

You want automatic bank feeds. That convenience is genuinely worth paying for once volume is high.

Until one of those applies, a well-maintained spreadsheet is sufficient, free, and gives you a much better understanding of your own numbers than software that categorises everything for you.

That understanding is worth having. Most freelancers who struggle with money are not earning too little — they simply do not know their numbers well enough to see the problem coming.