DEV Community

Brad
Brad

Posted on • Edited on

How to Build a Freelance Project Tracker in Notion (Free Template Inside)

#notion #freelancing #productivity #tutorial

How to Build a Freelance Project Tracker in Notion (Free Template Inside)

If you're freelancing without a system, you're leaving money on the table — and losing hours tracking down invoices, missed follow-ups, and forgotten project details.

In this guide, I'll show you how to build a complete freelance management system in Notion with four linked databases:

  1. Client Database — all client contacts, status, and rates in one place
  2. Projects Database — linked to clients, with timelines and deliverables
  3. Invoice Tracker — amounts, due dates, paid/unpaid status
  4. Weekly Review Template — a simple repeating checklist to stay on top of everything

Why Notion for Freelance Management?

Notion is free for individuals and works across devices. More importantly, it lets you link databases together — so you can see all projects for a client, all invoices for a project, and your weekly review for the week all in one workspace.

Other tools charge $15-30/month for this. Notion does it free.

Database 1: Client Tracker

Properties to include:

  • Name (title)
  • Status (select: Prospect / Active / Paused / Closed)
  • Hourly Rate or Fixed Rate (number)
  • Primary Contact (text)
  • Contact Email (email)
  • Notes (text)
  • First Project Date (date)

This replaces a CRM for most freelancers. You need exactly this — not 47 fields you'll never fill.

Database 2: Projects Tracker

Properties:

  • Project Name (title)
  • Client (relation → Client database)
  • Status (select: Scoping / Active / In Review / Delivered / Invoiced / Paid)
  • Start Date and Deadline (date)
  • Budget (number) — what you quoted
  • Hours Logged (number)
  • Deliverables (text)
  • GitHub / Drive Link (URL)

Key insight: the relation to Client means clicking a client shows all their projects. This is the feature you can't replicate in a spreadsheet.

Database 3: Invoice Tracker

Properties:

  • Invoice Number (title)
  • Project (relation → Projects)
  • Amount (number)
  • Status (select: Draft / Sent / Overdue / Paid)
  • Due Date (date)
  • Paid Date (date)
  • Payment Method (select: Bank Transfer / PayPal / Stripe / Wise / Crypto)

Filter view: create a filtered view showing only Sent and Overdue invoices. This is your daily "who owes me money" view.

Template 4: Weekly Review

Create a page template in Notion with a checklist:

# Week of {{date}}

## Money
- [ ] Check invoice statuses
- [ ] Follow up on any overdue invoices
- [ ] Log any new invoices sent this week

## Projects
- [ ] Update project status for each active project
- [ ] Identify blockers
- [ ] Confirm next week's priorities with clients

## Pipeline
- [ ] Review prospect list — anyone to follow up with?
- [ ] Send 2-3 outreach messages to warm leads

## Admin
- [ ] Log hours for billing
- [ ] Backup any project files
Enter fullscreen mode Exit fullscreen mode

This takes 20 minutes every Sunday and prevents 80% of the chaos that derails freelance businesses.

Setting Up the Links

Once all three databases exist:

  1. In Projects, create a relation property pointing to Clients
  2. In Invoices, create a relation property pointing to Projects
  3. Enable "Show on Client page" and "Show on Project page" for each relation

Now clicking a client shows their projects. Clicking a project shows its invoices. The system is complete.

The Pre-Built Version

If you want the template pre-built with sample data, views already set up, and a getting-started guide — grab the Freelance Business Starter Kit on Gumroad. It includes:

  • 4 CSV templates ready to import into Notion, Airtable, or Excel
  • Pre-configured column headers for all 4 databases
  • Sample data so you can see how everything connects
  • Quick-start guide for each template

→ Get the Freelance Business Starter Kit ($9)

Summary

A Notion freelance tracker replaces: a CRM, a project management tool, an invoice tracker, and a weekly review system — all for free.

Build it in 2 hours, maintain it in 20 minutes/week. The ROI from one recovered invoice or one followed-up lead pays for the setup time immediately.

If you're already using Notion, there's no reason not to build this today.

🔧 **Found this useful?* I build custom HN lead reports (20–50 companies with verified emails, tech stacks, 24h delivery) → Order done-for-you lead report — $75 | Got a workflow to automate? → 1-Hour Python Automation Audit — $39*

Top comments (0)