Auto-Track Overdue Client Invoices in Notion (With & Without Paid Tools)

How to Auto-Track Overdue Client Invoices in Notion (With & Without Paid Tools)

Introduction

You send an invoice and forget about it. Days pass. Suddenly you realize it’s overdue and nobody told you. Notion can fix this—you can set up automatic tracking so overdue invoices flag themselves. This article shows the free Notion-only way and when paid tools like Zapier make sense.

Section 1: Track Overdue Invoices in Notion (Free)

The free approach uses Notion’s built-in features—formulas, conditional formatting, and sorted views. You don’t need any integrations.

Set Up Your Invoices Database

Start with a simple Notion database. Create these columns:

• Invoice # (Text)
• Client (Text)
• Amount (Number)
• Date Sent (Date)
• Due Date (Date)
• Status (Select: Paid, Unpaid, Overdue)
• Days Overdue (Formula)

The “Days Overdue” column is where the automation happens. This formula calculates how many days past the due date an invoice is:

dateBetween(now(), prop(“Due Date”), “days”)

What this does: It takes today’s date and subtracts the due date. If the result is positive, the invoice is overdue. If it’s negative, it’s still upcoming. If it’s zero, it’s due today.

Important: This formula doesn’t change the Status column automatically. You still manually set Status to “Paid” or “Overdue.” But the Days Overdue number updates automatically every day.

Add Conditional Formatting

Now add a rule so overdue invoices stand out.

In your database view, click the view menu and select Conditional filters. Create a rule:

• If Days Overdue > 0
• Then highlight the row red (or yellow, your choice)

This way, every row with a positive Days Overdue value jumps out visually.

Sort by Days Overdue

Create a database view sorted by Days Overdue in descending order. This puts the oldest overdue invoices at the top.

Name this view something like “Overdue First” or “Invoices to Chase.” When you open Notion, you see the worst-case scenarios first.

Optional: Add a Button for Quick Actions

Notion buttons can create tasks or entries. For example:

• Create a button that says “Mark as Sent Reminder”
• When clicked, it creates a new task in a “Follow-ups” database with the invoice number and client name
• You can reference it later

This keeps your follow-up work in Notion without leaving the database.

What This Gives You

Pros:

• Free. No subscriptions.
• Instant visibility. Open Notion, see exactly which invoices are late and by how many days.
• Works offline. No API dependency.
• One source of truth. Invoices live in Notion.

Cons:

• Notion won’t remind you. You still have to open Notion to check.
• No automatic email or Slack alert if you forget to check.
• Still requires manual status updates (marking invoices as paid).

If you check Notion a few times a week anyway, this is often enough. If you’re someone who forgets to check tools, you’ll need the next approach.

Section 2: Adding Paid Tools (Zapier, Make, or n8n)

Paid tools add one thing: automated reminders. You don’t check Notion; Notion tells you.

Why You’d Want This

• You forget to log in. Zapier sends you a Slack message or email: “Invoice #42 to Acme Corp is now 3 days overdue.”
• You want invoices synced from accounting software. If you use Wave, Square, or another invoicing app, Zapier can pull new invoices into Notion automatically.
• You want a reminder at a specific time. Every Monday morning, get a report of all unpaid invoices.

The Tools

Zapier

• Cost: ~$10–20/month depending on task volume
• Setup time: 10–20 minutes
• Example zap: “When invoice is 2 days overdue → send me a Slack message”
• Easiest to set up for non-technical users

Make (formerly Integromat)

• Cost: ~$9–20/month
• Setup time: 15–30 minutes (slightly steeper learning curve)
• More flexible than Zapier; can do more complex workflows
• Similar to Zapier in practice

n8n

• Cost: Free (if self-hosted)
• Setup time: 2–4 hours (requires some technical knowledge)
• Best if you’re comfortable with servers or use a service like Replit
• No monthly fees after setup

Cost vs. Time Saved

If you bill $50/hour and a forgotten payment reminder costs you half an hour of chasing a client, that’s $25 lost. Zapier costs $10 for that month—so it pays for itself if it saves you once. Most freelancers it saves them several times a month.

If you bill $20/hour or less, the math gets tighter. The free Notion approach might be better.

How It Works (Zapier Example)

1. Connect Notion to Zapier

2. Set up a trigger: “When a database entry meets a condition” (Days Overdue > 2)

3. Set up an action: “Send me a Slack message” or “Send an email”

4. Test it and turn it on

Zapier checks your database every few minutes. When an invoice meets the condition, it sends the alert. That’s it.

Section 3: Best Approach

Start free. Set up the Notion-only system first. If you check it regularly and catch overdue invoices on time, stop there.

Add Zapier only if needed. If you’re missing invoices or constantly forgetting to check, add a single Zapier zap for overdue reminders. Don’t over-automate with 10 different alerts; pick one or two that matter.

Don’t automate what you’re already doing. If you manually check your Wave account every Monday, syncing invoices into Notion is busy work. If you never check Wave, sync it.

Section 4: Common Mistakes

Not setting due dates. If you leave the Due Date field blank, the Days Overdue formula returns null. Always fill it in, even if it’s 30 days from the date sent.

Not checking the view consistently. The free Notion system only works if you actually look at it. If you ignore the database for two weeks, don’t expect it to catch anything.

Over-complicating the formula. The formula above is enough. Don’t layer five other calculations on top of it. Keep it simple.

Forgetting to update status when paid. If you don’t mark an invoice “Paid,” it will show as overdue forever. Build this into your routine: when you see the payment hit your account, update the status in Notion.

Mixing unpaid and paid invoices in one view. Create separate views: one for “Unpaid” and one for “Paid.” It’s clearer.

Next Steps

“For a complete CRM system for client management in Notion,
start with building a free Notion CRM that works for freelancers.For a complete setup guide, see how to manage clients, projects, and invoices in Notion.

“For a complete overview of managing clients and projects in Notion,
see how to manage clients, projects, and invoices in Notion.”

If you want automated reminders without Notion tracking, check out how to automate payment reminders for overdue invoices.

Test the free Notion system for a month. If it works, great. If you’re still missing invoices, add Zapier. Most freelancers find the combo of free Notion + one simple Zapier reminder enough to catch everything. If you want to automate reminders alongside tracking,
see how to automate payment reminders without sounding pushy.”