Detailed A/R aging across 0-30, 31-60, 61-90, 91-120, 120+ buckets.
At a glance
Per-customer AR aging detail. Each row: Customer Name, total open AR, breakdown across 0-30 / 31-60 / 61-90 / 91-120 / 120+ buckets, oldest invoice age. The collections team’s daily worklist.
| What it counts | Open Customer Ledger Entries grouped by Customer No., bucketed by Due Date age. |
| Tax treatment | Gross (includes VAT). |
| Currency | Reporting Currency. |
| Time window | RT |
| Alert trigger | >25% in 90+ 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 distributor on BC, snapshot 14 Apr 26.| Customer | Total AR | 0-30 | 31-60 | 61-90 | 91-120 | 120+ | Oldest |
|---|---|---|---|---|---|---|---|
| Acme Tech | $1,840K | $620K | $480K | $420K | $200K | $120K | 145d |
| NorthEast | $740K | $480K | $180K | $80K | - | - | 88d |
| TechHub | $620K | $620K | - | - | - | - | 22d |
Sibling cards merchants should reference together
| Card | Why pair |
|---|---|
| Invoice Aging Summary | Headline aggregation. |
| DSO | The summary KPI. |
| Overdue Invoice Value | Past-due subset. |
| Customer Credit Utilisation | Credit risk per customer. |
| High-Value Overdue Invoices | Alert on worst rows. |
Reconciling against the vendor’s own dashboard
Where to look in Business Central:Reports > Finance > Customer > Aged Accounts Receivable (definitive) Customer List > StatisticsWhy may differ:
| Reason | Direction | Why |
|---|---|---|
| OData freshness | Card 15 min behind | |
| Bucket boundaries | Either | Card 30/60/90/120; BC defaults monthly |