SB Enterprise Help Center

UB Import Adjustments from KVS

Updated on

Summary

The Import Adjustments window is used to import KVS Collection Balance files into Cirus. 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.

Step by Step

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

 

2     Import the KVS collections adjustment file.

  • Click the Select File button and locate the Collection Balance file by browsing through the file structure on your network. You can also drag and drop the file into the area next to the button.
    • 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 VIEW LAYOUT/FORMAT to view the expected format of the import file.
  • 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 search button   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).
  • 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.
  • Click the Submit button   to import the file. You can view the progress of the import on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
Previous Article UB Export Assistance Accounts
Next Article UB Import Assistance Accounts
Still Need Help? Contact Us