Freelancers often run their business from memory, scattered notes, and an inbox full of threads, and that works until the moment it does not: a lead forgotten, a follow-up missed, or an invoice that nobody chased. A customer relationship system, or CRM, fixes that by keeping every lead, project, and payment in one place. You do not need expensive software for this; a simple Notion setup with three linked databases covers most solo freelancers completely.

The first database is leads. Each lead gets a row with the prospect's name, business, service they need, source, date contacted, status, and next follow-up date. Statuses should stay simple: new, contacted, proposal sent, negotiating, won, and lost. The discipline that makes this work is updating the status after every interaction, which takes seconds and turns a vague pipeline into a visible one you can actually manage.

The second database is projects, linked to the leads database so each project connects to the client it came from. Each project row holds the scope summary, start date, deadline, deliverables, and status, from not started through in progress to delivered. Linking projects to leads means you can see, at a glance, which clients came from which sources and which kinds of projects actually close, which is valuable information for deciding where to spend your marketing time.

The third database is payments, linked to projects. Each row records the invoice number, amount, date sent, due date, and payment status. A simple filtered view showing only unpaid and overdue invoices becomes your weekly money check, replacing the end-of-month scramble through your inbox. When a payment is marked received, the project and client history updates automatically through the links, giving you a clean record without duplicate data entry.

Build the system in stages to avoid overcomplicating it. Start with the leads database and use it for two weeks, then add projects once the lead habit sticks, then add payments. A CRM with three databases you actually update beats a CRM with twenty features you ignore, and the most common reason freelance CRMs fail is that they were built too complex on day one and abandoned by day ten.

Automate the edges once the core is working. A Notion form can capture new inquiries directly into the leads database, a calendar view can show upcoming follow-ups and deadlines, and a simple weekly review, fifteen minutes every Friday, keeps statuses honest. That Friday review is the real engine of the system: it surfaces the follow-up you forgot, the invoice that is overdue, and the project that needs attention before any of them become problems.

Start this afternoon by creating the leads database with the six fields above and adding your current prospects to it, even if the list is short. Add projects and payments over the following two weeks, and keep the Friday review sacred. Within a month you will have something most freelancers never build: a clear, calm view of your entire business, and the follow-ups and payments that used to slip through the cracks will start landing on time.

Once the three databases are running, add a simple dashboard page in Notion that pulls the most important views together: active leads needing follow-up this week, projects in progress with their next deadline, and unpaid invoices sorted by age. That single page becomes your Monday morning briefing, replacing the scattered check across inbox, calendar, and notes that most freelancers start the week with. Keep the dashboard to those three views at first, and resist adding charts or metrics you will not act on, since a dashboard you glance at daily beats a dashboard you admire once and ignore. Review the dashboard every Monday, update any stale statuses, and let it drive your priorities for the week, so the CRM stops being a record of the past and becomes a tool for the week ahead.