Aged Accounts Payable (report)

The Aged Accounts Payable report shows the amounts on outstanding invoices, credit memos, and payments for vendors.

You can configure report aging to generate three equal length periods as of a specified date (for example, three preceding months from the end of the current month). The vendor's outstanding balance is calculated for each period, and balances due before or after the three periods. You can name each period from the actual start and end dates, or the total number of days included (for example, 1 - 31 days).

To help you easily identify the company's current financial health, total percentages of outstanding amounts are calculated for each date range.

The report can either show 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:

• Monitor vendor performance. The report provides information on outstanding balances for each vendor. Use this information to monitor vendor performance and identify any potential issues that might affect the organization's procurement processes.

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, assuming that direct posting is disabled. Use this information to ensure accurate and timely financial reporting.

Controllers use the report to:

• Analyze financial health. The report calculates the total percentage of outstanding amounts for each date range, making it easy to identify the company's current financial health. Use this information to analyze the company's financial position and make informed decisions.

Try the report

Try the report here: Aged Accounts Payable

See also

Purchase reports
Ad hoc analysis of purchasing data
Purchasing analytics overview

Find free e-learning modules for Business Central here