Finance AI Skill

Accounts Receivable Optimization

Optimize accounts receivable processes to improve cash collection, reduce DSO, minimize bad debt, and streamline the order-to-cash cycle. Use when users want to improve collections, reduce days sales outstanding, set up automated collections workflows, impl...

Accounts Receivable Optimization

Systematically improve the entire order-to-cash cycle to accelerate cash inflows, reduce days sales outstanding (DSO), minimize bad debt write-offs, and improve working capital efficiency.

Workflow

Diagnose Current AR Health

Pull AR aging report and analyze distribution:

     AR AGING DIAGNOSTIC TEMPLATE
     ════════════════════════════════════════
     Current DSO: [X] days (industry benchmark: [Y] days)
     
     Aging Distribution:
       → Current (0-30 days):   [X]%  [Target: >60%]
       → 31-60 days:            [X]%  [Target: <20%]
       → 61-90 days:            [X]%  [Target: <10%]
       → 91-120 days:           [X]%  [Target: <5%]
       → 121+ days:             [X]%  [Target: <5%]
     
     Key Metrics:
       → Bad debt as % of revenue: [X]% (target: <1%)
       → Collection effectiveness index (CEI): [X]% (target: >95%)
       → % receivables with dunning action: [X]% (target: 100% of overdue)
       → Unapplied cash as % of total cash: [X]% (target: <2%)
       → Average days to apply cash: [X] days (target: <1 day)

Identify top 10 slow-paying customers (contribution to DSO)
Map current collections process: who contacts whom, when, through what channel
Analyze payment term compliance (% of customers paying within terms vs. habitual late payers)
Review credit policy consistency across customer segments

Optimize Credit Management

Establish customer credit scoring framework:

     CREDIT RATING MODEL
     ════════════════════════════════════════
     Score Factors (weighted):
       → Trade credit bureau score (D&B, Experian): 30%
       → Financial statement analysis (quick ratio, DSO trend): 25%
       → Payment history with us (on-time %, avg. days late): 20%
       → Industry risk / economic conditions: 15%
       → Relationship tenure / volume: 10%
     
     Credit Decision Matrix:
       ════════════════════════════════════════
       Score    Rating    Credit Limit    Payment Terms    Collateral
       ────────────────────────────────────────────────────────────────
       80-100   A+        6x monthly avg  Net 30           None
       70-79    A         4x monthly avg  Net 30           None
       60-69    B         2x monthly avg  Net 15           Letter of Credit (if >$50K)
       50-59    C         1x monthly avg  Net 15           COD or 50% deposit
       30-49    D         Case-by-case    COD              Full prepayment
       <30      F         No credit       100% advance     N/A

Set automatic credit limit holds that trigger at 80%, 90%, 100% utilization
Configure automatic order blocking when customer exceeds credit limit
Schedule quarterly credit limit reviews for all active customers
Set up credit insurance for high-risk or high-exposure accounts

Implement Automated Collections Workflow

Design tiered collections cadence:

     AUTOMATED DUNNINGS SCHEDULE
     ════════════════════════════════════════
     Day 0 (Due Date):
       → Auto-send payment reminder email (friendly, statement attached)
       → Include payment portal link, QR code, or ACH enrollment option
     
     Day 7 (7 days past due):
       → Second reminder email (increased urgency)
       → Include payment plan option for large balances
     
     Day 14 (14 days past due):
       → Collections team review
       → Phone call attempt + email with formal demand
       → Flag account for credit hold if balance > $10K
     
     Day 30 (30 days past due):
       → Formal dunning letter (registered mail option)
       → Collections manager call
       → Credit hold activated on all open orders
       → Internal escalation notification to sales/account manager
     
     Day 45 (45 days past due):
       → Final demand letter
       → Offer structured payment plan (3-6 month installment)
       → Escalation to VP Finance / CFO for strategic accounts
     
     Day 60+ (60+ days past due):
       → Engage third-party collections agency OR in-house legal
       → Document all collection efforts (required for charge-off)
       → Assess charge-off vs. continued collection ROI

