Summary

The UB GL Comparison Report displays the differences between the UB and GL accounts. If you discover any discrepancies when running the Summary GL Comparison Report, you can use this report to investigate the individual batches or journal entries where the problem occurred. You can filter this report by batch number or date and the results will be organized by GL account. The difference between the UB and GL totals will be printed in the final column to make spotting discrepancies easier.

Step by Step

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

2     Configure the report.

• Use the Selection drop-down menu to specify how you would like to filter the accounts that are pulled into the report.
  • Depending on your selection, some of the fields in the window will be disabled.
• To filter the accounts by batch, select Batch from the drop-down menu and then click the Batch Number field label to open the Batch Selection window.
  • The batch type selected in the drop-down menu next to the Batch Number field will determine what type of committed batches populate the Batch Selection window.
  • Select the desired batch and click the Confirm icon   to exit.
• To filter the accounts by journal entry date, select JE Date from the drop-down menu and specify a date range 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.
• The report will display the GL Account, Service, Code, Fee Code, Tax Code and Amount for each line item in the batch or on the JE Date. The UB Total, GL Total and Difference will also be displayed.

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).