Detailed A/R aging: 0-30, 31-60, 61-90, 91-120, 120+ buckets. The cash-conversion telemetry.
At a glance
Detailed AR aging buckets at customer level: 0-30, 31-60, 61-90, 91-120, 120+. The bar-chart view of Invoice Aging Summary, drilled to per-customer.
| What it counts | SUM(Transaction.Amount Due) for open Invoices, bucketed by (Today, DueDate) age, grouped by Customer. |
| Tax treatment | Includes tax (Amount Due is gross customer-owed). |
| Shipping | Included. |
| Refunds / Credit Memos | Open Credit Memos applied to an Invoice net Amount Due down. |
| Cancelled / voided invoices | Excluded. |
| Currency | OneWorld: reporting currency at current FX. |
| Bucket boundaries | Default 0-30, 31-60, 61-90, 91-120, 120+. Configurable. |
| Subsidiary scope | Respects dashboard filter. |
| Time window | RT (real-time snapshot) |
| Alert trigger | >25% in 90+ bucket, sentiment ar_aging |
| Roles | owner, finance |
Calculation
Calculated automatically from your NetSuite data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US wholesale apparel distributor on NetSuite. Snapshot 14 Apr 26.| Bucket | Open AR (USD) | % of total | Top contributor |
|---|---|---|---|
| Current (not yet due) | $5,840,000 | 49% | Major Department Store ($1.2M) |
| 1-30 days | $3,180,000 | 27% | Western Regional ($420K) |
| 31-60 days | $1,640,000 | 14% | Boutique Group A ($260K) |
| 61-90 days | $640,000 | 5% | Specialty Retailer ($180K) |
| 91-120 days | $360,000 | 3% | Three problem accounts |
| 120+ days | $260,000 | 2% | Two write-off candidates |
| Total Open AR | $11,920,000 | 100% |
- 49% Current is healthy. Net-30 invoices that aren’t yet due. The Controller wants this in the 45-55% range.
- 27% in 1-30 is the operational normal for B2B Net-30. Customers paying 5-10 days past due. Reminders go out, money flows.
- 14% in 31-60 is the warning zone. Collections team escalates from email reminders to phone calls.
- 10% in 60+ combined is approaching the alert threshold (25%). Today the merchant is well under, but trend matters: if 60+ ticked up from 6% to 10% in three months, the slope is the signal.
- The drill-down per customer is the action list. $260K Boutique Group A in 31-60 is one customer that needs a phone call today; the card surfaces the name. Without it, the AR clerk would scroll the Customer Aging report and miss the priority.
Sibling cards merchants should reference together
| Card | Why pair it with AR Aging Buckets |
|---|---|
| Invoice Aging Summary | The summary tile version of this bar chart. |
| DSO | Single-number compression. |
| Overdue Invoices Value | Sum of overdue (excludes Current). |
| Cash Application Rate | Operations efficiency. |
| Credit Hold Orders | Customers in 60+ are credit-hold candidates. |
| Top B2B Accounts | Concentration view. |
Reconciling against the vendor’s own dashboard
Where to look in NetSuite:Reports → Receivables → A/R Aging Detail (per-customer view) Customer record → Financial → Aging tab (single-customer)A/R Aging Detail is the matching native equivalent. The card mirrors it. Why our number may legitimately differ from NetSuite reports:
| Reason | Direction | Why |
|---|---|---|
| Bucket boundaries | Either | NetSuite default vs custom-configured buckets. |
| As-of date | Small | Real-time vs period-end snapshot. |
| FX rate | Small | Current spot vs report-saved rate. |
| Credit Memo netting | Either | Auto-apply vs manual. |
| Subsidiary scope | Either | Card defaults to all subs. |