Configure dynamic collections based on customer segment (VIP vs. standard)
Set up payment plan management with automatic installment tracking

Streamline Invoicing Process

Audit current invoice quality:

     INVOICE QUALITY CHECKLIST
     ════════════════════════════════════════
     ✓ Clear company branding and contact information
     ✓ Customer PO number prominently displayed
     ✓ Line-item detail matching PO/order exactly
     ✓ Payment terms clearly stated (Net 30, Net 45, etc.)
     ✓ Payment instructions included (ACH details, portal URL, wire info)
     ✓ Early payment discount clearly stated if applicable
     ✓ Dispute contact information (separate from collections)
     ✓ Multi-language support for international customers
     ✓ Electronic delivery as default (reduce mail delays)

Implement auto-invoicing triggered by shipment/delivery confirmation
Configure invoice consolidation for frequent small orders (weekly/monthly statements)
Set up customer self-service portal for invoice access, payment, and dispute filing

Optimize Payment Processing & Cash Application

Deploy payment methods that accelerate receipt:

     PAYMENT METHOD STRATEGY
     ════════════════════════════════════════
     ACH / EFT (Primary):
       → 1-2 day settlement vs. 5-7 for checks
       → Enroll customers via online portal
       → Offer 1-2% discount for ACH enrollment
     
     Virtual Cards:
       → Instant settlement, detailed metadata
       → Auto-matching of payment to invoice
       → 1% rebate opportunity
     
     Online Payment Portal:
       → 24/7 self-service payment
       → Instant cash application
       → Credit card support for B2C or small-ticket B2B
     
     Wire Transfer (International):
       → Standard for cross-border
       → Provide clear SWIFT instructions
       → Track and confirm within 24 hours
     
     Lockbox / Check Processing:
       → OCR scanning of incoming checks
       → Same-day deposit and cash application
       → Phase out in favor of electronic methods

Implement auto-cash application using:
Remittance data matching (invoice number from payment reference)
AI/ML fuzzy matching (amount + customer + date window)
Automatic application for exact-amount matches
Flag partial payments for manual review with suggested application

Reduce Disputes & Deductions Management

Categorize disputes by type and root cause:

     DISPUTE ROOT CAUSE ANALYSIS
     ════════════════════════════════════════
     Common Dispute Types:
       → Pricing errors: Invoice price differs from agreed price (5-15% of disputes)
       → Quantity discrepancies: Shipped qty ≠ received qty (10-20%)
       → Quality issues: Damaged or non-conforming goods (5-10%)
       → Late delivery: Charges for delay per contract terms (3-8%)
       → Missing documentation: No PO, wrong PO reference, missing COAs (10-15%)
       → Returns not processed: Credit memo not issued (5-10%)
       → Contractual disputes: Scope disagreements, service level failures (5-10%)
     
     Resolution SLA:
       → Acknowledge dispute: Within 24 hours
       → Initial investigation: 2-3 business days
       → Resolution / credit memo: 5-10 business days
       → Escalation to management: If unresolved after 15 days

Implement automated deduction tracking and trend analysis
Set up proactive dispute prevention (pre-shipment quality checks, PO validation before invoicing)

Monitor, Report, and Continuously Improve

Build AR optimization dashboard:

     AR OPTIMIZATION DASHBOARD
     ════════════════════════════════════════
     Cash Flow Impact:
       → DSO trend (30/60/90 day moving average)
       → Cash collected vs. forecast
       → Bad debt provision and write-offs
     
     Process Efficiency:
       → Auto-cash application rate
       → Average time from invoice to payment
       → Collections touchpoints per invoice (target: decreasing)
       → Straight-through processing rate
     
     Quality Metrics:
       → Invoice accuracy rate
       → Dispute rate as % of invoices
       → First-contact resolution rate for disputes
     
     Customer Behavior:
       → Payment term compliance rate by customer
       → Top 10 delinquent accounts (aging, amount, last contact)
       → Payment method adoption trends

Monthly AR review meeting with Sales, Operations, and Finance leaders
Quarterly credit policy review and limit adjustments

