Billing > Utility Billing > AR Processing > Delinquent Report/Late Charges

Recent Changes

Recent Changes: 
6.219 - Added functionality to "Always apply delinquent fees"  to added to a customer with a valid agreement.

6.176 - Added a second data pull for when Budget Billing is activated  

6.159 - Modifications to the query when "Include accounts with selected delinquencies only" to help improve processing time.

6.136 - Added a filter to the data pull to eliminate any customers with a zero balance or less as of delinquent date. 

6.101 - Fixed a bug which wouldn't pull in accounts correctly in certain circumstances when using the aging functionality

Refer to bottom of page for changes prior to version 6.100

Introduction

This report allows the user to print a list of delinquent customer balances and report on what penalty or late charges they owe based on a date selected.

Explanation

Late Charges

Delinquent Date - This date will filter payments or adjustment that occur after this date

Bill Date - If the system setting selected is delinquents by bill date, this date will be visible

Minimum / Maximum - Range of current balance OR subject to penalty balance to report delinquency on

Routes to include - Range or routes to include

Delinquent Notices

Print mailing labels instead of report - will print mailing labels instead of delinquent report

Print delinquent labels instead of report - will print delinquent labels instead of delinquent report

Delinquent Options

Print address to report - Prints service address on report

Print bill-to address on report - Print billing address on report

Omit customers flagged for omit penalty - Any customer marked as omit from penalty will not receive a delinquent fee. Check this option to exclude showing these customers on the report.

Include Pending Final/Finalized - will include, otherwise, does not include

Print total account balance on report - This option is only applicable for the Print delinquent labels instead of report option. When checked, the current account balance will be included on the delinquent labels report.

Compute penalty on current charges by delinquent date - This option includes any charges made after billing, but on or before the delinquent date.

Include accounts with selected delinquencies only - This option allows users to specify delinquency ranges to include on the report. Ranges include 0-30, 31-60, 61-90, 91-120, over 120, or All Values

Delinquent Configuration is used

These settings are defaulted on this screen and allow the user to override them

Delinquent Amount - Essentially a flat fee. This amount will be the delinquent amount added to the subject to penalty balance
Delinquent Percent - A percentage of the subject to penalty balance will be calculated to come up with the delinquent amount
Greater of: Amount or Percent x Outstanding Balance - the greater of the two values will be used. For example, if "amount" is higher than "percent", then that will be used. Otherwise, percent will be used
Amount + (Percent x Outstanding Balance) - this will add the amount to the calculated percentage amount

If Service Types is used

Charge type - choose to calculate service type penalty based on initial or additional

Include All Panel

These options allow the user to filter based on the following criteria:

  • Account name
  • Billing cycle
  • Master codes

Reference

Changes Prior to Version 6.100

6.83 - Removed the filter for Pre note customers for bank draft from Delinquent data pull and increased the space of the account number on the Delinquent Report 

6.74 - Added distribution processing to catch anything that has yet to be processed prior to running the report

6.67 - Changed the data pull to pull the service address from the location.

6.57 - Added option to select different delinquent ranges.

6.09 - The Delinquent/Late Charge report will now display the account balance as current account balance + late fee.  All delinquent notices will show the current account balance

6.01 - Made a modification to include current, unbilled charges when the "Compute penalty on current charges by delinquent date" option is checked. The system, previously, was not included these unbilled charges in the delinquent amount.