Overdue invoice chase
Remind customers of unpaid invoices one, seven and fourteen days after they fall due, firmer each time, and hand the twenty-one-day ones to the owner.
Chasing an invoice is awkward, so it is put off, and an invoice that is not chased in the first weeks becomes much harder to collect. A schedule that sends the polite reminder, then the firmer one, then hands over to the owner, does the awkward part every time and stops the day the invoice is marked paid.
How it works
This one runs on a schedule each weekday morning and reads the client’s unpaid invoices from an Airtable table with the columns Status, Due date, Name, Email, Invoice, Amount and Link. Each morning it looks for invoices still marked Unpaid that fell due exactly one, seven, fourteen or twenty-one days earlier.
One day late, the customer gets a gentle email saying the invoice was due yesterday and to ignore the note if payment is on its way. At seven days the email says it is a week overdue and asks for payment this week, or a reply if something is wrong with it. At fourteen days a second notice asks them to pay now or call to agree a date. Each email names the invoice and amount and carries the pay link from the table’s Link column, so every row needs the link from wherever the invoice was raised.
At twenty-one days no more email goes to the customer. The owner gets one email per invoice naming the customer, the invoice and the amount, saying three reminders have gone and it is now over to them.
Chasing stops the day the table shows anything other than Unpaid, so keeping Status current is what spares a paying customer a reminder. It reads that Airtable table and nothing else, which the client keeps up to date by hand or syncs from their invoicing.
The steps, as written for coaching
- Starts whenOn a schedule
- Airtable: Find recordsInvoices 1 day overdue
Airtable
- For eachEach one
- EmailA reminder
- Airtable: Find recordsInvoices 7 days overdue
Airtable
- For eachEach one
- EmailOverdue
- Airtable: Find recordsInvoices 14 days overdue
Airtable
- For eachEach one
- EmailSecond notice
- Airtable: Find recordsInvoices 21 days overdue
Airtable
- For eachEach one
- NotifyTell the owner
What changes in each trade
| Trade | What differs | Starts | Apps |
|---|---|---|---|
| Coaching | Coaches install it as a single playbook, outside the executive, group-program and small-business packs, with the same Airtable columns and the same four dates. | At a set time | |
| Marketing agency | It closes the Paid-ads agency pack, after Won-deal kickoff and Meeting follow-up, for an agency often paid as a share of its client’s ad spend. | At a set time | |
| Software development agency | Development agencies run the same table-driven schedule, and since neither dev agency pack includes it, it is installed on its own beside whichever pack the agency chose. | At a set time |
Install it for a trade
Each version installs into the client you choose, switched off, with a checklist of the accounts to connect and the details to fill in.
Thrum is cooking.
Get early access and you’ll be among the first in. Early members get a launch perk.