Articles·Early preview

Notion vs Spreadsheets for Freelancer Cashflow

Affiliate disclosure: This article may contain affiliate links and links to products sold by the site owner (Andrew / NDYT on Gumroad). If you buy through affiliate links, we may earn a commission at no extra cost to you. This is not financial, tax, or legal advice. Australian freelancers should confirm ABN/GST obligations with a registered tax agent or accountant.

Ask a room of Australian freelancers how they track cashflow and you will hear two proud camps: “Google Sheets forever” and “Everything lives in Notion.” Both can work. Both can fail. The useful question is not which tool is morally superior — it is which job you are hiring the tool for.

This guide compares Notion and spreadsheets for freelancer cashflow visibility (money in, money overdue, near-term outlook). It complements — not replaces — proper bookkeeping software. If you need BAS-ready ledgers, talk to your accountant and use their stack. If you need to stop being surprised by empty weeks, keep reading.

What “cashflow tracking” means here

We are talking about operational answers:

• Who owes me what, and when?
• What is likely to land in the next 14–30 days?
• Did I already chase this invoice?
• Roughly, can I afford that course / contractor / tax bill?
• Which clients are quietly becoming financing vehicles for my business?

We are not talking about audited financial statements, depreciation schedules, or inventing GST engines in Notion formulas.

Where spreadsheets win

Strengths

• Grid-native maths: running balances, simple forecasts, SUMIFS comfort
• Easy export/import with banks and accountants
• Everyone already knows the metaphor
• Versioning via Drive history; easy to duplicate “FY26 forecast” copies
• Lightweight scenario planning (“what if 2 invoices slip 30 days?”)
• Printable or shareable with a bookkeeper who refuses another SaaS login

Weaknesses

• Becomes spaghetti when you also want CRM, tasks, and notes
• Relational data (client → many invoices → follow-ups) gets awkward
• Mobile editing of complex sheets is fiddly on site visits
• No pleasant “dashboard home” unless you build one carefully
• Easy to create five competing “master” tabs and trust none

Best spreadsheet jobs: 12-month cash outlook, fee calculators, tax savings scenarios, one-tab invoice registers for ultra-minimalists, pricing experiments before you publish a rate card.

Where Notion wins

Strengths

• Relations: Client ↔ Project ↔ Invoice ↔ Follow-up feel natural
• Beautiful filtered views (Overdue, Due this week) non-technical people open daily
• Same place as your operating system — less context switching
• Page bodies hold nuance (AP contact notes, dispute history)
• Template buttons make “new invoice row” habitual

Weaknesses

• Formulas and rollups are clumsy compared with Sheets for forecasting
• Easy to fake precision with half-maintained properties
• Exporting clean tabular data to accountants can be fiddly
• Performance/clutter if you overload a single workspace
• Mobile apps are better than they were, still not Sheets-grid fluid for heavy edits

Best Notion jobs: invoice status cockpit, follow-up dates, linking money to projects, weekly review prompts, surfacing overdue items beside tasks.

Recommended hybrid (what most solos should do)

Use Notion as the cockpit and a single spreadsheet as the forecast engine.

Once a week: update Notion statuses → skim Overdue → copy Paid totals into the Sheet’s “Actuals” column → glance at outlook → send any Reminder 2 due.

This hybrid avoids religious wars and matches how money actually behaves for AU freelancers with lumpy income.

Building the Notion side

Reuse the invoice database from the cashflow stack article:

• Amount AUD, Due, Status, Next follow-up, Client relation, GST flag, Payment method
• Views: Overdue, Follow-ups this week, Paid this month, Deposits outstanding

Add a Money pulse linked view on Home. That is 80% of the value. If you never open it, no formula will save you.

Documents clients receive still come from templates — Freelance Cashflow Pack — not from Notion print views. Notion shows status; PDFs request money.

Building the Sheet side

One tab Outlook:

• Columns: Week starting, Opening balance (manual), Expected inflows, Expected outflows, Closing (formula)
• Expected inflows reference invoices you believe will pay — be conservative (haircut optimistic dates by 7 days)
• Outflows: rent/software/tax scratchpad, not a second ledger

Another tab Scenarios with best/base/worst slippage assumptions. Twenty minutes monthly beats a fancy app you ignore.

Optional third tab Rates for package pricing maths before you update the public one-pager.

Migration paths

From Sheet-only → hybrid: Keep historical invoice tab frozen. New invoices go to Notion. Sheet reads weekly totals you paste (no fragile live API required on day one).

From Notion-only → hybrid: When you catch yourself building multi-month forecast rollups in Notion, stop. Spawn the Outlook sheet the same afternoon.

From nothing: Start Notion invoice board first (behaviour), add Sheet in month two (planning). Behaviour before forecasting — otherwise you will forecast fiction.

Anti-patterns to avoid

• Duplicating every Xero line into Notion “for completeness”
• Building a 26-tab Sheet empire with conditional formatting as a personality
• Forecasting with 100% invoice collection assumptions
• Tracking GST payable in three tools and reconciling none
• Letting your forecast Sheet become the place tasks go to die

Tooling around the edges

• Timers feeding billable reality: [AFFILIATE: Toggl | Toggl Track | placeholder] / [AFFILIATE: Clockify | Clockify | placeholder]
• Overseas rails: [AFFILIATE: Wise | Wise Business | placeholder] / [AFFILIATE: Airwallex | Airwallex | placeholder]
• Hardware for dual-monitor admin blocks: [AFFILIATE: Amazon AU | portable monitor | placeholder]

Decision checklist

Choose Sheet-heavy if you love grids, forecast weekly, and keep CRM elsewhere. Choose Notion-heavy if unpaid invoices hide in email and you need relational views. Choose hybrid if you are a typical AU solo with lumpy income and a real accountant — most readers of Solo Ops AU.

A 30-day challenge

Week 1: Notion invoice board only — every invoice logged same day. Week 2: Add follow-up dates and send sequence emails. Week 3: Birth the Outlook sheet with conservative inflows. Week 4: Compare forecast vs actual; adjust haircut rules.

At day 30, delete whichever views you never opened. Scarcity of widgets is a feature.

Closing

Notion vs spreadsheets is a false binary for cashflow. Notion excels at status and behaviour; spreadsheets excel at arithmetic foresight. Run both lightly, keep tax truth in proper books, and spend the time you save actually sending Reminder 2. Clarity compounds faster than tooling debates.

Related: stop chasing invoices, Solo OS guide, ABN/GST lite admin.