> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Cash Applied Today, Microsoft Dynamics 365

**Metrics type:** [Card](/nerve-centre/overview#metrics-types-explained)

## 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 counts** | `SUM(Customer Ledger Entry.Amount)` where `Document Type = 'Payment'`, `Posting Date = TODAY`. Includes Bank Account Receipts and Customer-applied refunds-in-reverse. |
| **Tax treatment**  | Gross (the customer paid the gross invoice).                                                                                                                           |
| **Currency**       | Multi-Company: each Company's payments translated to Reporting Currency.                                                                                               |
| **Time window**    | `T` (today only)                                                                                                                                                       |
| **Alert trigger**  | `-` (paired with [Cash Application Rate](/nerve-centre/kpi-cards/microsoft-dynamics/cash-application-rate) for actionable alerts)                                      |
| **Roles**          | owner, 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.

| Source                                               | Today'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

| Card                                                                                      | Why pair it                                 |
| ----------------------------------------------------------------------------------------- | ------------------------------------------- |
| [Cash Collected](/nerve-centre/kpi-cards/microsoft-dynamics/cash-collected)               | Period total.                               |
| [Cash Application Rate](/nerve-centre/kpi-cards/microsoft-dynamics/cash-application-rate) | Operations efficiency.                      |
| [DSO](/nerve-centre/kpi-cards/microsoft-dynamics/days-sales-outstanding)                  | Strong days of cash applied bring DSO down. |
| [Invoice Aging Summary](/nerve-centre/kpi-cards/microsoft-dynamics/invoice-aging-summary) | What 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:**

| Reason                        | Direction          | Why |
| ----------------------------- | ------------------ | --- |
| **OData freshness**           | Card 15 min behind |     |
| **Multi-Company aggregation** | Card sums          |     |
| **Currency translation**      | Either             |     |

**Cross-connector reconciliation:**

[Stripe.amount\_captured](/nerve-centre/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](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.