How I Track Projects & Payments in Notion

Summary

I track projects and payments in Notion using two linked databases: one for projects (with status and deadlines) and one for payments (amount, due date, sent/paid). No separate spreadsheet—everything lives in the same workspace I use to manage 10+ clients with Notion and AI. This post is the exact structure: how I set it up, how I track projects and payments week to week, and how it fits into my freelancer client management system.

Bottom line: If you already use Notion for clients and tasks, adding a dedicated way to track projects and payments takes about 30 minutes. You get one place to see what’s due, what’s invoiced, and what’s paid—without switching tools. I’ve included a step-by-step setup and a short FAQ so you can copy and adapt.

Why Track Projects and Payments in One Place?

When projects and payments live in different tools (e.g. tasks in Notion, invoices in a spreadsheet or billing app), you end up checking multiple places to answer “what’s due this week?” and “who owes me what?”. I wanted a single source of truth: one workspace where I could see project status and payment status together. Notion’s databases and relations make that possible. You don’t need to track projects in one app and payments in another—you can link them so that when you open a project, you see its payments, and when you open a client, you see both. I’ve described the full client–project–payment setup in my freelancer client management system guide; below is the minimal version for track projects and payments in Notion only.

The Setup: Two Databases Linked

You need two databases (and optionally a third for Clients if you don’t have one yet).

1. Projects database

Create a database called Projects. Each row = one project (or retainer milestone). Properties I use: Name (title), Client (relation to Clients DB), Status (e.g. Not started / In progress / Review / Done), Deadline (date), Payments (relation to Payments DB). This is the same idea as in my manage clients in Notion post—projects linked to clients so you can filter by client or by deadline. To track projects effectively, I use a Board view by Status and a Table view filtered to “Due this week” or “Overdue”.

2. Payments database

Create a database called Payments. Each row = one invoice or payment expected. Properties: Name (e.g. “Mar 2026 – Project X”), Project (relation to Projects), Amount (number), Due date (date), Status (e.g. Not sent / Sent / Paid / Overdue). Optionally: Sent date, Paid date. When you link Payments to Projects, you can see from a project page all payments for that project—and from a payment row you see which project it belongs to. That’s how I track payments in Notion without a separate spreadsheet. For a full CRM-style setup including clients, see best CRM tools for freelancers in India—Notion is one of the options I use and recommend.

How I Track Payments in Notion

When I close a milestone or finish a project, I add a row to the Payments database: amount, due date, link to the project. Status starts as “Not sent”. When I send the invoice (via email, Stripe, or whatever I use for actual billing), I set Status to “Sent” and optionally fill Sent date. When the client pays, I set Status to “Paid” and add Paid date. I don’t process money inside Notion—I use it purely to track projects and payments so I know what’s outstanding. A simple Table view filtered to Status ≠ Paid shows everything that’s still open; a filter for Due date < this week surfaces what needs follow-up. This fits into the broader system I described in freelancer client management system and in the case study on freelance income and AI—tracking is the foundation; AI and automation help with the writing and follow-ups.

Weekly Workflow

Start of week: Open Projects, filter by Deadline this week. Move anything that’s done to “Review” or “Done” and create a Payment row if an invoice is due. Open Payments, filter by Status = Sent and Due date in the past—these are candidates for a polite follow-up. End of week: Update any new “Paid” statuses so the list stays accurate. I spend maybe 15 minutes on this; the rest of the time I’m doing the work, not updating trackers. If you’re scaling income and want to tie this to pricing and client growth, see my freelance income roadmap for how projects and payments fit into the bigger picture.

FAQ