Skip to content
English
  • There are no suggestions because the search field is empty.

Collection Reports

Collection Reports The FLEX system offers many Collection Reports available directly from the FLEX Main Menu making it easy for users to generate collection reports on demand. Reports are available under the Collections and Reports category in the FLEX Main Menu.

Bankruptcy Report – This option will generate a list of accounts that have been entered into the Bankruptcy and Legal Information menu option. This report includes account/suffix, member name, loan type, bankruptcy chapter, balance at time of filing, date bankruptcy filed, meeting date, proof of claim, reaffirm date, last payment, bankruptcy case number, attorney name and phone number, trustee name and phone number.

Charged Off Accounts – This option allows the user to create a report of charged off accounts based upon criteria defined. User will be prompted for starting/ending charge off date, include resolved items, sort order, whether to include loans, shares or both.

Charged Off Analysis – This option will generate an analysis of charged off items on the system.

This is a multifaceted report. The first section displays the charged off loans by interest rate, sorted from low to high. This will include the annual interest rate, 365 daily factor, count, count percent of total, amount, amount of percent of total and average balance.

The second section is the charged off dollar analysis including multiple balance ranges, count, count percent of total, amount, amount percent of total and average balance. A breakdown of loans $10,000 and under, loans in excess of $10,000, loans $15,000 and under and loans in excess of $15,000 are subtotaled at the end of this section.

The third section is a summary of charged off accounts by suffix. This includes the suffix number, total accounts and total loan balance.

Charged Off Total Listing – This option will generate a listing of charged off loans by social security number.

This report will include the social security number reported, sequence number, member name, charge off date, charge off teller, charge off code, status (R=resolved), current amount and original amount. The count, current amount and original amount or total charge offs, active charge offs and resolved charge offs are listed at the end of the report.

Charged Off Transaction Listing – This option will generate a list of accounts that have had transactions on their account and it is flagged as Charged Off. This report will include account number, teller, transaction code, transaction date, effective date, transaction amount, receipt number, transaction description, loan type, purpose code, security code, branch code and member name.

Collection Code Listing – This option will generate a list of collection codes used. A specific account, date range or code can be entered. This report will include account number, suffix, member name, code, collection actions taken, amount delinquent and date occurred.

Collection Notes Listing – This option will generate a list of collection notes entered based on a date range. An account number range can also be entered. This report will include account number, note and changed date.

Collections Call Back Report – This option will generate a list of accounts with call back dates based upon the criteria selected. This report will include the account number, member name, gender, birth date, social security number, call back date, current balance, last transaction date, collection officer, due date and security code.

Delinquent Loan Analysis by Officer – This option will generate an analysis of delinquent loans by officer based on the minimum number of days delinquent entered. This report will include officer, loan count, percentage of count, original loan amount, percentage of amount, current loan amount, percentage of amount, delinquent count, percentage of count, delinquent loan balance and percentage of delinquent.

Delinquent Notices – This option is used to create delinquent notices. This option is commonly set up and run through Daily Procedures but it is available from the reports menu to run on demand, if needed.

Entry Code Report – This option gives the user the ability to print a list of accounts that have a specific entry code. This report includes account, suffix and current delinquent amount.

Loan Delinquency Report – This option allows the user to generate a delinquency report based upon the criteria defined. Note – There are many fields on the prompt screen making the report very lengthy.

Use End of Month Data – If Y is indicated, the report will look at the last end of month’s data. If N is indicated, the data as of the time the report is generated will be used.

          Minimum Days Delinquent – Indicates the minimum number of days a loan must be delinquent to be included in the report.

Report Type – This option indicates the type of output that will generate for the selected loans. Other than the differences described below, each option (except No Detail) will have the following fields. Account/suffix, next payment due date, either number of days, months or payments delinquent (based upon option selected above), loan type, delinquent amount, current balance, payment amount, security code, purpose code, payment frequency, payment method, last payment date and credit score.

                   Abbreviated = Member name and interest due.

                   Full = Partial payment, interest due and loan interest rate.

                   Aged = Member name, original balance and all three periods delinquent counts (days, months and payments).

                   No Detail = Summary page of totals of delinquency (counts and balances) for each category defined.

Periods in Days, Months or Payments – Other than the Aged report which includes all three periods,        which count should display on the Abbreviated or Full report?

                   Days = Number of days delinquent.

                   Months = Number of months delinquent.

                   Payments = Number of payments delinquent.

          Share Detail – Use this option to add additional information to the standard output that would appear on the type of report selected.

