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

​
At a glance

Anomaly alert that fires when DSO (Days Sales Outstanding) rises by more than 10 days vs prior 30-day period. DSO is the canonical AR-health metric; a sudden 10-day rise on a 45-day base is a 22% deterioration in cash-collection velocity, materially affecting working capital. The alert routes to the AR clerk and Controller.
Trigger thresholdDSO_this_30D - DSO_prior_30D > 10 days. Floor: only fires if DSO_this > 30 days (suppresses alerts on healthy stores with structurally low DSO that move from 18 to 24 days, where the % change looks alarming but the absolute level is fine).
Signal interpretationA 10+ day DSO rise points at one of: (1) a major customer started paying late (cross-reference A/R Aging Buckets for concentration); (2) the term mix shifted toward longer terms (B2B Payment Terms Mix); (3) the AR collection effort declined (Cash Application Rate); (4) SO-to-Invoice lead time grew, lengthening the upstream cycle (SO to Invoice Lead Time).
Recommended action(1) Open A/R Aging Buckets, sort by 60+d bucket; identify top 5 delinquent accounts. (2) AR clerk priority-call those 5 accounts within 24 hours. (3) Cross-reference Customer Credit Utilisation for accounts at high utilisation AND delinquent (the operational triple-threat).
Time window30D vsP
Rolesowner, finance, AR clerk

​
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. Alert fired Monday 04 May 26. Alert payload:
MetricThis 30DPrior 30DDelta
DSO58.4 days47.2 days+11.2 days
AR balance$7,820,000$6,140,000+27%
Daily sales$134,000$130,000+3%
DSO rose 11.2 days; threshold breached. Investigation chain:
  1. Open A/R Aging Buckets: 60+d bucket grew from 810kto810k to 2.14m (+164%). The $1.33m increment in the 60+d bucket is the proximate cause.
  2. Drill the 60+d list: 4 accounts contribute 1.18mofthe1.18m of the 1.33m increment.
  3. Top contributor: Premier Construction Inc, $480k 60+d. Customer’s procurement contact is on parental leave; the AP team hasn’t picked up Premier’s invoice processing for 4 weeks.
  4. Action: AR clerk to phone Premier’s secondary contact, escalate to procurement director if needed. Estimated recovery: $400k+ within 14 days.
  5. Other 3 accounts have similar one-off causes; routine collection effort recovers 580kofthe580k of the 700k.
Outcome: within 21 days, 980kofthe980k of the 1.33m increment cleared. DSO recovered to 49.4 days (still 2.2 days above prior period; the residual is structural mix-shift). Working capital unlocked: $980k.

​
Sibling cards merchants should reference together

CardWhy pair it with DSO Increase Alert
Days Sales OutstandingThe headline metric; this alert fires on its movement.
A/R Aging BucketsThe decomposition; identifies which bucket grew.
B2B Payment Terms MixTerm mix shift can drive structural DSO rise.
Customer Credit UtilisationHigh-utilisation customers correlate with delinquency.
Cash Application RateSlow cash-application drives apparent DSO rise.
SO to Invoice Lead TimeUpstream lead-time pressures DSO.

​
Reconciling against the vendor’s own dashboard

This is an alert card; reconciliation is via the underlying DSO metric. NetSuite’s standard A/R Aging report and the Period-Over-Period DSO trend are the comparable views in NS. Threshold tuning: the +10 day default suits mid-market distribution (where typical DSO is 45 to 65 days). For DTC-heavy stores with low DSO (<30 days), tighten to +3 or +5 days. For project-services businesses with high variability, loosen to +20 days.

​
Known limitations / merchant FAQs

The alert fires after a single major customer paid late. False positive? Not really. Even one major customer paying late is a real DSO shift; the alert correctly surfaces it. The action (call the customer) is the right operational response. My DSO seasonal pattern fires this alert every January. Suppress it? Yes. Configure a seasonality calendar in the manifest. Many B2B distributors see a 7 to 12 day DSO rise in January (post-holiday payment delays); tagging it as expected suppresses the noise. The alert fires but my AR bucket distribution looks fine. What now? Check term-mix shift: if you signed a major Net-60 customer this period, structural DSO rises without delinquency. Cross-reference B2B Payment Terms Mix. Can I configure the alert to fire only above a certain DSO floor? Yes. Default floor is DSO > 30 days. Tune to your business’s DSO baseline. My OneWorld account: per-subsidiary alerting? Yes. Each subsidiary’s DSO is monitored independently. Should I escalate every DSO alert to the CFO? No. Most DSO alerts are routine (one customer, one explanation). Escalate only if (a) DSO rises persist >2 periods, (b) the cause is structural (term mix, credit policy), or (c) the dollar impact is >5% of monthly revenue.

​
Tracked live in Vortex IQ Nerve Centre

DSO Increase Alert 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.