SkillsLib.ai

AR Aging Analysis Interpreter

Transform AR aging reports into collection priorities and cash recovery forecasts

3.6(31 reviews)
100+ downloads
Updated Sep 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

Corporate Tax Provision Analysis & Documentation
$40
Corporate4.0(33)
Corporate Tax Provision Analysis & Documentation

You can systematically prepare tax provisions that survive audit scrutiny by calculating current and deferred tax impacts, reconciling effective tax rates from statutory to reported amounts, and documenting uncertain tax positions with FIN 48 support. The skill guides you through multi-jurisdictional tax exposure analysis and helps you create audit-ready workpapers with clear audit trails for quarterly (10-Q) and annual (10-K) financial statement filings.

Payroll Compliance & Processing Audit
$40
Processing3.7(35)
Payroll Compliance & Processing Audit

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.

Insurance Claims Fraud Detection & Analysis
$40
Insurance Claims Fraud Detection & Analysis

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.

Sales Tax Nexus & Obligation Analyzer
$30
Sales Tax4.0(33)
Sales Tax Nexus & Obligation Analyzer

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.

Healthcare Cost Allocation Analyzer
$40
Healthcare4.0(34)
Healthcare Cost Allocation Analyzer

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.

Regulatory Compliance Audit Framework for Financial Institutions
$40
Compliance4.2(19)
Regulatory Compliance Audit Framework for Financial Institutions

You can execute structured compliance audits that map regulatory requirements to operational controls, test control effectiveness with documented evidence, quantify compliance risk exposure, and track remediation progress with clear accountability. The framework produces audit findings in regulatory-acceptable format, transforming ad-hoc reviews into defensible procedures that satisfy internal audit standards (IIA) and regulatory expectations.

Insurance Claims Fraud Detection & Analysis
$40
Insurance Claims Fraud Detection & Analysis

You can analyze insurance claim files to uncover fraud indicators by synthesizing evidence from policyholder statements, medical/repair records, financial documents, and prior claims history. This skill helps you reconstruct timelines, identify inconsistencies and impossibilities, recognize suspicious financial patterns, and build defensible fraud conclusions suitable for claims adjustment, litigation support, or settlement negotiations. Transform raw claim data into an evidence hierarchy distinguishing confirmed facts, supported inferences, and investigative leads requiring further development.

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.

$35.00