--- name: accounts-receivable-optimization description: 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, implement credit management, optimize payment terms, reduce unapplied cash, improve AR aging, or implement dunning processes. Triggers on phrases like "reduce DSO", "improve collections", "accounts receivable optimization", "order to cash", "AR aging", "bad debt reduction", "collections workflow", "payment terms optimization", "unapplied cash", "dunning process", or related AR optimization queries. --- # 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 1. **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 2. **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 3. **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 4. **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 5. **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 6. **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) 7. **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?" ```