An AP aging view buckets what you owe by how overdue it is, which merges two things needing completely different responses. Part of the balance is deliberate: within terms, or held on purpose. The rest is stuck in your own process. The view cannot tell them apart, which is why the headline overdue figure so often produces an unproductive conversation.
Why the raw figure misleads
An invoice sits in a bucket because of its due date, regardless of why it is unpaid. A disputed invoice, one awaiting approval and one deliberately held to terms are indistinguishable. Presenting the total as a payables performance measure therefore reports, in large part, the payment terms somebody else negotiated.
The second column
Approved and scheduled, awaiting approval, in exception, disputed. With that alongside the age, the view answers how much is overdue because of us, which is the figure payables can move and the one worth reporting weekly. It is usually a fraction of the headline and a far more useful conversation to have.
What it is genuinely for
Cash planning, and spotting a supplier relationship about to become a phone call. A supplier whose overdue balance is growing is a problem forming, and the aging view finds them before the complaint does. Build the report for those two uses and the status column follows naturally.
Questions people ask about ap aging
Should the overdue figure ever be zero?
Rarely, since disputes exist and some invoices should not be paid yet. What should be near zero is the part overdue because of your own process.
What buckets should we use?
Ones aligned to your terms, otherwise everything looks better or worse than it is.
Who reads it?
Finance for cash and payables for the stuck items. The same report serves both only with the status column present.
How far back should the buckets go?
Far enough that anything genuinely stuck is visible rather than lumped into a final catch-all. A bucket labelled ninety days and over hides an invoice that has been outstanding for a year, which is exactly the one somebody needs to see.
Should disputed invoices appear at all?
Yes, flagged as disputed. Removing them makes the report look better and hides the relationship problem that a growing disputed balance represents, which is the opposite of what the report is for.