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 receive a comprehensive framework for evaluating diversified passive income streams, assessing client risk profiles, and recommending portfolio structures that maximize income while maintaining alignment with financial objectives. The skill analyzes income sources (real estate, dividends, bonds, peer lending, digital assets), models cash flow projections, evaluates tax efficiency, and provides data-driven strategy recommendations ranked by performance potential.
by eryet
You can systematically evaluate payment timing decisions across your vendor base by modeling discount capture opportunities against working capital requirements. The skill analyzes vendor payment terms, your cash flow constraints, and strategic vendor priorities to generate prioritized payment schedules that maximize savings while maintaining adequate liquidity and protecting critical supplier relationships.
by eryet
Create comprehensive, personalized wealth strategies that align client assets, goals, and risk tolerance. You can assess complex financial situations, generate multi-faceted investment and tax strategies, and produce professional recommendations that incorporate goal timelines, asset allocation frameworks, and tax efficiency considerations. The skill helps you move beyond generic advice to deliver actionable, client-specific wealth plans backed by structured analysis.
by eryet
You can generate professionally formatted SVG color palettes by providing a theme name, source URL, or specific hex codes. Claude researches color standards, extracts values from web sources, and organizes 4-7 swatches from dark to light with an anchor brand color at center. Each swatch includes click-to-copy hex codes and hover effects for easy reference.
by eryet
You can trace financial transactions across multiple accounts and entities, document complete chain-of-custody for audit evidence, identify fraud indicators and anomaly patterns, and construct defensible audit conclusions that satisfy both forensic rigor and legal admissibility requirements. This skill provides structured protocols for adversarial skepticism, hostile cross-examination preparation, and quantification of losses or damages with transparent methodologies.
by eryet
You can automatically calculate aging buckets (Current, 30/60/90+ days overdue), identify high-risk accounts requiring immediate attention, and generate prioritized collection lists with risk scoring. This skill transforms raw AR data into strategic collection intelligence, reducing manual spreadsheet work by 70-80% while improving accuracy and enabling proactive credit decisions.
by skyremote
You can input invoice data, PO details, and receipt information to automatically identify variance types, trace root causes, and generate resolution recommendations. The skill creates documented audit trails for each discrepancy, enabling faster month-end close and reducing manual investigation time from hours to minutes. It handles quantity mismatches, pricing discrepancies, duplicate submissions, GL coding errors, and tax/freight charge validation.
by eryet
You can systematically process court orders, IRS levies, and child support withholdings by validating order authenticity, calculating accurate deductions accounting for state exemptions and federal limits, sequencing multiple garnishments by legal priority, and generating compliant documentation for courts and creditors. This skill handles the highest-risk payroll functions—reducing legal exposure, audit risk, and manual processing time while ensuring every deduction meets federal and state regulations.
by eryet