SB Enterprise Help Center

UB Collections

Updated on

Summary

The Collections process is used to write off the balance of selected UB customer accounts and will create an adjustment type transaction on the accounts. The Generate step (UB> Collections> Generate) of the process is used to select the customer accounts to process in the batch. The balance of the customer accounts will be written off using the general ledger accounts attached to the service rates and fee codes being written off. The Collections adjustment type code (UB> Utilities> Setup> General tab> Collections Adjustment Type field) determines which general ledger accounts attached to the service rates and fee codes on the customer accounts will be used in the journal entry created by the Collections process. The collections adjustment type code will also display on the transaction line item created on the customer account.

After the batch has been generated, the Exceptions step (UB> Collections> Exceptions) will display the UB customer accounts that have been selected during the Generate step but have not been included in the Collections batch. Customer accounts with a credit balance on a service will not be included in the Collections batch. For example, if a customer has a balance due of $10.00 on the Water service but a $5.00 credit balance on the Waste Water service, the customer account will not be included in the Collections batch even if it is selected during the Generate step. If you would like to include the account in the Collections batch, run the redistribute credit balances process (UB> Adjustments and Fees> Redistribute Credit Balances) on the customer account to redistribute the credit balance. For example, if the Water service balance is $-10.00, but the Waste Water service balance is $54.00, you can include the customer account in the Collections process by running the redistribute credits process. The $10.00 credit balance will be used to reduce the balance of the Waste Water service and the customer account will be included in the Collections batch with a balance of $44.00.

The Select step (UB> Collections> Select/Update) is used to select the customer accounts included during the Generate step. This step is generally used to remove specific UB customer accounts from the Collections batch.

The GL Distribution report will display the journal entry created by the Collections process to write off the balance of the UB customer accounts included in the batch. If the Collections adjustment type code is set up as a Bill type adjustment (UB> Maintenance> Adjustment Type> GL Type drop-down> Bill), the following journal will be created.

Description of GL Account Debit Credit
AR account attached to service rate or fee code XXX
Revenue account attached to service rate or fee code
XXX

If the Collections adjustment type code is set up as a Cash type adjustment (UB> Maintenance> Adjustment Type> GL Type drop-down> Cash), the following journal will be created.

Description of GL Account Debit Credit
Cash account attached to service rate or fee code
XXX
AR account attached to service rate or fee code

XXX

The Commit step is used to commit the transactions in the batch. The day the Commit step is process will be the post date of the transactions in the batch.

Step by Step

1     Create a Collections batch.

  • Open the Collections Batches window (UB> Collections). The Batches window will display all the open Collections batches.
  • Click the Create New Batch button to create a new batch. This will open the Create Batch window.
    • If there are open batches in the Collections process, you can create a new batch without affecting the open batches.
  • Enter a Batch Month and Batch Year. These fields will default to the current calendar period and calendar year and are used for reference only. The batch month and batch year do not affect the transaction or journal entry date of the transactions in the batch.
    • The fiscal period of the transactions in the batch is determined by the Journal Entry Date entered during the Generate step.
  • Click Create to create the new Collections batch.

 

2     Open the Batch Overview page. 

  • The Batch Overview page provides a general overview of the selected batch.
  • The left navigation menu displays all the steps in the Collections process.
  • In the main section you'll see information about batch steps that are currently processing, next available batch steps, and the last completed batch step.
    • Batch steps that are currently processing will display a blue indicator bar to alert you that the step has not yet completed.
    • Once the preceding batch step is complete, the next available batch steps will be enabled and you can select the next step you would like to run.
      • While some batch steps are optional, any batch step that includes the Required tag   must be completed before the batch is allowed to proceed through to the Commit step.
  • The Batch Outputs section on the right will display any reports or exports that have already been generated in the Collections process.

 

