UB> Reports> UB GL Comparison

UB GL Comparison Report

 

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.

 

Related Links

 

Click here for information on the Summary GL Comparison Report.

 

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 report will be disabled.
  • To filter the accounts by batch, select Batch from the drop-down menu and then click the search button in the Batch field to open the Batch Selection screen.
    • The Batch Type selected in the drop-down menu next to the Batch field will determine what type of committed batches populate the Batch Selection screen.
    • Select the desired batch and click the Select button to return to the report screen.
  • 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.  

 

  • Once the required report settings have been specified, click the Print button to print your report.
  • Click the options arrow on the right side of the Print button to see other print options.
    • Select PDF to print the report in the default Springbrook PDF format.
    • Select Excel to export the report data to an Excel spreadsheet as unformatted data.
    • 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 a print option is selected, that option will automatically be selected the next time you access the report. For example, if you select Excel from the drop-down menu, the next time you access the report the Excel button will be displayed by default.
  • Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
    • Enter a Date and Time to generate the report and click SUBMIT.
  • Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
    • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button on the right side of the window.
    • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. Hover over the Info icon to view the parameters on the previous report.
    • This section will display the last ten times the report was generated.