Accounting 9 min read Updated August 2026

AI for Accounts Receivable Management: DSO Reduction, Collections, and AR Aging with Claude (2026)

How finance teams use Claude AI for AR management: aging analysis with collection priority, DSO benchmarking, escalating collection letter drafting, bad debt provision under ASC 326 (CECL), credit limit assessment, and DSO reduction program design.

Educational content, not professional advice — AI output and figures here can be wrong. Verify before you rely on it. Full disclaimer →

Accounts Receivable Management and AI

Accounts receivable is the single largest current asset on most B2B company balance sheets, and the gap between invoicing and cash receipt is where working capital disappears. A company with $50M in revenue and 60-day DSO carries $8.2M in receivables at any given time — every 10-day DSO reduction releases approximately $1.37M in operating cash. At scale, the difference between a 45-day and 65-day DSO for a $200M revenue company is $11M in working capital permanently trapped in the billing-to-cash cycle.

The AR function sits at the intersection of sales (credit terms extended to win deals), finance (cash flow and working capital management), and operations (billing accuracy, dispute resolution). Claude with FinSkilz helps AR teams across all three dimensions: analyzing aging data to prioritize collections, drafting escalating collection communications, estimating bad debt provisions under ASC 326 (CECL), assessing credit limits for new customers, and designing DSO reduction programs. The prompts below are designed for controllers, AR managers, and CFOs who want a first-pass analysis in minutes rather than hours.

The Cash Conversion Cycle Context

AR days (DSO) is one leg of the cash conversion cycle: CCC = DSO + DIO (inventory days) − DPO (payables days). For B2B companies, DSO is typically the most volatile and most actionable leg — it responds to invoicing speed, collection aggressiveness, payment terms, and customer credit quality. Industry benchmarks: SaaS subscription businesses 35–45 days; professional services 45–65 days; manufacturing 45–70 days; healthcare/government receivables 75–120 days. Benchmarking your DSO against peers is the first step in understanding whether the AR function is a working capital source of strength or drag.

AR Aging Analysis and Collection Priority

  • "Analyze this AR aging report and prioritize collections: Current $2.4M (42 customers), 31-60 days $820K (18 customers), 61-90 days $380K (8 customers), 91-120 days $145K (4 customers), 120+ days $95K (3 customers). Total AR $3.84M. For each aging bucket: (1) estimate collection probability (Current: 97%, 31-60: 88%, 61-90: 72%, 91-120: 55%, 120+: 30%); (2) compute expected collectible amount; (3) bad debt provision required (AR × (1-collection rate)). Total expected collections: $3.26M. Bad debt provision needed: $580K. Which customers are in the 90+ buckets?"
  • "Identify the top 10 AR balances by size: Customer A $420K (45 days outstanding), Customer B $380K (67 days), Customer C $295K (22 days), Customer D $215K (89 days), Customer E $185K (12 days). Prioritize outreach: Customer D ($215K, 89 days) is the highest risk requiring immediate escalated contact. Customer B ($380K, 67 days) is the largest high-risk balance. Draft a collection priority action plan for this week: who to call first, what message, what escalation trigger."

Collection Letter Drafting

  • "Draft a collection letter sequence for Customer XYZ: Invoice #4821, $42,000, due March 15, 2025. Level 1 (14 days overdue, friendly reminder): brief, assume oversight, include payment link and invoice attachment reminder. Level 2 (30 days overdue, formal notice): reference the original due date, state that payment is now 30 days past due, request payment within 10 business days to avoid service interruption. Level 3 (45 days overdue, demand letter): formal demand, specify consequences (service suspension, referral to collections, reporting to credit bureaus if applicable), request payment within 5 business days."

Bad Debt Provision Under ASC 326 (CECL)

  • "Estimate the bad debt provision using the aging schedule method under ASC 326 (current expected credit loss): AR aging: 0-30 days $2.4M, historical loss rate 1.5%; 31-60 days $820K, historical loss rate 4.2%; 61-90 days $380K, historical loss rate 9.8%; 91-120 days $145K, historical loss rate 22%; 120+ days $95K, historical loss rate 48%. Qualitative adjustment: +0.5% on all buckets for current economic uncertainty (macro overlay). Compute the allowance for credit losses by bucket. Total provision: compare to current allowance balance ($145K) — is a provision increase or release required?"

Credit Limit Analysis

  • "Assess the credit limit for new customer Acme Manufacturing: they request net 30 terms with an initial order of $85,000. Creditworthiness data: Dun & Bradstreet credit score 72 (out of 100, moderate risk), 3-year average revenue $12M, net profit margin 4.2%, current ratio 1.8, bank references positive. Comparable customers on net 30 terms average $35K credit limit. Recommendation: approve net 30 terms with initial $35K credit limit (standard for new accounts), with 6-month review to increase to $85K if payment history is clean. Conditions: personal guarantee not required at this level."