3     Generate the collections. 

  • Open the Generate/Collections window (UB> Collections> Generate).
  • The Generate step is used to select which customers will be included in the Collections batch. After the Collections batch has been generated, individual accounts can be removed from the batch using the Select/Update window (UB> Collections> Select/Update). After the Collections batch has been generated, returning to the Generate step and regenerating the batch will overwrite the customer accounts already included in the batch.
  • Select the cycles you would like to include in the Collections batch in the Cycles field.
    • Click SELECT ALL or DESELECT ALL to select or deselect all the displayed cycles.
  • Select the services you would like to include in the Collections batch in the Services field.
    • Click SELECT ALL or DESELECT ALL to select or deselect all the displayed services.
    • The balance on any service that is not included in the Collections batch will not be included in the Collections amount.
    • You can view the balance of a service on a customer account from the Account Maintenance window (UB> Maintenance> Account> Overview tab> Account Balance section).
  • Click the Account Number field search button to include a single customer in the batch. This will open the Account Search window in order to select a customer account.
    • When filtering by account number, the Past Dues Batch, Account Status, and Final Date filters below will be ignored.
  • Click the Past Dues Batch field search button to include the customer accounts in a committed Utility Billing Past Due batch. This will open a selection window that displays all committed UB Past Due batches.
    • When filtering by Past Dues batch number, the Account Status and Final Date filters below will be ignored.
  • Check the toggles of the account statuses that you would like to include in the batch in the Account Status field.
    • Click SELECT ALL or DESELECT ALL to select or deselect all the displayed statuses.
  • The Final Date Prior or Equal To field will only be active if Delete is selected in the Account Status field. Select a date from this drop-down menu to filter the deleted accounts included in the batch by final date.
  • The Due Date Prior or Equal to field is used to filter the transactions included in the batch by due date.
    • Only those transactions that have due dates that fall before or on the specified date will be included in the batch. Transactions that do not have due dates will be filtered by the other parameters on the window.
    • If no date is selected, this functionality will not be used.
  • The Journal Entry Date field will default to the current date. The journal entry date is the date that the journal entries created by the Collections process will be posted to the general ledger.
    • The Journal Entry Date will also be used as the Transaction Date.
    • The journal entry date is different than the Post date in the UB module. The Post Date is the date that the transactions are committed in UB> Collections> Commit.
    • The journal entry date will also display when you are creating the GL Distribution Report during the GL Distribution step.
  • Enter an amount in the Debt Greater Than field to include only customer accounts with a balance greater than the value entered in the field. The value entered in this field represents the minimum value of the balances that will be included in the batch.
  • Enter an amount in the Debt Less Than field to include only customer accounts with a balance less than the value entered in the field. The value entered in this field represents the maximum value of balances that will be included in the batch.
    • The Debt Greater Than and Debt Less Than fields can be used together if you would like to create a range of accounts to pull in into the batch.
  • The Write off to AR field, AR Billing Cycle field and the Use AR revenue account toggle are only used when writing off the balance of UB customer accounts to the AR module.
  • Click the Submit button to generate the Collections or click the Schedule button to schedule the batch to generate at a later time.
  • The Generate step will select the general ledger accounts used in the process. If you get to the GL Distribution step of the Collections process and realize that the GL accounts used on the journal entry are incorrect, you will have to rerun the Generate step after you change to GL accounts attached to the fee code.

 

4     The Exceptions step displays the customer accounts not included in the batch due to exceptions or errors. This is an optional step.

  • Open the Exceptions/Collections window (UB> Collections> Exceptions). If no exceptions were generated in the batch, an information window will open.
  • The UB customer accounts that display in the Exceptions window will not be processed in the Collections batch.
  • The most common exception that will display in the window is “Found credit balance in Service XX for the amount of XXX.” This message will display if there is a credit balance in a service included in the Collections batch.
    • This message will even display if there is a debit balance on another service on the customer account. If the customer has a debit balance on one service and a credit balance on another service you should run the redistribute credits process (UB> Cash Receipts> Redistribute Credit) in order to redistribute the credit balances on the services.

 

5     The Select/Update step is used to select which customer accounts to include in the batch.

  • Skip this step if you would like to include all of the customer accounts selected during the Generate step.
  • The Update/Collections window will display the customer information and account balance.
    • The Amount column displays only the balance on services that have been included in the batch.
      • You can edit the value displayed in the Amount column.
      • The services included in the Collections batch were set up during the Services field of the Generate step.
  • Uncheck the Selected toggle to remove the customer account from the Collections batch.
    • Use the Select and Deselect buttons in the data grid header to select or deselect the displayed customer accounts.
  • Click the Save button or press ENTER when complete.

 

6     Print a Proof List.

  • The Proof List will display all of the customer accounts included in the Collections batch and the collection amount of each service included in the batch.
  • Open the Proof List/Collections window in UB> Collections> Proof List.
  • Select how you would like the report to sort and order the data in the Sort By drop-down menu.
    • The Reference Number field is generally used to store the customer number from previously used software. The reference number is set up on each customer account in UB> Maintenance> Account> Account tab> General section> Reference Number field.
  • 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.
    • Enter a Date and Time to generate the report and click SUBMIT.
  • The Proof List will display the customer information and the collections balance on each service included in the Collections batch. The report will also include a batch total by service and a batch total of the entire collections amount.

 

7     Print a Turnover report.

  • The Turnover Report will display the customer information and the total amount sent to collections. This report is typically given to an outside agency for collection processing.
  • Select how you would like to sort the information that displays on the report in the Sort By drop-down menu.
    • Select Account Number if you would like to sort the report by UB customer account number.
    • Select Reference Number if you would like to sort the report by the reference number attached to the UB customer account.
      • The Reference Number field is generally used to store the customer number from previously used software. The reference number is set up on each customer account (UB> Maintenance> Account> Account tab> General section> Reference Number field).
    • Select Last Name if you would like to sort the accounts that display on the report by last name.
  • Select which information you would like to display in the Display drop-down menu.
    • Select Tenant information if you would like the tenant or primary customer information to display on the report.
    • Select Owner Information if you would like the owner attached to the lot to display on the report.
  • Select the Report Type you would like to generate.
    • The Summary report will display the Account Number, Reference Number, Tenant Name, Tenant Phone Number, Tenant Mailing Address, Service Address, Social Security Number, Driver's License Number, Tax Lot, Last Bill Date, Last Bill Amount and Amount to Collections. The report also provides batch totals for Last Bill Amount and Amount to Collections.
    • The Detail report will display everything included in the Summary report as well as the Service Code, Rate Code, Tax Code, Fee Code and Description for each line item.
  • Check the Group details by service group toggle to group the line items on the report by the service group the services are assigned to.
    • This toggle will only be enabled when generating the detailed version of 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.
    • Enter a Date and Time to generate the report and click SUBMIT.

 

