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

HELOC Module

HELOC Module Published: January 11, 2017 HELOC Module • Purchasable Module • Loan Group Code = H • Interest calculation is Average Daily Balance • Average daily balance o Interest is calculated on Average Daily Balance of current statement period and memoed to be collected at time of payment o Multiply interest rate by average period balance, divide result by number of days in period. o If HELOC is not an interest only payment, payment is calculated based on configuration of loan type. Interest due is still based on average daily balance of prior period. If interest due is greater than calculated payment, payment is increased to cover interest due. • Billing Cycle = Interest due, payment, statement generation • Can be interest only payment • Can use loan conversion program when draw period expires • Can be variable interest rate

Group Codes

Group codes are defined by the FLEX System and indicate a general designation used to group loans with common features. Group codes also dictate how functions of the system will impact loans.

Loans of type V, L and H will have credit limits so the system will not close the suffix during End of Month if balance is zero.

Group codes V and H also tell the system to use month-end billing cycles.

The valid group codes for a Home Equity are:

          H = Home Equity Line of Credit. Used for line of credit loans, normally secured by real property and have a period where the payment amount each month is interest due for the month. On the FLEX system, these loans have their own month-end billing process and statements.

          L = Line of Credit. Used for line of credit.

 

Home Equity LOC Payment Calculations

C = Calculate based on current calculated payoff. System calculates when loan will payoff using current loan variables including balance, interest rate and frequency. It will calculate a new payment amount based upon balance, new interest rate, frequency and calculated term.

          I = Interest only payment.

M = Calculate based on original maturity. System determines when loan would have originally matured and calculates payment so it will pay off at same time.

          O = Calculate based on original term of loan.

          P = Calculate based on percentage of balance. Not valid for balloon loans.

          Q = Calculate based on term table defined. Not valid for balloon loans.

R = Calculate based on remaining term of loan. System determines how many payment frequencies have passed since loan was opened (or since last advance date), subtract number from original term of loan to determine remaining term.

          T = Calculate based on payment table defined. Not valid for balloon loans.

 

HELOC (H) - Control Parameters

Control Parameters allow configuration for GL offsets, statement sequence, and End of Month Processing for H group loans.

 

 

GL Offsets & Fees – Enter general ledger account numbers applicable to Over Limit Fees and Cash Advance Fees.

 

Statement Processing

HELOC Statement Sequence Code – Identifies order HELOC statements will be printed.

          1 = According to setup order

          2 = By account and suffix

          3 = By zip code

          4 = By name (Last, First)

CASS Certification – Indicates if statements should be sorted into CASS/non-CASS certified addresses. If CASS is specified, non-CASS addresses are printed first.

HELOC Statement Printer – Indicates printer OUTQ statements will be spooled and held in.

HELOC Statement Message – Contains message that will appear on top portion of statement.

Account Number Mask – Provides for masking of account number on printed statement. Enter replace character X in positions of account number to be replaced when statement prints.

XML Exit Program – HE44212R– Image Printing, record length 256. Utilized for sending statements to third party for printing.

Load STMT Fee File – Indicates if statement fee file should be loaded.

 

HELOC Month End Processing

Last Statement Date – Displays the date the last EOM process was run and statements were produced.

Create Statement if No Activity – Indicates if a statement should be produced if the account has had no activity during the month.

Exclude Unpaid Int from Ave Dly Bal – Indicates whether or not to exclude unpaid interest from the average daily balance calculation.

Reset Partial Payments – Indicates if the partial payment should be reset.

Preload Partial Payments if Delinquent – Indicates if partial payments should preload, if delinquent.

Update Orig Balance at Conversion – Indicates if original balance on HELOC Loan should be updated to new balance at time of conversion if loan is subject to convert to another type, upon expiration of draw period.

Print Conversion Pre-Notice on Stmt – Indicates if pre-notice text configured for original loan type should print on statement if loan is subject to conversion. Text is setup on Conversion tab for original loan type in Type Configuration, Loan Types tab.

Print Conversion Notice on Stmt – Indicates if conversion notice text configured for original loan type should print on statement if loan is subject to conversion. Text is setup on Conversion tab for original loan type in Type Configuration, Loan Types tab.

Max Days Delq for EOM Charges – Displays number of days loan payment can be delinquent for End of Month charges to be made.

