What Is an Accounts Payable Aging Report?
An accounts payable aging report lists every unpaid supplier invoice, grouped by how long it has been outstanding. Suppliers run down the rows, aging buckets run across the columns, and the intersection shows exactly how much is owed to whom and how overdue it is.
How the Aging Buckets Work
Invoices are sorted into columns by days outstanding, measured from either the invoice date or the due date depending on how the report is configured. The standard buckets are current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days.
EXAMPLE
A supplier row might read: Current $18,200 | 1-30 $6,400 | 31-60 $2,100 | 61-90 $0 | 90+ $1,850, for a total of $28,550. The $1,850 sitting past 90 days is the line that needs explaining, and it is usually either a disputed invoice or one that never completed approval.
What the Report Actually Tells You
- Near-term cash need: the current bucket is what has to be funded in the next payment run.
- Supplier risk: concentrated overdue balances signal relationships likely to come under strain.
- Process failure, not dispute: aged balances with no dispute attached usually mean an invoice stalled in approval.
- Discount windows: invoices still inside an early payment discount period are visible before the window closes.
- DPO validation: the aging profile should be consistent with reported days payable outstanding.
Reading Aged Balances Correctly
An aged balance is not automatically a problem. There are three distinct causes and they call for different responses.
- Genuine dispute. The invoice is contested on price, quantity, or delivery and is being held deliberately.
- Stalled approval. Nothing is wrong with the invoice, it is simply waiting on an approver who has not acted.
- Deliberate cash management. The business is stretching terms intentionally to preserve working capital.
Only the first is a legitimate reason for a balance to age. The second is a process failure that quietly damages supplier relationships, and it is the most common of the three in manual AP environments.
Why the Report Is Usually Out of Date
An aging report can only show invoices that have been entered into the system. Invoices still sitting in an inbox, on a desk, or in an approval queue that never posted do not appear anywhere on it, which means total obligations look smaller than they are.
EXAMPLE
A business with $340,000 showing on its aging report and 250 unprocessed invoices averaging $1,100 is actually carrying closer to $615,000 in obligations. The report is not wrong, it is just incomplete, and the gap is invisible to anyone reading it.
Frequently Asked Questions About Accounts Payable Aging Report
1. What is an accounts payable aging report?
An accounts payable aging report lists all unpaid supplier invoices grouped by how long they have been outstanding, showing what is owed, to which suppliers, and how far past due each balance is.
2. What are the standard AP aging buckets?
Most reports use current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days. The buckets can be configured to match a company's actual payment terms, and can be measured from either invoice date or due date.
3. What is the difference between an AP aging report and an AR aging report?
An AP aging report shows what a business owes its suppliers. An AR aging report shows what customers owe the business. Both use the same bucket structure but track obligations in opposite directions.
4. What does it mean if invoices are sitting past 90 days?
It means one of three things: the invoice is genuinely disputed, it stalled in approval and was never actioned, or payment is being stretched deliberately for cash reasons. Only the first is a legitimate reason for a balance to age that far.
5. Why might an AP aging report be inaccurate?
Because it only reflects invoices already entered into the accounting system. Invoices still unprocessed in an inbox or approval queue do not appear at all, so total obligations can be understated by a substantial margin.
