Invoice Aging and Collections Risk Analysis
Analyze accounts receivable aging data to prioritize collections, forecast cash flow risk, and recommend outreach actions.
Prompt Template
Act as a finance analytics lead. Analyze invoice aging and collections risk for [company/business model] using the data below. Data available: [paste table or describe fields: customer, invoice amount, due date, invoice date, days overdue, payment history, account owner, segment, disputed status, promised pay date] Current AR total: [amount] Cash flow target: [monthly/quarterly target] Collections policy: [reminder cadence, late fees, escalation rules] Customer segments: [SMB, enterprise, strategic accounts, region, industry] Known constraints: [do-not-contact accounts, disputed invoices, payment plans, relationship sensitivity] Deliver: 1. **Executive summary** — total AR, overdue amount, high-risk exposure, and cash flow implication 2. **Aging breakdown** — current, 1-30, 31-60, 61-90, 90+ days, with percentages 3. **Risk segmentation** — customer groups by amount, age, payment behavior, dispute status, and strategic value 4. **Collections priority list** — top accounts to contact first and why 5. **Cash forecast scenarios** — conservative, expected, and upside collection assumptions 6. **Recommended actions** — outreach sequence, owner assignment, escalation, dispute resolution, and payment plan options 7. **Dashboard metrics** — KPIs to track weekly 8. **Data quality issues** — missing fields, inconsistent dates, duplicate invoices, or classification gaps If exact data is incomplete, state assumptions clearly and show what fields would improve the analysis.
Example Output
Invoice Aging Analysis — B2B Services Firm
Executive Summary
Total AR is $418,200. Overdue AR is $156,400, or 37% of the balance. The highest cash risk sits in five accounts that are 61+ days overdue and represent $74,000 of exposure.
Aging Breakdown
| Bucket | Amount | % of AR | Notes |
|---|---:|---:|---|
| Current | $261,800 | 63% | Healthy, mostly enterprise retainers |
| 1-30 days | $62,500 | 15% | Normal reminder cadence |
| 31-60 days | $19,900 | 5% | Needs account-owner follow-up |
| 61-90 days | $41,000 | 10% | Two disputed invoices |
| 90+ days | $33,000 | 8% | High write-off risk |
Priority Actions
1. Northstar Retail — $28,000, 73 days overdue, promised payment missed twice. Escalate to account lead and request payment date today.
2. Blue Dock Ltd — $19,500, disputed scope item. Assign finance + delivery owner to resolve blocker within 48 hours.
Tips for Best Results
- 💡Include customer segment and account owner fields so recommendations can balance cash urgency with relationship sensitivity.
- 💡Ask for conservative, expected, and upside scenarios if the output will feed a cash forecast.
- 💡Flag disputed invoices separately; they need resolution workflow, not just more reminders.
- 💡Do not paste sensitive banking details or unnecessary personal data into the prompt.
Related Prompts
Dataset Summary and Insights
Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.
SQL Query Writer for Business Reports
Generate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.
Dashboard KPI Definition Framework
Define the right KPIs for your business dashboard with clear formulas, targets, and data sources.