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)
  • ☐ Email
  • ☐ 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):

  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 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.

Buy FollowRail Full — $23.99   See kits on the homepage

Related guides: HoneyBook vs Notion · invoice follow-up checklist · 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