Skip to main content
Card class: 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.
What it countsSUM(Customer Ledger Entry.Amount) where Document Type = 'Payment', Posting Date = TODAY. Includes Bank Account Receipts and Customer-applied refunds-in-reverse.
Tax treatmentGross (the customer paid the gross invoice).
CurrencyMulti-Company: each Company’s payments translated to Reporting Currency.
Time windowT (today only)
Alert trigger- (paired with Cash Application Rate for actionable alerts)
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 wholesale distributor on BC, snapshot 14 Apr 26 at 9:00am.
SourceToday’s posting (USD)
Cash Receipt Journal (ACH wires from B2B customers)$182,400
Stripe-captured DTC payments synced via AL Extension$14,200
Lockbox imports (overnight bank file)$94,800
Cash Applied Today (this card)$291,400
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

CardWhy pair it
Cash CollectedPeriod total.
Cash Application RateOperations efficiency.
DSOStrong days of cash applied bring DSO down.
Invoice Aging SummaryWhat is left to collect.

​
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:
ReasonDirectionWhy
OData freshnessCard 15 min behind
Multi-Company aggregationCard sums
Currency translationEither
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.