Prompt/Print New Rate on Statement – Indicates if new rate should print on all statements. This does not actually change loan rates.

Interest Only Payment – Indicates if payment amount equals interest due for prior month (based on average daily balance).

Add Last Ins Prem to Pmt (int only) - Indicates if last insurance premium posted should be added to payment amount on interest only HELOC loans. This is only applicable if payment is interest only and loan has CD/CL insurance added to loan.

 

Loan Type Configuration

 

 

Over Limit Grace Amount – Indicates fixed amount by which loan may exceed credit limit before over limit fees are assessed.

Over Limit Grace Percent – Indicates percentage by which loan may exceed credit limit before over limit fees are assessed.

Over Limit Fee Rate – Defines rate used to calculate over limit fee.

Over Limit Fee Minimum/Maximum – Defines minimum/maximum over limit fee to charge.

Advance Minimum/Maximum – Indicates minimum/maximum cash advance for loan type.

Monthly Advance Maximum – Indicates maximum monthly amount for advance.

Monthly Advance Count Maximum – Indicates maximum count of monthly advances.

Cash Advance Fee Rate – Indicates rate used to calculate cash advance fee.

Cash Advance Fee Minimum/Maximum – Indicates minimum/maximum cash advance fee.

Minimum Finance Charge – Indicates minimum finance charge to be charged to loan. If calculated finance charge is less than amount, amount will be charged to loan.

Minimum Balance for Finance Charge – Indicates minimum balance to receive finance charge. If balance of loan is lower than amount, loan will not be charged Finance charge.

Charge Over Limit Fee – Indicates if over limit fee will be charged.

Interest Only Payments – Indicates if payment is interest only. If unchecked, payment will be calculated based on configuration for loan type under Payment Recalculation tab. Interest due will still be based on average daily balance of billing cycle. If interest due is greater than calculated payment, payment is increased to cover interest due.

Minimum Principal Pmt Amt – Indicates minimum principal amount to be included in required payment.

Add Interest to Pmt – Indicates if payment is percentage of balance, should new interest be added on.

Use Original Balance – If payment is percentage of balance, should percentage be based on original balance as shown in loan file.

Print Principal/Interest Breakdown – Indicates if next payment breakdown is to be printed on statement.

 

HELOC Maintenance

HELOC Maintenance will list all HELOC loans on the system and allows changes for existing HELOC loans on the system.

 

 

HELOC EOM Worksheet and Posting

This procedure should be run before End of Day is started. The following functions will be performed:

  • Posting of over limit fees, if applicable
  • Calculation of average daily balance
  • Calculation of interest due/new payment amount
  • Printing of monthly statements
  • Conditional clearing of partial payments
  • Setting of ending statement balance and next statement history fields
  • Runs loan type conversion program

 

 

 

If statements need to be re-run, select Re-Run Statements from the HELOC menu. Enter the statement End of Month date and select Process.

 

 

 

Loan Type Conversion

 

Loans can be setup to convert from one loan type to another loan type after a given period using Loan Type Conversion. The reason why credit unions might want to convert loan types is because most HELOCs have an initial draw period and then a repayment period. This is the most efficient way to convert loan types. If the loan is changed from a variable rate to a fixed rate, loan maintenance will not show users who are in repayment. The conversion record can be configured to be required when the loan is disbursed, or can be setup and/or maintained in Loan Maintenance.

 

 

New Loan Type – Defines type of loan it will convert to on conversion date.

Conversion Date – Determines what date loan will convert to new loan type.

Notice Date – Indicates date notice will be sent regarding conversion.

New Term – Indicates new term of loan.

Recalculate Payment – Indicates if loan payment should be recalculated at time of conversion.

Reset Loan Open Date – Indicates if open date of loan should reset to conversion date or remain date of original disbursement.

Loan Type Conversions are run through the Loans menu in the FLEX Main Menu.

 

 

 

Loan Type – Indicates loan type(s) to convert. Individual loan types may be converted or select All to convert all loans with conversion record setup.

Effective Date – Enter effective date of conversion. This will look at open date of original loan calculated along with Months Until Conversion Date number.

Update Files – Check Yes to update files or No to run a worksheet. FLEX recommends running worksheet prior to updating files.

Run Type – Indicates whether to Print Notices or Convert Loan Types. Print notices will generate the pre-notices or disclosures. Convert Loan Types will show which loans are going to convert using effective date.

 

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.