Freelancer Bookkeeping Made Simple: Track Income, Expenses & Tax in One Spreadsheet (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:
- Income — every payment you receive: the date, who it’s from (client or platform), an invoice number if you have one, and the amount.
- 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.
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.
The simplest tool to do all of this
You can build this yourself in a free spreadsheet — two tabs and a few SUM formulas. If you’d rather skip the setup, 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.
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.
Frequently asked questions
How do freelancers keep track of income and expenses?
The simplest reliable method is a single spreadsheet with two tabs — one for income (date, client, invoice, amount) and one for expenses (date, category, amount) — that totals profit automatically. Log every payment and cost as it happens, and review monthly. Apps work too, but a clean spreadsheet is free, private and good enough for most solo businesses.
How much should a freelancer set aside for tax?
A common rule of thumb is to set aside 25–30% of your profit (income minus expenses) for tax, but the right number depends on your country, income level and deductions. Move it to a separate savings account as you get paid so it's never a shock. Check your local tax authority or an accountant for your exact rate.
What expenses can freelancers usually claim?
Typically the ordinary costs of running your business: software subscriptions, payment-processing fees, advertising, supplies, a portion of home-office and internet costs, and professional fees. Rules vary by country — keep a record and receipt for everything and confirm specifics with your tax authority or accountant.
Do I need accounting software as a freelancer?
Not necessarily. When you're starting out, a well-structured spreadsheet that tracks income, expenses, profit and a tax set-aside is usually enough. Move to dedicated software when the volume of transactions or invoicing makes a spreadsheet slow — not before.