Guides › Finance & Accounting
Review your aged debt report and agree next steps
Get a clear view of who owes what, which balances are getting worse and a suggested action for each, ready for your weekly credit meeting.
When to use it
Before each weekly or monthly credit meeting
Step by step
Export two aged debt reports
Export this period's and last period's aged debtor or collections report, using customer references rather than names if you can.
Ask for the review
Attach both reports to your AI assistant and use this prompt.
Prompt to copyHere are our aged debt reports for [this period] and [last period]. Our collection policy: [paste key rules, e.g. stop supply at 60 days, refer to collections at 90 days]. Give me: 1) Totals by age band for both periods and the change. 2) The ten largest overdue balances with days overdue and the next step under our policy. 3) Accounts that moved into a worse band since last period. 4) Accounts at or near referral under our policy. 5) Three points for the credit meeting. Tables where possible. Follow our policy only; don't recommend legal action.Check before you act
Confirm balances in your accounting system, since payments or disputes may not show in the export. Agree referrals with whoever has the authority.
Share the agreed actions
Post the agreed actions and owners in your Teams channel so the team can get going.
What you get
Total overdue £126k (last month £118k). 90+ days up £9k. Worse band: C-2210 (£14.2k, now 64 days), C-1877 (£6.1k, now 92 days). Near referral: C-1877, policy says refer at 90 days, owner to confirm no dispute. Meeting point: one customer is 31% of all overdue debt.
Tips
- Ask it to spot customers who always pay at about the same delay; changing their terms may help more than chasing.
- Don't paste client personal data, full account numbers or payroll details into a public AI tool unless your organisation allows it. Use your work-approved assistant if you have one.