Skip to content

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

  1. Starts whenOn a schedule
  2. Airtable: Find recordsInvoices 1 day overdue
  3. For eachEach one
  4. EmailA reminder
  5. Airtable: Find recordsInvoices 7 days overdue
  6. For eachEach one
  7. EmailOverdue
  8. Airtable: Find recordsInvoices 14 days overdue
  9. For eachEach one
  10. EmailSecond notice
  11. Airtable: Find recordsInvoices 21 days overdue
  12. For eachEach one
  13. NotifyTell the owner

What changes in each trade

Each trade’s version of Overdue invoice chase
TradeWhat differsStartsApps
CoachingCoaches 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 agencyIt 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 agencyDevelopment 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.

Every playbook type

Thrum is cooking.

Get early access and you’ll be among the first in. Early members get a launch perk.