8     Export the collections data.

  • Generate an export file if your organizations sends collections information to a third-party agency.
  • The exported collections file will include the Account Number, Account Balance, Service Code, Service Description, Itemization Date, Balance as of Itemization Date, Interest and Fees Added Since Itemization Date, and Payments Since Itemization Date for each account included in the batch.
  • Select a Configuration for the export file.
    • The Configuration drop-down menu will display the standard Springbrook export format as well as any custom export formats that have been created for the Collections process.
    • Select (Standard) to generate the a basic export file based on standard Springbrook parameters.
    • Custom export configurations are created and maintained on the Export Configuration Maintenance window (SS> Maintenance> Export Configuration). Click the Export Settings button at the top of the window to display the format of the export file.
      • Please work with your third-party agency when creating and testing a custom export configuration.
  • Check the Group details by service group toggle to group the line items in the export file by the service group the services are assigned to.
  • The export file must be in comma-separated value (.csv) format.
  • Click the Submit button to export the collections data file.

 

9     Print a GL Distribution report.

  • The GL Distribution Report will display the journal entry created by the Collections process. The GL accounts selected by the process are determined during the Generate step. If you would like to modify the GL account used in the transaction, you will have to change the GL accounts attached to the fee codes and then regenerate the Collections batch.
  • The GL Distribution step will only display on the Collections menu if the General Ledger module is set up to interface with the Utility Billing Module.
  • The Journal Entry Date field will populate from the Journal Entry Date field in UB> Collections> Generate> Journal Entry Date field. The Fiscal Period and Fiscal Year fields will populate with the fiscal period and year based on the journal entry date.
    • The Journal Entry Date field will not be enabled. If you would like to modify the journal entry date of the transactions in the Collections batch, you will have to regenerate the batch and enter a new date in the Journal Entry Date field in UB> Collections> Generate.
  • Select the level of detail you want to include in the report and how it will sort in the Report Type drop-down menu.
    • The detail version of the report will display the journal entry line item on each customer account. The summary version will only display the transactions totaled by general ledger account and exclude the customer information.
    • The detail version of the report will display the general ledger account number, customer number, service code, rate code, description, and the debit and credit amounts. The report will also group by fund and display a report total.
    • The summary version of the report will display the net transaction on each general ledger account. The report will display the general ledger account, general ledger account description, and the debit and credit amount. The report will also group by fund and display a report total.
    • Once a Report Type is selected for a GL Distribution report, that report type will be automatically set as the default for all UB GL Distribution reports.
  • Select how you want to sort the information on the report.
    • If you sort the report by general ledger accounts, the report will sort by general ledger accounts.
    • If you sort the report by transaction type, the transactions will sort by AR adjustments and billing adjustments. The report will also sort by general ledger account within the AR adjustments and billing adjustments.
  • 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.
    • Enter a Date and Time to generate the report and click SUBMIT.
  • The journal entry created by the process will vary depending on how the Collections adjustment type code is set up (UB> Utilities> Setup> General tab> Collections Adjustment Type field).
    • If the Collections adjustment type code is set up as a Bill type adjustment (UB> Maintenance> Adjustment Type> GL Type drop- down> Bill), the following journal will be created.
Description of GL Account Debit Credit
AR account attached to service rate or fee code
XXX
Revenue account attached to service rate or fee code

XXX
  • If the Collections adjustment type code is set up as a Cash type adjustment (UB> Maintenance> Adjustment Type> GL Type drop-down> Cash), the following journal will be created.
Description of GL Account Debit Credit
Cash account attached to service rate or fee code
XXX
AR account attached to service rate or fee code

XXX

10     Commit the Collections batch.

  • After the Proof List and GL Distribution Report have been reviewed, the Collections batch is ready to commit. Once a Collections batch has been committed, you cannot roll the transactions back, so make sure the transactions in the batch are correct.
  • Open the Commit window (UB> Collections> Commit).
  • The Batch Number field will display the batch number of the batch being created. If you have several open Collections batched, make sure you are committing the correct Collections batch.
  • The Journal Entry Date field will display the journal entry date entered during the Generate step of the Collections process.
    • The Fiscal Period and Fiscal Year field will populate based on the journal entry date.
    • The journal entry date cannot be modified from the Commit window. In order to change the journal entry date, you will have to regenerate the Collections batch and enter a different date in the Journal Entry Date field in UB> Collections> Generate.
  • Click the Commit button when complete to commit the batch.
Previous Article UB Collections Setup
Next Article UB Final an Account Process Overview
Still Need Help? Contact Us