Xero Metric
Accounting
Accounts receivable ageing groups outstanding customer invoices into age buckets (current, 1-30, 31-60, 61-90, and 90+ days past due). It is the single clearest view of collection health and customer payment behaviour.
XeroAccountingAccounts Receivable Ageing
Accounts receivable ageing groups outstanding customer invoices into age buckets (current, 1-30, 31-60, 61-90, and 90+ days past due). It is the single clearest view of collection health and customer payment behaviour.
Why accounts receivable ageing matters for Xero users
The shape of the ageing buckets tells a story that DSO alone cannot. A sudden growth in the 61-90 bucket means a specific cohort of customers is falling behind, usually because of a process change or an unsigned renewal, and catching it early is the difference between a conversation and a write-off.
Xero keeps this report native, and KPI Tree makes it a tree-structured owned metric instead of a PDF nobody opens.
Understand and act on accounts receivable ageing with KPI Tree
Pull the Xero MCP `list-aged-receivables-by-contact` tool or your warehouse replica and let KPI Tree track each ageing bucket as a separate owned metric child of total AR. Decompose further by customer segment so the owner of each segment sees only what they can act on.
Assign ownership to revenue operations and set alerts when the 60+ or 90+ bucket grows by more than a defined amount week-over-week.
Get started with your Xero data
MCPPull metrics from Xero directly through the Model Context Protocol.
Connect your existing warehouse where Xero data already lands.
Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.
Related Xero metrics
Days Sales Outstanding
AccountingMetric Definition
DSO = (Accounts Receivable / Total Credit Sales) × Days in Period
Days sales outstanding (DSO) measures the average number of days it takes to collect payment after an invoice is raised. It is the most direct measure of the efficiency of your credit and collections process.
Operating Cash Flow
AccountingMetric Definition
Operating cash flow measures the cash generated (or consumed) by the core trading activity of the business over a period. Unlike profit, it is not distorted by accruals, non-cash items, or timing of invoices.
Cash Runway
AccountingMetric Definition
Cash Runway (months) = Cash Balance / Monthly Net Burn
Cash runway measures how many months the business can continue operating at its current net burn rate before cash runs out. It is the single most important survival metric for any business spending more than it earns.
Total Revenue
AccountingMetric Definition
Total revenue is the sum of all income recognised across every income account over a period. It is the top line of the profit and loss statement and the foundation metric every other financial KPI depends on.
Empower your team to understand and act on Xero data
Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.
