The Aged Accounts Payable report shows the amounts on outstanding invoices, credit memos, and payments for vendors.
Note
Report 322 is marked obsolete from version 28.0 and is replaced by Aged Accounts Payable (Excel). Its caption is Aged Accounts Payable (Obsolete) in versions where it remains available. Learn more in Aged Accounts Payable Excel.
Set Aged As Of, Period Length, and Aging by to group balances by due date, posting date, or document date. The report shows three aging periods and an older balance; due-date aging also shows amounts that aren't due yet. Heading Type controls whether headings show date intervals or numbers of days.
The report calculates the percentage of outstanding amounts in each date range to help you review the distribution of payables.
The report can show either a summed balance for each vendor or a detailed breakdown of each outstanding document.
Use cases
Analyze vendor balances at the end of each period. Monitor unpaid invoices, and prioritize payments for overdue accounts. Easily reconcile vendor subledgers against payables accounts in the general ledger, assuming that direct posting is disabled.
Procurement specialists use the report to:
- Monitor vendor payments. The report provides a detailed breakdown of each outstanding document for analysis. Use this information to monitor vendor payments and ensure timely payment of outstanding invoices.
Vendor managers use the report to:
- Review outstanding vendor balances. Use aged amounts to support discussions about payment timing.
Accounts payable specialists use the report to:
- Reconcile vendor subledgers. The report is used to reconcile the vendor subledger against the payables accounts in the general ledger, provided that direct posting is disabled. Use this information to ensure accurate and timely financial reporting.
Controllers use the report to:
- Analyze the aging of payables. Compare percentages across date ranges to see where outstanding amounts are concentrated.
Try the report
Try the report here: Aged Accounts Payable
Tip
If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.
Alternative reports
There are several other ways to analyze aged accounts payable. Learn more in the following articles:
- Aged Payables (Back Dating) in Power BI
- Using data analysis to analyze accounts payable
- Aged Accounts Payable Excel
Related information
Aged Payables (Back Dating) in Power BI
Using data analysis to analyze accounts payable
Aged Accounts Payable Excel
Purchase reports
Ad hoc analysis of purchasing data
Purchasing analytics overview