Finance ➔ Accounts receivable ➔ Receivables ➔ Aging analysis
In this screen, you can generate the aging analysis report for debtors. This report displays the outstanding receivable invoices in different age groups over a specific period of time based on invoice dates, due dates, or reporting dates. Therefore, you can check the period for which payment from debtors have been outstanding. As such, you can obtain a quick view of who is behind with their payments.
You can filter the outstanding invoices that you want to display in the report by defining one or more of the following criteria and clicking Start. The report will be generated based on the defined criteria.
Select Debtor code, Name, Postal code, Classification, Country, or Due date to sort the report accordingly.
Select this check box to enable the Project, Cost center, and Resource fields under the Range section.
Select one of the following options to generate the report based on the corresponding options:
Select one of the following options to further refine the report that is generated based on the due dates of transactions:
Note: This field is enabled only when you select Due date at Age.
Click this to define additional criteria for the report. For more information, see Defining additional criteria for generating debtor aging analysis report.
Type three different age groups to display the report according to the age groups. For example, to display the aging for 14 days, 30 days, and 60 days, type the corresponding numbers in the boxes. The information in the boxes is mandatory.
Select the required option to determine whether the invoice currency is based on All – Invoice currency, All – Default currency, the default currency, or other foreign currencies that are registered in the settings. If you select a foreign currency, only the entries that have been posted in that currency are displayed. If you select All – Invoice currency or All – Default currency, all payments due are displayed irrespective of the currency code.
Select one of the following options to display the report accordingly:
Note: This field is applicable only if you clear the Summarize check box in the Additional criteria screen.
Type or select a reference date to generate the report based on the invoice dates, due dates, or reporting dates of transactions that fall on this date or earlier. For example, define the reference date as November 17, 2020 and select Invoice date at Age. If there are three invoices with invoice dates of November 1, November 17, and November 18, 2020, only the first two invoices will be displayed in the report.
Select Active, Blocked, Inactive, Pilot, Reference, or Passive to generate the report for debtors with the corresponding status. Select All to generate the report for debtors with any status.
Select Customer or Resource to generate the report for debtors of the corresponding type. Select All to generate the report for any type of debtors.
Type or select a name or range of names to generate the report for debtors with the corresponding name(s). Select the All check box to generate the report for debtors with any name.
Note: This field is displayed only when you select Name at Sorting under the Criteria section.
Type or select a debtor code or range of debtor codes to generate the report for debtors with the corresponding code(s). Select the All check box to generate the report for debtors with any code.
Note: This field is displayed only when you select Debtor code at Sorting under the Criteria section.
Type a postal code or range of postal codes to generate the report for debtors with the corresponding postal code(s). Select the All check box to generate the report for debtors with any postal code.
Note: This field is displayed only when you select Postal code at Sorting under the Criteria section.
Type or select a classification or range of classifications to generate the report for debtors under the corresponding classification(s). Select the All check box to generate the report for debtors under any classification.
Note: This field is displayed only when you select Classification at Sorting under the Criteria section.
Type or select a country or range of countries to generate the report for debtors from the corresponding country(ies). Select the All check box to generate the report for debtors from any country.
Note: This field is displayed only when you select Country at Sorting under the Criteria section.
Type or select a due date or range of due dates to generate the report for transactions with the selected due date(s). Select the All check box to generate the report for transactions with any due date.
Note: This field is displayed only if you select Due date at Sorting under the Criteria section.
Type or select a project or range of projects to generate the report for debtors linked to the selected project(s). Select the All check box to generate the report for debtors linked to any project.
Note: This field is enabled only if you select the Show: Analytical values check box under the Criteria section.
Type or select a cost center or range of cost centers to generate the report for debtors linked to the selected cost center(s). Select the All check box to generate the report for debtors linked to any cost center.
Select one of the following options to include the corresponding transactions in the report:
Select On credit, Cash, Credit card, Cheque, Post dated cheque, Letter of credit, Collection, Debt collection, Factoring, Payment on delivery, EFT, or Settle to generate the report for transactions with the corresponding payment method. Select All to generate the report for transactions with any payment method.
Select All or Due to generate the report for transactions linked to all payment items or items that are due only, respectively.
Note: This field is enabled only when you select Invoice date or Reporting date at Age under the Criteria section.
Type or select an employee account or a range of employee accounts to generate the report linked to the employee account(s). Select the All check box to generate the report linked to any employee account.
Type or select a resource or range of resources to generate the report for debtors linked to the resource(s). Select the All check box to generate the report for debtors linked to any resource.
Type an intermediary or a range of intermediaries to generate the report for debtors linked to the intermediary(ies). Select the All check box to generate the report for debtors linked to any intermediary.
Select Normal, Complaints, Payment agreement, or Transferred to generate the report for debtors linked to the corresponding type of payment scenario. Select All to generate the report for debtors linked to any type of payment scenario.
Select this check box to include a summary for foreign currencies at the bottom of the report.
Note: This check box is enabled only when you select All - Default currency at Invoice currency under the Criteria section.
Select Original, Current, or Historical to convert the amounts in the report based on the corresponding type of exchange rate.
Note: This field is enabled only when you select All - Default currency at Invoice currency under the Criteria section.
Type or select the date of exchange rate to convert the amounts in the report based on the exchange rate on the selected date.
Note: This field is enabled only if you select Historical at Exchange rate.
Click this to generate the report based on the defined criteria.
Click this to exit.