Home / Writing

Build a Notion Invoice Tracker in 20 Minutes

First, the honest question

Notion is a good place to track invoices if you already work in Notion and want invoices next to clients, projects and notes. It is a worse place than a spreadsheet if all you need is a sum and a sort.

The dividing line: use Notion when the invoice needs context (which project, which contact, what was promised) and a spreadsheet when it does not. If you are sending five invoices a month to repeat clients, Notion wins because you stop rebuilding the same rows.

The schema

One database called Invoices, five properties that do the work:

PropertyTypeWhy
InvoiceTitleINV-2026-0142 — keep the number in the title so search works
ClientRelation → ClientsLets you see everything for one client in one place
AmountNumber (currency)The number you will sum
IssuedDateStart of the clock
DueDateThe date that matters; do not rely on terms alone
StatusSelectDraft / Sent / Paid / Overdue / Written off
Paid onDateOptional, but it lets you compute real payment time

If you add nothing else, add these. Every extra property is a field you will stop filling in by week three.

The three formulas worth having

Days overdue. In a formula property:

`` if(and(not(empty(prop("Paid on"))), prop("Status") == "Paid"), 0, if(empty(prop("Due")), 0, dateBetween(now(), prop("Due"), "days"))) ``

Positive means late, negative means still within terms.

Aging bucket. A second formula turns that number into a label you can group by:

`` if(prop("Status") == "Paid", "Paid", if(prop("Days overdue") <= 0, "Current", if(prop("Days overdue") <= 30, "1–30", if(prop("Days overdue") <= 60, "31–60", "60+")))) ``

Group a view by this and you have an aging report, which is the thing that tells you whether to send a reminder or change your terms.

Effective wait. A number property you fill when paid: dateBetween(prop("Paid on"), prop("Issued"), "days"). Average it across twelve months and you know your true days sales outstanding, not the number you assumed.

Four views that replace a dashboard

  1. Chase today — filter Status = Sent and Days overdue ≥ 0, sort by days overdue descending. This is the only view you need on a Monday.
  2. Outstanding by client — group by Client, sum Amount whole database. Shows concentration risk in one screen.
  3. Aging — group by the aging bucket. If more than 20% sits in 1–30, start calling.
  4. Paid this year — filter Status = Paid, sort by Paid on. This is your income record for tax, and it takes ten seconds to export.

The weekly ritual

Fifteen minutes, same day every week:

  1. Open the chase view. Send the day-one reminder to everything new.
  2. Move anything past eight days to the firmer email.
  3. Update Status to Paid as payments land. This is the step people skip, and it is the reason the numbers go stale.

That is the whole system. The value is not the database, it is that the chase view exists and you look at it.

What Notion does badly here

  • Recurring invoices. No native recurrence on a row; you copy manually or use a template button.
  • Totals across filtered views. Rollups help, but summing a filtered set is clunkier than a spreadsheet formula.
  • Sharing with an accountant. They will want a CSV; export works, but the columns are not tuned for bookkeeping.

If your invoicing is mostly recurring retainers with fixed amounts, the spreadsheet route is shorter — the Freelance Cash-Flow OS covers that case, and this tracker covers the project-based one.

If you want the schema pre-built

The Solopreneur Business OS ships this Invoices database plus Clients, Projects, Deliverables and Expenses, already related and with the formulas above installed.