The first thing most freelancers do when they want to manage clients in Notion: they search for a CRM template.
It makes sense. A CRM sounds serious. It looks like what proper businesses use.
The problem: a CRM is designed for sales teams managing hundreds of prospects. You're managing ten active clients, maybe twenty. You don't need a twelve-stage sales pipeline.
You need to know, in thirty seconds, where each client relationship stands. That's it.
What a client database needs to do
Before creating a single property, one question: what does this database do in your daily workflow?
For a freelancer, a client database needs to answer three simple needs:
- Know who your active clients are right now
- Find contact and context information quickly
- Link through to the ongoing projects for each client
Nothing else is essential to start. If your system already does these three things cleanly, it works.
The essential properties
Placeholder: client database with essential properties visible.
An effective client database works with six to eight properties maximum. The essentials:
- Client name: the entry title, always
- Status: Prospect, Active, On hold, Done
- Client type: Company, Sole trader, Non-profit
- Main contact: name and email
- Start date: to know how long the relationship has existed
- Linked projects: a relation to your Projects database
Properties to avoid at the start: priority score, closing probability, acquisition source, projected budget. This information can have value, but if you don't update it regularly, it creates the illusion of tracking without actually providing any.
Start with less. Add a property only when you notice you're searching for that information on a regular basis.
The view that changes everything in daily use
A database without a useful view is just a list. It doesn't help you make decisions.
The simplest and most useful view for daily work: a table filtered to clients with the "Active" status. You open Notion. You see your active clients. You immediately know what you're working on.
Placeholder: filtered "active clients" view with statuses visible as columns.
A useful second view: a Board view by status. Prospect, Active, On hold, Done. Four columns. You see the state of your client portfolio at a glance.
What connects to the client database
The client database isn't a silo. It's the entry point of a connected system.
The most important relation to create: the link to the Projects database. Each project belongs to a client. When this relation exists in Notion, you can open a client's record and immediately see all their associated projects, past and ongoing.
Placeholder: minimal relational diagram — two boxes labelled "Clients" and "Projects" connected by a two-way arrow, with 3 or 4 properties listed under each box.
What you don't connect at this stage: tasks, invoices, contractual documents. These can come later, if the need is real. Integrating them too early weighs the system down before it's even been used.
A word on client portals in Notion
Some freelancers create shared Notion spaces with their clients. A dedicated page per client, with deliverables, feedback, and project stages.
It's an interesting practice. But it's an advanced feature. It requires a paid Notion plan, rigorous organisation, and a client who is willing to use Notion on their end.
If you're just starting with Notion, build your internal system first. Client portals come after, when the foundation is solid.
Want a concrete starting point? The "Manage your business" Notion template includes a pre-configured client database with the properties and views described in this article. See the template →
