How do I track income and expenses as a freelancer in a spreadsheet?

Create two tabs: an Income tracker with columns for client, project, amount, and date paid; and an Expense tracker with amount, date, and a category column for tax type (software, equipment, travel, etc.). A formula on a monthly dashboard subtracts total expenses from total income to show your real profit. Tag everything as it happens so month-end is just a review, not a reconstruction.

Should I use Notion or a spreadsheet for freelance bookkeeping?

Both can work, but a spreadsheet wins for most freelancers doing money math: Google Sheets and Excel are built for exactly this — summing income, categorizing expenses, and calculating a tax set-aside — and they open on any device with no learning curve. Notion is nice if you already live in it, but a spreadsheet is faster to start and the tool we recommend and sell here.

How do I set aside money for quarterly taxes as a freelancer?

Add a Tax Fund tab that multiplies each payment by your estimated tax rate (many US freelancers set aside 25–30%, but your rate depends on your income and situation — this is not tax advice). Log the set-aside amount every time a client pays, and check the running total against your quarterly deadlines. A formula automates the percentage so you never forget.

Can a spreadsheet template replace accounting software like QuickBooks?

For a solo freelancer with straightforward finances, a well-built Google Sheets template can replace accounting software for day-to-day income, expense, and invoice tracking. It is a tracking tool, not tax-filing software or an accountant — at tax time you (or your accountant) still file the return. Many freelancers track all year in the sheet and hand the clean totals to a professional in April.

The Best Freelancer Finance Tracker Template (Google Sheets, 2026)

Last updated July 7, 2026

A freelancer finance tracker template needs four linked tabs: an Income tracker (by client and project), an Expense tracker (tagged by tax category), an Invoice log (paid / unpaid / overdue), and a Tax Fund that sets aside a percentage of each payment for quarterly taxes. Connect them to a dashboard that shows gross-vs-net profit by month. Build it in a Google Sheet in a few hours, or start from a pre-built template and make a copy in one click (it also downloads as Excel).

Most freelancers don't have a bookkeeping problem — they have a visibility problem. The money comes in, the expenses go out, and somewhere in there is a real profit number and a real tax bill, but nobody can see either until it's too late to do anything about them. A freelancer finance tracker template fixes that by putting all four moving parts — income, expenses, invoices, and taxes — in one spreadsheet you already know how to use.

This guide shows you exactly what to build in Google Sheets. If you'd rather skip the build, the Freelancer Finance OS is this exact system, ready to copy (and it downloads as Excel too).

The four tabs every freelancer tracker needs

1. Income (by client and project)

A tab with: client, project, amount, invoice date, date paid, status. This is the foundation — every other view pulls from it. Filter it by "paid this month" for a running income total, or sort by client to see who actually pays your bills.

2. Expenses (tagged by tax category)

A tab with: description, amount, date, and — critically — a category column for tax type (software, equipment, home office, travel, contractor, etc.). Tagging as you spend is the single highest-leverage habit here: it turns tax prep from a weekend of receipt archaeology into a sort.

3. Invoices (paid / unpaid / overdue)

A tab (or a filtered view of income) that surfaces what you're owed. The status column — unpaid, paid, overdue — is what stops money from slipping through the cracks. A filter on "overdue" is your follow-up list.

4. Tax Fund (set aside as you go)

A tab that takes a percentage of each payment and logs it as "set aside." The point is behavioral: money you've mentally moved to the tax pile doesn't get spent. (How much to set aside depends on your income and situation — this is not tax advice; confirm your rate with a professional.)

Wire it into a dashboard

The magic is the gross-vs-net dashboard: a monthly tab that sums income, subtracts expenses, and shows your real profit — with the tax set-aside already accounted for. That one screen answers the question every freelancer actually has: what did I really make this month, and how much of it is mine to keep? Spreadsheet formulas (SUMIF, SUMIFS) do all of this automatically once the tabs are in place.

Build it, or copy it

You can build the above in an afternoon if you're comfortable with spreadsheet formulas. If you'd rather start Monday with it already working, the Freelancer Finance OS is exactly this — four linked tabs, the dashboard, and a PDF setup guide — as a one-click Google Sheets copy, with an Excel version in the same download.

For deeper dives, see the guides on tracking freelance income in a spreadsheet, spreadsheet vs Notion for bookkeeping, and setting aside quarterly taxes.

Frequently asked

How do I track income and expenses as a freelancer in a spreadsheet?: Create two tabs: an Income tracker with columns for client, project, amount, and date paid; and an Expense tracker with amount, date, and a category column for tax type (software, equipment, travel, etc.). A formula on a monthly dashboard subtracts total expenses from total income to show your real profit. Tag everything as it happens so month-end is just a review, not a reconstruction.
Should I use Notion or a spreadsheet for freelance bookkeeping?: Both can work, but a spreadsheet wins for most freelancers doing money math: Google Sheets and Excel are built for exactly this — summing income, categorizing expenses, and calculating a tax set-aside — and they open on any device with no learning curve. Notion is nice if you already live in it, but a spreadsheet is faster to start and the tool we recommend and sell here.
How do I set aside money for quarterly taxes as a freelancer?: Add a Tax Fund tab that multiplies each payment by your estimated tax rate (many US freelancers set aside 25–30%, but your rate depends on your income and situation — this is not tax advice). Log the set-aside amount every time a client pays, and check the running total against your quarterly deadlines. A formula automates the percentage so you never forget.
Can a spreadsheet template replace accounting software like QuickBooks?: For a solo freelancer with straightforward finances, a well-built Google Sheets template can replace accounting software for day-to-day income, expense, and invoice tracking. It is a tracking tool, not tax-filing software or an accountant — at tax time you (or your accountant) still file the return. Many freelancers track all year in the sheet and hand the clean totals to a professional in April.

Keep reading

Ready to shop? See the gear →