AR and AP aging analysis

Use the AR and AP Aging Analysis report to generate details of the amounts of past due payments by period past due. These include comparisons to the previous quarter and year.

You may include invoices created within a specified time and in all cases, no payment or invoice record will be included which occurred after the aging date. In all cases, this report excludes new, unconfirmed and in AP, Held invoices.

By default, generic filters are available to generate this report. You can use Advanced Filters to customize or expand your filter criteria. For more information about Advanced Filters, click here.

To generate AR and AP Aging Analysis Report

1. Open the AR and AP Aging Analysis (RPARAP) page.

   a. Select Executive Information System> EIS Reports > Financial Performance > AR and AP Aging Analysis.

   Or

   b. Search for RPARAP in the Navigation box and then select AR and AP Aging Analysis

   The AR and AP Aging Analysis (RPARAP) page appears.

2. In the Selection list, select the information you want to view.

3. In the Sort Order list, select how to sort the report.

   The Sort Order list is populated based on the type of report selected in the Selection list.

4. In the Layout list, select the layout in which you want to view the report.

   The Layout list is populated based on the type of report selected in the Selection list.

5. In the Date Range area, specify the date range for the report to be generated. You can select the date from the From and To fields only if you select the Custom option in the Fill Dates list.

   The Date On field is populated based on the type of report selected in the Selection list.

To include the entire time frame, leave the date fields blank.

In the Fill Dates list, you can select from the predefined date ranges. They are:

• Custom:
  Select this option to enable the From and To fields in the Date Range area.

• Calendar Year:
  Select this option to display the Calendar Year list. You can select any of the predefined calendar year formats from the list.

• GL Periods:
  Select this option to display the GL Periods list. You can select any of the predefined GL period formats from the list.

6. In the Other Variables section, enter the date in the Enter Date for Aging (default today) field.

7. On the Toolbar, click Run Report. The Please Select dialog box appears.

   Select Open now to open the report in a new tab or select Notify when Complete to get notification. You can open the downloaded report from My Reports page.