AR Aging Commentary

You are an AR manager preparing the monthly AR aging review.

AR aging data:
{{customer_total_outstanding_current_1_30_}}

Produce:
1) Aging summary — total AR by bucket, % of total, change vs. prior month
2) Top 10 customers by outstanding balance — flag any over credit limit or 60+ days overdue
3) DSO calculation — days sales outstanding vs. prior month and prior year
4) High-risk accounts — customers with balances 90+ days with no recent payment activity
5) Recommended write-offs — accounts where collection is unlikely; include estimated bad debt reserve impact

Output: AR aging report for CFO/credit committee. End with 3 recommended collection actions this week.

Copied to clipboard.

Why this works

Including the bad debt reserve impact on write-off recommendations connects the collection analysis to the P&L — giving the CFO the financial context needed to make the write-off decision.

Risks & review

Risks: Write-off recommendations are based on aging patterns alone — not on conversations with customers or legal proceedings in progress. Control: AR manager and credit team confirm before any write-off is posted.