> ## Documentation Index > Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt > Use this file to discover all available pages before exploring further. # A/R Aging Detail, Oracle ERP Cloud > Detailed A/R aging across 0-30, 31-60, 61-90, 91-120, 120+ buckets. How to read it, why it matters, and how to act on it. **Metrics type:** [Supporting Metrics](/nerve-centre/overview#metrics-types-explained) • **Category:** [Ecommerce Platform](/nerve-centre/connectors#connectors-by-type) > Detailed A/R aging across 0-30, 31-60, 61-90, 91-120, 120+ buckets. ## At a glance > Detailed Accounts Receivable aging from Oracle Receivables, sliced into standard buckets: 0-30, 31-60, 61-90, 91-120, 120+ days past due date. Each bucket shows total dollars and customer count. The diagnostic complement to the [DSO](/nerve-centre/kpi-cards/oracle-erp/days-sales-outstanding) headline. | | | | ----------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **What it counts** | Open Receivables transactions (`Amount Due Remaining > 0`) bucketed by `today minus due_date`. Sources: Standard Invoices, Debit Memos, Chargebacks. Credit Memos appear as negative balances reducing customer aging. | | **Tax treatment** | Includes tax (gross of tax). | | **Currency** | Multi-Ledger consolidated. | | **Business Unit scope** | Respects dashboard filter. | | **Time window** | Real-time snapshot. | | **Alert trigger** | `>25% of total AR in 90+ bucket` | | **Sentiment key** | `ar_aging` | | **Roles** | owner, finance | ## Calculation Calculated automatically from your Oracle ERP Cloud data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading. ## Worked example A US Fortune 500 industrial distributor on Oracle ERP Cloud. Snapshot 14 Apr 26. Total AR \$148.2M. | Bucket | Value | Share | Customer count | | --------------------- | ----------------- | ----- | -------------- | | Current (not yet due) | \$84,200,000 | 56.8% | 482 | | 0-30 days past due | \$32,400,000 | 21.9% | 218 | | 31-60 days | \$14,800,000 | 10.0% | 84 | | 61-90 days | \$8,400,000 | 5.7% | 42 | | 91-120 days | \$4,800,000 | 3.2% | 22 | | 120+ days | \$3,600,000 | 2.4% | 18 | | **Total open AR** | **\$148,200,000** | 100% | | Five things to notice: 1. **5.6% in 90+ buckets (\$8.4M).** Below the 25% alert threshold. Healthy AR profile. 2. **18 customers in 120+.** These are the chronic-late accounts. Drill into per-customer detail; some may be candidates for collection action or terms tightening. 3. **The 0-30 past-due bucket (\$32.4M) is the leading indicator.** If this is rising vs prior periods, DSO will rise next month. 4. **Net of Credit Memos** appears at the customer level on detail; some 120+ customers may have offsetting Credit Memos pending application. 5. **Cross-reference [DSO](/nerve-centre/kpi-cards/oracle-erp/days-sales-outstanding):** AR / Revenue × 90 produces DSO; bucket distribution explains DSO movement. ## Sibling cards merchants should reference together | Card | Why pair it with A/R Aging Detail | | --------------------------------------------------------------------------------------------- | -------------------------------------------- | | [DSO](/nerve-centre/kpi-cards/oracle-erp/days-sales-outstanding) | Aging is the diagnostic for DSO movement. | | [Overdue Invoice Value](/nerve-centre/kpi-cards/oracle-erp/overdue-invoice-value) | Total of past-due buckets. | | [Cash Application Rate](/nerve-centre/kpi-cards/oracle-erp/cash-application-rate) | Process efficiency on the cash side. | | [Customer Credit Utilisation](/nerve-centre/kpi-cards/oracle-erp/customer-credit-utilisation) | Predictive: who is approaching credit limit. | | [High-Value Overdue Invoices](/nerve-centre/kpi-cards/oracle-erp/high-value-overdue-invoices) | Drill-down by individual invoice. | | [Top B2B Accounts by Revenue](/nerve-centre/kpi-cards/oracle-erp/oerp-top-b2b-accounts) | Revenue concentration and risk. | ## Reconciling against the vendor's own dashboard **Where to look in Oracle ERP Cloud:** > **Receivables → Reports → AR Aging Report (7-bucket)** > **OTBI → Receivables Real Time Subject Area** with `Bucket Bands = Standard 4` or 7-bucket > **Customer Account Inquiry** for per-customer drill-down The standard AR Aging Report should match this card to within rounding when bucket boundaries align. **Why our number may legitimately differ:** | Reason | Direction | Why | | ------------------------------ | --------- | --------------------------------------------------------------------------------------------------- | | **Bucket boundary** | Either | Oracle's 4-bucket vs 7-bucket choice; card defaults to 5-bucket (0-30, 31-60, 61-90, 91-120, 120+). | | **As-of-date selection** | Small | Card uses today; some Oracle reports use period-end. | | **Multi-currency translation** | Small | Card translates at corporate rate; native UI shows transaction currency. | | **Credit Memo netting** | Either | Card nets Credit Memos at customer level; some reports show separately. | **Cross-connector reconciliation:** This is an Oracle-internal AR metric. No commerce-platform counterpart. ## Known limitations / merchant FAQs **What is a healthy aging mix for Net-30 B2B?** Current 60-70%, 0-30 PD 20-25%, 31-60 5-10%, 61+ under 5%. If 91+ exceeds 5%, collections is slipping. **Why are some customers in 120+ but still on credit hold release?** Credit hold and aging are independent dimensions. A customer can be on credit hold (cannot place new orders) while still having aged receivables you are collecting on. The hold is on new orders; aging is on existing invoices. **Multi-Ledger, can I see per-Ledger aging?** Yes via dashboard filter. **Disputed invoices, how are they treated?** Configurable. Default: included in their bucket; flag visible in detail. If dispute-flagged invoices should not count toward DSO, the field map can exclude. **Foreign-currency invoices, FX impact?** Each AR transaction translated at the corporate rate; aging bucket assignment uses the original due date in the transaction calendar. FX revaluation runs at period-end may shift dollar values; bucket assignment is currency-neutral. *** ### Tracked live in Vortex IQ Nerve Centre *A/R Aging Detail* is one of hundreds of KPI pulses Vortex IQ tracks across Oracle ERP Cloud and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English. [Start for free](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.