At a glance
Count of open Invoices not yet fully paid. The work-volume measurement, paired with Overdue Invoices Value for the dollar view.
| What it counts | COUNT(DISTINCT Transaction) for Transaction.Type = 'CustInvc', Status NOT IN ('Paid In Full', 'Cancelled'). |
| Tax treatment | n/a (count, not value). |
| Currency | n/a (count). |
| Subsidiary scope | Respects dashboard filter. |
| Time window | RT |
| Alert trigger | None at headline; the value-based alert lives on Overdue Invoices Value |
| 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.| Count | |
|---|---|
| Total open Invoices | 1,142 |
| Of which: Current (not due) | 612 |
| 1-30 days overdue | 320 |
| 31-60 days | 138 |
| 61-90 days | 42 |
| 91+ days | 30 |
- 1,142 open Invoices is the AR clerk’s backlog. Average 11.92M / 1142). High-volume small Invoices.
- 612 Current is healthy churn. These will close as customers pay on time.
- 320 in 1-30 is the typical reminder workload. AR clerk sends reminders; most close within 5 days.
- 30 Invoices >91 days is the write-off candidate list. Average $8.7K. Likely 5-8 customer accounts.
- Count + Value pair tells different stories. 50K from 2 invoices = customer-specific problem.
Sibling cards merchants should reference together
| Card | Why pair it with Unpaid Invoices Count |
|---|---|
| Overdue Invoices Value | Dollar view. Pair to read both work-volume and risk. |
| Invoice Aging Summary | Bucket detail. |
| DSO | Compressed metric. |
| Cash Application Rate | Operations efficiency. |
| Invoiced Revenue | The flow side. |
Reconciling against the vendor’s own dashboard
Where to look in NetSuite:
Reports → Receivables → Open Invoices (count rows)
Saved search: Invoice WHERE Status NOT IN ('Paid', 'Cancelled')
Why our number may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| Partial payments | Card includes | An Invoice with 1000 paid is still “Open” (not Paid In Full). Card counts it. |
| Subsidiary scope | Either | Card defaults to all subs. |
| Real-time vs cached | Small | 15-minute refresh. |