AR Aging Analysis Interpreter
Transform AR aging reports into collection priorities and cash recovery forecasts
What You Can Do
This skill interprets your aging reports to reveal collection priorities, quantify risk exposure, and forecast cash recovery timelines. You'll identify which accounts need immediate escalation, calculate DSO and aging percentages, project bad debt reserves, and support management presentations with data-driven insights on your AR portfolio's health.
Features
Interprets current, 30, 60, 90+ day buckets to identify concentration of past-due balances
Computes DSO and trends to benchmark AR efficiency against targets
Highlights accounts requiring immediate collection action or credit review based on aging severity
Projects reserves for doubtful accounts under GAAP/IFRS standards based on aging patterns
Estimates recovery timelines and cash inflow projections based on historical collection rates
Detects deterioration or improvement in payment patterns to identify operational issues
Suggests dunning escalation, payment plan options, and negotiation talking points by account segment
Example Output
Input: Monthly aging report showing $2.4M in 90+ day overdue balances across 47 accounts, with 35% of total AR past-due.
Output Generated:
- DSO: 52 days (vs. 45-day target) — indicates 7-day deterioration
- Top 10 at-risk accounts representing $840K (35% of overdue) requiring immediate contact
- Recommended bad debt reserve: $180K (7.5% of 90+ bucket based on historical write-off rates)
- Projected cash recovery: $1.8M over 60 days if standard collection protocols applied
- Trend alert: Medical devices customer segment showing 40% increase in 60+ day balances quarter-over-quarter
What's Included
- SKILL.md: Complete AR aging analysis instruction file
- Aging Analysis Template: Structured format for uploading aging data and defining bucket thresholds
- DSO Calculation Worksheet: Formula and methodology for Days Sales Outstanding tracking
- Collection Priority Matrix: Framework for segmenting accounts by risk level and recommended action
- Cash Flow Forecast Model: Template for projecting recovery timelines by collection strategy
- Bad Debt Reserve Guide: GAAP/IFRS compliance framework for provisioning calculations
Who It's For
- Accounts Receivable Specialists — Prioritizing collections and managing daily portfolio risk
- Credit Managers — Evaluating creditworthiness and monitoring customer payment behavior
- Finance Controllers — Preparing aging summaries, provisions, and management reporting
- Collections Managers — Supporting dunning strategy and escalation decisions
- CFOs/Finance Leadership — Analyzing AR portfolio health and cash flow forecasting
Best For
- Month-end and quarter-end aging analysis and reporting
- Identifying accounts requiring escalated collection or legal action
- Calculating DSO trends and benchmarking against targets or industry standards
- Projecting bad debt reserves and provisions for financial statements
- Supporting customer negotiations and payment plan discussions with data
- Analyzing aging trends to detect operational problems or customer insolvency risk
You might also like
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 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 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