> ## 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 Collected, Microsoft Dynamics 365

> Customer payments applied in the period. Lags invoiced revenue by typical DSO. How to read it, why it matters, and how to act on it.

**Metrics type:** [Supporting Metrics](/nerve-centre/overview#metrics-types-explained)  •  **Category:** [Ecommerce Platform](/nerve-centre/connectors#connectors-by-type)

> 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 counts** | `SUM(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 treatment**  | Gross (includes VAT in the customer payment).                                                                                                                                                                               |
| **Currency**       | Multi-Company: each Company translated to Reporting Currency.                                                                                                                                                               |
| **Time window**    | `30D vsP`                                                                                                                                                                                                                   |
| **Alert trigger**  | `drop >15% vsP`                                                                                                                                                                                                             |
| **Sentiment key**  | `cash_collected`                                                                                                                                                                                                            |
| **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 distributor on BC, 30-day window 14 Mar to 12 Apr 26.

| Source                                | Cash 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.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

| Card                                                                                        | Why pair               |
| ------------------------------------------------------------------------------------------- | ---------------------- |
| [Cash Applied Today](/nerve-centre/kpi-cards/microsoft-dynamics/msd-cash-applied-today)     | Daily slice.           |
| [DSO](/nerve-centre/kpi-cards/microsoft-dynamics/days-sales-outstanding)                    | Lag indicator.         |
| [Invoiced Revenue](/nerve-centre/kpi-cards/microsoft-dynamics/invoiced-revenue)             | Sales side.            |
| [Cash Application Rate](/nerve-centre/kpi-cards/microsoft-dynamics/cash-application-rate)   | Operations efficiency. |
| [Revenue Booked into GL](/nerve-centre/kpi-cards/microsoft-dynamics/revenue-booked-into-gl) | Top-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:**

| Reason                        | Direction          | Why                                                                                             |
| ----------------------------- | ------------------ | ----------------------------------------------------------------------------------------------- |
| **OData freshness**           | Card 15 min behind |                                                                                                 |
| **Bank reconciliation**       | None               | Card uses BC posting, not bank-cleared, so a deposit-in-transit shows here before bank confirms |
| **Multi-Company aggregation** | Card sums          |                                                                                                 |

**Cross-connector reconciliation:**

[stripe.amount\_captured](/nerve-centre/stripe/amount_captured) for the same window approximates the Stripe portion. [paypal.pp\_total\_volume](/nerve-centre/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](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.