In-House Credit Cards- EOM Processing
In-House Credit Cards - EOM Processing Credit Card Control Parameters Credit Card Control Parameters controls the billing cycle and statement settings. Control Parameters can be found under Cards, Credit Cards and Credit Card Configuration in the FLEX Main Menu.
Credit Unions have the ability to maintain custom messages that can be added to statements. These messages are credit union defined and can be used for promotions, delinquency messages, messages pertaining to a certain loan type, etc.
Users should maintain these messages prior to running the Credit Card Billing Cycle to ensure that the proper messages are included on the statements.
Default Messages Tab
Enter up to 6 lines for Delinquency Messages, Grace Messages and/or No Grace Messages.
Type Messages Tab
To create a message by type, click Add to add a new type or highlight and click Edit or Delete to edit or delete an existing type.
Enter up to 6 lines for a statement message for the type selected.
Secondary Statements Tab
If used, this is for additional statement runs.
Notices
All current notices will list by default. Highlight and click Edit to edit an existing notice.
Customizable heading and message boxes will be displayed. The system will use a default notice heading and message if the credit union does not want to customize these notices.
Users should maintain these notices prior to running the Credit Card Billing Cycle to ensure that the proper notices are included on the statements.
Images
This option gives the credit union the ability to specify if image files will be appended to PDF documents.
Configuration
Billing Cycle Options
Last Billing Date – Displays date last billing cycle was processed.
Maximum Days Delinquent for Processing/Statements – Displays maximum number of days loan may be delinquent and still incur fees during billing cycle or generate a statement.
Discontinue Over Limit Fee After XX consecutive months without new debits – Indicates maximum number of consecutive months in which over limit fee will be collected for member without new advances occurring.
Regulation Z Section 226.56 - Indicates over limit fee may be imposed only once during billing cycle in which consumer’s credit limit is actually exceeded and only once in each of two subsequent billing cycles, unless consumer has obtained additional extensions of credit in excess of credit card account limit.
Minimum Days Loan Open Before Variable – Indicates number of days credit card loan must be open before variable rate loan adjustment will occur.
Purchase Return End of Period Crossover Days – Indicates number of days after end of period in which purchase returns will be considered to have occurred before end of period. If return transaction is considered to have occurred within crossover period, payments required to avoid finance charge will be reduced by amount of return.
Maximum Fees Charged in First Year – Indicates maximum portion of credit limit for which fees can be charged to credit card loan in first year of being opened. Any fees in excess of amount will be refunded during billing cycle that follows fee posting.
Refund GL - Indicates refund general ledger account for Maximum Fees Charged in First Year, if applicable.
Consider Account Holder Bankruptcy Setting – Indicates whether or not to consider if account is marked bankrupt. If checked, this causes billing cycle to treat account holder’s credit card loans as bankrupt, even if individual loans are not flagged. If unchecked, system will only treat loans as bankrupt if they are flagged.
Exclude Unpaid Interest From Average Balance – Indicates whether or not unpaid interest will be included in average balance calculation during billing cycle.
Post Late Fees During Billing Cycle – Indicates whether or not late fees are collected during end of period billing cycle.
Y = Late fees are collected during billing cycle.
N = Late fees are not collected during billing cycle but are collected when credit union manually posts them using batch fee posting method to coincide with late fee grace period.
Grace by Entire Loan – Indicates whether or not grace period defined in a category has an affect for specific category or entire loan.
If checked, grace period is defined for entire loan. If any category has not paid required balance within grace period, all categories will be charged interest regardless of whether or not within grace period.
If unchecked, grace period is not defined for entire loan. Each category is independent and some interest may be collected for categories not in grace period while some may be free from interest within grace period.
Over Limit Fee is Over Limit any time in Cycle – Indicates if over limit fee is collected if balance exceeds credit limit in billing cycle or only if over limit at credit card end of month.
Include Inactive Accounts in Cycle – Indicates if accounts with no activity and zero balance will still receive statement during billing cycle.
Credit Card Loan Entry Options
CD Suffix Class– Indicates which type of card record will be created when using Credit Card Loan Setup under Credit Card Loans. These options will be configured by FLEX
Forms Prompt– Indicates whether a prompt to print forms will be displayed following the creation of a credit card.
General Ledger Accounts
Over Limit Fee – Displays general ledger account over limit fees will be posted to.
Cash Advance Fee – Displays general ledger account cash advance fees will be posted to.
Statement Printing Options
CASS Certification – Indicates whether or not the statements will be pre-sorted into CASS certified and non-certified groups prior to the main sort. This should only be used in conjunction with Postal Service CASS programs. The CASS program is a purchasable module.
Print Mail Code – Indicates whether or not the credit union defined mail codes will print on the credit card statements.
Export Statements to DocMan – Indicates if a copy of statements are generated in Document Manager.
Export Statements to eMail – Indicates if an email is triggered for loans where the accounts are set-up to receive eStatements.
Include Bad Address Members – Indicates if a statement is generated for loans where the statement address is flagged as a bad address.
Prevent Barcode From Printing – When printing the form overlay, a ZIP code barcode can be printed. This indicates whether or not to print the barcode.
Print Form Overlay – Indicates whether or not statement form information is included on the statements. Typically this is checked if statements are generated by FLEX. If a third party is printing credit union statements, usually this is not used.
Print VISA Logo – Indicates whether or not the VISA logo is printed on the statement. Do not include the VISA logo if not printing the form overlay.
Print Tran Highlighting Lines – When printing the form overlay, transaction highlighting lines can be printed.
Statement Sequence Code – Indicates the order in which the credit card statements will be printed.
Due Date Print Code – Indicates how the payment due date will print on the statement when a loan is delinquent. For all delinquent loans, the first link in the transaction description section of the statement will contain the words ‘**THIS LOAN IS $XXX.XX DELINQUENT**’.
X/Y Offsets Logo 1 – Indicates the position of the VISA logo 1. Logo 1 by default prints below and the left of the member’s name. To adjust the position of the logo on the statement, toward the right, increase this number. To adjust to the left, decrease the number. This offset indicates how many points from the default position the logo will print. One inch equals approximately 300 points.
X/Y Offsets Logo 2 – Indicates the position of the VISA logo 2. Logo 2 by default prints above and to the right of the member’s name. To adjust the position of the logo on the statement, toward the right, increase this number. To adjust to the left, decrease the number. This offset indicates how many points from the default position the logo will print. One inch equals approximately 300 points.
Detach Message X/Y Positions – When printing the form overlay, text ‘Detach Top Portion and Return With Your Payment’ will print. To change the position on the page horizontally, enter a number between 1 and 1700. The recommended position is 190. If both the X and Y positions are set to 0, the ‘Detach’ message will not print. The higher the number, the farther to the right of the page this line will print. This option only applies if the form overlay is printed.
Account Number Mask – Provides for masking of the account number printed on the statement. Enter a replacement character, e.g. X, in the positions of the account number that are to be replaced when the statement prints.
XML Exit Program – This option is for FLEX use only.
Include Card Numbers on Statement – Up to ten card numbers associated with the loan suffix can be included on the statement, if checked. These will be non-expired cards listed in open date order.
Card Number Mask – Provides for masking of the card number on the printed statement. Enter a replacement character, e.g. X, in the positions of the account number that are to be replaced when the statement prints. Use the ~ character to replace a position with a blank.
Activate Corporate Grouping – Indicates whether or not corporate grouping of statements are to be processed along with the regular members’ credit card statements.
Print DFI Warning Message – Indicates whether or not the mandated DFI (Department of Financial Institutions) warning message is to be printed on the members’ credit card statements. The DFI Consumer Services Offices facilitates communication between consumers and the various financial institutions that DFI regulates to assist in the dispute resolution process.
Print & (Ampersand) Character By Name – Indicates whether or not the ampersand character (&) is printed to the left of the member’s names on the statements. Some statement printers require the character for printing purposes.
Print Tax Name – Indicates whether or not the tax name of the account, if any, will print on the statements.
Print Joint Owner Name – Indicates whether or not the name of the first joint owner attached to the account will print on the statements. If checked, it will print immediately below the members’ name.
Adjust Payment Description – Indicates whether or not payments will show on member statements as ‘Payment-Thank You’ rather than as the default description. This will not affect transactions where the description differs from the default description. The default descriptions are : LOAN PAYMENT, PAYMENT—NO INT AND LOAN CREDIT. If a teller enters a transaction and modifies the description, the modified description will show on the statement.
Over Limit Fee Opted In Notice – A notice of a consumer’s affirmative consent for an over limit fee may be included on the credit card statement. This indicates if the notice will print on the first credit card statement printed after a loan’s over limit fee code is changed to a ‘Y’.
Payment Disclosure Boxes – Indicates if lined boxes will be generated around the payment disclosure on the credit card statement.
Charge-Offs Receive Statement – Indicates whether or not a statement is generated for credit card loans that are charged off.
Export Statements to DocMan – Indicates if copy of statements are generated in Document Manager.
Export Statements to eMail – Indicates if an email is triggered for loans where the accounts are set-up to receive eStatements.
Include Bad Address Members – Indicates if a statement is generated for loans where the statement address is flagged as a bad address.
Prevent Barcode From Printing – When printing the form overlay, a ZIP code barcode can be printed. This indicates whether or not to print the barcode.
Print Form Overlay – Indicates whether or not statement form information is included on the statements. Typically this is checked if statements are generated by FLEX. If a third party is printing credit union statements, usually this is not used.
Print VISA Logo – Indicates whether or not the VISA logo is printed on the statement. Do not include the VISA logo if not printing the form overlay.
Print Tran Highlighting Lines – When printing the form overlay, transaction highlighting lines can be printed.
Statement Sequence Code – Indicates the order in which the credit card statements will be printed.
Due Date Print Code – Indicates how the payment due date will print on the statement when a loan is delinquent. For all delinquent loans, the first link in the transaction description section of the statement will contain the words ‘**THIS LOAN IS $XXX.XX DELINQUENT**’.
X/Y Offsets Logo 1 – Indicates the position of the VISA logo 1. Logo 1 by default prints below and the left of the member’s name. To adjust the position of the logo on the statement, toward the right, increase this number. To adjust to the left, decrease the number. This offset indicates how many points from the default position the logo will print. One inch equals approximately 300 points.
X/Y Offsets Logo 2 – Indicates the position of the VISA logo 2. Logo 2 by default prints above and to the right of the member’s name. To adjust the position of the logo on the statement, toward the right, increase this number. To adjust to the left, decrease the number. This offset indicates how many points from the default position the logo will print. One inch equals approximately 300 points.
Detach Message X/Y Positions – When printing the form overlay, text ‘Detach Top Portion and Return With Your Payment’ will print. To change the position on the page horizontally, enter a number between 1 and 1700. The recommended position is 190. If both the X and Y positions are set to 0, the ‘Detach’ message will not print. The higher the number, the farther to the right of the page this line will print. This option only applies if the form overlay is printed.
Account Number Mask – Provides for masking of the account number printed on the statement. Enter a replacement character, e.g. X, in the positions of the account number that are to be replaced when the statement prints.
XML Exit Program – This option is for FLEX use only.
Include Card Numbers on Statement – Up to ten card numbers associated with the loan suffix can be included on the statement, if checked. These will be non-expired cards listed in open date order.
Card Number Mask – Provides for masking of the card number on the printed statement. Enter a replacement character, e.g. X, in the positions of the account number that are to be replaced when the statement prints. Use the ~ character to replace a position with a blank.
Credit Card Billing Cycle
The Credit Card Billing Cycle must be run monthly prior to running End of Day and after all credit card transactions have been completed. The Credit Card Billing Cycle posts fees, interest and creates statement files, etc.
Statement Period
From/To Date– Enter the date range for the billing cycle (statement period).
The To Date can be set in the future or in the past. However, there are issues that need to be taken into consideration prior to back dating or forward dating the billing cycle.
Back dating the billing cycle can only be done if there have NOT been transactions posted to any credit card loans between the current date and the date for which the user is back dating the billing cycle.
Example: The billing cycle for October can be run on November 1st and back dated to October 31st only if no transactions (FLEXTeller and Audio Response transactions included) have posted to a member’s credit card loan since October 31st. The screen will warn the user if there are transactions that have occurred.
FLEX does NOT recommend forward dating the billing cycle. When forward dating the billing cycle, the transactions that have or will occur between the current date and the date to which the cycle is forward dated, will not be calculated in the billing cycle until the next cycle is run.
Example: When running the billing cycle on October 30th and forward dating the cycle to October 31st. Any transaction that posted to the member’s credit card loan on October 30th or 31st will not be part of the October billing cycle. They will be included in the November billing cycle and will be considered effective November 1st. This will affect interest calculations.
Update Files
N= Generates worksheets to review. FLEX recommends running a worksheet first. Running worksheets allows the user to catch any errors before actual statements are generated.
Y= This will actually run the Credit Card Billing Cycle, post fees and interest to member accounts and generate statements. Once the billing cycle has been posted, it cannot be reversed or re-run.
Credit Card Billing Cycle performs the following functions:
- Annual Fee Posting
- Over Limit Fee Posting
- Calculation of MTD Loan Activity
- Finance Charge (interest) Posting
- Calculation of Minimum Required Payment
- Loan Due Date Advance (non-delinquent loans)
- Statement Printing
Once the Billing Cycle has started, a task bar will appear that shows the percent of progress completed.
Reports
The worksheet generates the following reports:
- Fee Detail Worksheet
- Fee Summary Worksheet
- Late Fee Detail Worksheet
- Category Expiration Worksheet
- Month to Date Average Daily Balance Worksheet
- Negative Categories Worksheet
- Credit Card Statements Worksheet
The statements will also generate during a worksheet version showing CARDSTMTW. This allows the credit union to verify the statement messages. These are not valid statements and should not be printed.
The posting generates the following reports:
- Fee Detail
- Fee Summary
- Late Fee Detail
- Category Expiration
- Month to Date Average Daily Balance
- Negative Categories
- Credit Card Statements
If there are any errors, a message will display ‘Processing will be cancelled. Loans exist that have balances that do not equal the category balances. Please view the generated reports’.
Two reports will generate, CC5002P– Unbalanced Credit Card Loans and CC5003P– Unallocated Credit Card Loans. Any accounts that show on either of these reports MUST be corrected before the cycle can be run. Please review them and contact FLEX Loan Support for assistance with these corrections. These reports can also be run manually prior to running the billing cycle for verification.
There may be a message stating, ‘There are loans that exist with a negative balance’. This is just a warning message; it will also produce a report of these accounts. This report should be reviewed. However, no action is required in order for the cycle to run. If credit union procedure dictates, the negative (credit) amounts can be advanced into another suffix on the member’s account.
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.