Edit

Share via

Aged Accounts Payable (report)

  • Article

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 periods of equal length as of a specified date (for example, the three preceding months from the end of the current month). The vendor's outstanding balance is calculated for each period, as are balances due before or after the three periods. You can name each period based on either 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 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:

  • Monitor vendor performance. The report provides information about 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, provided 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

Tip

If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. In this way, you can stay on the current page while you explore the report on the other browser tab.

Purchase reports
Ad hoc analysis of purchasing data
Purchasing analytics overview

Find free e-learning modules for Business Central here