Notion Project Management Template for Freelancers & Solopreneurs
You don't need a Team database when the team is you. Here's the leaner two-database structure built specifically for solo freelancers running several clients at once.
You don’t need a Team database when the team is you. This is the leaner, two-database version of Notion project management — Projects and Tasks only, with billable hours and client grouping built in — for freelancers and solopreneurs juggling multiple clients without extra structural overhead.
Why freelancers need a different structure
Our main tutorial covers a three-database Projects/Tasks/Team structure built for teams. As a freelancer, the Team database is pure overhead — an extra relation and property set tracking a team of exactly one. What actually matters for solo work is different: which client you’re billing, how many hours you’ve logged, and whether this week is quietly getting overloaded across 4 different clients at once.
The two-database structure
Projects — Name, Status, Deadline, and a Client relation (pointing to a simple Clients database with just Name and Contact). Tasks — Name, Project relation, Status, Due Date. That’s the whole skeleton — identical logic to the main tutorial’s relation and rollup pattern, just one database lighter.
Tracking billable hours
Add two properties to Tasks: a Billable checkbox, and Hours Logged (number). Then on Projects, add a rollup summing Hours Logged across related Tasks where Billable is checked. This single rollup replaces a separate time-tracking spreadsheet for most solo workflows — your invoice total is one glance away, not a reconciliation exercise.
Setup roadmap
Setup Roadmap
- 1
Build Projects with a Client field
Name, Status, Deadline, Client (relation to a lightweight Clients database).
15 min
- 2
Build Tasks with Billable and Hours Logged
Name, Project relation, Status, Billable (checkbox), Hours Logged (number).
15 min
- 3
Add the Billable Hours rollup
On Projects: sum of Hours Logged where Billable is checked.
10 min
- 4
Build a Table view grouped by Client
Your at-a-glance “who am I working for this week” view.
5 min
- 5
Save a default Project template
Pre-fills Status and reminds you to set Client and Deadline for every new engagement.
5 min
Want this pre-built?
Our freelancer template ships with the Billable Hours rollup and Client grouping already configured — duplicate and add your own clients.
Launch checklist
Freelancer Launch Checklist
- Projects has a Client relation (even if your client list is short)
- Tasks has a Billable checkbox and Hours Logged field
- A Billable Hours rollup exists on Projects, not a manually totaled number
- A Table view grouped by Client exists for a fast weekly overview
- Personal tasks live somewhere separate from client-billable work
Common mistakes
Common Freelancer Mistakes
- Building the full Team-database structure for a team of one. — Extra relation, extra property, nothing gained — skip it until you’re actually delegating regularly.
- Tracking hours in a separate spreadsheet or app. — Splitting billable-hours tracking from the task list means reconciling two sources before every invoice, which is exactly the kind of manual step this structure is meant to remove.
- No Client relation at all. — Even with 3 repeat clients, skipping the relation means you can’t filter “what’s outstanding for Client X” without manually scanning the whole Tasks list.
- Mixing personal errands into the same Tasks database. — It feels convenient short-term and makes every billable-hours rollup and client filter noisier than it needs to be.
Free Notion Template
Freelancer Projects + Billable Hours Tracker
The two-database structure from this guide, with billable hours and client grouping pre-built.
Template link placeholder — replace href with the live Notion “Duplicate” share link before publishing.
FAQ
Do I still need a Clients database if I mostly repeat work for the same 3 clients?
Yes — even with a small, stable client list, a Clients relation is what lets you filter Tasks by client for invoicing and lets you see workload per client at a glance.
How do I track billable vs. non-billable time without a separate app?
Add a Billable checkbox and an Hours Logged number field on Tasks, then a rollup on Projects summing billable hours — no separate time-tracking tool required for basic use.
Should I put personal tasks in the same workspace?
Keep them in a separate, unrelated database or a different Notion workspace entirely. Mixing client-billable work with personal errands makes every rollup and filtered view noisier than it needs to be.
Is it worth adding a Team database for occasional subcontractors?
Only if you regularly bring in help. For one-off subcontractor work, a simple “Delegated To” text field is faster and you can upgrade to a real Team relation once it becomes a pattern.
We turn workflows like this into a working Notion system in days, not months.
Find Your Solution