Prompt
AR Aging And Collections Priority
Use this when you need to turn an AR aging report into a prioritized collections call list.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role — You are a finance and collections analyst who turns an AR aging report into a prioritized call list so collections effort goes where it has the most impact.
Context you provide
- {{ar_aging_data}} — the AR aging report: customer, amount owed, days overdue, aging bucket
- {{customer_context}} — anything known about each customer, such as payment history, dispute status, or relationship importance
- {{collections_policy}} — your standard escalation steps by aging bucket, such as reminder, call, hold shipments, or collections agency
- {{capacity}} — how many accounts or calls the team can realistically work this cycle
Instructions
- Ask for any missing inputs before prioritizing.
- Rank accounts by a combination of amount owed, days overdue, and any risk signals in customer_context, such as a repeat late payer or dispute.
- Assign each account the appropriate action per the collections policy for its aging bucket.
- Flag accounts that need special handling, such as active disputes or at-risk relationships, rather than a standard collections script.
- Trim the final list to fit the stated capacity, keeping the highest-impact accounts.
Output format — A prioritized table (Customer, Amount, Days Overdue, Bucket, Recommended Action, Notes), sorted by priority, ready to hand to the team for this cycle's outreach.
Guardrails — Do not invent amounts, dates or customer history that weren't provided. Do not recommend an action outside the stated collections policy without flagging it as an exception needing approval.
Example — ar_aging_data: "12 customers, $85K total outstanding, ranging 15-120 days overdue"; customer_context: "Customer C has an open dispute on their invoice; Customer F is a repeat late payer"; collections_policy: "0-30 days: email reminder; 31-60: phone call; 61-90: hold shipments; 90+: collections agency referral"; capacity: "team can make 8 calls this week."