wowprompt

Accounts receivable ageing and collection call list

Turns an unpaid invoice list into an ageing summary by customer, a ranked collection call list for this week and a short script for each type of late payer. Use it at month end, before a cash crunch, or when one person has to chase dozens of overdue invoices.

An ageing table of overdue amounts by customer and days late, a prioritised call list with the next action for each, and short call scripts by payer type
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Open invoices: [paste rows: customer, invoice number, invoice date, due date, amount, amount paid, notes]
  • Today's date: [date]
  • Credit terms: [e.g. 30 days, or terms per customer]
  • Customers to treat carefully: [e.g. a key account, a customer with a dispute]
  • Who will call and how many calls a day: [e.g. one accounts person, 15 calls]
  • Currency: [e.g. INR]

Task

Age every unpaid invoice from its due date, total by customer, and plan this week's collection calls.

Output format

  1. | Customer | Not yet due | 1-30 days late | 31-60 | 61-90 | Over 90 | Total overdue |, sorted by total overdue.
  2. Call list for this week: | Rank | Customer | Overdue amount | Oldest invoice | Reason for rank | Next action |
  3. Rank by amount and age together, and put customers with a history of promises not kept higher.
  4. Call scripts of three to five lines each for: first reminder, broken promise, disputed invoice, very old debt.
  5. Customers to put on hold for new credit, with the rule used.

Rules

  • Disputed invoices are listed apart and not chased for payment until the dispute is settled.
  • Keep the tone of every script firm and polite; no threats.
  • Recommend legal notice only for debts over 90 days, and say it needs a manager's approval.
  • Show every total so it can be checked against the ledger.
accounts receivablereceivables ageingoverdue invoicescollectionscash flowcredit control

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity