UB> Reports> Account Master

Account Master Report

Summary

The Account Master report is a list of Utility Billing customer accounts filtered by account status, billing cycle, connection date and/or final date. The report will display the balance forward on each customer account. Unbilled meter readings and uncommitted transactions are not included in the balance forward.

Step by Step

1 Open the Account Master window (UB> Reports> Account Master).

2 Configure the report.

Select how you would like the report to sort in the Report Sort drop-down menu.

Select Account Number to sort the report by the account number.
Select Customer Name to sort the report by the name associated with the account. You can view the customer information in UB> Maintenance> Account> People tab.
Select Owner Name to sort the report by the name of the owner on the lot. You can view the owner of a lot in UB> Maintenance> Account> Lot tab> Owner’s Customer Number field.
Select Reference Number to sort the report by reference number. You can view the reference number of a customer account in UB> Maintenance> Account> Account tab> Account sub-tab> General section> Reference Number field.
Select Route/Sequence to sort the report by route and sequence number. This will replace the Reference number column on the report with Route and Sequence number column.
Select Service Address to sort the report by the address the UB service is attached to. The service address will default to the lot address set up on UB> Maintenance> Account> Lot tab.

Select a Billing Cycle from the Billing Cycle drop-down menu to filter the report by billing cycle.

Select All to include all billing cycles in the report.
The Billing Cycle drop-down menu will display all billing cycles that have been created in UB> Maintenance> Cycle Code.
You can view the billing cycle that is attached to a UB customer account in UB> Maintenance> Account> Account tab> Account sub-tab> General section> Billing Cycle field.

Select the account statuses that you would like to include in the Account Status field.

If you include Delete status accounts on the report, accounts with a zero balance and a delete status will not be included in the report unless you check the Show Delete accounts with zero balances toggle at the bottom of the window.

Zero balance accounts of all other account statuses will display on the report.

The Connect Date From and Connect Date To fields are used to filter the accounts included in the report by the account connect date. Press DELETE to remove a date from a date field.
- You can view the connect date of an account in UB> Maintenance> Account> Account tab> Account sub-tab> Connect Date field.
- If you enter a value in the Connect Date From or Connect Date To field, the other field must also be used. Press the Down arrow to insert the current date into a field.
- The connect date on the account is not the same as the connect date on the service rate. The connect date on the service rate is the date the service rate is connected on the account. By filtering the report by connect date, you are not filtering the services that will be included in the balance of the accounts on the report. The balance of each account will not be affected by the connect date filter.
The Final Date From and the Final Date To fields are used to filter the accounts that are included in the report by the final date on the account. Press DELETE to remove a date from a date field.

You can view the final date on an account in UB> Maintenance> Account> Account tab> Account sub-tab> General section> Final Date field.
If you enter a value in the Final Date From or Final Date To field, the other field must also be used. Press the Down arrow to insert the current date into a field.
The final date on the account is not the same as the final date on the service rate. The final date on the service rate is the date the service rate is finaled on the account. By filtering the report by final date, you are not filtering the services that will be included in the balance of the accounts on the report. The final date filter will not affect the balance of the customer accounts on the report.

Check the Show Delete accounts with zero balances toggle to include Delete status accounts with a zero balance on the account.

If you do not check this toggle, customer accounts with a delete status and zero balance will not be included in the report.
Customer accounts of other statuses (active, suspended, vacation, final) with a zero balance are included on the report even if the Show Delete accounts with zero balances toggle is not checked.

The report will display the following information: customer number, reference number, customer name, mailing address, business phone, home phone, connect date, service address, final date and account balance. The report will also provide a total number of accounts listed.
- If the report was sorted by Route and Sequence number, the reference number column will be replaced with a route\sequence number column.
- The Account Balance column on the report displays the Balance Forward and does not include unbilled meter readings or uncommitted transactions.