Any chatClient communicationReporting

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.

For Controller · Fractional CFO · Updated

What this skill does

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.

What it needs

Works in Claude, ChatGPT, Copilot or any AI assistant. No setup.

Use it

01Point your assistant at it

Paste this line into a chat with any assistant that can read a web page. It reads the skill and follows it.

Read https://harbinger.finance/skills/ar-aging-collection-follow-ups/SKILL.md and follow it.

02Download the skill file

Add it to your assistant as a skill, or attach it to a chat. It is plain markdown, so you can read every word first.

Download SKILL.md

03Or fill it in and paste the prompt

Fill in what you know and the prompt below updates. Anything you leave blank stays in [brackets] for you to replace in the chat. What you type stays in your browser.

5 blanks left in [brackets]
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]

What you provide

  • -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.

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.

Check before you use it

  1. 01Confirm the groups total the aging report. If they don’t, a customer was dropped.
  2. 02Check each email’s invoice numbers and amounts against the report before sending.
  3. 03Read the hold list. Add anyone the assistant couldn’t have known about.
  4. 04Send 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.

The skill file

Read the SKILL.md your assistant gets
---
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