Skip to main content
Metrics type: Supporting Metrics • Category: Ecommerce Platform
Customer payments applied in the period. Lags invoiced revenue by typical DSO.

​
At a glance

Total customer payments applied across the 30-day window. Lags invoiced revenue by the typical DSO. The treasury-relevant view of how much actually banked vs how much was booked.

​
Calculation

Calculated automatically from your Oracle ERP Cloud 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 Fortune 500 distributor on Oracle ERP Cloud. 30-day window 14 Mar 26 to 12 Apr 26. Five things to notice:
  1. **186Mcollectedin30days∗∗vs186M collected in 30 days** vs 232M revenue invoiced for the same window. The ratio (cash / revenue) is 80% on a 30-day window, consistent with Net-30 terms and 50-day DSO (cash today reflects revenue from ~50 days ago).
  2. 3.1% drop vsP, well within the 15% alert threshold. Normal noise. If this drop persists 2-3 periods running, look at DSO.
  3. Channel mix: lockbox (auto) ~65%, ACH ~20%, wires ~10%, credit card ~5%. Healthy automation rate.
  4. Cross-reference Cash Application Rate: cash collected and successfully applied at 88% means $20M is in the unapplied / on-account queue.
  5. Trend matters most: cash collected vs invoiced revenue for the same period gives the rolling collection efficiency.

​
Sibling cards merchants should reference together

​
Reconciling against the vendor’s own dashboard

Where to look in Oracle ERP Cloud:
Receivables → Reports → Receipts Register OTBI → Receivables Receipts Real Time filtered by date range Cash Management → Bank Reconciliation for bank-side parity
Why our number may legitimately differ: Cross-connector reconciliation:

​
Known limitations / merchant FAQs

Why does cash collected lag invoiced revenue by ~30-50 days? Net-30 terms means typical receipt 30 days after invoice plus collection slippage. Healthy. Includes credit-card receipts processed via Oracle Payments? Yes by default. Stripe/PayPal-routed payments flow through to Oracle Receivables when settled. Multi-Ledger view? Yes via filter. Why does this differ from bank deposits? Timing. Cash received in bank vs cash applied in AR can differ by 1-3 days while the cash-app team processes.

​
Tracked live in Vortex IQ Nerve Centre

Cash Collected is one of hundreds of KPI pulses Vortex IQ tracks across Oracle ERP Cloud 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.