Skip to main content
Card class: Non-Hero • Category: Ecommerce Platform

​
At a glance

Real-time alert table: invoices >50,000thatare>60daysoverdue.The"phonetoday"listfortheARclerkandController.Eachrowisoneinvoice;columnsincludecustomer,invoiceamount,daysoverdue,customer′stotalARbalance,customercreditutilisation,last−contact−date.Sizedtothehighest−priorityhorizonforAReffort:asingle50,000 that are >60 days overdue. The "phone today" list for the AR clerk and Controller. Each row is one invoice; columns include customer, invoice amount, days overdue, customer's total AR balance, customer credit utilisation, last-contact-date. Sized to the highest-priority horizon for AR effort: a single 50k+ invoice 60+d overdue is more important than 50 small overdue invoices combined.
Trigger thresholdInvoice WHERE amount > $50,000 AND days_overdue > 60. Threshold dollar amount configurable per merchant; defaults set for mid-market distribution.
Signal interpretationHigh-value invoices >60d overdue are typically NOT slipping through routine processes; somebody at the customer is intentionally delaying. Causes: (a) customer in financial trouble (bankruptcy precursor); (b) dispute (unresolved billing or quality issue); (c) AP team turnover at the customer; (d) the customer’s bank-line is restrictive and they are stretching payables.
Recommended action(1) Phone the customer’s AR / AP contact within 24h of alert firing. (2) Cross-reference Customer Credit Utilisation: if customer is at 100% utilisation, place new orders on credit hold. (3) Cross-reference Customer Churn Signals: if also showing churn signals, this is bankruptcy / churn precursor; escalate to credit committee.
Time windowRT
Rolesowner, finance, AR clerk, Controller

​
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 OneWorld. Snapshot 04 May 26. Alert payload: 6 invoices >50kand>60daysoverdue.Totalatrisk:50k and >60 days overdue. Total at risk: 1,420,000.
InvoiceCustomerAmountDays overdueCredit utilLast contactNotes
INV-84412Premier Construction$480,00078100%14 days agoAP contact on parental leave
INV-84520Cobb Industrial$284,0009295%6 days agoDispute on freight charges
INV-84481Hartwell Junior Stores$186,0006888%22 days agoSales rep transition
INV-84455Bertram & Sons$182,0007192%8 days agoCash-flow stretching
INV-84539Western Steel Co$168,0006478%11 days agoRecent CS escalation
INV-84612Coastal Marine Supply$120,0006284%4 days agoQ1 collection cycle
Investigation actions:
  1. Premier Construction $480k: AP contact on parental leave 4 weeks. Action: AR clerk to phone the secondary contact (CFO directly). Escalate to procurement director if needed. Estimated recovery within 14 days.
  2. **Cobb Industrial 284k∗∗:disputeonfreightcharges.Action:Salesrep+Controllerjointcalltoresolvedispute,issuecreditmemoforlegitimatefreightcredit,secureremainder.Estimatedrecovery284k**: dispute on freight charges. Action: Sales rep + Controller joint call to resolve dispute, issue credit memo for legitimate freight credit, secure remainder. Estimated recovery 250k within 7 days.
  3. Hartwell Junior Stores $186k: sales rep transition disrupted relationship. Action: re-introduce new sales rep + AR clerk joint call. Recovery within 14 days.
  4. **Bertram & Sons 182k∗∗:customerisintentionallystretchingpayables(cashflowtight).Action:paymentplandiscussion(4−weekstructured)+placenewordersoncreditholdpending.Recovery182k**: customer is intentionally stretching payables (cash flow tight). Action: payment plan discussion (4-week structured) + place new orders on credit hold pending. Recovery 182k over 4 weeks.
  5. Western Steel $168k: recent CS escalation (damaged shipment claim). Action: resolve the underlying complaint, then collect.
  6. Coastal Marine $120k: routine slow-payer (Q1 always lags). Less urgent; standard reminder cadence.
Total estimated recovery within 30 days: 1,140,000ofthe1,140,000 of the 1,420,000.

​
Sibling cards merchants should reference together

CardWhy pair it with High-Value Overdue Invoices
A/R Aging BucketsThe portfolio view; this card is the >60d high-value subset.
Overdue Invoice ValueTotal overdue dollars; this card is the high-value subset.
DSO Increase AlertDSO is the consequence; this card surfaces the cause-by-cause.
Customer Credit UtilisationCross-reference for which overdue customers are also at the limit.
Customer Churn SignalsOverdue + silent = bankruptcy precursor.

​
Reconciling against the vendor’s own dashboard

Where to look in NetSuite’s own dashboard:
Reports > Customer/Receivables > A/R Aging Detail, filter by Amount > $50,000 AND Days Overdue > 60. Direct comparable list.
Threshold tuning: 50kdefaultsuitsmid−marketdistribution.DTCstoresrarelyhaveinvoices>50k default suits mid-market distribution. DTC stores rarely have invoices >5k; tune to merchant scale.

​
Known limitations / merchant FAQs

The same invoices show up week after week. Why? Because they remain unpaid; the alert is real-time and reflects the live AR state. Aged unpaid invoices stay on the alert until paid, written off, or sold to a collection agency. Should I write off invoices >180 days overdue? Depends on collection-agency strategy. Most merchants write off >90% of invoices >180 days old as bad debt; before that, persistent collection effort is warranted. Cross-reference your bad-debt history. Can I see this per-sales-rep for accountability? Yes via Ask Viq. Useful when sales-rep compensation is tied to collected revenue (some commission plans claw back unpaid revenue beyond N days). My OneWorld account: per-subsidiary? Yes. Each subsidiary’s overdue list runs independently. An invoice is overdue but I know the customer is paying tomorrow. Suppress? Configure a “promise to pay” custom field. Vortex IQ suppresses alerts on invoices with a future-dated promise. Auto-resolves when the date passes. **Why 50kand60dasdefaults?∗∗Empirical.>50k and 60d as defaults?** Empirical. >50k is “material” for a mid-market AR balance; <60 days is “routine” delinquency. Together, the intersection is the priority-call list. Tune per merchant.

​
Tracked live in Vortex IQ Nerve Centre

High-Value Overdue Invoices is one of hundreds of KPI pulses Vortex IQ tracks across NetSuite 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 or book a demo to see this metric running on your own data.