Loading…
Performance ?
Insights — by tab ?
AR Trend ?
Revenue & Profitability — LTM ?
FY26 Budget — Full Year ?
YTD Actual vs Budget ?
🤖 AI Commentary (use with caution) —YTD vs Budget
Annualized Run-Rate vs FY26 Budget ?
🤖 AI Commentary (use with caution) —Annualized run-rate
Q1 2026 — Annualized Recurring Revenue & Retention ?
🤖 AI Commentary (use with caution) —Q1 ARR & retention
Latest Month MRR ?
LTM ARR ?
🤖 AI Commentary (use with caution) —MRR trajectory vs LTM
Direct-Method Cash Flow ?
—
🤖 AI Commentary (use with caution) —cashflow review (latest month vs prior)
Cash flow report not yet available for this subsidiary
Currently the direct-method cash flow report is only published for XAP. Other subsidiaries will follow once the calculation methodology is validated per sub.
AR Trend — Outstanding & Past Due ?
—
🤖 AI Commentary (use with caution) —current situation vs prior month
📋 Recommended Actions — for the BU lead ?
Collection Performance — month-end ?
By month ?
| As of | Current | 1-30 | 31-60 | 61-90 | 91-180 | 181-360 | 360+ | Outstanding | Past Due | % Past Due | # Open | DSO (3-Mo) | Avg Days to Pay | Avg Days Outstanding | Avg Days Overdue |
|---|
Customer detail ?
Metric definitions & calculation methods
- Outstanding
- What: Total AR sitting on the books at a given month-end. How: Sum of every per-invoice remaining across all aging buckets (signed — unapplied credits offset positives). Ties to NS Balance Sheet account 11001 by construction.
- Past Due
- What: Subset of Outstanding where invoice due date has passed as of the snapshot. How: Sum of remaining across all non-Current aging buckets (1-30 through 360+). Signed.
- Avg Days to Pay
- What: When customers DO pay, how many days does it take from invoice date to last apply?
How:
AVG(last_apply_date − invoice_date)over invoices fully paid by snapshot (remaining < $0.50) AND issued in the trailing 12 months. Signal: Pure customer-behavior. Not diluted by billing volume or unpaid old invoices. - Avg Days Outstanding
- What: Average age of every open invoice on the books.
How:
AVG(asOf − invoice_date)over all invoices withremaining > $0.50(Current + every past-due bucket). Signal: Operational — "how old is the average invoice sitting in the in-tray." Not revenue-anchored. - Avg Days Overdue
- What: Among invoices past due, how late are they on average?
How:
AVG(asOf − due_date)over invoices withremaining > $0.50 AND due_date < asOf. Strict subset of Outstanding. Signal: Pure delinquency, isolated from billing terms (Net 30 vs Net 60). Catches "more invoices slipping past due" before DSO moves. - DSO (3-Month rolling)
- What: Days Sales Outstanding — how many days of revenue is sitting unpaid.
How:
Outstanding × 91 / Σ revenue(snapshot month + 2 prior). Revenue fromconsolidated_pl(accounts4xxxexcluding492xx, sign-flipped). Signal: Standard financial KPI for collections quality, normalized for revenue scale. Comparable across subs and time. - Note: Why Avg Days Overdue can exceed Avg Days Outstanding
- Outstanding averages over all unpaid invoices (including brand-new ones aged 5 days). Overdue averages over only the older subset (past due_date), so the average age of that subset is always ≥ the average of the full set. Not a bug.
Support — Under Construction
Support ticket volume, response time, and customer-health signals will appear here once the ticketing-system integration is built (Zendesk / HubSpot / per-BU helpdesk TBD).
- Open tickets by priority + age
- First-response and resolution SLAs
- CSAT trend
- Top customers by ticket volume
- AI Commentary — support load anomalies + escalation risk