SkillsLib.ai

AR Aging Analysis Interpreter

Transform AR aging reports into collection priorities and cash recovery forecasts

3.6(31 reviews)
100+ downloads
Updated Nov 2026
Verified SafeSecurity VerifiedThis skill was analyzed by our AI security scanner for harmful content including data exfiltration, system manipulation, credential theft, and prompt injection. No threats were detected.

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

Aging bucket analysis

Interprets current, 30, 60, 90+ day buckets to identify concentration of past-due balances

Days Sales Outstanding (DSO) calculation

Computes DSO and trends to benchmark AR efficiency against targets

High-risk account flagging

Highlights accounts requiring immediate collection action or credit review based on aging severity

Bad debt provisioning

Projects reserves for doubtful accounts under GAAP/IFRS standards based on aging patterns

Cash flow forecasting

Estimates recovery timelines and cash inflow projections based on historical collection rates

Aging trend analysis

Detects deterioration or improvement in payment patterns to identify operational issues

Collection strategy recommendations

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

Garnishment Order Processing & Compliance Skill
$45
Garnishment Order Processing & Compliance Skill

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.

Passive Income Portfolio Analyzer
$25
Passive Income Portfolio Analyzer

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.

AP Payment Schedule Optimizer
$40
AP Payment Schedule Optimizer

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.

Client Wealth Strategy Framework
$35
Client Wealth Strategy Framework

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.

Generate Palette
$45
Guidelines3.6(19)
Generate Palette

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.

Forensic Audit Evidence Analysis & Chain-of-Custody Documentation
$40
Forensic4.3(35)
Forensic Audit Evidence Analysis & Chain-of-Custody Documentation

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.

1099 Form Generation & IRS Compliance Automation
$25
1099 Form Generation & IRS Compliance Automation

You can systematically prepare, validate, and generate accurate 1099-NEC and 1099-MISC forms while ensuring full IRS compliance. The skill handles vendor categorization based on payment type, tracks filing thresholds automatically, identifies when CORRECTED forms are needed, and verifies Tax ID Numbers—eliminating manual errors and compressing your year-end compliance timeline by 40-60%. You'll streamline the complex distinction between form types and manage exemptions, multiple legal entities, and Form 1096 transmittal requirements effortlessly.

Nonprofit Grant & Restricted Fund Accounting
$40
Nonprofit4.0(35)
Nonprofit Grant & Restricted Fund Accounting

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.

$35.00