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 |
- **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).
- 3.1% drop vsP, well within the 15% alert threshold. Normal noise. If this drop persists 2-3 periods running, look at DSO.
- Channel mix: lockbox (auto) ~65%, ACH ~20%, wires ~10%, credit card ~5%. Healthy automation rate.
- Cross-reference Cash Application Rate: cash collected and successfully applied at 88% means $20M is in the unapplied / on-account queue.
- 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 | Long-run efficiency. |
| Invoiced Revenue | Numerator on the booking side. |
| Cash Applied Today | Daily intraday view. |
| Cash Application Rate | Process efficiency. |
| 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 parityWhy 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. |
| Card | Notes |
|---|---|
| Stripe / PayPal payouts | Card-payment receipts that flow Stripe→bank→Oracle Receivables. |
| Bank statements | Match daily total to bank deposit total. |