Generate bank reconciliation report

Article • 4/27/2026 • 2 min read

Use the Bank Reconciliation Report report to generate Forward/Backward Reconciliation report.

By default, generic filters are available to generate this report. You can use Advanced Filters to customize or expand your filter criteria.

This report does not include Advanced Filters feature.

To generate Bank Reconciliation Report

  1. Open the Bank Reconciliation Report (RPBREC) page.

    1. Select Financial Management > Financial Reports > Bank Reconciliation

    > Bank Reconciliation Report.

    Or

    1. Search for RPBREC in the Navigation box and then select Bank Reconciliation Report.

      Bank Reconciliation Report (RPBREC) page appears.

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

  2. In the Sort Order dropdown, select how to sort the report.

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

  3. In the Layout dropdown, select the layout in which you want to view the report.

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

  4. In the Sort Range list, specify the sort range.

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

    The available sort ranges are:

    » Single: Select this option to include only one item. Selecting this option enables the From field. Do one of the following:

    ≡ In the From field, enter the item reference.

    ≡ Click the Lookup Reference and from the Lookup For From window, select the required sort item, and click Select.

    » Range: Select this option to include a range of items to sort from. Selecting this option enables the From and To fields. Do one of the following:

    ≡ In the From and To fields, enter the first and last values of the range.

≡ Click the Lookup Reference, if available, and from the Lookup For window, select the required sort item, and click Select.

» **All**: Select this to include all available items.

6. In the Other Variables section, enter the value in the Display Credit Card Payment only field.

  1. On the toolbar, click Run Report to generate the report.

    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.