GL trial balance

Article • 7/21/2025 • 2 min read

Use the GL Trial Balance report to generate balances for all accounts as of the end of a period that you chose and to generate review totals for reasonableness and investigate questionable accounts.

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 GL Trial Balance Report:

  1. Open the GL Trial Balance (RPGLTB) page.

    a. Select Financial Management > Financial Reports > General Ledger > GL Trial Balance.

    Or

    b. Search for RPGLTB in the Navigation box and then select GL Trial Balance

    TheGL Trial Balance (RPGLTB) 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 On field is populated based on the order selected in the Sort Order 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 Sort Range list, you can sort the information from the available sort range.

    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:

    • Type the item reference in the From field.

    • Click the Lookup Reference and from the Lookup For From, 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:

    • Type the first and last values of the range in the From and To fields.

    • 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, filter the report generation based on the balance date:

    • In the Enter Balance Date field, enter the required date.

    • Click the calendar icon at the end of the Enter Balance Date field to display the calendar. Select the required date.

  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.

​