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 automatically detect attendance discrepancies across time-tracking data, classify exceptions by root cause (system errors, policy violations, legitimate absences), and generate audit-ready documentation. This skill establishes decision frameworks that handle routine exceptions efficiently while flagging complex cases for human review, reducing payroll processing time by 60-70% while improving accuracy and reducing compliance liability.
by eryet
This skill automates the complex work of calculating material price, quantity, and usage variances; labor rate and efficiency variances; and overhead variances across products, departments, and time periods. You input production data and standard cost tables, and Claude processes the variance calculations, organizes findings by significance, and generates detailed narratives explaining root causes of deviations. This transforms hours of spreadsheet manipulation into a structured analysis package ready for management review and variance committee meetings.
by eryet
You can rapidly cross-reference transaction patterns, revenue data, and economic activity against state-specific nexus thresholds to identify which states trigger filing obligations. The skill flags compliance gaps across physical presence, economic nexus, click-through, and affiliate nexus types, helping you determine filing requirements, quantify retroactive exposure risk, and prioritize registration in new states as clients expand.
by eryet
You can upload aging reports and AR subledger data to Claude, which analyzes bucket distributions, reconciles balances to the general ledger, flags anomalies and aging pattern irregularities, and generates documented collection strategies. Claude produces prioritized customer lists, DSO benchmarking analysis, allowance adequacy assessments, and compliance-ready audit schedules—transforming raw AR data into actionable cash flow optimization strategies.
by eryet
You can systematically validate employee payroll records, cross-check tax withholding calculations against current tax brackets, verify regulatory compliance across federal/state/local requirements, and flag anomalies that could trigger penalties—all before executing payment runs. This reduces processing time by 40-60% while catching errors that manual spreadsheet reviews typically miss, working across ADP, Workday, Gusto, and manual payroll systems.
by eryet
You systematically extract financial red flags from claim submissions, construct causal narratives linking evidence to fraud conclusions, and quantify potential loss exposure. This skill helps you distinguish between legitimate claim variations and fraud indicators, enabling you to generate investigation summaries defensible in litigation, settlement negotiations, or Special Investigation Unit (SIU) presentations.
by eryet
This skill helps you audit nexus comprehensively by analyzing physical presence rules, economic thresholds, affiliate connections, and marketplace facilitator statutes across all 50 states and relevant localities. You'll document nexus triggers specific to your client's business model—whether they're selling through marketplaces, using drop-shipping, hiring remote employees, or expanding operations. The result is an actionable filing calendar and remediation strategy that minimizes compliance gaps and protects against substantial back-tax assessments, penalties, and interest.
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