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

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.

​
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. 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

​
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: 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.