AR Aging Analysis & Collection Prioritization
Analyze AR aging patterns and prioritize collections by credit risk
What You Can Do
This skill transforms raw AR data into strategic collection intelligence by automatically categorizing invoices by aging bucket, flagging high-risk accounts based on payment deviations, calculating DSO trends, and recommending prioritized collection actions. You'll reduce manual aging report compilation from 4-6 hours weekly to minutes while improving cash flow visibility and recovery rates.
Features
Example Output
Input: AR aging data for 85 customer accounts with invoice details, payment history, and current balances
Output:
High Priority (28 accounts)
- ABC Manufacturing: $47,500 past-due | 127 days average age | Pattern: 60-day payment cycle broken | Action: Immediate contact + payment plan negotiation
- XYZ Corp: $23,000 past-due | Deteriorating trend (was 30-day payer, now 75+) | Action: Credit review + escalation
Medium Priority (34 accounts)
- Client D: $12,300 at-risk | Industry downturn signals | Action: Proactive outreach + flexibility offer
Low Priority (23 accounts)
- Reliable customers with minor current balances | Standard collection cadence
Cash Impact: $156,400 collectible within 30 days with prioritized efforts | DSO trending from 42 to 48 days (industry: 35 days)
What's Included
- SKILL.md instruction file with complete AR aging analysis framework:
- AR Data Template: standardized CSV/JSON format for invoice-level input (customer, invoice #, amount, due date, days past due)
- Credit Risk Assessment Checklist: payment pattern deviations, industry factors, and red flags to monitor
- Collection Priority Matrix: mapping accounts by risk level and cash impact for action sequencing
- Executive Summary Template: cash forecast, DSO analysis, and management reporting format
Who It's For
- Staff accountants managing AR reconciliation and aging report generation
- AR managers analyzing collection strategies and credit risk trends
- Credit controllers prioritizing accounts for recovery action
- Finance teams forecasting collectible cash for period closings
- Collection departments receiving prioritized account lists for engagement
Best For
- Weekly or monthly AR aging report compilation with 50+ customer accounts
- Identifying high-risk accounts requiring aggressive collection vs. negotiated payment plans
- Assessing whether customer payment deterioration is temporary cash flow or structural credit risk
- DSO trend analysis and cash flow forecasting for month-end closings
- Collection department handoff preparation with prioritized action lists
- Post-process change effectiveness measurement and collection performance benchmarking
You might also like
You can systematically prepare tax provisions that survive audit scrutiny by calculating current and deferred tax impacts, reconciling effective tax rates from statutory to reported amounts, and documenting uncertain tax positions with FIN 48 support. The skill guides you through multi-jurisdictional tax exposure analysis and helps you create audit-ready workpapers with clear audit trails for quarterly (10-Q) and annual (10-K) financial statement filings.
by eryet
You can analyze large volumes of transaction data to identify telltale fraud patterns that perpetrators use to obscure illegal activity—including threshold splitting, timing manipulations, circular routing, and gradual escalation tactics. Claude processes multiple detection lenses simultaneously (temporal anomalies, network patterns, statistical outliers, behavioral shifts) and synthesizes findings into coherent fraud narratives with quantified exposure estimates and litigation-ready evidence chains.
by eryet
You can analyze transaction clusters to identify layering, placement, and integration schemes using proven AML methodologies. Claude applies typology frameworks to suspicious fund flows, cross-border movements, and beneficiary ownership chains—transforming raw transaction flags into regulatory-grade narratives that justify SAR escalation and withstand compliance audits.
by eryet
You can execute structured compliance audits that map regulatory requirements to operational controls, test control effectiveness with documented evidence, quantify compliance risk exposure, and track remediation progress with clear accountability. The framework produces audit findings in regulatory-acceptable format, transforming ad-hoc reviews into defensible procedures that satisfy internal audit standards (IIA) and regulatory expectations.
by eryet
You can analyze insurance claim files to uncover fraud indicators by synthesizing evidence from policyholder statements, medical/repair records, financial documents, and prior claims history. This skill helps you reconstruct timelines, identify inconsistencies and impossibilities, recognize suspicious financial patterns, and build defensible fraud conclusions suitable for claims adjustment, litigation support, or settlement negotiations. Transform raw claim data into an evidence hierarchy distinguishing confirmed facts, supported inferences, and investigative leads requiring further development.
by eryet
You can allocate indirect costs (administration, utilities, depreciation, maintenance) across clinical and non-clinical departments using activity-based costing (ABC) and traditional allocation methodologies. This skill helps you calculate precise allocation rates, model reimbursement scenarios, validate cost driver selections, and document allocation methods for compliance—enabling data-driven decisions on service line profitability, pricing strategies, and payer contract negotiations.
by eryet
You can systematically classify and track expenses against specific restricted grants and donations, reconcile fund balances with compliance verification, and generate accurate financial statements that separate restricted and unrestricted funds. This skill prevents audit failures, donor relation damage, and grant non-compliance penalties by ensuring every restricted fund expense is properly documented, allowable under grant terms, and traceable to donor/grantor requirements.
by eryet
You can rapidly design, document, and validate internal control frameworks aligned with COSO 2013, SOX compliance, and audit standards. Claude helps you map business processes to control objectives, create control matrices linking risks to preventive and detective controls, generate control narratives for auditors, and identify control gaps for remediation planning—compressing what typically takes 200+ annual hours into a fraction of that time while improving control design quality.
by eryet