Setting Up a Notion Workspace as a Freelancer: Clients, Projects and Invoices in One Place
Disclosure: this post was written with AI assistance. Freelancers usually run their business across five tools: a spreadsheet for clients, a to-do app, a folder of invoices, an email inbox and their own memory. Notion can replace several of those, but only if you set it up around a few linked databases rather than a pile of pages. Here's a structure that works for most solo freelancers and stays…
Freelancers often rely on several tools to manage their business, including spreadsheets, to-do apps, invoice folders, email inboxes, and their own memory. Notion can replace many of these tools, but its effectiveness depends on proper setup. The recommended structure consists of four linked databases: Clients, Projects, Tasks, and Invoices.
Clients are listed with one row per client, including their name, status (Lead, Active, Paused, Past), contact email, website, and rate (currency). Projects are linked to clients and have a status (Not started, In progress, Waiting on client, Done) along with dates, budget, and pricing. Tasks are linked to projects and have a title, due date, completion status, and time spent if billed hourly.
Invoices track invoice numbers, clients, projects, amounts, issued and due dates, status (Draft, Sent, Paid, Overdue), and attached PDF files. Days overdue is calculated using a formula property.
A central HQ page serves as the primary workspace, displaying linked views for Tasks (showing the Today view), Projects (a board view filtered for projects not yet completed), Invoices (filtered to overdue items), and Clients (showing only Active clients). This single page should be the first opened every morning.
Notion offers templates to save time, such as a New project template with a checklist for tasks and a Client onboarding template with a checklist for contracts, deposits, access, and kickoff scheduling. Initial automation might require external tools like Zapier or Make, but a thorough manual review for a month can help identify repetitive tasks for automation.
A weekly 15-minute review involves clearing the Today view, rescheduling pending projects, checking overdue invoices, and updating client statuses. Common mistakes include treating Notion as an accounting tool, storing sensitive client data poorly, and creating unnecessary database properties. The structure outlined above provides a clear overview of work and finances for most freelancers.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
