Share of received cash that has been auto-matched to invoices. Low rates mean manual reconciliation backlog.
At a glance
Share of cash received that has been auto-matched to specific Sales Invoices in BC. auto-applied / total received. Low rates indicate manual reconciliation backlog.
| What it counts | SUM(Customer Ledger Entry.Amount where Applies-to Doc No is set) / SUM(all Payment Customer Ledger Entries) over 30D. |
| Currency | Reporting Currency. |
| Time window | 30D |
| Alert trigger | <85% |
| Sentiment key | cash_app_rate |
| 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, 30D window 14 Mar to 12 Apr 26.| Metric | Value |
|---|---|
| Total cash received | $6,984,000 |
| Auto-applied to specific Invoice | $6,043,000 |
| Cash Application Rate | 86.5% |
| Manual queue (unapplied) | $941,000 |
Sibling cards merchants should reference together
| Card | Why pair |
|---|---|
| Cash Collected | Total cash. |
| DSO | Slow application = higher DSO. |
| Cash Applied Today | Daily slice. |
Reconciling against the vendor’s own dashboard
Where to look in Business Central:Customer Ledger Entries with Applies-to Doc No filter Payment Reconciliation JournalWhy may differ:
| Reason | Direction | Why |
|---|---|---|
| OData freshness | Card 15 min behind |
Known limitations / merchant FAQs
Healthy rate?90% via lockbox + auto-apply rules. <80% indicates manual reconciliation problem.Improving from 85% to 95%: how? Lockbox vendor with structured remittance, BC’s Match Customer Ledger Entries auto-apply rules, customer self-service portals. Power Automate AL workflow integration? Yes, BC’s Payment Reconciliation Journal supports Power Automate triggers for unmatched payments.