At a glance
Total dollar value of past-due Receivables across all open Invoices. The collection-pressure target. Rising overdue value drives DSO and signals collection slippage.
| What it counts | SUM(amount_due_remaining) for transactions where due_date < today and status = OPEN. Excludes Credit Memos as overdue (a CM is a credit, not a receivable). |
| Tax treatment | Gross. |
| Currency | Reporting ledger. |
| Business Unit scope | Respects dashboard filter. |
| Time window | Real-time snapshot. |
| Alert trigger | >$50k overdue >60 days |
| Sentiment key | overdue |
| 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 distributor on Oracle ERP Cloud. Snapshot 14 Apr 26.| Bucket | Overdue value |
|---|---|
| 0-30 PD | $32,400,000 |
| 31-60 PD | $14,800,000 |
| 61-90 PD | $8,400,000 |
| 91-120 PD | $4,800,000 |
| 120+ PD | $3,600,000 |
| Total Overdue | $64,000,000 |
- 148M total open AR (43%). This sounds high but reflects healthy Net-30 terms where most “overdue” is < 30 days late.
- $16.8M in 61+ buckets is the collection target. Above the alert threshold; collections team needs to actively work.
- 120+ ($3.6M) is the write-off conversation. These are 4+ months unpaid.
- Overdue trend matters: rising overdue is a leading indicator for DSO movement.
- Action playbook: Collections call routine on 61-120 customers; legal / write-off review for 120+.
Sibling cards merchants should reference together
| Card | Why pair it with Overdue Invoice Value |
|---|---|
| A/R Aging Detail | Bucket detail. |
| DSO | Long-run consequence of overdue. |
| High-Value Overdue Invoices | Per-invoice drill-down. |
| Cash Collected | What is reducing overdue. |
Reconciling against the vendor’s own dashboard
Where to look in Oracle ERP Cloud:Receivables → Reports → AR Aging Report filter past-due Customer Account Inquiry → Past Due for per-customer drillWhy our number may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| As-of-date | Either | Card uses today; some reports use period-end. |
| Disputed invoices | Configurable | Default includes; can exclude via field map. |