Generate bank statement summary report

Article • 4/27/2026 • 3 min read

Use the Bank Statement Summary Report report to generate the statements cleared, withdrawals, deposits, and other transactions.

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 statement summary report

  1. Open the Bank Statement Summary Report (RPBSUM) page.

    1. Select Financial Management > Financial Reports > Bank Reconciliation> Bank Statement Summary Report.

    Or

    1. Search for RPBSUM in the Navigation box and then select Bank Statement Summary Report

      The Bank Statement Summary Report (RPBSUM) page appears.

  2. In the Selection dropdown, Bank Statement Summary.

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

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

    The Sort On field is populated based on the order selected in the Sort Order list.

  4. In the Date Range section, enter the data range to include in the report.

    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.

  5. In the Sort Range list, you can sort the information.

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.

  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.