All = Adds one additional line for member name, home phone, and base share information. Also adds more additional lines for each share suffix (including balance) existing on the same account as the loan. Due to the additional lines, this report may be lengthy.

                   Single = Adds one additional line for member name, home phone and base share information.

                   No Shares = Adds no additional information in regards to shares.

Credit Score Source – Indicates if the credit score stored in the loan record or the credit score stored in the member record should be used for the report. The score in the loan record is often the score that was used when the loan was disbursed. The member score is often the most recent (newest) score received.

Display Interest Due/Original Balance – Indicates if the interest due or original balance should appear on the report. Only the Abbreviated and Full versions include this information

          Sort Order – Indicates the order the information will appear in each detail section of the report.

Delinquency Category in Days 1-6 – Up to six different categories may be defined using number of days delinquent. When a new category is reached, the previous category will break and total.

          Sort Code 1-3 – Up to three sort codes may be defined to indicate how detail information will be sorted.

          Branch Code – To generate a delinquency report for just one branch, enter the branch ID here.

Print Category Summary – Select whether a category summary should print. This is a one page report that will print at the end of the detail and include each category break, the delinquent count, current balance, delinquent amount, interest due and grand totals.

Print Loan Officer Summary – Select whether a loan officer summary should print at the end of the detail report. The summary will include loan officer, delinquent count, percentage of total delinquency the count represents, current loan balance, percentage of total current balances, delinquent amount, percentage of total delinquent amount, interest due and percentage of total interest due.

Print Periods Summary – Select whether a summary for each delinquent period should print (based upon period indicated in Period in Days/Months/Payments field above). For each period (such as delinquent), count, percentage of total count, current balance, percentage of total current balance, delinquent amount, percentage of total delinquent amount, interest due, and percentage of total interest due will be included.

Print Interest GL Summary – Select if a summary for each interest income GL should print. For each income GL, delinquent count, percentage of total delinquent count, current balance, percentage of total current balance, delinquent amount, percentage of total delinquent amount, interest due, and percentage of total interest due will be included.

Print Member Branch Summary – Select if delinquent loans by branch summary should print. Summary will include branch ID, delinquent count, current delinquent loan balance, current delinquent amount and total interest due.

Include/Exclude Types - Use this option to include or exclude loan types. Loan types to include or exclude may then be listed in the following Loan Types 1-10 fields.

          Loan Type 1-10 – Up to ten loan types may be included or excluded, based upon the condition defined in the previous field.

Effective Date Forward – This allows the report to be run ahead of the current date. Running the report with an effective forward date assumes that no payments will be made.

Base Share Selection – This is used in conjunction with the Share Detail option above. If Single or All is selected, this determines what suffix the report considers the base share to be. Typically, this would be suffix 001.

Loan Officer Report – This option will generate a list of number of loans by loan officer based on minimum days delinquent. The report will include loan officer, count, loan original balance, delinquent count, delinquent original balance, amount delinquent and percent.

Notes on Delinquent Loans – This option will generate a list of delinquent loans along with collection notes based upon the criteria entered. The report will include the account/suffix, member name, next payment due date, number of days delinquent, number of times delinquent 30, 60, 90 and 120 days and all collection notes attached to the loan. If selected in the prompt screen the address, home phone and work phone will also be included.

Overdrawn Shares Trial Balance – This report allows the user to generate a list of overdrawn shares based on selected criteria. The report will include account/suffix, share type, branch code, member name, number of days overdrawn, current balance, available balance, base share account balance, courtesy pay flag (Y/N), courtesy pay amount, last transaction date and total fees collected.

Schedule of Delinquent Loans – This option will generate a detailed list, sorted by loan type, number of delinquent loans and includes a partial line of the collection note. This report will be sorted by loan type, then alphabetical by last name with subtotals at the end of each type and category columns indicating the delinquent period (2-6 months, 6-12 months, and 12 months and over). The report will include type, account/suffix, member name, date of loan, original balance, current balance under the category column in which the loan is delinquent, last activity date and a partial line of the collection note, if applicable.

Today’s Payments to Delinquent Loans – This option will generate a list sorted by account of payments made to delinquent loans based on the minimum number of days delinquent entered. This report will include account/suffix, member name, previous due date, days delinquent, delinquent amount, payment amount, scheduled payment amount, next payment due date, payment frequency, current days delinquent, current loan balance and member phone number.

 

Confidentiality Notice: This document is published by Computer Marketing Corporation/FLEX and is intended solely for its contracted clients. It may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this document and any accompanying attached information by someone other than the intended recipient(s), or an employee or agent acting on behalf of the intended recipient, is strictly prohibited.