A/R balance bucketed by 0-30 / 31-60 / 61-90 / 91-120 / 120+ days. Cash-flow telemetry.
At a glance
AR balance bucketed by Customer Ledger Entry due-date age: 0-30 / 31-60 / 61-90 / 91-120 / 120+ days. Cash-flow telemetry, aggregated headline alongside the AR Aging Buckets per-customer card.
| What it counts | Open Customer Ledger Entries (Document Type = 'Invoice', Open = TRUE) bucketed by Due Date age relative to today. |
| Tax treatment | Includes VAT (the AR balance is the gross amount the customer owes). |
| Currency | Multi-Company: each Company’s AR translated to Reporting Currency. |
| Time window | RT |
| Alert trigger | >30% in 60+ bucket |
| Sentiment key | ar_aging |
| 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 electronics distributor, $90M revenue, snapshot 14 Apr 26.| Bucket | AR Balance (USD) | % of total |
|---|---|---|
| 0-30 days (current) | $6,840,000 | 60% |
| 31-60 days | $2,420,000 | 21% |
| 61-90 days | $1,180,000 | 10% |
| 91-120 days | $620,000 | 5% |
| 120+ days | $360,000 | 3% |
| Total Open AR | $11,420,000 | 100% |
- 18% of AR is past 60 days. Just below the 30% alert threshold, but trending up from 14% three months ago.
- 120+ bucket ($360K) needs write-down review. UK FRS 102 / US GAAP allowance for doubtful debts policies typically require provisions on AR > 120 days.
- Concentration check: 3 customers carry $940K of the 60+ buckets. Pair with AR Aging Buckets for the per-customer drill.
Sibling cards merchants should reference together
| Card | Why pair it with Invoice Aging Summary |
|---|---|
| DSO | Aging summary translates into DSO. |
| AR Aging Buckets | Per-customer detail. |
| Overdue Invoice Value | Subset: invoices past Due Date. |
| Cash Application Rate | Operations efficiency. |
| Customer Credit Utilisation | Predictive risk. |
| High-Value Overdue Invoices | Alert on the worst rows. |
Reconciling against the vendor’s own dashboard
Where to look in Business Central:Reports > Finance > Customer > Aged Accounts Receivable (definitive) Power BI > Cash Flow content pack > Receivables Aging tile Customer List > Statistics FlowFieldsThe Aged Accounts Receivable report matches this card to within rounding when run for the same Aging Periods (1M, 2M, 3M default). Why our buckets may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| Bucket boundaries | Either | Card uses 30/60/90/120; BC defaults to “1M, 2M, 3M, prior” which is approximate. |
| Aging-by date | Either | Card uses Due Date; BC reports can use Document Date, Posting Date, or Due Date. Configure to match. |
| Multi-Company aggregation | Card materially higher | Card consolidates. |
| OData freshness | Card 15 min behind | Customer Ledger Entries appear via OData within 15 minutes. |