Guide
Freelance Tax Prep Spreadsheet: Income by Client, Deductions, and a Set-Aside Log
Not a guide to what you owe — a guide to having clean, organized numbers ready when someone qualified tells you. Three things make up a real freelance tax-prep spreadsheet: income broken out by client, expenses in generic categories, and a running log of what you've already set aside.
This is not tax advice. Nothing here tells you what's deductible, what percentage to reserve, or what you actually owe — those depend on where you live, how your business is structured, and your specific circumstances, none of which a generic article can see. What this page covers is the record-keeping structure: how to organize a year of freelance income and expenses so that whoever prepares your taxes is working from clean totals instead of a shoebox of invoices and bank statements.
Why "income by client" matters more than one annual total
A single number — "I made $58,000 this year" — is technically income, but it's not useful income. Breaking that same total down by client does two things a lump sum can't. First, it gives you something to check against any statement or form a client sends you at year end, so a mismatch gets caught as one row to investigate rather than buried in a total that happens to look about right. Second, it shows you concentration — if one client is 70% of your income, that's a business fact worth knowing regardless of taxes, and it falls straight out of a log that was already tracking client alongside amount.
The mechanics are simple: every income row gets a Date, a Client, a Category (what kind of income it was — client work, a retainer, a product sale), and an Amount. Keep the client name consistent — the same spelling every time — the same discipline that matters for property names in a rental spreadsheet or vendor names in any expense log. A flat list like that is easy to sort or filter by client whenever you need a per-client total; whether your particular spreadsheet also rolls that up into its own automatic table is worth checking rather than assuming.
Generic deductible categories — and their limits
A workable expense category list for most freelance businesses runs somewhere around a dozen: things like Software, Equipment, Marketing, Insurance, Contractors, Office, Travel, Education, Fees, Phone/Internet, Health, and a catch-all Other. That list is generic on purpose — it's built to be a recognizable starting point across most freelance businesses, not a definitive statement about what's deductible for yours.
That distinction matters and is easy to blur. A category label like "Travel" or "Education" describes what the money was spent on; it says nothing about whether that spending is actually deductible where you live, at what rate, or under what conditions. Two freelancers in different countries — or different states, or different business structures — can have identical Travel line items and completely different deductibility rules apply to them. Use the categories to keep your spending organized and searchable. Use a licensed accountant or tax preparer to tell you which categories, and which specific line items within them, actually reduce what you owe.
The set-aside log: proof the habit is actually working
Setting aside a percentage of every payment for taxes is a habit, covered in full in our guide on how much freelancers should set aside for taxes — including why it has to happen per payment rather than once a month, and why the percentage itself isn't something a generic page can tell you. A tax-prep spreadsheet's job is to be the record of that habit: a payments log with a date, client, and gross amount, plus a formula column that works out the reserved amount from whatever percentage you've told it to use. Log every payment there and you get a running year-to-date total of what should currently be sitting in your tax savings account — a number worth checking against the account itself periodically, because a mismatch usually means a transfer got missed.
Worth being precise about what this log does and doesn't do: it calculates a reserved amount from a percentage you supply — it doesn't know what percentage is correct for you, and it doesn't calculate your actual tax liability. Those are two different numbers. The set-aside amount is a conservative cushion you control; the actual liability is a figure only a tax filing, prepared with real knowledge of your situation, can produce.
What to actually hand your accountant
At year end, three organized totals are what turn a stressful handoff into a routine one:
- Total income, by category and by client. The client breakdown lets them cross-check against any statement or form they've received about you; the category breakdown shows the shape of your revenue.
- Total expenses, by category. Not a pile of receipts — a totaled figure per category, with the receipts available if something needs backing up.
- Your set-aside log. What's been reserved for taxes so far, so they can see whether it's likely to cover what you'll actually owe or whether an adjustment is needed for next year.
What you shouldn't hand over is a guess dressed up as a number — "I think I owe about $9,000" isn't a record, it's an assumption. Organized totals let your accountant do the part that's actually theirs: working out what you owe, not reconstructing your year from memory first.
A simpler starting point
If a full monthly system feels like more than you need right now, the free income & expense tracker on this site is a reasonable place to start logging — one flat Transactions tab with a Type and eight fixed categories covering both income and expenses. It's genuinely simple: no client column, no set-aside math, no monthly tabs. That's fine for getting the habit of logging started, but once you want income broken out by client and a set-aside log running alongside it, that's a different, more structured tool than a flat generic log.
What this doesn't cover
This is a guide to organizing freelance records, not a guide to filing taxes. What counts as income, what's deductible, what percentage to set aside, and how a freelance business should be reported all depend on rules that vary by where you live and how you're structured — none of which a spreadsheet or this article can tell you. Keep clean, organized, client-and-category-level records and bring them to a qualified accountant or tax preparer; deciding how the numbers get reported is their job.
Frequently asked questions
What does "income by client" mean, and does a spreadsheet total it per client automatically?
It means every income row carries a Client column alongside the date, category, and amount — so instead of one lump annual figure, you can see and sort exactly what each client paid. A simple monthly log gives you the raw, filterable data for that; it doesn't necessarily roll clients up into their own automatic dashboard total the way it rolls up categories. If you want a total per client, sort or filter the log by that column — the data is there, but check whether your specific spreadsheet builds the summary table for you or leaves that as a manual step.
Are generic deduction categories in a template safe to use for filing taxes?
The categories themselves are just labels for organizing your spending — Software, Equipment, Travel, and similar groupings that most freelance businesses recognize. Whether a given expense is actually deductible, and how much of it, depends on tax rules that vary by where you live and how your business is structured, which no generic category list can determine. Use the categories to keep clean, organized records; get a licensed accountant or tax preparer to confirm what's actually deductible for your situation.
What's the difference between a tax set-aside log and the general set-aside habit?
The habit is the discipline — move a percentage of every payment into a separate account the moment it lands, so the money is never available to spend. A set-aside log is the record of that habit in action: a row per payment with the gross amount and the reserved amount calculated next to it, plus a running year-to-date total. The log doesn't create the habit on its own — you still have to actually move the money — but it does make it obvious at a glance whether the number sitting in your tax account matches what should be there.
What should I actually hand my accountant at year end?
Three totals, organized rather than raw: total income for the year, broken out by category and by client if you've kept that column; total expenses for the year, broken out by category; and your set-aside log showing what's been reserved for taxes so far. That's a complete, organized picture an accountant can work from quickly. What you shouldn't hand over is a guess at what you owe — figuring out the actual tax liability from those totals is exactly the part that belongs to them, not a spreadsheet.
Does a tax-prep spreadsheet calculate what I actually owe in taxes?
No. It organizes and totals the numbers — income by category and client, expenses by category, a percentage reserved from each payment — but it doesn't know your tax bracket, your local rules, your business structure, or whether you owe income tax, self-employment contributions, or both. Those depend on where you live and your specific circumstances. The spreadsheet's job is to make sure the underlying numbers are clean and complete when you sit down with someone qualified to work out what you actually owe.
Can I use a freelance tax-prep spreadsheet if I'm self-employed outside the US?
Yes — logging income by client and category, expenses by category, and a percentage set aside from each payment is a structure that works regardless of country, because none of it depends on any specific tax code. What changes by location is what percentage to set aside, which categories are actually deductible, and how the numbers get reported — all questions for a licensed accountant or tax preparer where you live, not something a generic spreadsheet template can answer.
Want the client log, the set-aside log, and the deduction categories already built?
The Freelancer Finance Toolkit's Income & Expense Tracker logs income with Date, Client/Source, Category, and Amount columns across twelve monthly tabs, with 6 editable income categories and 12 editable expense categories, and a Year Dashboard that totals income and expenses by month, by category, plus a best-income-month and highest-expense-month highlight. Alongside it, the Tax Set-Aside Calculator logs every payment with Date, Client, and Gross Amount, then works out a tax set-aside and a separate savings set-aside from percentages you set yourself, with a running year-to-date total and a monthly breakdown — worth knowing plainly, it doesn't roll income up by client automatically on its own summary tab; the Client column is there for you to sort and filter. A Client & Invoice Tracker and Rate Calculator ship in the same toolkit.
One-time purchase. No subscription. It's a set of spreadsheets — not tax software, and not tax advice.
Need a spreadsheet built around your exact business instead? We build custom workbooks to order, delivered in 5 business days.