The Accounts Payable Aging report can be found under Purchasing - Reports - Accounts Payable Aging.
This report details suppliers with contracts that have overdue balances, categorized by aging intervals for the chosen date. The report uses a default set of aging intervals, which can be reviewed or updated through the Administration > See also > Aging Intervals form. Data can also be filtered by Entity and Company.
Accounts Payable Aging report form
This report can be generated in both transaction and accounting currency. To choose the desired variant, use the menu option "More actions - Select Variant Report."
There are two variants by default:
The Accounts Payable Aging report gathers data from the Accumulation Registers for Accounts Payable and Accounts Payable (Payment Terms).
The information in the report is automatically compiled based on the date entered by the user in the Quick Settings panel. The system uses the computer's current date if no date is specified.
Here's how data for Total Balance and Total Overdue is collected in the report:
For example, to view details for the Total Balance, double-click on the Total Balance amount.
details:
In the Payment Term Analysis section, the Stage data matches what is shown on the Payment Terms tab in the related Invoice Received document. This enables users to verify the report's data accuracy by comparing it with the Invoice Received document.
The Total Balance displays the unpaid balance for each company. The Total Overdue reflects unpaid amounts that are overdue according to the payment terms. For instance, if an invoice has a due date of May 29 and the report is checked on June 6, 2024, the invoice is 8 days overdue. As a result, it falls into the 8-14 days overdue interval and will be listed in the Total Overdue column.
If the Total Overdue amount is greater than zero, the system highlights the Total Balance in red.
Thank you for being FirstBit Customer! #Reports of purchasing #Accounts Payable aging #Overdue balance