Skip to main content
Metrics type: Card

​
At a glance

Total cash applied (Customer Payment posted via Cash Receipt Journal or Payment Application) today across all connected Companies. The 9am Monday “did the AR team work the queue?” check.

​
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 wholesale distributor on BC, snapshot 14 Apr 26 at 9:00am. Three observations:
  1. Lockbox imports ($94,800) flow in around 7am via the overnight bank file. That is a healthy signal: the lockbox vendor is on time. Missing lockbox days show as a sudden drop here.
  2. DTC card payments (Stripe $14,200) are smaller than B2B but constant. A drop to zero would indicate Stripe-to-BC sync failure.
  3. Trailing 7-day average is $312K/day. Today is below average but not alarmingly. A bank holiday tomorrow would normally pull volume into today, so seasonal context matters.

​
Sibling cards merchants should reference together

​
Reconciling against the vendor’s own dashboard

Where to look in Business Central:
Cash Receipt Journal > Posted Documents filtered to today Customer Ledger Entries filtered to Document Type = Payment, Posting Date = TODAY Bank Account Reconciliation for daily bank-side check
Why may differ: Cross-connector reconciliation: Stripe.amount_captured for the day should approximately equal the Stripe portion of this card.

​
Known limitations / merchant FAQs

Time zone? Card uses tenant time zone (set in BC Company Information). Multi-Company tenants with different time zones aggregate to the workspace’s reporting time zone. Lockbox import not showing? Lockbox imports post via the Bank File Import. If the file is delayed, today’s number is artificially low. Card refreshes every 15 minutes; if the lockbox vendor is late, expect the morning number to spike around 10am once posted. Includes Sales Credit Memos applied? No. SCMs are negative AR adjustments, not cash. Excluded. Stripe DTC payments: when do they appear? Settlement is typically T+2; the BC posting is at the AL Extension’s batch run (often nightly). Today’s Stripe number reflects the prior day’s settled card payments. Multi-Company: same payment received in two Companies? Possible if a customer pays a consolidated invoice spanning Companies. Each Company posts separately; both appear here.

​
Tracked live in Vortex IQ Nerve Centre

Cash Applied Today 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.