Quick answer
- Set up a client database in Notion with contact details, project history and payment terms
- Create a project tracker with status, deadlines and linked client records
- Build an invoice database that calculates totals and tracks payment status
- Use templates and relations to connect clients, projects and invoices automatically
- Automate repetitive admin tasks with AI tools to save hours each week
Freelancing means wearing every hat: project manager, accountant, client liaison. When you’re switching between Trello for tasks, spreadsheets for invoices and email for client notes, things slip through the cracks.
Notion lets you consolidate all of that into one workspace. With the right templates, you can track who owes you money, which projects are due this week, and what you promised each client—without opening five different apps.
This guide walks you through the essential Notion templates for freelancers, what to include in each, and how to connect them so your admin practically runs itself.
Why Notion Works Well for Freelancers
Notion combines databases, documents and tasks in one tool. That means you can link a project to its client record, attach invoices to projects, and see everything in one view.

You’re not paying for separate subscriptions to a CRM, project tracker and invoicing tool. Everything lives in Notion, and you control exactly how it’s structured.
The learning curve exists—Notion’s flexibility can feel overwhelming at first. But once you set up your core databases, daily upkeep takes minutes.
The Three Core Databases Every Freelancer Needs
Start with three connected databases: Clients, Projects and Invoices. These form the backbone of your freelance workspace.
Each database serves a specific purpose, but they work together through Notion’s relation and rollup properties. When you update a project status, the client record reflects it. When you mark an invoice paid, the total updates automatically.
You can add more databases later (tasks, meeting notes, expenses), but these three give you immediate clarity on cash flow and workload.
Setting Up Your Client Database
Create a new database and name it “Clients.” Add properties for contact name, company, email, phone, and any other details you reference regularly.

