AR Aging Commentary Prompt

Prompt

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

AR aging data:
[PASTE: Customer | Total outstanding | Current | 1-30 days | 31-60 days | 61-90 days | 90+ days | Credit limit]

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.

Why it 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.

Watch out for

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.

Used by

Finance TeamsExecutives

Browse all prompts →