After years of freelancing, I've tried every project management tool out there. Trello, Asana, Monday, ClickUp — they all did too much or not enough.
What I actually needed was dead simple:
- Where are my clients?
- What projects am I working on?
- Who owes me money?
- Who should I follow up with?
So I built it in Notion. One page, five databases, zero monthly cost.
What's In the Template
1. Clients Database
Every client in one place. Contact info, how they found you, current status (Active, Lead, Past Client, Prospect), and total revenue generated.
Why it matters: When you can sort clients by revenue source, you stop guessing which marketing channels work.
2. Projects Tracker
Active work with deadlines, fees, hours logged, and priority levels. Supports fixed, hourly, and retainer fee types.
Why it matters: Knowing your actual hours-per-project reveals which clients are profitable and which are burning your time.
3. Invoice Tracker
Auto-numbered invoices with status tracking: Draft → Sent → Paid → Overdue. Linked to clients and projects.
Why it matters: I used to lose track of who paid and who didn't. Now overdue invoices scream at me in red.
4. Lead Pipeline
Track prospects through stages: New Lead → Contacted → Proposal Sent → Negotiating → Won/Lost. Each lead has a follow-up date and next action.
Why it matters: Most freelancers let leads die because they forget to follow up. A follow-up date field fixes that.
5. Time Log
Billable hours by project and client, with rates. Simple but essential.
Why it matters: If you're not tracking time, you're leaving money on the table.
How I Actually Use It
Every morning (2 minutes):
- Check Lead Pipeline for today's follow-ups
- Scan Invoices for anything overdue
During work:
- Log time as I go (not at the end of the week — you'll forget hours)
Weekly (10 minutes):
- Review pipeline health
- Send any draft invoices
- Check which sources brought new leads
The Setup
The template comes with sample data so you can see it in action. Duplicate it, delete the samples, and start adding your own clients.
It works on Notion's free plan. No paid features required.
I packaged it as a ready-to-use template with all 5 databases pre-configured. Duplicate it and you're running in 30 seconds.
What does your freelance workflow look like? I'm curious what other people use to track clients and projects.
Top comments (0)