AR Aging Analysis & Reconciliation Skill
Analyze AR aging reports, reconcile discrepancies, and prioritize collections
What You Can Do
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.
Features
Categorize receivables by 30/60/90+ day buckets and identify concentration risks
Match AR subledger balances to general ledger accounts and flag unreconciled items
Identify unusual aging patterns, duplicate invoices, and potential bad debt candidates
Rank customers by aging days, balance size, and payment history for targeted outreach
Compute Days Sales Outstanding and compare against industry standards
Evaluate adequacy of bad debt reserves based on aging profile and historical write-offs
Generate GAAP-compliant aging schedules and reconciliation workpapers
Highlight month-over-month aging changes and DSO trends for management review
Example Output
Collection Priority Report:
- Customer ABC Corp: $125,000 (91+ days) — High priority
- Customer XYZ LLC: $48,500 (61-90 days) — Medium priority
- Customer DEF Inc: $22,000 (31-60 days) — Monitor
DSO Analysis: Current DSO: 52 days | Industry benchmark: 45 days | Gap: 7 days impact = $180K cash delay
GL Reconciliation: ✓ AR subledger: $2,340,500 | GL balance: $2,340,500 | Status: Reconciled ⚠ Unapplied credits: $15,200 (requires investigation)
Bad Debt Assessment:
- Recommended allowance increase: $8,500 (based on 91+ day aging of $95K at 9% historical loss rate)
- Write-off candidates: 3 customers totaling $12,300 (aged 180+ days, no payments in 6 months)
What's Included
- SKILL.md instruction file with core workflow and data input specifications:
- AR Aging Analysis Template: Standardized format for submitting aging reports and subledger data
- Collection Priority Matrix Framework: Tiered customer ranking criteria (aging days, balance size, payment patterns)
- GL Reconciliation Checklist: Step-by-step validation procedures and common reconciling items
- Audit Documentation Workpaper: GAAP-compliant aging schedule template and variance analysis format
Who It's For
- Staff Accountants — Execute monthly AR close procedures and reconciliation tasks
- AR Managers — Monitor collection metrics, DSO trends, and portfolio aging patterns
- Controller/Finance Manager — Review aging analysis for cash flow forecasting and allowance adequacy
- Internal Auditors — Validate AR aging procedures and support control testing
- Finance Business Partners — Analyze DSO drivers and cash flow impact by customer segment
Best For
- Monthly AR aging report analysis and reconciliation
- Customer balance verification against general ledger
- Collection priority ranking and outreach strategy development
- DSO benchmarking and cash flow improvement initiatives
- Bad debt allowance assessment and write-off candidate identification
- Audit workpaper preparation and GAAP compliance documentation
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 design and implement activity-based cost allocation models tailored to healthcare facility structures, using clinically-relevant cost drivers like patient encounters, bed-days, and procedure minutes. Claude helps you establish allocation methodologies, calculate departmental profitability by service line, and generate cost-to-charge ratios needed for payer contracts and Medicare compliance reporting.
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