Home / Writing

Notion vs Spreadsheet for Freelancers: An Honest Split

The argument is usually about taste

Search for a comparison and you get two camps, each arguing from aesthetics. One says spreadsheets look dated, the other says Notion looks like a hobby. The honest answer for a one-person business is less exciting. Notion vs spreadsheet for freelancers is a question about jobs rather than tools, and the two tools are good at different jobs.

The short version: a spreadsheet does arithmetic better than anything else you can install this afternoon. Notion holds linked context and produces a page you can hand to a client. Most freelancers settle on a split within a year, and the ones who fight the split spend their Sundays copying numbers between the two.

Side by side

JobSpreadsheetNotion
Reconciliation and tax mathStrong: formulas, pivot tables, XIRRWeak: no pivot tables, no financial functions
Everything about one clientWeak: a tab per thing, no linksStrong: a client row that opens into projects and invoices
Client-facing status pageWeak: send a file and hopeStrong: a shared page with filtered views
Fast entry, 200 invoicesStrong: type and dragMedium: fine at hundreds of rows, slow beyond
Handing numbers to an accountantStrong: they expect a fileWeak: they will ask for a file anyway
Working from a phoneStrongMedium: views work, editing is cramped
CostFree or one-timePer seat, every month

The pattern is consistent. When the task is math over numbers you already have, the spreadsheet wins. When the task is context over records that point at each other, Notion wins.

Where a spreadsheet genuinely wins

Reconciliation is the clearest case. Matching bank lines to invoices is a cell-by-cell job, and a pivot table will group a year of expenses faster than any database view. Effective rate, tax set-asides, and collections math all live comfortably in a workbook. If you sell fixed-fee work, effective rate is the whole business, and the cash flow spreadsheet layout is still the fastest way to see it.

The second win is auditability. An accountant can open a sheet and check a formula in five seconds. They cannot check a rollup.

Where Notion genuinely wins

A client record that opens into everything else is a different data shape. Click a client, see the three active projects, the invoice that is 31 days late, and the last time you spoke. That is not a spreadsheet with a filter. The rollup setup is what makes it work, because rollups pull numbers up from linked rows instead of asking you to retype them.

The second win is the page you hand over. A filtered view shared with a client costs nothing to produce and updates itself. In a spreadsheet, that usually means exporting a PDF that is wrong by Tuesday.

Where each one breaks

Notion breaks on anything that needs dense arithmetic. Rollups sum and count; they do not do XIRR, they do not pivot, and a formula property cannot reach into an unrelated database without a relation in the middle. It also slows down past a few thousand rows.

Spreadsheets break on context. A workbook is a set of tabs with no relationships, so six months in you cannot answer "which client cost me the most" without building a summary tab you will not maintain. A shared sheet also invites someone to type over the formula column.

Notion vs spreadsheet for freelancers: the split that holds

The setup that survives a year, in order:

  1. Keep the ledger in a spreadsheet. Bank reconciliation, expense categories, tax set-aside. One file, one account, one number of record for cash.
  2. Keep clients, projects, deliverables, and the pipeline in Notion. These are records that point at each other.
  3. Keep invoices in exactly one place. If accounting needs a sheet, export monthly instead of running both.
  4. Write down which system owns cash. Two answers to that question is how the two systems drift apart.

The invoice question is the one people get wrong. Track invoices in Notion so you have a follow-up view, but let the spreadsheet hold the payment that actually cleared. Then the aging number and the bank balance agree, which is the whole point of the exercise. The DSO explainer has the arithmetic if you want to know how slow payment really is, and the invoice tracker template is a reasonable starting file if the ledger already works.

Do not migrate history

Move the current quarter, not three years of invoices. Historical rows in a new system generate work and answer no question you have. The one exception is a client list you will genuinely use for follow-up, because a client list is a working document rather than a record.

Migration also has a trap in the other direction. Rebuilding your ledger inside Notion looks tidy and then fails on the first reconciliation, because databases are not built for cell-by-cell matching. Keep the math where the math is fast.

Pick one number of record per question

The split fails in one specific way: two systems answer the same question and the answers disagree. Decide, for each of the three questions below, which system owns the answer.

  • How much cash do I have? The spreadsheet.
  • Who owes me money and how late? Notion, because the follow-up view is the reason to know.
  • What am I working on next week? Notion, because the task list lives there.

Write those three lines at the top of each system. When a number is in dispute, the line tells you which one to trust, and the other one is just a view.

Do this today

  1. List the five questions you ask every week and mark each as math or context.
  2. Put the context questions in Notion and the math questions in one spreadsheet you do not split.
  3. Delete the duplicate tracker you are currently keeping in both places.