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 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% |
- 5.6% in 90+ buckets ($8.4M). Below the 25% alert threshold. Healthy AR profile.
- 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.
- The 0-30 past-due bucket ($32.4M) is the leading indicator. If this is rising vs prior periods, DSO will rise next month.
- Net of Credit Memos appears at the customer level on detail; some 120+ customers may have offsetting Credit Memos pending application.
- Cross-reference DSO: 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 | Aging is the diagnostic for DSO movement. |
| Overdue Invoice Value | Total of past-due buckets. |
| Cash Application Rate | Process efficiency on the cash side. |
| Customer Credit Utilisation | Predictive: who is approaching credit limit. |
| High-Value Overdue Invoices | Drill-down by individual invoice. |
| Top B2B Accounts by Revenue | 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. |