Guides · Notion CRM fields
Simple Notion CRM fields you actually need (12 or fewer)
Most “Notion CRM” templates fail the same way: forty properties, seven linked databases, and a dashboard you open once. A simple Notion CRM for freelancers is not a smaller life OS. It is a desk that answers three questions without scrolling: who do I chase today, what is in the pipeline, and who owes me money.
This post caps each database at about twelve must-have fields. If a property does not change what you do this week, delete it.
The four databases (and nothing else)
| Database | Job | Typical field ceiling |
|---|---|---|
| Clients | People and health | ≤12 |
| Deals | Proposal money and stage | ≤10 |
| Follow-ups | Next chase date + tone | ≤10 |
| Invoices | Sent / overdue / paid | ≤12 |
| Dashboard | Linked views only | 0 new properties |
No time tracker. No habit board. No marketing calendar. Those belong in other systems if you need them at all. For how this desk compares to full clientflow tools, see HoneyBook vs Notion freelance CRM.
Printable field checklist
Tick what you will keep. Cap each DB near twelve fields. Delete the rest.
Clients (≤12)
- ☐ Name
- ☐ Status (Lead / Active / Past / Cold)
- ☐ Source (optional)
- ☐ Default rate / currency
- ☐ Last contact
- ☐ Days since contact (formula)
- ☐ Next action
- ☐ Next action date
- ☐ Health (Green / Amber / Red)
- ☐ Outstanding balance (rollup)
Deals (≤10)
- ☐ Deal name
- ☐ → Client
- ☐ Stage
- ☐ Value
- ☐ Proposal sent date
- ☐ Scope notes / link
Follow-ups (≤10)
- ☐ → Client (+ optional Deal / Invoice)
- ☐ Type (Proposal nudge / Invoice chase / Check-in / Other)
- ☐ Due date
- ☐ Status (Open / Done / Skipped)
- ☐ Cadence (D+3 / D+7 / D+14 / D+30)
- ☐ Script snippet
Invoices (≤12)
- ☐ Invoice #
- ☐ → Client
- ☐ Amount
- ☐ Status (Draft / Sent / Partial / Paid / Void)
- ☐ Issue date
- ☐ Due date
- ☐ Overdue (formula / checkbox)
- ☐ Days overdue (formula)
- ☐ Next chase date
- ☐ Paid date / amount
For the invoice chase ritual, see the freelance invoice follow-up checklist. Kits Coming soon on #kits — buyable now: Full only.
Clients: people, not projects
Keep the person record thin. Deals and invoices carry the work.
Must-have (aim for ≤12 total, including formulas and rollups):
- Name
- Status — Lead / Active / Past / Cold
- Source — where they found you (optional if you never look at it)
- Default rate / currency — so quotes stay consistent
- Last contact (date)
- Days since contact (formula)
- Next action (text)
- Next action date
- Health — Green / Amber / Red (manual is fine)
- Outstanding balance (rollup from Invoices)
Cut hard: birthday, social handles, NPS, “personality notes,” company size, industry tags you never filter on. If you need a long brief, put a link in Scope notes on the Deal.
Deals: stage and value only
- Deal name
- → Client (relation)
- Stage — Lead → Proposal sent → Negotiation → Won → Lost
- Value
- Proposal sent date — starts your D+3 / D+7 / D+14 ladder
- Scope notes / link
That is six. Resist “probability %,” “expected close month,” and five custom stage names. Solo freelancers win by updating Stage honestly, not by forecasting. Pair the Proposal sent date with the proposal follow up cadence.
Follow-ups: the desk that saves money
This is the differentiator. Without it you are staring at a kanban hoping your memory works. It is also the heart of a good client follow up tracker.
- → Client (relation; optional Deal / Invoice too)
- Type — Proposal nudge / Invoice chase / Check-in / Other
- Due date
- Status — Open / Done / Skipped
- Cadence — D+3 / D+7 / D+14 / D+30
- Script snippet — friendly or firm paste text
Views that matter: Follow up today, Overdue, This week, By type. When you mark Done, create the next row the same minute—or close the deal. The field set is useless without that habit.
Notion does not send the email for you. You paste the snippet into Gmail or Outlook on purpose. That boundary keeps the CRM honest.
Invoices: status beats accounting
- Invoice #
- → Client (+ optional Deal)
- Amount
- Status — Draft / Sent / Partial / Paid / Void
- Issue date
- Due date
- Overdue (formula or checkbox)
- Days overdue (formula)
- Next chase date
- Paid date / amount
Do not turn Notion into Wave or Stripe. Record what you already sent from your real invoicing tool. Tax ledgers, multi-currency books, and bank sync are not v1 for a template CRM. For the chase rhythm, use the Notion overdue invoice tracker guide and the invoice follow-up email scripts.
Dashboard: three questions, zero bloat
Build linked views, not new databases:
- Who today? → Follow-ups where Due ≤ today and Status = Open
- Pipeline $? → Deals in Proposal sent / Negotiation, sum of Value
- Who owes me? → Invoices Sent/Partial with Overdue
Add a one-page Start Here (≤10 minutes on Notion Free) and a weekly 15-minute checklist. Then stop decorating.
The ten-minute acceptance path
- Duplicate the four databases (or a starter template).
- Delete sample rows.
- Add 1 Client, 1 Deal (Proposal sent + date), 1 Invoice (Sent + due), 1 Follow-up (Due today).
- Open Follow up today. If the row is missing, fix the filter before adding properties.
- If setup takes longer than about ten minutes, you still have too many fields.
What “simple Notion CRM” is not
- A HoneyBook / Dubsado replacement with portals and e-sign
- An email blaster (paste snippets into your own inbox on purpose)
- An ADHD life OS with habits and second brains bolted on
- A HubSpot clone with lead scoring
Those products are fine when you need them. A freelance Notion CRM earns its keep when it makes the next chase obvious.
Want the desk without wiring every relation?
FollowRail Full ($23.99 one-time) is a narrow Notion freelance CRM: who to chase today, proposal stages, and overdue invoices. Duplicate link after purchase only. Paste snippets from your own mail client on purpose. No monthly CRM fee.
Focused Invoice ($12) and Follow-up ($14) kits — Coming soon — see #kits.
Related guides: HoneyBook vs Notion · invoice follow-up checklist · client follow up tracker · overdue invoice tracker