UB Summary GL Comparison Report

Updated on Jul 17, 2023

Summary

The Summary GL Comparison Report displays discrepancies between the UB accounts receivable amount and the GL amount. This report can be filtered by journal entry date and the results are organized by date and batch number. If there is a discrepancy between the UB and the GL, it will be noted by a sequence of three asterisks in the final column.

If discrepancies are discovered, you can run the UB GL Comparison report to investigate the individual batches or journal entries where the discrepancies occurred.

Step by Step

1 Open the Summary GL Comparison Report window (UB> Reports> Summary GL Comparison).

2 Configure the report.

Select a date range for comparison in the JE Date From and JE Date To fields.
Select the GL Type your organization utilizes in Utility Billing from the drop-down menu.
- When Accrual Basis is selected, the report will display the JE Date, Batch number, AR Amount and GL Amount for each entry.
- When Cash Basis is selected, the report will display the JE Date, Batch number, Cash Amount, GL Amount and Other Amount for each entry.
The Out of Balance column at the right side of the report will display a series of three asterisks if the entries are out of balance.

3 Print the report.

Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
- Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
- Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
- Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
- Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).