AP Aging Schedule

An AP aging schedule (also called an aged payables report or accounts payable aging report) is a list of all outstanding supplier invoices, grouped by how long they have been outstanding relative to their due date or invoice date. The typical buckets are: current (not yet due), 1-30 days overdue, 31-60 days overdue, 61-90 days overdue, and 90+ days overdue. The aging schedule shows the finance team exactly what is owed, to whom, and whether any obligations are past due.

The AP aging schedule is different from the AP balance in the same way that a student's full transcript is different from their GPA. The balance tells you the total -- the aging schedule tells you the composition, timing, and health of that balance. A business with AU$500,000 in accounts payable could have all of that in the current bucket (normal and well-managed) or AU$200,000 overdue by more than 90 days (a significant relationship and compliance problem). The balance number alone cannot distinguish between these situations.

How the AP aging schedule is used

The primary use of the AP aging schedule is identifying what needs to be paid and when. Finance teams reviewing the aging report before a payment run use it to confirm: which invoices are due for payment in the current payment cycle; which invoices are overdue and at risk of supplier relationship damage or penalty charges; which invoices are upcoming and should be included in the cash flow forecast for the next 30 to 60 days.

The aging schedule is also used to identify AP processing problems. Invoices that have been in the AP system for more than 90 days and remain unpaid may indicate: an ongoing payment dispute, a cash flow constraint preventing payment, an invoice that was coded incorrectly and is pending correction, or an invoice that should have been paid but was missed due to a processing error. Each long-aged item should be investigated individually rather than ignored.

From a cash flow management perspective, the aging schedule provides the raw data for a payment forecast: total current obligations due in the next 7 days, next 14 days, next 30 days. This forecast is a key input to the business's treasury function, informing decisions about when to draw on credit facilities or when excess cash can be deployed for early payment discounts.

AP aging versus AR aging

AP aging is the opposite perspective from accounts receivable (AR) aging. AR aging shows what customers owe the business; AP aging shows what the business owes suppliers. Managing both together -- looking at the expected cash inflows from AR collection alongside the expected cash outflows from AP payments -- gives the finance team a complete picture of the working capital cycle and enables proactive management of potential shortfalls before they become crises.