An accounts payable report is usually read badly, because the eye goes to the total and the total is the least informative number on the page. What you owe in aggregate reflects how much you buy on credit as much as anything you control. The information is in the shape: how much is overdue, how much is badly overdue, and how the balance compares with what you buy. Three numbers, read together, tell you which of four situations you are in, and the reading takes about ten seconds once you know what to look for. This page is that reading, and what each combination means.
The three numbers, in order
The overdue share first, because it moves for reasons you control. Then the sixty-plus bucket, because it is where the damage is. Then days payable outstanding, which puts the balance in the context of what you actually buy. On the worked example on this site, $48,000 current, $21,000 at thirty days, $9,500 at sixty and $4,200 beyond is $82,700 owed, 42% of it overdue, with days payable outstanding of 30.26.
What the combinations mean
Low overdue and low DPO is a business paying promptly, which may be paying too promptly. High overdue with low DPO is a process problem: the money is there and invoices are stuck. High DPO with low overdue is a deliberate payment policy working. High on both is a cash problem, and it is the one combination that needs a decision this week.
What the total tells you, which is not nothing
Its trend against your purchases. A total rising faster than what you buy is the early signal of the fourth situation, and it shows up a month before the overdue share does. Watching that relationship is the cheapest early warning available, and it costs nothing beyond looking at two figures side by side.
Questions people ask about accounts payable report
Should we compare our DPO with competitors?
It is a weak comparison and we would not build a decision on it. Terms, industry and supplier mix differ enough that the number is not like for like. Your own trend against your own terms is stronger.
What if the report and the ledger disagree?
Then reconcile before reading either. An aging that does not tie to the control account is a report about a subsidiary ledger rather than about what you owe.
How far back should we compare?
Twelve months, so seasonality is visible. Three months of payables data is rarely enough to tell a trend from a cycle.