At a glance
Total value of Invoices past their due date. The single-number focus on what’s late.
| What it counts | SUM(Transaction.Amount Due) for Transaction.Type = 'CustInvc', Status NOT IN ('Paid In Full', 'Cancelled'), where Today > DueDate. Equivalent to total AR minus the Current bucket. |
| Tax treatment | Includes tax. |
| Shipping | Included. |
| Refunds / Credit Memos | Net Amount Due. |
| Cancelled / voided invoices | Excluded. |
| Currency | OneWorld: reporting currency at current FX. |
| Subsidiary scope | Respects dashboard filter. |
| Time window | RT |
| Alert trigger | >$50k overdue >60 days, sentiment overdue |
| Roles | owner, finance |
Calculation
Calculated automatically from your NetSuite 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 wholesale distributor on NetSuite. Snapshot 14 Apr 26.| Amount (USD) | |
|---|---|
| Total Open AR | $11,920,000 |
| Less: Current bucket | ($5,840,000) |
| Overdue Invoices Value (this card) | $6,080,000 |
| of which >60 days overdue | $1,260,000 |
- 51% of AR is overdue (11.92M). That’s the headline collections challenge.
- 50K threshold by 25x. Alert fires; Controller has urgent action.
- Drill-down per customer is the worklist. The card surfaces top 10 overdue contributors with phone numbers and last-payment date.
- The trend matters more than the absolute. Rolling overdue should track revenue growth, +/- 10%. If overdue is rising while revenue is flat, collections discipline is slipping.
- Compare to last year same date. Overdue often grows faster than revenue if customer terms aren’t being enforced. The chart shows YoY for context.
Sibling cards merchants should reference together
| Card | Why pair it with Overdue Invoices Value |
|---|---|
| Invoice Aging Summary | Bucket detail. |
| AR Aging Buckets | Per-customer detail. |
| DSO | Compressed metric. |
| Unpaid Invoices Count | Count side. |
| Credit Hold Orders | Customers with overdue Invoices typically trip credit holds. |
| Customer Credit Utilisation | Predictive. |
Reconciling against the vendor’s own dashboard
Where to look in NetSuite:
Reports → Receivables → A/R Aging Summary (sum the non-Current buckets)
Saved search: Invoice WHERE DueDate < TODAY AND Status NOT IN ('Paid', 'Cancelled')
Why our number may legitimately differ from NetSuite reports:
| Reason | Direction | Why |
|---|---|---|
| Boundary timing | Small | Card uses real-time today; report uses period-end. |
| FX rate | Small | Current spot. |
| Subsidiary scope | Either | Card defaults to all subs. |