Accountant Accounts Receivable Aging Review
===========================================

Create an accounts receivable aging review and collection action plan for [Company].

AR details:
- Company: [name]
- Total AR balance: $[amount]
- Report date: [date]
- Payment terms: [net 30/60/other]
- Average collection period: [days]

AR AGING REVIEW

AGING SUMMARY
| Bucket | Amount | % of Total |
| Current (0-30 days) | $[] | [%] |
| 31-60 days | $[] | [%] |
| 61-90 days | $[] | [%] |
| 91-120 days | $[] | [%] |
| Over 120 days | $[] | [%] |
| TOTAL | $[] | 100% |

TOP 10 OUTSTANDING BALANCES
1. [Customer]: $[amount] — [days outstanding]
2. [Customer]: $[amount] — [days]
[Continue for top 10]

COLLECTION ACTION PLAN

31-60 DAYS PAST DUE
- Action: Friendly reminder email
- Tone: Assume oversight
- Timing: Immediately
- Script: "Just a friendly reminder that invoice #[X] for $[amount] was due on [date]. Please let us know if you have any questions."

61-90 DAYS PAST DUE
- Action: Phone call + follow-up email
- Tone: Firm but professional
- Escalate to: [owner/manager]
- Discuss: Payment plan if needed

91-120 DAYS PAST DUE
- Action: Formal demand letter
- Consider: Hold future services
- Discuss: Settlement or payment plan
- Consult: Attorney if large balance

OVER 120 DAYS
- Action: Final demand
- Consider: Collections agency
- Consider: Write off assessment
- Tax implication: Bad debt deduction

KEY METRICS
- Days Sales Outstanding (DSO): [days]
- Collection effectiveness index: [%]
- Bad debt as % of revenue: [%]

RECOMMENDATIONS
- Credit policy review: [if needed]
- Deposit requirements: [for new clients]
- Automated reminders: [set up]
- Lien rights: [for construction clients]

Source: https://promptzyo.com/prompt/accountant-accounts-receivable-aging-review