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

1Open theAccount Masterwindow (UB Reports Account Master).

2Configure the report.

• Select how you would like the report to sort in theReport Sortdrop-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 theBilling Cycledrop-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 theAccount Statusfield.
  • 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 theShow Delete accounts with zero balancestoggle 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.
• TheConnect Date FromandConnect Date Tofields 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-tabConnect Datefield.
  • 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.
• TheFinal Date Fromand theFinal Date Tofields 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 sectionFinal Datefield.
  • 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 theShow Delete accounts with zero balancestoggle 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.

3Print the report.

• Once the required report settings have been specified, click the Print buttonto 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. Hover over the Info icon to view the parameters on the previous report.
  • This section will display the last three times the report was generated.