UB> Utilities> Import Adjustments

Import Collections Adjustments from KVS

 

Summary

 

The Import Adjustments window is used to import KVS Collection Balance files into Springbrook. These files will update associated UB account information with the current account balances that are maintained in the KVS system. These account balance amounts will be imported as billing adjustments and will display as previous balances in the billing process.

 

This tool is designed for KVS users that would like to utilize Springbrook's UB Billing functionality but must continue to use KVS UB Collections for processing taxes.

 

Related Links

 

Click here for information on Fee Code Maintenance.

Click here for information on New Billing Export.

 

Step by Step

 

1     Open the Import Adjustments window (UB> Utilities> Import Adjustments).

 

2     Import the KVS collections adjustment file. 

 

  • The File Name field is used to select the path of the Collection Balance file you would like to import into Springbrook. Enter a path or click the File Name field label to locate the file by browsing through the file structure on your network.
    • Each account number included in the Collection Balance file must already exist as a Springbrook UB account. If not, an error message will be displayed and the import will fail.
    • Click the Display Report Layout icon to view the expected format of the import file. Click here for information on the File Layout window.
  • The Fee Code field is used to select the UB Fee Code that will charge the account balance amounts associated with KVS accounts after importing the file to Springbrook. Enter a Fee Code or click the field label to select one from a list.
    • The Service to Charge specified on the selected fee code must be an active service on all the accounts included in the Collection Balance file. If not, an error message will be displayed and the import will fail.
    • Fee codes are created and maintained on the Fee Code Maintenance window (UB> Maintenance> Fee Code). Click here for information on Fee Code Maintenance.
  • The Tran Date field is used to specify a transaction date that will be associated with the account balance adjustment transactions created when the Collection Balance file is imported. This will default to today's date.
  • Imported transactions will be assigned a post-date prior to the last billing date. This ensures the balance displays as a previous balance on the billing statement.
  • Press ENTER or click the Confirm icon to import the file immediately or enter a date and time in the field next to the Confirm icon to schedule the import to process at a later time. You can view the progress of the import on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).