DSO Reduction Strategy

  • "Design a DSO reduction program: current DSO 62 days (industry benchmark 45 days), target 48 days in 6 months. Revenue $42M, current AR $7.1M. Target AR at 48 days: $42M × 48/365 = $5.53M (cash release $1.57M). Tactics: (1) invoicing on delivery (currently invoicing 3 days after delivery — save 3 days DSO); (2) electronic invoicing + payment portal (reduce payment friction — target 5 days DSO improvement); (3) early payment incentive for top 20 customers (2% discount for payment within 10 days — analyze cost vs. cash benefit); (4) auto-escalation of collections workflow (systematic follow-up at day 15, 30, 45). Model the DSO improvement from each tactic."

Cash Application and Deduction Management

Beyond collections, AR efficiency depends on correctly applying cash receipts to open invoices and resolving deductions (short payments). Unapplied cash inflates AR balances and distorts aging reports; unresolved deductions create disputes that delay payment further.

  • "Match these unapplied cash receipts to open invoices: Payment $42,500 received from Acme Corp. Open invoices: Inv #4821 $28,000, Inv #4850 $14,000, Inv #4872 $9,500. Customer remittance advice references invoices 4821 and 4850. Suggest application: $28,000 to Inv #4821, $14,000 to Inv #4850, $500 overpayment — recommend holding as unapplied credit vs. requesting refund based on customer relationship context."
  • "Analyze these customer deductions: (1) $4,200 deduction on Inv #5001 — customer cites 'damaged goods per BOL #TR-8821'; (2) $1,850 deduction on Inv #4990 — customer cites 'pricing discrepancy per contract Schedule B'; (3) $700 deduction — no documentation provided. For each deduction: validity assessment, supporting document needed, recommended resolution (credit, rebill, dispute), and suggested follow-up communication."

AR Financing Options

When working capital is tight, AR can be monetized before collection through factoring or supply chain finance programs. Understanding the economics helps the CFO decide whether to self-fund receivables or sell them.

  • "Evaluate invoice factoring for $2.8M of AR (average 55-day DSO). Factoring terms: 80% advance rate on face value, 2.5% fee on face value per 30 days. Compute: advance received ($2.24M), factoring cost for 55-day average = 2.5% × 2 months × $2.8M = $140K, effective annualized rate: $140K / $2.24M × (365/55) = 41.5%. Compare to the company's cost of revolving credit at prime + 1.5% (currently 9.5%). Factoring is expensive — use only for customers in excess of credit line availability or significant cash emergency. Recommend selective factoring of slow-paying, credit-approved accounts only."
  • "Model reverse factoring (supply chain finance) from the buyer's perspective: we extend our DPO from 35 days to 60 days while our suppliers receive early payment at Day 10 from the financing bank. Cost to us: 1.8% flat fee on invoices financed. Annual invoice volume $85M. Cost: $85M × 1.8% = $1.53M/year. Working capital benefit: ($85M × (60-35)/365) = $5.82M cash freed. Effective cost of the working capital improvement: $1.53M / $5.82M = 26.3% — compare to revolving credit cost."

AR Aging Benchmarks and Industry Standards

Interpreting AR aging requires industry context. A 65-day DSO is alarming for SaaS but ordinary for healthcare reimbursement. Key benchmarks:

IndustryTypical DSOWarning DSOKey driver
B2B SaaS (annual contracts)35–50 days>65 daysInvoicing at renewal vs. payment lag
Manufacturing / Distribution45–65 days>80 daysNet 30–45 standard terms
Professional Services50–70 days>90 daysMilestone billing, scope disputes
Healthcare (insurance)55–90 days>120 daysPayer adjudication timelines
Government / Federal60–90 days>120 daysStatutory payment cycles (Prompt Payment Act)
Construction / Project60–90 days>110 daysRetainage, milestone disputes

Where to Start

Export your AR aging report and paste it to Claude. Start with three questions: (1) What is my expected collectible amount by bucket, using historical loss rates? (2) What bad debt provision do I need under ASC 326? (3) Which 5 balances require immediate escalated collection action? That 15-minute exercise replaces a half-day of manual aging analysis and gives the credit manager a prioritized action list. From there, model the DSO reduction program: identify the 2–3 operational changes (faster invoicing, early payment incentives, auto-escalation at day 15/30/45) with the best cash release per dollar of implementation cost. The benchmarking table above gives you the peer comparison to set a realistic target.

Using Claude at your firm?

Connect Claude to live financial data via MCP — EDGAR, FDIC, BIS, CME and 18 more.

New guides & tools — free

Get notified when we add new MCP servers, finance AI guides, and eval results.

Try These Skills

Browse all Accounting tools →
FEEDBACK