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 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 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 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.
  • Click the toggle next to the field title to select or deselect all the account statuses.
• The Connect Date From and Connect Date To fields are used to filter the accounts included in the report by the account connect date.
  • 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.
  • 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.
  • 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.
  • 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.

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.