Skip to main content
Card class: Non-Hero • Category: Ecommerce Platform
Customer payments applied in the period. Lags invoiced revenue by typical DSO.

​
At a glance

Total customer payments applied to AR in the rolling 30-day window. Lags invoiced revenue by typical DSO. The cash-flow truth.
What it countsSUM(Transaction.Amount) for Transaction.Type = 'CustPymt' posted in the period and at least partially applied to one or more Invoices.
Tax treatmentIncludes tax (customer-paid total).
ShippingIncluded.
RefundsCustomer Refunds (cash going back to customers) are NOT in this card. They’re an outflow tracked separately.
Cancelled / voided paymentsExcluded.
CurrencyOneWorld: reporting currency at receipt-date FX. Single-subsidiary: native currency.
Subsidiary scopeRespects dashboard filter.
Apply stateCounts only applied receipts. Unapplied cash sits separately in the AR holding account; the Cash Application Rate card captures that bucket.
Time window30D vsP (rolling)
Alert triggerdrop >15% vsP, sentiment cash_collected
Rolesowner, 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. 30-day window covers 14 Mar 26 to 12 Apr 26.
Receipt sourceReceipts countCash collected (USD)
ACH wires412$4,120,000
Cheques (mailed-in)186$980,000
Stripe-routed online924$1,180,000
PayPal-routed online78$84,000
Wire transfers (international)14$620,000
Cash Collected (this card)1,614$6,984,000
ComparisonAmount
Invoiced Revenue (same window)$6,560,000
Cash Collected (this card)$6,984,000
Difference (cash > invoiced)$424,000
Five things to notice:
  1. Cash > Invoiced typically signals collection of older AR. This period’s receipts include cash applied to Invoices billed in prior months. That’s the working-capital cycle running healthily; old AR is closing.
  2. **ACH dominates (4.12M,594.12M, 59%)** for B2B distributors. Cheques are still significant (980K, 14%) because traditional retail buyers haven’t migrated. Stripe + PayPal handle small-volume online payments.
  3. Comparing to last period: 6.42Mprevious,6.42M previous, 6.98M this. Up 8.7%, meaning the AR cycle is running faster than the invoicing cycle. Check whether DSO is dropping (it should be).
  4. Last period was $6,420,000. Up 8.7%, no alert. The trend is favourable.
  5. The 14 international wires of $620K are typically distributor invoices billed in USD but customers paying from non-US banks. SWIFT fees and FX conversion happen at the bank, not in NetSuite, so the receipt amount equals the Invoice amount; the bank charge sits in the bank reconciliation difference account.

​
Sibling cards merchants should reference together

CardWhy pair it with Cash Collected
Cash Applied TodayThe daily heartbeat; this card is the rolling 30-day.
Cash Application RateEfficiency. Tells you what fraction of received cash applied vs sat unapplied.
Invoiced RevenueThe billing side. Difference is AR change.
DSODays from Invoice to cash. Health metric on the cycle.
Invoice Aging SummaryWhat’s left to collect.
Overdue Invoices ValuePressure target.
stripe.stripe_total_revenue / paypal.pp_total_volumeOnline-payment slices.

​
Reconciling against the vendor’s own dashboard

Where to look in NetSuite:
Reports → Receivables → Customer Payment Detail for the matching window Reports → Cash Receipts Journal (more comprehensive) Bank Register for the bank-side view
The Customer Payment Detail report is the matching native equivalent. The Cash Receipts Journal also includes Cash Sales (POS), which this card excludes. Why our number may legitimately differ from NetSuite reports:
ReasonDirectionWhy
Cash Sales exclusionCard lower than Cash Receipts JournalCash Sales book direct revenue + cash; not in this card.
Unapplied cashCard lower than Bank RegisterUnapplied receipts hit the bank but not the AR cycle. Tracked separately.
FX rateSmallReceipt-date FX.
Subsidiary scopeEitherCard defaults to all subsidiaries; native typically per-sub.
Time zoneBoundary daysSubsidiary base time zone vs user time zone for “today”.
Cross-connector reconciliation:
CardRelationshipWhy
stripe.stripe_total_revenueStripe-routed sliceStripe-paid Invoices auto-apply via SuiteApp. Stripe’s settled total ≈ NetSuite Stripe-applied.
paypal.pp_total_volumePayPal-routed sliceSame logic.

​
Known limitations / merchant FAQs

Why is Cash Collected sometimes higher than Invoiced Revenue? Because customers pay invoices issued in prior periods. A 30-day window’s cash collection includes payments on invoices billed up to 90+ days earlier (depending on DSO). This is normal; cash > invoiced means the AR cycle is closing well. What’s the right ratio of Cash Collected to Invoiced Revenue over time? Over a year they should converge to roughly 1:1 (you can’t collect more than you bill). In any 30-day window the ratio fluctuates. Look at rolling 12-month for the cycle truth; rolling 30-day for tactical health. Why is the alert on a drop, not a spike? A spike usually means a backlog cleared (one-off positive). A drop signals collection slowdown, which compounds: invoices that don’t collect this month migrate into 60+ aging buckets next month. Sales Order vs Invoice vs Cash App lifecycle, where am I? Final stage. Cash Collected is the end of the cycle. Once cash applies, the Invoice closes and AR drops to zero. The cash now sits in the bank. Multi-currency, what FX rate? Receipt-date FX. Realised FX gain/loss between Invoice-date and receipt-date posts to a separate account; it’s not in this card. B2B Net-30 customers, why does my Cash Collected lag invoicing by exactly 30 days? Because that’s the contractual term. Pay it forward: a $100K Invoice billed 1 Mar 26 is due 31 Mar 26 and most B2B customers pay 5-10 days after due date, so the receipt hits 5 Apr 26 to 10 Apr 26. The 30-day lag is structural for Net-30; it’d be 60 days for Net-60. ASC 606 / Advanced Revenue Management, any impact? None. Cash Collected is balance-sheet movement (AR → Cash), not revenue recognition. ARM affects when revenue is recognised on the P&L, separately. Does the card include intercompany payments? Default yes. If you want third-party only, add the filter via field map.

​
Tracked live in Vortex IQ Nerve Centre

Cash Collected 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.