UB AR Totals by UB Cycle Code

Updated on May 06, 2022

Summary

The AR 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 Summary sub-tab of the History 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.

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.