You were juggling Excel sheets that contradicted each other, notes scattered across three different apps, and a calendar that didn't tell you whether you were profitable this month. That's the daily reality for most independent consultants — and it's avoidable. Notion lets you centralize your entire business in one single space, without writing a line of code, without paying a developer.
The purpose of this article isn't to sell you a perfect system to customize for weeks. It's to give you an operational framework that you can build in one hour, use starting today, and evolve as your real needs change.
What your system must absolutely cover
↪ Read also : ChatGPT for consultants: 10 prompts that change everything
Before opening Notion, ask yourself this question: what information do I need to find in less than 30 seconds? For a consultant, the answer always revolves around the same areas — who are my active clients, where do my projects stand, how much have I invoiced this quarter, and who do I need to follow up with this week.
The temptation is to want to model everything from the start. That's pitfall number one. A system that's too complex doesn't get used. Start with the minimum viable: five linked databases, a homepage that centralizes the essential views. Nothing more at launch.
The 5 databases to create first
The Clients database is your foundation. For each client, record the company name, main contact name, email, phone, industry, and status (Prospect, Active, On hold, Archived). That's all. Don't add ten extra fields you'll never fill out.
The Projects database is linked to the Clients database via a Notion relation. Each entry represents a project or mission. Essential fields: title, linked client, start date, expected end date, status (In progress / Completed / On hold), and total amount excluding tax. This amount field will later let you calculate your revenue directly from Notion.
The Invoices database is linked to Projects. It contains: invoice number, linked project, issue date, amount excluding tax, status (Draft / Sent / Paid / Overdue). Add a due date property so you never forget a follow-up. The Pipeline database lists your business opportunities with a stage (Initial contact / Proposal sent / Negotiation / Won / Lost) and a closing probability. Finally, the Tasks database, linked to both Projects and Clients, centralizes all your action items with a due date and priority level.
Build your homepage in 20 minutes
Your homepage is the only place you open every morning. It doesn't contain raw databases — it displays filtered and linked views from your existing databases. Create this page with "Linked database" blocks: insert a view of your Tasks database filtered on "Priority = High AND Status ≠ Completed", a view of your Invoices database filtered on "Status = Overdue", and a view of your Pipeline filtered on "Stage = Proposal sent".
Organize the page in two columns using Notion's native feature: left column for urgent tasks, right column for key monthly metrics. At the top, add a "Callout" block with a simple formula — or just a line of text you update every Monday — showing your current month revenue and your target. This forces you to look at your numbers every week.
The 4 views that change everything daily
Each database can be displayed from multiple angles. Here are the views that consultants use most:
- ✦ Board view for the Pipeline: each column represents a sales stage, you drag your opportunities from left to right as discussions progress.
- ✦ Timeline view for Projects: instantly visualize project overlaps and anticipate your busy periods.
- ✦ Gallery view for Clients: one card per client with their logo (dragged as cover image) and their status displayed. Faster to scan than a table.
- ✦ Filtered table view for Invoices: sort by ascending due date, with a column color-coded by status. You see in three seconds what's overdue.
These views don't require advanced setup. They're available natively in Notion Free. Create them once, pin them, and you no longer need to dig through your raw databases daily.
Integrate a weekly routine into the system
A system is worthless if it's not fed regularly. Create a "Weekly Review" page with a template database. Every Monday morning, you duplicate this template in 2 minutes: you note your revenue from the previous week, the three priorities for the week, follow-ups to make, and a status update on your pipeline. This 15-minute ritual replaces an hour of meeting with yourself.
Link this review page to your databases via mentions (@Project name) rather than formal relations. It's faster to enter and sufficient for finding your notes during a quarterly audit. After three months, you'll have valuable history to guide your growth and identify your activity cycles.
Common mistakes to avoid from the start
Creating too many unused properties is the most common mistake. Every field you add is a field you need to fill. If you don't use it in a view or filter, delete it. A streamlined system is a system you maintain. The golden rule: if a property doesn't feed into a decision or view, it doesn't exist.
Duplicating information across multiple databases creates inconsistencies over time. If a client's name changes, you only want to update it in one place. That's exactly what Notion relations are for: databases talk to each other, and changes propagate automatically. Never enter the same information twice in your workspace.
Waiting for a perfect system before you start using it is probably the costliest mistake. Launch your imperfect system today. In three weeks, you'll know exactly what to improve because you'll have used it in real life, with real clients and real constraints.
An imperfect management system you use every day is worth a hundred times more than a perfect system you never finish building.