Xero Metric
Accounting
DPO = (Accounts Payable / COGS) × Days in Period
Days payable outstanding (DPO) measures the average number of days it takes the business to pay its suppliers after receiving a bill. A higher DPO preserves cash for longer but can damage supplier relationships if stretched beyond agreed terms.
XeroAccountingDays Payable Outstanding
Days payable outstanding (DPO) measures the average number of days it takes the business to pay its suppliers after receiving a bill. A higher DPO preserves cash for longer but can damage supplier relationships if stretched beyond agreed terms.
How to calculate days payable outstanding
Why days payable outstanding matters for Xero users
DPO is the other side of the working capital equation. A DPO that is too low leaves cash on the table; one that is too high risks late fees, stopped orders, or worse, critical suppliers refusing to trade. Most finance teams track it in a spreadsheet once a quarter and react only when a supplier complains.
Xero users can watch DPO move in real time, by supplier, and catch drift before it becomes a relationship problem.
Understand and act on days payable outstanding with KPI Tree
Query the Xero MCP `list-aged-payables-by-contact` tool alongside the profit and loss cost of goods sold accounts, or use your warehouse tables, and let KPI Tree compute DPO rolling over your chosen window. Break it down by supplier segment so you can tell strategic payment deferral from operational drag.
Assign ownership to your AP lead and set alerts when DPO drifts above or below the agreed supplier terms.
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.
Expense-to-Revenue Ratio
AccountingMetric Definition
Expense-to-Revenue Ratio = Operating Expenses / Total Revenue
Expense-to-revenue ratio measures total operating expenses as a percentage of total revenue over the same period. It is a single-number summary of how operationally efficient the business is at each level of revenue.
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.