Add a “Status” select property with options like Active, Onboarding, Paused and Past. This lets you filter clients quickly and spot who hasn’t been in touch lately.
Include a “Payment Terms” text field where you note things like NET-30, upfront deposit percentage, or preferred payment method. When invoice time comes, you won’t have to dig through old emails.
Use the notes section (or a long-text property) for anything that doesn’t fit a field: quirks, timezone, preferred communication style. The goal is a single source of truth for each client relationship.
Building a Project Tracker That Actually Gets Used
Your Projects database should track deliverables, deadlines and progress. Create properties for Project Name, Client (relation to your Clients database), Status, Start Date, Deadline and Budget.
The relation property is key: when you link a project to a client, you can roll up all projects for that client in their record. You’ll see at a glance how many active projects each client has and what’s coming due.
Add a “Status” select with stages that match your workflow—something like Briefing, In Progress, Review, Completed and Invoiced. Adjust these to fit how you actually work, not how you think you should.
If you manage tasks within projects, add a Kanban view or link to a separate Tasks database. For more complex project tracking, check out the best Notion templates for project management or learn how to build a Kanban board in Notion.
If you’re running sprints or working with agile workflows, the Scrum Board PRO template gives you a complete sprint board, backlog with MoSCoW priorities, and burndown charts—all set up in ten minutes with no recurring fees.
Creating an Invoice Database With Automatic Calculations
Start a new database called “Invoices.” Add properties for Invoice Number, Client (relation), Project (relation), Amount, Issue Date, Due Date, Status and Payment Date.
Use a formula property to calculate days overdue. The formula dateBetween(prop("Due Date"), now(), "days") shows how many days an invoice is past due. Combine this with conditional formatting or a filter to highlight late payments.
Set the Status property to a select field with options like Draft, Sent, Paid and Overdue. Update this as invoices move through their lifecycle, and you’ll always know what’s outstanding.
If you need line items (hours worked, expenses, etc.), create a separate Line Items database and relate it to Invoices. Use a rollup property to sum the totals. This keeps invoices clean while giving you detailed breakdowns when you need them.
Linking Clients, Projects and Invoices Together
The real power comes from connecting these databases. In your Projects database, add a relation to Clients. Now you can filter projects by client or see all of a client’s projects in one view.
In your Invoices database, relate invoices to both Clients and Projects. This tri-directional link means you can:
- See all invoices for a specific client
- Check if a project has been invoiced yet
- Roll up total revenue per client or project
Add rollup properties to pull in totals. For example, in your Clients database, add a rollup that sums all related invoice amounts. You’ll see lifetime revenue per client at a glance.
This setup takes an hour to build the first time, but it saves you from manually cross-referencing spreadsheets every week.
Using Views and Filters to See What Matters
Databases get cluttered fast. Create filtered views for the information you check daily. In your Projects database, make a view called “Active Projects” that filters for Status = In Progress or Review.
In Invoices, create an “Unpaid” view that shows only invoices with Status = Sent or Overdue. Pin this view to your dashboard so you know exactly what’s owed.
Use a calendar view for deadlines. In Projects, add a calendar view based on the Deadline property. You’ll see the next two weeks at a glance and can plan your workload accordingly.
Notion lets you save multiple views per database. Don’t be afraid to create views for specific clients, project types or date ranges—switch between them as your focus shifts.
Ready-made Notion template
Scrum Board PRO
A complete agile project-management system in Notion: sprint board, backlog with MoSCoW priorities, bug tracker, sprint planner with burndown, meeting notes and reports. Set up in 10 minutes, no monthly subscription.
Templates Within Notion to Speed Up Repetitive Work
Notion’s database templates (the blue “New” button dropdown) let you pre-fill properties and content. Create a project template with your standard checklist: onboarding call, contract sent, deposit received, first draft, revisions, final delivery.
Build an invoice template with your standard payment terms, bank details and footer text. When you create a new invoice, the template populates everything except the variable details.
This cuts down on copy-paste errors and ensures you don’t forget a step. It also makes delegating easier if you ever bring on help.
Adding a Dashboard to See Everything at Once
Create a new page called “Freelance Dashboard.” Use linked databases to pull in your key views: Active Projects, Unpaid Invoices, and a client list filtered to Active status.
Add a simple text section for your weekly priorities or a toggle list for recurring tasks (send invoices, follow up on proposals, update time logs). Keep it minimal—dashboards that try to show everything end up showing nothing useful.
Pin this page to your sidebar. It becomes your home base every morning.
Where to Find Ready-Made Notion Templates for Freelancers
If building from scratch sounds like too much work, start with a pre-built template. Notion’s template gallery has several freelance options, though they vary in quality and complexity.
Third-party marketplaces like Gumroad, Etsy and Notion Everything sell more polished templates. Look for ones that include sample data so you can see how the databases connect before you commit.
Check what’s included: some templates are just a pretty dashboard with no actual automation. The best ones have relational databases, rollups and formulas already configured.
For a broader look at Notion setups, browse the Notion templates category on Digitify for more guides and comparisons.
Automating Admin Tasks to Save Time Every Week
Once your Notion workspace is set up, you can layer in automation to reduce manual updates. Use Notion’s built-in automations (if available on your plan) to send reminders when invoices are overdue or projects approach their deadlines.
Connect Notion to Zapier or Make to trigger actions outside Notion: send an email when a project status changes, add a calendar event when a deadline is set, or log expenses from a receipt-scanning app.
For more ways to cut down on repetitive work, read how to automate repetitive admin work with AI. You can also explore the best AI tools for freelancers to handle everything from email drafting to proposal generation.
Common Mistakes When Setting Up Notion for Freelancing
Overcomplicating your setup. You don’t need twenty databases on day one. Start with Clients, Projects and Invoices, then add more only when you feel the pain of not having them.
Not using relations and rollups. If your databases don’t talk to each other, you’re just recreating a folder of spreadsheets. The power is in the connections.
Skipping regular reviews. Notion only helps if you update it. Block 15 minutes every Friday to mark invoices paid, archive completed projects and update statuses. Make it a habit, not a chore you do when something breaks.
Tips for Keeping Your Freelance Workspace Tidy
Archive old projects instead of deleting them. Add an “Archived” status and filter them out of your active views. You’ll still have the history if a client returns or you need to reference past work.
Use consistent naming conventions. If you name projects “ClientName – ProjectType – Month”, sorting and searching becomes instant. Pick a format and stick to it.
Review your templates quarterly. As your business evolves, your workflows change. Update your project and invoice templates to reflect what you’re actually doing, not what you did six months ago.
Notion vs Standalone Tools: When to Stick With Notion
Notion works brilliantly when you want everything in one place and you’re comfortable with a bit of setup. It’s not ideal if you need robust accounting features, automatic tax calculations or deep invoicing integrations.
If invoicing gets complex (multiple currencies, VAT, recurring billing), consider pairing Notion with a dedicated tool like Bonsai or Wave. Use Notion for client and project management, and let the invoicing app handle compliance.
For small teams wondering whether Notion scales, read Notion vs Jira for small teams to see when Notion is enough and when you need something more specialised.
Next Steps After Setting Up Your Freelance Workspace
Add a time-tracking database if you bill hourly. Relate time entries to projects and clients, then use rollups to calculate billable hours automatically.
Create a proposals or leads database to track potential work. Link it to Clients so you can see conversion rates and follow-up history.
Integrate meeting notes. Create a Meetings database linked to Clients and Projects. After every call, log notes, action items and decisions. Everything stays in context, and you’ll never lose track of what was agreed.
As your workspace grows, keep asking: does this save me time, or am I just making busy work? The best Notion setups are the ones you actually use.
Frequently asked questions
Can I use Notion templates for invoicing without accounting software?
Yes, you can track invoice amounts, due dates and payment status in Notion using databases and formulas. However, Notion doesn't generate PDF invoices or handle tax calculations automatically. For simple invoicing, it works well; for compliance, VAT or recurring billing, pair it with a dedicated tool like Wave or Bonsai.
Are Notion templates for freelancers free?
Notion itself offers free templates in its template gallery, including some for freelancers. Third-party templates from marketplaces like Gumroad or Etsy range from free to around €50, depending on complexity. Notion's free plan supports unlimited pages and databases, so you can build your own without paying anything.
How do I link clients to projects in Notion?
In your Projects database, add a property and choose 'Relation' as the type. Select your Clients database as the target. Now you can link each project to a client record. Use rollup properties in the Clients database to display all related projects, budgets or deadlines automatically.
Can I automate invoice reminders in Notion?
Notion's built-in automations (available on paid plans) can send notifications or update properties based on triggers. For email reminders, connect Notion to Zapier or Make to send automated emails when an invoice is overdue. You can also use formula properties to highlight overdue invoices in your dashboard.
What's the best Notion template for managing multiple freelance clients?
Look for templates that include relational databases for Clients, Projects and Invoices, with rollup properties to track totals and statuses. Pre-built templates from Notion's gallery or third-party sellers often include sample data and instructions. The best template is one that matches your workflow—start simple and customise as you go.
How long does it take to set up a freelance workspace in Notion?
Building the three core databases (Clients, Projects, Invoices) with basic properties and relations takes one to two hours if you're new to Notion. Using a pre-built template cuts this to 15–30 minutes. Either way, expect to tweak and refine over the first few weeks as you discover what information you actually need daily.