✧ Key takeaways
Three linked databases — Clients, Projects, Tasks — plus one dashboard page is all a freelancer needs to run their business in Notion's free plan.
Most freelancers do not have a client management problem. They have a remembering problem: which client asked for what, which project is waiting on whom, and which invoice is two weeks overdue. The work itself is fine — the tracking is where things quietly fall apart.
Notion fixes that without another subscription, because the free plan for individuals covers everything in this setup. Three linked databases — Clients, Projects, Tasks — plus one dashboard page, and you have a tracker that shows your whole business every morning. This guide builds it step by step, in about an hour, with no template download and no paid plan.
What you need before you start
A free Notion account and a list of your current clients and active projects — even a rough one. Do not start by designing the perfect system. Start with the real work you already have, because a tracker built around imaginary projects gets abandoned the first time a real deadline hits.
One decision first: this tracker is for you, not your clients. Clients will see single shared pages later, but the databases stay private. That separation is what keeps the system simple — you never have to worry about a client seeing your internal notes or your rate calculations.
If you are still deciding which tools deserve a place in your business at all, our guide to choosing AI tools for freelancers and small businesses covers how to pick tools that earn their keep instead of piling up subscriptions.
Step 1: Create the three databases
In a fresh Notion page, create three full-page databases. Name them Clients, Projects, and Tasks. Keep them as separate pages for now — you will pull them together into a dashboard at the end.
For Clients, add these properties: Name (title), Contact (email), Status (select: Active, Paused, Past), Rate (number, your hourly or project rate), and Notes (text, for anything you need to remember — time zone, preferred contact method, how they found you). Five properties is enough. More fields mean more friction every time you add a client.
For Projects, add: Name (title), Client (relation — covered in step 3), Status (select: Not started, In progress, Waiting on client, Done), Deadline (date), Value (number, the project fee), and Type (select: one-off, retainer, ongoing). The Value field is the one most freelancers skip, and it is the one that tells you whether your month is actually profitable.
For Tasks, add: Name (title), Project (relation), Status (select: To do, Doing, Done), Due date (date), and Priority (select: High, Medium, Low). Tasks are the smallest unit — a single deliverable, not a whole project. If a task takes more than a day, split it.
Step 2: Set up the views you will actually use
A database without views is a spreadsheet, and nobody opens a spreadsheet for fun. Set up two views per database, and stop there.
For Tasks, add a Kanban board grouped by Status. This is your daily view: what is in progress, what is stuck, what is done. Add a calendar view grouped by due date, so deadlines stop sneaking up on you. When a task has no due date, it has no place on the calendar — which is exactly the point.
For Projects, add a table view filtered to Status is not Done, sorted by Deadline. That is your pipeline. Add a second view grouped by Client, so you can see at a glance which client is getting most of your hours — useful when one client quietly becomes 80% of your income.
For Clients, a simple table is enough, sorted by Status. Active clients on top, past clients at the bottom where they belong.
Step 3: Link them with relations
Relations are the feature that turns three lists into one system. In the Projects database, the Client property is a relation to the Clients database — pick the client, and the project knows who it belongs to. In the Tasks database, the Project property is a relation to the Projects database.
Once the relations exist, add one rollup: in Projects, roll up the Tasks relation to count tasks, or sum the hours if you track them. Now a project shows its own progress without you updating anything by hand. The point of relations is that you enter each fact once and it shows up everywhere it matters.
Do not overbuild this. One relation per link, one rollup where it clearly helps, and move on. The freelancers who abandon Notion are usually the ones who built a second job out of maintaining it.
Step 4: Build the dashboard page
Create a new page called Dashboard. This is the page you open every morning, so it should answer three questions: what is due, what is waiting, and what is making money.
Add three linked views of your databases: Tasks filtered to Due date is this week and Status is not Done; Projects filtered to Status is Waiting on client; and Projects as a table sorted by Value, so the month's money is visible. Add a short text block at the top with your current priorities for the week — three lines, rewritten every Monday. A dashboard that never changes is a dashboard you stop reading.
Keep the dashboard to one screen. If you have to scroll past two screens of widgets to find today's work, the dashboard has failed.
Step 5: Add templates for repeat work
Every new client follows the same steps, so make a template for it. In the Clients database, create a template called New Client that opens a page with a checklist: send contract, collect deposit, confirm scope, set up project page, add to invoicing. Same for Projects: a New Project template with a standard task list — kickoff, first draft, review, revisions, delivery, invoice.
Templates are where the time saving actually happens. Setting up a client goes from twenty minutes of remembering what you usually do to two minutes of clicking through a checklist you already wrote.
Step 6: The 15-minute Friday review
A tracker only works if it stays current, and it only stays current if the review is short enough to actually happen. Every Friday, spend fifteen minutes on four things: close finished tasks, move stalled projects to a follow-up list, update the status of anything waiting on a client, and check the Value column against the invoices you sent.
That last check matters most. A project marked Done with no invoice sent is unpaid work, and the Friday review is where you catch it. Skip two Fridays and the tracker becomes a graveyard of stale statuses — which is when most people declare the system does not work and go back to sticky notes.
Linking invoices to projects
Money tracking is where most freelance systems quietly fail: the project is marked done, but nobody checks whether the invoice went out. Add a simple habit to close the loop. In the Projects database, add a select property called Invoiced with two options: Yes and No. When a project reaches Done, the Friday review checks the Invoiced column — anything marked Done with Invoiced set to No gets an invoice that day.
If you use Wave or FreshBooks for invoicing, keep the invoice itself in that tool and use Notion only for the status. Duplicating numbers across two systems is how they drift apart. Notion answers whether the invoice went out; the accounting tool answers how much and when it was paid. One fact, one home.
Sharing progress with clients
Share a single page, never the workspace. For a client who wants visibility, create a project page with a linked view of their tasks filtered to their project, set it to read-only, and share the link. They see progress without seeing your other clients, your rates, or your internal notes.
Do not give clients edit access to your databases. Read-only sharing is the whole point of the separation you set up in step one.
Mistakes that kill a Notion tracker
Too many properties. Every field you add is a field you must fill. Start with the five per database listed above and add a new one only when you have missed it three times.
Tracking everything. Notion can track your reading list, your meals, and your gym routine. Keep this workspace for business. A second workspace for life is fine; mixing them is how the dashboard turns into noise.
No weekly review. Covered above, but it bears repeating: the review is the system. Without it, you have a database, not a tracker.
Notion vs Todoist vs ClickUp
Notion is the right call when you want one place for client notes, project docs, and tasks together. If you only want a fast task list with reminders, Todoist is simpler and faster — it does one thing and gets out of the way. If you need time tracking, team workflows, and built-in reporting, ClickUp covers more ground, with a steeper learning curve to match. None of them is wrong; they solve different problems, and the honest test is which one you still open in a month.
The bottom line
Three databases, one dashboard, two templates, and a fifteen-minute Friday review. That is the whole system. Build it with your real clients and real projects today, use it for two weeks before changing anything, and let the Friday review tell you what is missing. A tracker you actually open beats a perfect one you abandon — and the free plan means the only cost is the hour it takes to set it up.
Frequently asked questions
Do I need a paid Notion plan to build a client and project tracker?
No. The free plan for individuals covers unlimited pages and blocks, databases, relations, and views — everything in this setup.
How long does it take to set up?
About an hour for the basic version: three databases and a dashboard. Add templates and saved views in a second pass once you have used it for a week.
Can I share project progress with clients from Notion?
Yes — share a single read-only page or a filtered view with a client. Keep your internal databases private and never share the whole workspace.
Setup verified against Notion's current free plan and database features. Notion's plans and limits change — check the official site for current terms.