01
The problem
Collections is a discipline problem. Manual chasing covers the squeaky-wheel accounts and quietly drops the rest, so DSO creeps up and cash that should be in the bank is sitting in someone inbox as a task they meant to get to.
02
How it is built
- 1Schedule trigger runs the AR aging check every day.
- 2ERP or Stripe block pulls the open invoices and their current status at the start of each run.
- 3Loop block iterates over the overdue invoices.
- 4Condition block picks the reminder stage based on how far past due the invoice is, and skips any invoice that has been paid since the last run, so no one gets chased after they have settled.
- 5Email block sends the stage-appropriate message, from a gentle nudge to a firm notice.
- 6Condition block escalates high-value or long-overdue accounts to a collector on Slack instead of another email.
03
The payoff
| Metric | Manual chasing | With this template |
|---|---|---|
| Follow-up coverage | The accounts someone remembers | Every overdue invoice |
| Escalation | Ad hoc | Rule-based, by value and age |
| Stop on payment | Manual, sometimes missed | Paid invoices drop out each run |
| Record of contact | Scattered | Logged per invoice |
Want this workflow built and maintained for your finance stack?
Book a demo