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.

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):

  1. Name
  2. Status — Lead / Active / Past / Cold
  3. Email
  4. Source — where they found you (optional if you never look at it)
  5. Default rate / currency — so quotes stay consistent
  6. Last contact (date)
  7. Days since contact (formula)
  8. Next action (text)
  9. Next action date
  10. Health — Green / Amber / Red (manual is fine)
  11. 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

  1. Deal name
  2. → Client (relation)
  3. Stage — Lead → Proposal sent → Negotiation → Won → Lost
  4. Value
  5. Proposal sent date — starts your D+3 / D+7 / D+14 ladder
  6. 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.

  1. → Client (relation; optional Deal / Invoice too)
  2. Type — Proposal nudge / Invoice chase / Check-in / Other
  3. Due date
  4. Status — Open / Done / Skipped
  5. Cadence — D+3 / D+7 / D+14 / D+30
  6. 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

  1. Invoice #
  2. → Client (+ optional Deal)
  3. Amount
  4. Status — Draft / Sent / Partial / Paid / Void
  5. Issue date
  6. Due date
  7. Overdue (formula or checkbox)
  8. Days overdue (formula)
  9. Next chase date
  10. 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

  1. Duplicate the four databases (or a starter template).
  2. Delete sample rows.
  3. Add 1 Client, 1 Deal (Proposal sent + date), 1 Invoice (Sent + due), 1 Follow-up (Due today).
  4. Open Follow up today. If the row is missing, fix the filter before adding properties.
  5. 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 is a narrow Notion freelance CRM: who to chase today, proposal stages, and overdue invoices. Duplicate on Notion Free. Paste snippets from your own mail client on purpose. One-time purchase—$23.99. No monthly CRM fee.

See checkout on the homepage   Buy FollowRail — $23.99

Related guides: HoneyBook vs Notion · client follow up tracker · overdue invoice tracker

Keep the field list short

Install a ready-made freelance CRM Notion template with Clients, Deals, Follow-ups, and Invoices—without forty mystery properties.

Buy FollowRail — $23.99 one-time

Back to FollowRail home