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.

• 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 Send PDF to Job Viewer to print the report in the default Springbrook format.
  • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
  • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
• Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
  • Scheduled printing has not yet been enabled for reports generated from process batches. This functionality will be released in an upcoming service pack.
• 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. This section will display the last three times the report was generated.