Integration Points

ERP: SAP, Oracle, NetSuite, Dynamics 365, QuickBooks
CRM: Salesforce, HubSpot (for account health linkage)
Payment Platforms: Stripe, Adyen, Bill.com, Tipalti, ACH processors
Credit Bureaus: Dun & Bradstreet, Experian Business, Creditsafe
Collections Software: HighRadius, Rootware, BillForward, Versapay
Customer Portals: Custom or SaaS self-service payment/invoice portals
Accounting Automation: BlackLine, Trintech, FloQast

Edge Cases & Handling

EDGE CASES
═══════════════════════════════════════

1. Key Customer Is Late Paying (Revenue >10% of total)
   → Escalate to C-level relationship (CFO-to-CFO call)
   → Offer payment plan without damaging the relationship
   → Sales team involved in collection (protecting revenue relationship)
   → Document all communications for potential charge-off

2. Customer Bankruptcy / Insolvency
   → Immediately freeze all open orders and shipments
   → File proof of claim in bankruptcy proceedings
   → Assess bad debt provision impact on financial statements
   → Review credit policies to prevent similar exposure

3. Cross-Border / Multi-Currency Collections
   → Collect in customer's local currency where feasible
   → Use netting arrangements for multi-entity relationships
   → Factor in FX risk when setting collection timelines
   → Comply with local collection laws and data privacy (GDPR)

4. Government / Public Sector Customers
   → Longer payment terms (Net 45-60 is common)
   → Strict invoicing format compliance requirements
   → Prompt Pay Act considerations for US federal contracts
   → Track statutory interest for late government payments

5. Recurring / Subscription Revenue Collections
   → Auto-bill with card-on-file or ACH on-file
   → Drip notification before billing (3 days, 1 day, day-of)
   → Handle failed payment retries (3 attempts over 7 days)
   → Auto-downgrade service for sustained non-payment

Conversation Examples

DSO Improvement Request

User: "Our DSO has crept up to 58 days. Industry benchmark is 35. How do we fix this?"
AI: "A 23-day gap is significant and likely costing you working capital. Let me run through a diagnostic:

1. Quick Assessment — Pull your AR aging report and tell me:
   → What % of your receivables are past 60 days?
   → How many customers make up 80% of your overdue balance?
   → What's your auto-cash application rate? (if tracked)

2. Immediate Wins (can reduce DSO by 5-10 days in 30 days):
   → Enforce credit holds automatically at overdue thresholds
   → Switch top 20 slow payers to payment plans with automatic enforcement
   → Reduce unapplied cash (this artificially inflates DSO)
   → Implement electronic payment options for all customers

3. Structural Fixes (30-90 day timeline):
   → Tighten credit policies and perform credit reviews
   → Implement tiered automated dunning
   → Negotiate payment term adjustments with strategic customers
   → Offer 1-2% early payment discount for Net 10 payment

Share your AR aging data and I'll build a specific action plan with projected DSO impact."

Unapplied Cash Issue

User: "We have $180K in unapplied cash. Our AP team says they're paying us but we can't match it."
AI: "Unapplied cash of $180K is a cash flow drag — that money is in your bank account but not credited to customer accounts, which means customers think they owe money they've already paid.

Root causes to investigate:
1. Missing remittance data — Payments arriving without invoice references
2. Multiple invoices per payment — Payment amount doesn't match any single invoice
3. Data mismatch — Customer name/number doesn't match your records (subsidiary names, parent company payments)
4. Timing gap — Invoices issued after payment received (advance payments not flagged)

Immediate actions:
→ Pull the unapplied cash report and sort by amount, date, and payer
→ Check for recurring patterns (same customer, similar amounts)
→ Run fuzzy matching on amount + customer name + date window (±14 days)
→ For amounts >$5K, manual review with suggested invoice matches

Long-term fix:
→ Implement virtual payment accounts (each customer gets unique account number)
→ Deploy AI cash application tool
→ Mandate invoice reference in payment remittance via customer agreements

Want me to help you set up a cash application matching engine?"