UB> Past Dues
Past Dues
Summary
The Past Due process allows you to pull UB customer accounts into a Past Dues batch based on billing cycle,
age of outstanding transactions and customer account status. Once customer
accounts have been included in a Past Dues batch, penalties are assessed using
an adjustment type code.
Customer accounts can be processed in more than one Past Dues batch at a time, so make sure when you are
assessing penalties that if customers are being processed in another batch that
they are not being double charged.
The adjustment code used to assess the late fees is a collection of fee codes. The fee codes attached to the
adjustment type code determine which GL accounts will be used in the transaction
and how penalty charges are assessed on the customer accounts. The fee codes on
the adjustment code will also determine which customer accounts are pulled into
the Past Dues batch based on the services attached to the fee codes and the
minimum amount of past due balances that the fee code will apply to. If there is
credit information attached to the adjustment type code, a credit history line
item will be created on all customer accounts processed in the Past Dues batch.
Credit history line items display in the Credit History section on the Account
Master Maintenance window (UB> Maintenance> Account> Overview
tab).
The entire balance of the customer accounts will only be pulled into the batch if all of the services that
are attached to the customer accounts are also attached to the fee codes used to
assess the penalties. Only the account balances on services that are attached to
the selected Past fee codes will be pulled into the batch.
The journal entry created by the Past Dues process will debit the AR account and credit the revenue account
attached to the fee code. The GL type of the adjustment type code will not
affect the journal entry created by the Past Dues process.
After customer accounts have been selected and processed in the Past Dues batch, you can generate Past Due
statements for the customer accounts in the batch. Past due statements are set up
in UB> Utilities> Statement Maintenance.
After the Past Dues batch is committed, the past dues will display on the customer account as an adjustment
line item transaction type. The amount of the adjustment line item will be the
amount of the penalties assessed on the account. The adjustments will only
display on the customer accounts when the batch is committed (UB> Maintenance>
Account> History tab). Uncommitted Past Due transactions will
not display on the accounts in the batch.
Related Links
Click here for information on Adjustment Type Code Maintenance.
Click here for information on Fee Code Maintenance.
Click here for information on Statement Setup.
Click here for information on Statement Message Maintenance.
Click here for an overview of the Credit History feature.
Click here for an overview on service requests.
Step by Step
2 Generate the Past Dues.
3 Complete the Exceptions step. This is an optional step.
- The Exceptions step will display errors and exceptions generated on customer
accounts during the Past Dues process.
- Open the Exceptions/Past Dues window (UB> Past Dues> Exceptions).
- The “Found credit balance in Service XX for the amount of XXX,” message will display if there is a credit
balance on a service attached to the account.
- If you would like to process the customer account in the Past Dues batch, run the Redistribute Credits process
(UB> Adjustments and Fees> Redistribute Credits).
- The “Missing Service XXX. Cannot apply penalty,” message will display if the service to charge on a fee code used
to assess a past due penalty is not attached to a customer account. For example,
if LATE fee code charges service PENALTY, the PENALTY service must be attached
to the customer account. You can view the service a fee code will charge on the
Fee Code Maintenance window (UB> Maintenance> Fee Code> Service To Charge field).
Click here for
information on fee code maintenance.
- Press ESC when complete to exit the window.
4 Select which customer accounts to include in the Past Dues batch and/or add
additional charges. This is an optional step.
- Skip this step if you would like
to charge all of the customer accounts selected during the Generate step.
- The Select/Update step on the Past Dues palette is used to select the customer accounts that will be included in
the Past Dues batch. The Select/Update window will display the past dues
generated based on the selections during the Generate step. The Select/Update
window allows you to select which generate past dues are processed in the batch,
and is also used to modify the past dues amount.
- Open the Select Update window (UB> Past Due> Select/Update).
- The Select Update window will display all of the UB customer accounts included in the Past Dues batch.
- Uncheck the Print toggle if you do not want the customer account to print on a Past Due statement (UB>
Past Dues> Statements). Charges will still be applied to the customer account,
but a Past Due statement will not be generated.
- The Print toggle will not apply if the Selected toggle is unchecked. You cannot print a Past Dues
Statement unless the customer account is included in the batch.
- Uncheck the Selected toggle if you do not want to include the customer account in the Past Dues batch. No
charges will be generated on the customer account.
- If the Selected toggle is unchecked, the selection in the Print toggle will not apply. You cannot
print a Past Dues Statement unless the customer account is included in the
batch.
- Customer accounts with the Selected toggle unchecked will be removed from the Select/Update window
after you click the Save icon. This means if you uncheck the Selected
toggle of a customer account and save the window, you will have to regenerate
the Past Dues batch in order to add that customer account back into the Past
Dues batch.
- Check the IVR Call toggle for each account that should receive an IVR call when the Past Dues batch is committed.
- Interactive Voice Response (IVR) systems are third-party tools that can be set up to automatically generate past due courtesy calls when an account is flagged as past due.
- For more information on implementing an IVR system, please contact Springbrook Support at 800-777-0069.
- Click the Expand button to view the fee code amounts that will be applied to the customer account.
- Each fee code that is attached to the adjustment type selected during the Generate step (UB> Past Dues> Generate>
Adjustment Type For New Charges section) will display as a separate line item.
- The Additional Charges column will displays the charges calculated during the Generate step based on
the fee codes attached to the selected adjustment type. Modify the amount in the
Additional Charges column if you would like to modify the amount
of the fee.
- The selection in the Create adjustment history for zero amounts toggle on the Generate window (UB> Past
Dues> Generate) will affect the functionality of the Select Update window. If
the Create adjustment history for zero amounts toggle was checked when
the batch was generated, customer accounts that are not assessed a penalty
(there is a $0 in the Additional Charges column) will be included in the
batch if they are selected. If the Create adjustment history for zero amounts
toggle was not checked during the Generate step, customer accounts that are
not assessed a penalty will not be included in the batch even if they are
selected in the window.
- Click the Save icon
or press ENTER when complete.
5 Print the Aging Report.
- The Aging Report will display the age of the balances included in the
Past Dues batch and the penalty fees that will be applied. This report can
also display comments attached to customer accounts using the Account Master
Maintenance window (UB> Maintenance> Account> Comments
tab).
- Select Aging Report from the Past Dues palette to open the Aging window.
- The Sort By drop-down menu is used to select how the report will sort.
- Select a fee code option (fee code, customer number or fee code, reference number) to filter the customer accounts
that display on the report by the fee codes used to apply the penalty charges.
This will display a total for each fee code used to charge penalty fees. For
example, if penalty fees are applied using LATE% and LATEFLAT, selecting a fee
code option will display a total of the fees generated using LATE% and LATEFLAT.
If you do not select a fee code option, the report will not display a separate
total for each fee code used to generate penalties.
- The Alert Codes field is used to add the comments attached to the
customer accounts to the report. For example, if you have a comment status
used to record conversations with customers regarding past dues, you can select
that comment status so that those comments will display on the report. The
report will display both the comment status and the comment description (the
comment description is the comment text entered on the customer account in UB> Maintenance> Account> Comments tab> Select a comment>
Comment Body section).
- Click the Print icon
to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time.
You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs). Click here for information on the Jobs Viewer window.- Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
- Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
- Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
- Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report). Click here for information on the View Reports window.
- The Aging Report will display the following information: customer information (customer name, account
number, reference number), fee code, fee code description, balance forward, past
due amount, under 30 days, 30-60 days, 60-90 days, 90-120 days and other.
- The difference between the amount in the Balance Forward column and the Past Due
column is the penalty charge applied to the customer account.
- The Reference Number that displays on the report is the reference number on the customer account. You
can view the reference number attached to a customer account in UB> Maintenance>
Account> Account tab> Account sub-tab> Reference Number field.
6 Print a Proof List.
- The Proof List will display the Past Due amount, the penalty charges generated on the account, and the new
balance forward on the account. This report can also display comments
attached to customer accounts using the Account Master Maintenance window (UB> Maintenance> Account> Comments
tab).
- Select Proof List from the Past Due palette. This will open the Proof List window.
- Select how you would like the report to sort in the Sort By drop-down menu. The selection in this field
will only affect how information is displayed on the report.
- The Alert Codes field is used to add the comments attached to
the customer accounts to the report. For example, if you have a comment status
used to record conversations with customers regarding past dues, you can select
that comment status so that those comments will display on the report. The
report will display both the comment status and the comment description (the
comment description is the comment text entered on the customer account in UB> Maintenance> Account> Comments tab> Select a comment>
Comment Body section).
- Click the Print icon
to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time.
You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs). Click here for information on the Jobs Viewer window.- Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
- Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
- Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
- Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report). Click here for information on the View Reports window.
7 Print a Shut Off Listing Report.
- The Shut Off Listing Report will display the customer information,
meters attached to the account, past due amount, penalties, and the new
account balance forward. This report can also display comments attached to
customer accounts using the Account Master Maintenance window (UB> Maintenance> Account> Comments
tab).
- Select Shut Off Listing from the Past Due palette. This will open the Shut Off Listing window.
- Select how you would like the report to sort in the Sort By drop-down menu. The selection in this field
will only affect how information is displayed on the report.
- The Alert Codes field is used to add the comments attached to
the customer accounts to the report. For example, if you have a comment status
used to record conversations with customers regarding past dues, you can select
that comment status so that those comments will display on the report. The
report will display both the comment status and the comment description (the
comment description is the comment text entered on the customer account in UB> Maintenance> Account> Comments tab> Select a comment>
Comment Body section).
- Click the Print icon
to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time.
You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs). Click here for information on the Jobs Viewer window.- Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
- Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
- Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
- Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report). Click here for information on the View Reports window.
8 Set up the past dues statements.
- The Statement Settings window is used to set up the Past Dues statements and select which customer accounts in the
Past Dues batch will receive statements. If a statement is not generated for a
customer account included in the Past Dues batch, past due penalties will still
be assessed on the account.
- Select Statement Settings from the Past Due palette. This will open the Statement Settings window.
- Enter the due date of the past dues in the Due Date field.
- The value in this field will default to the current date plus 15 days.
- Enter the transaction date of the past dues batch in the Transaction Date field. The Transaction Date field will
default to the transaction date entered during the Generate step (UB> Past Dues> Generate> Transaction Date field).
- The Minimum and Maximum fields are not used in the Past
Dues process.
- Select the past dues statement you would like to print in the Statement drop-down menu.
- Statements are created and maintained in the Statement Setup Maintenance window (UB> Utilities> Statement Setup).
- The Account Status field is used to select the status of the customer accounts that a statement
will print for.
- The Message 1 and Message 2 fields are used to add messages to the past due statements. You
can either enter a message in the field, or click the Message 1 or Message 2 field label to select a message from a list.
- The Statement Message Maintenance window (UB> Maintenance> Statement Message) allows you to create and maintain
message statements.
- Press ENTER when complete. The statements will be generated after the addresses of the customer accounts
included in the Past Dues batch have been verified.
9 Certify the addresses of the customer accounts included in the Past Dues batch.
10 Print the past dues statements.
- The Statements step is used to generate the past due statements based on
the statement settings selected on the Statement Settings step (UB> Past Dues> Statement Settings). The statements will be generated in a PDF
report. Once the PDF file is complete, you can print the statements onto
your past dues statement stock.
- Select Statements from the Past Dues palette. This will open the Statements window.
- Select a customer account in the Account Number field to print a statement for a single account.
- Click the Account Number field label to select a customer account from a list. You will only be able to print
Past Due statements for customer accounts that have been included in the batch.
If you select a customer account that is not in the Past Due batch, the report
will not print and the Jobs Viewer will display an error message (Unable to find
any UB Accounts that match the Print options.)
- This option is generally used to reprint statements.
- Select the order that statements will print in the Sort drop-down menu.
- If the addresses of the customer accounts have been certified, select Auto Presort. This will select Certified
Bills in the Mail Type drop-down menu and disable the field.
- If the customer accounts in the Past Dues batch have not been certified using the Export Addresses and Import
Addresses steps, do not select Auto Presort in the Sort drop-down menu. No
statements will print and the Jobs Viewer window will display an error message
(Unable to find any UB Accounts that match the Print options).
- The Mail Type drop-down menu will be enabled if Auto Presort was not selected in the Sort
drop-down menu.
- Do not select Certified Bills if the Export Addresses and Import Addresses steps on the Past Dues palette have
not been used to certify the addresses in the batch. If this option is selected
and the addresses have not been certified, the Jobs Viewer window will display
an error message (Unable to find any UB Accounts that match the Print options).
- The Include drop-down menu is used to select the past due statements you would
like to include in the printing. This field is disabled for the Past Dues process as all statements are automatically included.
- A past dues statement will not print for a customer account if the statement is not attached to the customer
account.
- You can view the statements attached to a customer account on the Account Master Maintenance window (UB>
Maintenance> Account> People tab> Bill To sub-tab).
- The Past Due Statements are set up and maintained in UB> Utilities> Statement Setup. The Statement Name
field of the report will display in the drop-down menu.
- Press ENTER to generate the Statements immediately or enter a date and time in the field next to the Print
icon
to schedule the Statements to print at a later time.
- If the Statement selected in the Statement drop-down menu is not attached to any of the customer accounts
included in the batch the Jobs Viewer window will display an error message
(Unable to find any UB Accounts that match the Print options).
- Additional Past Dues statements will print if there are additional customers attached to any of the customer
accounts included in the Past Dues batch.
- Additional customer accounts are attached to the Account Master Maintenance window of the account included in the
batch (UB> Maintenance> Account> People tab> Bill To sub-tab).
11 Export Statements.
12 Print a GL Distribution report.
- For organizations that have the GL module interfaced with the Utility Billing module, the GL Distribution step will
display on the Past Dues palette. The GL Distribution step is used to set up the
journal entry date and create a GL Distribution Report that displays the journal
entry created by the Past Dues batch.
- Select GL Distribution to open the UB GL Distribution report window.
- Enter a Journal Entry Date. The Journal Entry Date will determine the fiscal year and period the
transactions in the batch will be posted to.
- The Fiscal Period and Fiscal Year fields will populate based on the date entered in the
Journal Entry Date field.
- The Journal Entry Date is not necessarily the same date as the Post Date that will display on the History tab
of the Account Master Maintenance window (UB> Maintenance> Account). The post date is the date that the batch is committed.
- Select the level of detail on the report.
- The summary version of the report will display the net change in the general ledger accounts. It will not display
the fee code and the penalties assessed to each customer account.
- The detail version of the GL Distribution report will display the transaction line on each general ledger
account. The report will also display the fee code of each journal entry line
item and the penalty assessed on each customer account.
- Click the Print icon
to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time.
You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs). Click here for information on the Jobs Viewer window.- Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
- Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
- Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
- Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report). Click here for information on the View Reports window.
- The general ledger accounts used to assess the penalties depends on the general ledger accounts on the fee codes
attached to the adjustment type selected during the Generate step.
- You can view the fee codes used to create the journal entry by generating the report in detail format, or you can
view the fee codes attached to the type code on the Adjustment Type Maintenance
window (UB> Maintenance> Adjustment Type> Fee Code field).
- The AR GL account on the fee code (UB> Maintenance> Fee Code> AR Account field)
will be debited in the transaction.
- The revenue GL Account on the fee code (UB> Maintenance> Fee Code> Revenue Account
field) will be credited in the transaction.
- The GL Type of the adjustment type code does not affect the journal entry created by the Past Dues process.
Adjustment types set up as cash or bill will generate the same journal entry.
- Generate the GL Distribution report in the detail version if you want to view the fee codes used in the transaction.
This will help you track back where the GL accounts are being pulled from if you
are processing a Past Dues batch that uses more than one fee code to assess
penalties.
13 Commit the batch when complete.
- Select Commit step from the Past Dues palette. This will open the Commit Past Due Information window.
- The Commit step generates the history records on the customer accounts for the assessed penalty charges and
the service requests for the customers in the batch if you selected a service
request code during the Generate step.
- If you are creating service requests on the customer accounts in the batch, the Commit step will create the
service requests.
Springbrook Software
® All Rights Reserved 2017
Toll Free Support 866-777-0069