Build a Notion Invoice Tracker That Actually Gets You Paid
How to track freelance invoices in Notion so overdue payments surface themselves — the formulas, the views, and the one number that matters.
Most freelance proposals don't get rejected. They get forgotten — by the client, who meant to reply and didn't, and by the freelancer, who sent it and moved on to the next thing. The proposal isn't dead. It's just sitting in an inbox with no follow-up date attached to it, which for practical purposes is the same thing.
The fix isn't a better proposal template. It's a place to log every proposal you send with one property that matters more than the rest: when you'll follow up if you don't hear back.
One database, one row per proposal. Keep it smaller than you think you need:
Sent, Accepted, Declined, No ResponseThat's it. Resist adding a "confidence level" or "notes on client vibe" property on day one — those get filled in enthusiastically for the first three proposals and never again. A tracker that's tedious to update stops being a tracker.
The single formula that makes this system work:
Needs Follow-up:
if(and(prop("Status") == "Sent", prop("Follow-up Date") <= now()),
"📬 Follow up", "")
Filter a view to Needs Follow-up is not empty and you have a list that only contains proposals
that are actually due for a nudge — not every proposal you've ever sent, just the ones sitting past
their follow-up window with no reply. Check that view once a week and you'll never again wonder
whether you already followed up with someone.
The follow-up itself doesn't need to be complicated. "Just checking in on this — happy to answer any questions" is enough. The value isn't in the wording, it's in the message existing at all. Most proposals that convert late convert because someone sent exactly this email.
A second view, grouped by Status, tells you something a single "proposals sent" number can't:
your real conversion rate. If ten proposals sat as Sent for a month and only two moved to
Accepted, that's not bad luck — it's a signal about your pricing, your targeting, or how you're
following up. A pipeline you can see is a pipeline you can actually improve; a pipeline that only
exists in your memory just feels vaguely stressful.
Proposals and invoices are the same shape of problem pointed in opposite directions — one is money that might arrive, the other is money that should have. Keeping them in the same system means you can answer "what am I actually owed or likely to be owed this month" without switching tools. Invoice & Proposal Hub builds exactly this: proposal tracking with a follow-up flag, sitting next to an invoice log with its own overdue flag, both rolling up to one outstanding-balance view.
A flat proposal list works fine while you're sending a handful a month to people you already know.
It stops working once a proposal needs its own history — every call, every revision, every "can you
also quote X" — because a single Notes field can't hold a relationship, only a snapshot of it. That's
the point to move to Freelance CRM Pro, where a proposal becomes a
deal stage on a client's page instead of an isolated row, and the follow-up logic gets the client's
whole history attached to it instead of just a date.
If none of this feels worth building today, do the smallest version: add one column to whatever you're already using — a spreadsheet, a notes app, anything — called "follow up by," and fill it in every time you send a proposal. That single habit fixes the actual problem. Everything else here is just a better place to keep that column once you're tracking more than a few proposals at once.
Track every invoice's status and outstanding balance without leaving Notion.
Business & FreelanceClients, projects, and deals linked together, with a pipeline that shows exactly what's active.
Business & FreelanceA free, simple client list with contact info, status, and notes.
Business & FreelanceHow to track freelance invoices in Notion so overdue payments surface themselves — the formulas, the views, and the one number that matters.
A practical guide to building a freelance client tracker in Notion — what to include, what to skip, and when a simple list should become a real CRM.
How to adapt a Notion CRM to track monthly retainer clients — hours used, renewal dates, and the one view that stops a retainer quietly running over.
One email when something new ships, plus the occasional Notion system breakdown. No drip sequence, no upsell ladder — unsubscribe in one click.