Summary

The A/R Totals by Billing Cycle Report displays a balance forward total of all UB customer accounts in a billing cycle regardless of the status of the customer account. The report will display a single line item for each billing cycle included on the report, it will not display a line item for each UB customer account included in the report. If you would like a report that will display all of the UB customer accounts in a billing cycle and the balance forward on the account, create an Account Master Report for a billing cycle (UB> Reports> Account Master). Both reports pull the amount due from the field Balance_Forward in the UB_Financial table.

Unbilled meter readings and uncommitted transactions are not included in the total on the report. Only committed billings, payments and adjustments made on UB customer accounts in the selected billing cycles will be included. You can view the history of an account in UB> Maintenance> Account> History tab. Uncommitted transactions will be in red.

If you would like to view the balance on AR GL accounts attached to fee codes and service rates, run the Balance by AR Account Report (UB> Reports> Balance by AR Account). The transactions that display on the Balance by AR Account Report are filtered by journal entry date.

Step by Step

1     Open the AR Totals By Cycle window (UB> Reports> AR Totals By Cycle).

2     Configure the report.

• Select a billing cycle in the Billing Cycle drop-down menu.
  • Select All to include all billing cycles in the report.
  • All billing cycles that have been created in UB> Maintenance> Cycle Code will display in the drop-down menu.
  • You can view the billing cycle attached to a specific UB customer account in UB> Maintenance> Account> Account tab> Account sub-tab> General section> Billing Cycle field.
• The report will display a billing cycle and total column, and a Grand Total field for all of the billing cycles included on the report. The Total column displays the balance forward of all customer accounts in the billing cycle. You can view the balance forward of a single customer account in Balance Forward column in the Account Balances section on the Overview tab of the Account Master Maintenance window (UB> Maintenance> Account> Overview tab). Since the Account Balance field is the Balance Forward field, the Account Balance field does not include unbilled meter readings.

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