New BuildPhase 1 — FoundationWF-04

Collections & AR

Unpaid invoices were being tracked by memory, not by system. Follow-ups happened when someone had bandwidth — which meant they were inconsistent, late, or skipped entirely. This workflow closes the invoice-to-cash cycle automatically.

The Gap I Found

The invoice went out.
Everything after that was someone's job to remember.

Once an invoice was sent, the system had done its job. There was no mechanism tracking whether it had been paid, how long it had been outstanding, or when a follow-up was due. That monitoring lived entirely in someone's head — cross-referenced against a spreadsheet, a sticky note, or a mental list of who owed what.

The result was not that follow-ups never happened. It was that they happened inconsistently. When the person responsible was under pressure — which is exactly when the most invoices tend to be outstanding — AR follow-up was the first thing that got deprioritised. Overdue invoices aged silently because there was no trigger to surface them.

Cash position was guessed, not known. The number on the screen reflected what had been invoiced, not what had actually been collected. Leadership was making decisions on a number that nobody had verified in days.

Why It Happens

The invoice-to-cash cycle
had no automated touchpoints after "sent."

Invoicing tools are built to send — not to monitor. Once the invoice leaves, the system considers the job complete. What happens between "sent" and "paid" is a gap that belongs to no tool and no automated process — which means it defaults to whoever is willing to carry it manually.

Payment follow-up is not a difficult task. It is a repetitive, time-sensitive one. And repetitive, time-sensitive tasks that require human initiative fail in exactly the same way every time: they compete with everything else on someone's plate, and they lose when the day is full.

What I Designed

A system that monitors every invoice
from sent to paid — without anyone watching it.

A monitoring layer sits behind every outstanding invoice from the moment it goes out. Three timed triggers fire automatically: a reminder seven days before the due date, a due-date check on the day, and an overdue notice at day seven past due. Each trigger escalates — the final one prompts direct follow-up from the account owner, not just an automated email.

When payment arrives, the Financial DB updates and the AR balance in the Report Dashboard refreshes live. No invoice is forgotten. No follow-up requires someone to remember it. The quality and timing of each touchpoint is consistent regardless of who is having a busy week.

Before

Invoice sent, system considers job complete
Manual review of outstanding invoices when bandwidth allows
Follow-up email drafted and sent per invoice, by hand
Second and third chasers inconsistent — depends on who remembers
Cash position estimated, not tracked live
AR management: 2–4 hrs/week · Follow-up: inconsistent · Cash position: guessed

After

Invoice sent, monitoring begins automatically
Day −7: automated payment reminder sent to client
Day 0: due date alert fires to account owner
Day +7: overdue notice sent, direct follow-up prompted
Payment received → Financial DB updates → AR balance refreshes live
AR management: ~0 manual hrs · Follow-up: timed, automatic · Cash: live

Trigger sequence — invoice sent to payment received

Invoice

Invoice sent → monitoring starts

The moment an invoice goes out, the system registers it as outstanding and starts the clock.

Day −7

Automated reminder email to client

A professional reminder goes out a week before the due date — same tone, same timing, every time.

Day 0

Due date check → escalation alert to account owner

If unpaid on the due date, the account owner is flagged directly. Escalation is now a conscious choice, not an oversight.

Day +7

Overdue notice + direct follow-up prompted

An overdue notice goes to the client. The account owner is prompted for direct contact — the system hands off where human judgment matters most.

Paid

Payment received → status = Paid → AR balance updates live

On payment, the Financial DB updates and the AR balance in the Report Dashboard refreshes. Cash position reflects reality — immediately.

Systems Involved

Financial DB (Notion / Airtable / QuickBooks)CRM (client contact data)Email automation (Gmail / Outlook)Report DashboardAutomation (Make / Zapier / n8n)

What Changed

Every invoice chased on time.
Cash position visible live.

0

Manual follow-up hours

What was 2–4 hours per week of manual chasing is now handled by the system. Follow-ups go out on schedule whether or not anyone has bandwidth that day.

100%

Consistency across every invoice

Every outstanding invoice gets the same treatment — the same timing, the same escalation sequence — regardless of who is managing it or how busy the week is.

Live

AR balance in the dashboard

Cash position updates the moment a payment is received. No manual reconciliation, no end-of-week catch-up. The number leadership sees is always current.

Human at the right moment

The system handles the first two touchpoints automatically. It escalates to the account owner at day zero and hands off for direct contact at day seven — where human judgment actually matters.

Before, AR follow-up quality depended entirely on who was doing it and when they got to it. Two invoices sent the same week could receive completely different follow-up experiences based on nothing more than who happened to have bandwidth. Now every invoice receives identical treatment — on schedule, without exception, without mental overhead.

How It Connects

Closes the invoice loop that
Invoice & Billing opens.

Invoice & Billing generates the invoice. This workflow monitors what happens after. Together they form the complete billing cycle — from hours worked to cash collected — with no manual step required between the two ends. The AR balance that feeds the Report Dashboard is only accurate if this monitoring layer is running.

◄──Invoice & BillingAR follow-up only works on invoices that exist; Invoice & Billing generates the record this workflow monitors.
──►Financial DBPayment status updates on receipt; the AR balance reflects collected cash, not just invoiced amounts.
──►Report DashboardAR balance refreshes live on payment; cash forecast is accurate only because this workflow is closing the loop in real time.

Feel the Gap

Walk the old process.

This is what managing accounts receivable looked like before the system existed. Step through it and feel where the time and certainty drain out.

1
2
3
4
5

Step 1 of 5

An invoice just went out.

You sent it, filed it, moved on. There are six other invoices outstanding this week. You have a project to deliver, a proposal to finish, and three things in your inbox that needed a reply yesterday. The invoice is out — that felt like progress.

invoice sent — clock is running
Step 1 of 5

Linh Pham

Operations Analyst

Ready to automate your ops?

pdlinh.vyco@gmail.com

© 2025 Linh Pham · Based in Canada · Remote Worldwide

Live Demo

Try the AR Follow-up Flow

Describe your current AR situation and see how the automated follow-up sequence responds.

Your Situation
Cmd+Enter to run
Follow-up Sequence

Submit a prompt to see the workflow output here

Ready to implement this in your business?

See This Running in Your Business

Free 30-min audit · No commitment required

Linh Pham

Operations Workflow Architect

Turning chaos into systems that work

Home

Works

Contact

Ready to automate your ops?

pdlinh.vyco@gmail.com

© 2025 Linh Pham · Based in Canada · Remote Worldwide