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

Customer payments applied to invoices in the period. Lags Invoiced Revenue by typical DSO. The actual cash hitting the bank account, before bank-side reconciliation.
What it countsSUM(Customer Ledger Entry.Amount) where Document Type = 'Payment' and Posting Date in window. Includes Cash Receipts via Cash Receipt Journal, Lockbox imports, Stripe-captured DTC payments synced via AL Extension.
Tax treatmentGross (includes VAT in the customer payment).
CurrencyMulti-Company: each Company translated to Reporting Currency.
Time window30D vsP
Alert triggerdrop >15% vsP
Sentiment keycash_collected
Rolesowner, finance

​
Calculation

Calculated automatically from your Microsoft Dynamics 365 data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.

​
Worked example

US distributor on BC, 30-day window 14 Mar to 12 Apr 26.
SourceCash collected (USD)
Cash Receipt Journal (B2B ACH wires)$5,420,000
Lockbox imports (overnight bank file)$1,180,000
Stripe DTC card captures$384,000
Cash Collected (this card)$6,984,000
Three observations:
  1. Cash Collected 6.98MlagsInvoicedRevenue6.98M lags Invoiced Revenue 7.24M by $260K. That gap is the AR build for the period.
  2. Lockbox flow steady at ~$40K/day. Drop signals lockbox vendor issues.
  3. Stripe DTC ($384K) ~5% of total. Confirms B2B-heavy mix.

​
Sibling cards merchants should reference together

CardWhy pair
Cash Applied TodayDaily slice.
DSOLag indicator.
Invoiced RevenueSales side.
Cash Application RateOperations efficiency.
Revenue Booked into GLTop-line.

​
Reconciling against the vendor’s own dashboard

Where to look in Business Central:
Customer Ledger Entries filtered to Document Type = Payment Bank Account Reconciliation Power BI > Cash Flow content pack > Cash Inflow tile
Why may differ:
ReasonDirectionWhy
OData freshnessCard 15 min behind
Bank reconciliationNoneCard uses BC posting, not bank-cleared, so a deposit-in-transit shows here before bank confirms
Multi-Company aggregationCard sums
Cross-connector reconciliation: stripe.amount_captured for the same window approximates the Stripe portion. paypal.pp_total_volume similarly for PayPal-routed payments.

​
Known limitations / merchant FAQs

Bank-side reconciliation: when does this match the bank balance? After the Bank Account Reconciliation runs (typically nightly). This card uses BC-side posting; deposits-in-transit appear here before they clear bank. Customer overpayments? Excluded from this card by default; configurable. Some merchants want to include because cash hit the account. Refunds out (negative cash)? Customer Refund Payments post as negative; included. Stripe sync timing? Stripe captures on T+0 to T+2 settlement. The AL Extension batch posts to BC nightly. Today’s Stripe figure is yesterday’s settled card payments. Multi-Company: same payment received in two Companies? Possible if a customer pays a consolidated invoice; each Company posts separately.

​
Tracked live in Vortex IQ Nerve Centre

Cash Collected is one of hundreds of KPI pulses Vortex IQ tracks across Microsoft Dynamics 365 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.