How to Build a CRM in Notion for Freelancers and Small Businesses
How to Build a CRM in Notion for Freelancers and Small Businesses
A customer relationship manager does not have to be a sprawling enterprise platform with a monthly bill to match. For most freelancers and small businesses, a CRM is really just three things working together: a place to keep track of the people you work with, a way to see where each deal stands, and a link between those relationships and the money they bring in. Notion handles all three comfortably, and the free Notable Dashboard already contains most of the moving parts you need. This guide walks through how to turn its Order Management and Financial Tracker sections into a lightweight, honest customer manager.
Why Notion Works as a Simple CRM
Notion’s core strength is that everything is a database surfaced through multiple linked views, filters, and rollups. The same set of records can appear as a table in one place, a filtered summary in another, and a rolled-up number in a Quick Stats row. That flexibility is exactly what a small CRM needs. You are not buying a rigid pipeline tool; you are shaping a few related databases to mirror how you actually sell and deliver.
The Notable Dashboard leans into this. Its Recent Orders section sits under Order Management, and its Financial Tracker records income and expenses by category. Between them you already have the bones of a contacts list, a deals view, and a payments ledger. The work is mostly connecting those pieces and adding a couple of fields, not building from scratch.
Get the Free Notion Dashboard
Tasks, goals, habits, budget and calendar. 100% free.
Grab the Free Template →The three databases you actually need
- A Clients database — one row per person or company you work with.
- A Deals or Orders view — one row per engagement, quote, or order, linked back to a client.
- The Financial Tracker — where payments land, tagged to the client who paid them.
Keep them as separate databases connected by relation properties rather than cramming everything into one table. That separation is what lets you answer questions like “how much has this client paid me this year” without scrolling through unrelated rows.
Building the Contacts and Deals Layer
Start with the Order Management area of the dashboard. The Recent Orders section is structured as a database, which makes it a natural home for deals. Rename or duplicate it into an Orders database and give each record the fields a small business tracks: the client, the value of the work, a date, and a status. Then add a companion Clients database with the basics — name, company, email, and a notes field for context you would otherwise forget.
Connect the two with a relation property so each order points at exactly one client, and each client shows a list of their orders. This is the single most important step. Once the relation exists, Notion can roll figures up from orders to clients automatically, which is where the “revenue per client” view later comes from.
Pipeline stages with a Status field
The Tasks & Projects database in the Notable Dashboard already uses a Status field with Not started, In progress, and Done. Borrow that idea for your Orders database, but expand the options to match a sales pipeline: Lead, Contacted, Proposal Sent, Won, and Lost work well for most freelancers. Because Status is a select field, you can switch the Orders view to a board grouped by Status and drag records from one column to the next as a deal progresses. That board is your pipeline. Add a filter to hide Won and Lost deals and you get a clean view of only the opportunities that still need attention.
Linking Payments to Clients in the Financial Tracker
The Financial Tracker is the piece that makes this a real CRM rather than a static address book. Its Category field already includes Client Payment and Client, and its Type field separates Income, Expense, and Investment. When a client pays you, log the amount as an Income record with the Client Payment category. The dashboard’s Monthly Revenue stat, which sums Amount where Type is Income for the current month, then reflects that payment without any manual tallying.
To tie payments back to specific people, add a relation property on the Financial Tracker that points to your Clients database. Now every payment record can name the client it came from. A single well-placed relation turns a general income log into a per-customer payment history you can filter and total.
Seeing revenue per client with rollups
With payments related to clients, open the Clients database and add a rollup property. Point it at the related Financial Tracker records, choose the Amount field, and set the calculation to Sum. Each client row now displays the total you have earned from them. Add a second rollup that counts related orders and you have a compact snapshot of every relationship: who they are, how many jobs you have done, and how much revenue they represent. Sort the Clients table by that revenue rollup and your best accounts rise to the top.
Following Up Without Dropping the Ball
Relationships are won and lost on follow-through, so route your follow-ups through the Tasks & Projects database. Create a task such as “Send proposal to Acme” with a Due Date, set Priority to High, and use the Project field to bucket it under Sales. The dashboard’s Tasks Due Today stat, a filtered view of that same database, then surfaces the follow-up on the day it matters. If you want tighter integration, add a relation from tasks to clients so each contact page lists its own open follow-ups alongside its payment history.
You can build all of this on top of the free Notable Dashboard, adapting its existing Order Management and Financial Tracker sections rather than starting with a blank page.
Know the Limits: Notion Is a Lightweight CRM
Be honest with yourself about scope. Notion is a lightweight CRM, not a Salesforce replacement. It has no built-in email sync, no automated lead scoring, no call logging, and no native sales forecasting. If you manage hundreds of active deals or a team of sales reps, a dedicated platform will serve you better. For a freelancer or a small shop juggling a few dozen clients, though, a Notion setup is fast, free, and completely yours to reshape. Start simple, add fields only when a real question demands them, and let the dashboard’s rollups do the counting.
