> ## Documentation Index > Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt > Use this file to discover all available pages before exploring further. # Cash Collected, Oracle ERP Cloud > Customer payments applied in the period. Lags invoiced revenue by typical DSO. How to read it, why it matters, and how to act on it. **Metrics type:** [Supporting Metrics](/nerve-centre/overview#metrics-types-explained) • **Category:** [Ecommerce Platform](/nerve-centre/connectors#connectors-by-type) > 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. | | | | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **What it counts** | Sum of `applied_receipt_amount` across Oracle Receivables for the window. Includes lockbox, ACH, wire, cheque, credit-card payments processed via Oracle Payments module. | | **Tax treatment** | Gross. | | **Currency** | Reporting ledger. | | **Business Unit scope** | Respects dashboard filter. | | **Time window** | `30D vsP` | | **Alert trigger** | `drop >15% vsP` | | **Sentiment key** | `cash_collected` | | **Roles** | owner, finance | ## 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. | Period | Cash Collected | vsP | | ------------ | -------------- | ----- | | This period | \$186,200,000 | -3.1% | | Prior period | \$192,200,000 | | Five things to notice: 1. \*\*$186M 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](/nerve-centre/kpi-cards/oracle-erp/days-sales-outstanding). 3. **Channel mix:** lockbox (auto) \~65%, ACH \~20%, wires \~10%, credit card \~5%. Healthy automation rate. 4. **Cross-reference [Cash Application Rate](/nerve-centre/kpi-cards/oracle-erp/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 | Card | Why pair it with Cash Collected | | ----------------------------------------------------------------------------------- | ------------------------------------- | | [DSO](/nerve-centre/kpi-cards/oracle-erp/days-sales-outstanding) | Long-run efficiency. | | [Invoiced Revenue](/nerve-centre/kpi-cards/oracle-erp/invoiced-revenue) | Numerator on the booking side. | | [Cash Applied Today](/nerve-centre/kpi-cards/oracle-erp/oerp-cash-applied-today) | Daily intraday view. | | [Cash Application Rate](/nerve-centre/kpi-cards/oracle-erp/cash-application-rate) | Process efficiency. | | [Revenue Booked into GL](/nerve-centre/kpi-cards/oracle-erp/revenue-booked-into-gl) | Spread to cash = working-capital lag. | ## 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:** | Reason | Direction | Why | | ------------------------------------ | --------- | --------------------------------------------------------------------------- | | **Receipt date vs application date** | Either | Card uses application date. Receipts received but not applied are excluded. | | **Multi-currency translation** | Small | Reporting-currency conversion. | **Cross-connector reconciliation:** | Card | Notes | | ----------------------- | --------------------------------------------------------------- | | Stripe / PayPal payouts | Card-payment receipts that flow Stripe→bank→Oracle Receivables. | | Bank statements | Match daily total to bank deposit total. | ## 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](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.