Freelancer Bookkeeping Made Simple: Track Income, Expenses & Tax in One Spreadsheet (2026)

Published May 31, 2026

Disclosure: Some links below are affiliate links. If you sign up through them we may earn a commission at no extra cost to you. We only recommend tools we'd genuinely suggest to a friend. See our full disclosure.

If you freelance, sell on Etsy, run a print-on-demand shop, or earn on the side, the bookkeeping question creeps up fast: am I actually making money, and how much should I keep for tax? You don’t need accounting software or a course to answer that. You need one clean system you’ll actually keep up with. Here’s the simple version.

What to track (and what to ignore)

Two things, consistently:

1. Income — every payment you receive: the date, who it’s from (client or platform), an invoice number if you have one, and the amount. (If you’re not invoicing clients with sequential numbers yet, start — it makes this record far cleaner.)
2. Expenses — every business cost: the date, a category (software, fees, marketing, supplies…), a short description, and the amount.

That’s it. Don’t over-engineer it with 30 categories you’ll never use. The goal is a record you’ll actually maintain, because the best bookkeeping system is the one you don’t abandon by March.

The number that actually matters: profit

Revenue feels good, but profit (income minus expenses) is what you live on and what you’re taxed on. The moment you can see profit at a glance, two things happen: you price better, and you stop being surprised at tax time. So your system should total income, total expenses, and profit automatically — not make you add it up by hand.

One honest limit on that number, because it catches people out: profit puts the cost of a job and the payment for that job in the same reckoning, which is exactly right for judging whether the work was worth doing — and is not how your bank account experiences it. You pay the costs while you work and get paid weeks after you finish. So a genuinely profitable freelancer can still be short in a specific week without anything going wrong, and no backwards-looking record will ever warn them. That second question — will the money arrive before the bills do — needs a dated forward view, which is what freelance cash flow covers.

Set aside for tax as you earn

The classic freelancer mistake is spending the whole payment, then panicking when tax is due. The fix is boring and works: every time you get paid, move a percentage of the profit into a separate “tax” pot. A common starting point is 25–30%, but your real rate depends on where you live and what you earn — check your tax authority or accountant. The habit matters more than the exact figure: pay your future self first.

Review monthly, not yearly

Spend ten minutes at the end of each month: log anything you missed, glance at profit and margin, and confirm your tax pot matches what you’ve set aside. A monthly rhythm turns tax season from a frantic shoebox-of-receipts weekend into a non-event.

It’s also the natural moment to export your order records from wherever you sell, since you’re already in that account looking at exactly those numbers. Attaching the export to a habit you already have is the only version of backing up your business that survives past the second month — and those records are your evidence as well as your customer list.

A second thing worth pulling out of the same data once a quarter, since the income column is already in front of you: what share of the last six months came from your single largest client. A monthly review shows you the total and never the composition, which is why almost nobody knows their own answer — see client concentration risk for the test that beats a percentage.

Keeping the records outside the tools also matters for a reason that only shows up once: retention doesn’t end when trading does. Tax and accounting rules generally expect records to survive for years after the last invoice, and they are usually sitting inside a payment processor and a storefront that get cancelled first when someone closes a business down. A monthly export habit is what makes that a non-issue rather than a scramble.

One thing a monthly review will never show you, though: an annual subscription only appears in the single month it’s charged, so it reads as a one-off rather than a commitment. That’s why the software line is worth a separate look once a year — auditing your subscriptions is the step where you stop recording that expense and start deciding whether it should still be there.

The simplest tool to do all of this

You can build this yourself in a free spreadsheet — two tabs and a few SUM formulas. Prefer pen and paper? Our free printable income & budget tracker gives you an income log, an expense log, a monthly profit summary and a tax set-aside reminder to fill in by hand — no signup. If you’d rather have the numbers total themselves, we made a done-for-you Business & Freelancer Income & Expense Tracker: log income and expenses and it instantly shows total income, total expenses, net profit, profit margin, and an estimated tax set-aside (you set the %). It works in Excel, Google Sheets and Apple Numbers, with no macros.

If you also want your personal money handled, it’s part of our Money & Productivity Bundle alongside a budget dashboard, a debt payoff tracker and a daily planner. Either way, the method above is what keeps you out of trouble — the tool just saves you the setup.

(Wondering whether you also need to formally register a company to do any of this? Usually not to start — in many places you can earn as a self-employed individual and keep records like this from day one. Here’s the plain-English take on registering a business to sell online.)

The bottom line

Freelance bookkeeping doesn’t need to be complicated: log income and expenses as they happen, watch profit (not just revenue), set aside tax money the moment you’re paid, and review for ten minutes a month. Do that and you’ll always know where you stand — and tax time stops being scary. Start with one simple spreadsheet today; you can upgrade to software later if you ever outgrow it.