If you've been freelancing for more than a few months, you know the feeling: a client emails asking about an invoice you're not sure you sent. A project deadline sneaks up because it was buried in a note somewhere. You check your bank account and can't tell if that deposit was from the March project or the April one.
It's not that you're disorganized. It's that freelancing forces you to be a designer AND an accountant AND a project manager AND a sales team — all at once, with no system holding it together.
I spent way too long managing my freelance work across scattered tools: spreadsheets for invoices, a to-do app for tasks, email threads for client info, a notes app for project details. Everything lived somewhere different, and nothing talked to anything else.
So I built a system in Notion that connects everything into one workspace. Here's the framework behind it — whether you use my template or build your own.
The 5 things every freelancer needs to track
After trying dozens of setups, I landed on five core areas. Not more, not less. Every piece of freelance admin falls into one of these:
1. Clients
Not just names and emails — you need to see a client's full picture at a glance. Are they a lead, active, or past? What's their rate? What projects have you done for them? What invoices are outstanding?
Most freelancers track this in their head until they have 5+ clients. Then things start slipping.
The fix: A single client database where every client links to their projects and invoices. You click on "Acme Co" and see everything — every project, every invoice, every payment — without searching.
2. Projects
Every piece of work needs a status (not started, in progress, completed, on hold), a deadline, a fee, and a connection to the client who's paying for it.
The key insight: projects aren't tasks. "Website Redesign" is a project. "Design the homepage" is a task inside that project. Mixing these up is why most freelancer to-do lists become unusable.
The fix: A project pipeline with both a table view (for detail) and a kanban board (for a visual overview of what's where). Each project links to its client.
3. Tasks
The daily work. Each task belongs to a project, has a priority, a due date, and a status. You need two views: a flat list for "what do I need to do today?" and a board for dragging things between To Do, In Progress, and Done.
The fix: A task database linked to projects, with a kanban board view. Filter by "not done" and you have your daily action list.
4. Invoices
This is where most freelancers lose money — literally. You finish a project, forget to invoice for two weeks, then can't remember the exact amount or what it was for.
Every invoice should link to both the client AND the project, have a clear status (draft, sent, paid, overdue), and show the amount and dates.
The fix: An invoice tracker that connects to both clients and projects. You can see all unpaid invoices in one view, and every invoice traces back to the work it covers.
5. Finances
Income and expenses in one place. The critical feature most freelancers miss: linking income entries to their invoices. When a payment lands, you mark which invoice it covers. Now you can trace the full path: Client → Project → Invoice → Payment.
Expenses get tracked separately with categories (software, marketing, education, office). Come tax time, you have everything in one place instead of scrolling through bank statements.
The fix: A finance database with income linked to invoices, and expenses categorized. You can see your net position at any time without opening a spreadsheet.
Why connected databases matter
The magic isn't in any single database — it's in the links between them. When you click on a client, you see their projects. Click a project, you see its tasks and invoices. Click an invoice, you see the payment.
This means:
- You never lose track of what you owe or what you're owed
- Every task traces back to a project and a paying client
- Your finances connect to real work, not just anonymous numbers
- Status changes in one place make sense everywhere else
If you've tried building something like this in spreadsheets, you know it falls apart fast. Spreadsheets don't link. Notion does.
The system I built
I put this exact framework into a Notion template called Freelance OS. It has all five databases pre-built and connected, filled with sample data so you can see how it works before swapping in your own info.
It includes:
- Client manager with status tracking
- Project pipeline (table + kanban)
- Task manager with priority levels and board view
- Invoice tracker linked to clients and projects
- Finance tracker with income linked to invoices
- Setup guide to get running in 5 minutes
It works on Notion's free plan and takes about 5 minutes to set up.
If you want to skip building this yourself: Get Freelance OS here
Or build your own
If you prefer to build it yourself, here's the order that works best:
- Clients first — this is the foundation everything links to
- Projects second — add a relation column pointing to Clients
- Tasks third — add a relation column pointing to Projects
- Invoices fourth — add relations to both Clients AND Projects
- Finances last — add a relation to Invoices for income entries
Build in this order because each database links to the one before it. If you try to build finances first, you'll have nothing to connect it to.
The most important Notion feature to learn: relations and rollups. Relations link databases. Rollups pull data from linked entries (like summing all invoice amounts for a client). These two features turn five separate tables into one connected system.
The takeaway
Freelancing doesn't have to mean chaos. The moment you connect your clients to your projects to your invoices to your money, everything gets simpler. You spend less time on admin and more time on the work that actually pays.
Whether you build this yourself or grab the template, the framework is the same: five databases, all connected, one home for everything.
If you found this useful, I'm building more tools for freelancers. Follow me here or check out Freelance OS on Gumroad.
Top comments (0)