How to track freelance invoices and payments in Notion (and stop chasing clients)
Losing track of which invoices are paid and which aren't is one of the most expensive mistakes a freelancer can make. Here's how to fix it with Notion.
There’s a conversation almost every freelancer has had: “Hey, how much do I owe you exactly?” And you, in that moment, open your email, your spreadsheet, your WhatsApp, search through Drive… and take three minutes to answer something as basic as how much money you’re owed.
That’s not a memory problem. It’s a system problem.
The real cost of not tracking your payments
It’s not just about invoices you collect late. It’s about the ones you collect incorrectly, the ones you forget to chase, the clients who “will pay you next month” and suddenly two months have gone by without payment.
Without a clear system, you lose money. Not all at once — in small amounts that accumulate.
What information you need accessible at all times
To properly track your income as a freelancer, you need to know at any moment:
Per client: how much money is outstanding, which invoices are issued and unpaid, and whether any have been overdue longer than agreed.
Per project: what percentage of the total agreed amount you’ve already invoiced and how much remains to invoice.
In total: how much you’ve earned this month, this quarter, this year. And how much is currently outstanding.
If you can’t access that information in under 10 seconds, your invoicing system isn’t working.
How to set it up in Notion
The structure that works has three connected pieces:
Clients database — with name, relationship status, and a calculated field that automatically sums everything they currently owe you.
Projects database — linked to clients. With the agreed price, percentage completed, and amount already invoiced.
Invoices database — linked to projects. With invoice number, amount, issue date, due date, and status: Issued / Paid / Overdue.
With this structure and some basic formulas, Notion automatically calculates:
- Total outstanding per client
- Whether any invoice has passed its due date
- How much you’ve invoiced this month vs. last month
- Which projects have outstanding amounts to invoice
The field that changes everything: “Days overdue”
If you add a formula that calculates how many days an invoice has gone unpaid since its due date, you stop having to remember who owes you what. Notion tells you.
You can sort your invoice view by that column and see at a glance which clients have gone the longest without paying. That turns an awkward conversation into routine management.
If you don’t want to build it from scratch
Setting up this system properly — with the relationships between databases, formulas, and correct views — takes time. Time you could spend on client work.
Freelance CRM Pro already includes all of this ready to use: the invoice database with overdue tracking, linked to projects and clients, with automatic calculations already configured.
Ready to use in one minute.
→ Get Freelance CRM Pro on Gumroad
And if what you’re missing isn’t knowing who owes you what, but the tax side — how much VAT and income tax you owe each quarter — a CRM won’t solve that. That’s what the Freelance Finance Tracker is for: it automatically calculates VAT and tax per invoice and gives you a quarterly summary ready to file.
→ Get the Freelance Finance Tracker on Gumroad
How long does it take you right now to know exactly how much you’re owed? If the answer is “more than 10 seconds,” there’s room for improvement.