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
- | Customer | Not yet due | 1-30 days late | 31-60 | 61-90 | Over 90 | Total overdue |, sorted by total overdue.
- Call list for this week: | Rank | Customer | Overdue amount | Oldest invoice | Reason for rank | Next action |
- Rank by amount and age together, and put customers with a history of promises not kept higher.
- Call scripts of three to five lines each for: first reminder, broken promise, disputed invoice, very old debt.
- 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.






