---
name: ar-aging-collection-follow-ups
description: "Use when the user pastes an accounts receivable aging report and wants customers sorted by the follow-up each needs, with a collection email drafted per customer from the invoice numbers, dates and amounts in the data. Triggers: AR aging, collections, past due invoices, chase payments, dunning emails, overdue customers."
metadata:
  lane: use
  requires: "none"
  source: https://harbinger.finance/skills/ar-aging-collection-follow-ups
  updated: "2026-11-18"
---

# Turn an AR aging into collection follow-ups

Sort an aging report into who gets a reminder, who gets a firmer note and who gets a phone call, with each email drafted from the invoice data.

## When to use it

Weekly, or whenever the aging has grown and nobody has had time to work it. Collections slip because each follow-up is small and there are forty of them. The assistant does the sorting and the first draft of each note, so the time goes to the calls that need a person.

It only knows what's in the report and what you tell it. A customer with a billing dispute or a payment promise looks the same as one who is ignoring you, so give it what you know, and it holds those out.

**Where it works.** Any AI assistant. No setup.

## Ask the user for

- The aging report: customer, invoice number, invoice date, due date, amount.
- Your payment terms, and whether they include late fees.
- What you know: disputes, promised dates, customers to leave alone.
- The tone you want.
- Use customer names only if you’re comfortable pasting them. Codes work as well.

Ask for anything missing before you start. Never invent a figure to fill a gap.

## Do this

Carry out the request below. Fill each [bracketed] item from what the user gave you.

Work this accounts receivable aging, as of [date]. Our terms are [terms, and whether they include late fees].

Put every customer with an open balance into exactly one group:
1. Not due yet: nothing to send.
2. Reminder: a little past due, first contact.
3. Firmer follow-up: well past due, or already reminded.
4. Call, don't email: the largest overdue balances, or anything long past due.
5. Hold: a dispute, a promised date that hasn't passed, or a customer I said to leave alone.

For groups 2 and 3, draft one short email per customer. List each overdue invoice by number, date and amount, exactly as in the report, and ask for a payment date. Tone: [friendly or firm]. Don't threaten, and don't mention late fees or stopping work unless our terms say so.

For group 4, give me three lines to open the call with.

Then show that the five groups add up to the total on the report, and tell me how much of the overdue balance sits with the three largest customers.

Use only invoices in the report. If a customer's lines look wrong, such as a credit that would clear an invoice, flag it instead of chasing it.

What I already know:
[disputes, promised dates, customers to leave alone]

Aging:
[paste the aging report]

## Before you hand it over

Tell the user which of these checks they still need to make:

- Confirm the groups total the aging report. If they don’t, a customer was dropped.
- Check each email’s invoice numbers and amounts against the report before sending.
- Read the hold list. Add anyone the assistant couldn’t have known about.
- Send from your own account, in your own name. Nothing here sends anything.

The assistant drafts. The person whose name is on the work approves it.

## What a good answer looks like

*Illustrative figures for made-up customers.*

**1. Not due yet ($41,200)** 6 customers.

**2. Reminder ($12,850)**

*Harlow Supply*
> Hi, a quick note that invoice 2304 (10-12, $3,150) was due on 11-11 and is still open on our side. Could you let me know when we should expect payment? If it's already on its way, thank you and please ignore this.

**3. Firmer follow-up ($9,400)**

*Bexley Group*
> Following up on two invoices that are now past due: 2251 (09-03, $4,900, due 10-03) and 2277 (09-24, $4,500, due 10-24), $9,400 in total. Please reply with a payment date for each by Friday.

**4. Call, don't email ($28,600)**
*Northfield Electrical*, $28,600, oldest invoice 96 days. Open with: the total and the oldest invoice; ask whether anything is holding up approval; ask for a date, or a schedule if they can't pay in full.

**5. Hold ($7,300)** Lakeside (disputes 2291), Orchard (promised the 25th).

**Flag.** Dunmore shows invoice 2260 for $1,800 and an unapplied credit of $1,800. That looks like a payment not applied.

Groups total $99,350, matching the report. The three largest overdue customers hold 71% of the overdue balance.

---

From the Harbinger FinLab skill library: https://harbinger.finance/skills/ar-aging-collection-follow-ups
