AP Aging Report Generator

What is an AP aging report and why does it matter?

An accounts payable (AP) aging report groups your outstanding supplier invoices by how long they have been unpaid — typically into buckets labelled Current (not yet due), 1–30 days past due, 31–60 days, 61–90 days, and 90+ days. It gives your finance team an instant snapshot of where your payables stand, which suppliers are waiting longest, and where late-payment penalties may already be accruing. Most Australian businesses run this report monthly as part of their end-of-period close process, though high-volume AP teams often review it weekly to stay across payment obligations before they become overdue.

Beyond compliance, the AP aging report is a practical cash-flow management tool. Reviewing bucket totals lets you prioritise which invoices to clear first — protecting key supplier relationships and capturing any early-payment discounts on offer — while deferring lower-priority payments to manage working capital. The 90+ days bucket deserves particular attention: invoices sitting there risk supplier credit holds, late-payment fees, or strained relationships with vendors critical to your supply chain. Many Australian supplier contracts include interest clauses for overdue accounts, and some trade creditors will place accounts on stop-supply without notice once payments lapse beyond their terms.

A common mistake is treating the AP aging report as a passive reference rather than an active management tool. Finance teams that review the report but don't act on it — following up internally on stuck approvals, querying disputed invoices, or scheduling payments for current-bucket items before they age — end up with an aging distribution that trends older over time. Consistent weekly or fortnightly review, with clear ownership of each bucket, prevents this drift.

How to use this generator

1. Enter your company name and report date at the top of the form.
2. Add each outstanding supplier invoice: supplier name, invoice number, invoice date, and amount owing. The tool auto-assigns each invoice to the correct aging bucket based on the invoice date and report date.
3. Review the bucket totals in the summary bar — identify which suppliers or invoice types are concentrated in the 60+ day and 90+ day buckets.
4. Download as PDF to share with your CFO, controller, or external accountant, or to file as part of your month-end close documentation.

What does each aging bucket mean?

The Current bucket contains invoices that are not yet past their due date — these should be your standard payment run focus. The 1–30 days bucket is the early-warning zone: invoices here are recently overdue and most suppliers will not yet have escalated. The 31–60 days bucket signals that payment is significantly delayed — expect supplier follow-up calls and potential credit review. The 61–90 days bucket represents serious overdue balances that can trigger credit holds, and the 90+ days bucket is where supplier relationships and your credit reputation are genuinely at risk.

How does the AP aging report relate to cash flow forecasting?

The current-bucket total from your AP aging report is your near-term payment obligation — it should feed directly into your 13-week rolling cash flow forecast. Many finance teams run AP aging and cash flow forecast together at the start of each week: the aging report shows what is owed and to whom, and the cash flow forecast shows whether sufficient cash will be available to meet those obligations without drawing on a credit facility.

Do I need AP aging reports for AASB compliance?

The AP aging report itself is not a statutory reporting requirement under Australian Accounting Standards, but the accuracy of your accounts payable balance — which the aging report supports — directly affects the accuracy of your balance sheet (AASB 101) and cash flow statement (AASB 107). Auditors and lenders routinely request aged creditor listings as part of financial due diligence and year-end audit procedures. Maintaining a clean, current aging report reduces friction at audit time significantly.