Our billing includes Active Memberships (as opposed to Closed Memberships) excluding those with Written Off Loans. Use the Membership Analysis Report (Tool # 520). When choosing your selections, be sure to use the previous month in the Date to Process field, Select Active in the Accounts to Include field and select Report written off loans separately in the Report Option field. This total will match the Active Memberships total on your invoice.

The differences between the Loan/Share Trial Balance Review and the Loan Risk Analysis Report are: The Loan/Share Trial Balance Review is pulled with beginning of day totals, does not include loan category 99, but does include loans with a risk score of 0. The Risk Score Analysis Report is pulled from end of day totals, does not include loan category 99 (if excluded in the response options), and does not include loans with a risk score of 0.

The two reports are using different criteria to determine loan delinquency: Loan Delinquency Analysis With the 13.0 release in the spring of 2013, the Loan Delinquency Analysis Report (Tool #461) was changed to report loan delinquency in days instead of months per updated NCUA requirements (see below*). The current processing date is compared to the next payment date to determine the actual number of days delinquent. This is most commonly used report for obtaining delinquency information for  More...

The report you are looking for is in CU*Spy or on your inhouse eDOC server and is called PESCAB “Escrow Analysis Accounts Processed for…”. It is a daily report, so you can search for the date of your most recent escrow analysis changes. There is also an associated report with exceptions that will pull up.

When the report is pulled from month-end totals the count is different when you query the MEMBER6 file due to review dates. If the review date of the loan has been reached the report will ignore the loan total due to the member no longer being able to draw on the available funds. This is controlled at the loan category definition level with the Use review date for disbursements flag being checked.

This is updated every time the Query is saved. Hint: If you access a Query to view the results, then exit without saving, the Change Date will remain the same but the Last Used date will show today’s date.

This is updated every time you print a Query report to a printer. It is updated when you use F5-View to see the results of the Query on your screen, or run the Query to “Display.” For Queries that output to a database file, this date is NOT updated if you use the “Run” or “Run in Batch/Job Queue” feature to generate a file only. Also, this date is cleared altogether whenever we install a new System i (for example, for online CU*Answers clients this occurre  More...

To avoid any payments changing incorrectly due to the error, you can re-run a final escrow analysis for all accounts again as long as it is done the same day. For this second run, do it for 12+ months out. That way, the analysis will overwrite the prior run from today, and not schedule any payment changes for a long time. When you run the escrow analysis next year on your regularly scheduled date, the system will overwrite the data from today’s final run.

For this use Tool #218 Closed Membership Report . This provides a listing of each of the memberships that were closed, along with the specific closed account reason code for each. If you do not want to print a report, but would like to use the information, you can select to Export To File, choose Account Detail for Query, and then you can download the resulting file onto your PC and into an Excel spreadsheet using Tool #1375 Data Transfers (Upload or Download) . NOTE: This report pulls the   More...

There are a couple of things a credit union CEO should do with the Money Movement Analysis tool (Tool #536) in CU*BASE: Comparing to last month: The tool is designed to use last month's ending balance to compare to the current date. So one way to use this each and every month is to regularly compare the balance during, say, the third week of each month and see what accounts have had wide swings either up or down, and then act accordingly on a regular basis. For example: On July 20, compare  More...

IMPORTANT NOTE: When It’s Me 247 was updated in 2021, the “See” option shown on here was made unavailable. There are two major points to consider when thinking about allowing members to see information beyond the account to which they are actually logged in. Both extend beyond online banking to consider a financial institution’s role and responsibility in protecting member private data via all access channels, from the teller line to a back office employee answering   More...

There are two methods used to track delinquent loans for reporting purposes in CU*BASE: Method One (for Collections tracking) We have always tracked delinquency in two separate fields for “Months” and ‘Days” in the member files. When a loan is 30 days delinquent, it shows as “0 Months, 30 Days” delinquent. When a loan is 31 days delinquent, it is “1 Month, 0 Days” delinquent. A month is always considered 30 days regardless of the actual number o  More...

The Secondary Names (SECNAMES) file stores instructions that link a membership account to another member or non-member record. The file stores links to joint owner names and beneficiary names for all non-IRA account types. (IRA beneficiaries are stored in a completely different file because they are linked to an IRA Plan Type, not specific individual sub-accounts.) The file also stores a third type referred to as miscellaneous owner which can be used for any purpose you wish. The most co  More...

If a member cannot view their check, the research team needs the following information: Credit Union Questions What is your credit union name? Have multiple members reported that they cannot view checks? Are these members having the same experience when viewing their check? (See Member Questions. ) Has the check appeared on the Check Exceptions Report? (TNDET) Was this check cleared at the teller line? (Sometimes this is referred to as a counter-killed check.) Are you able to retrieve a chec  More...

Refer to the Escrow Processing with CU*BASE booklet for more information on the escrow analysis. Also schedule virtual or on-site Mortgage training for more details. See link below to access the CU*Answers store to request a training.

Here are seven things to review if you are trying to research why a loan did not report to the credit bureau. Look to see if the loan is flagged not to report to the credit bureau: Access Tool #20 Update Account Information (shortcut: acct) for the account and click the Credit Reporting Info button. The Report to credit bureau flag must be checked. Look at the Credit Report History located in Loan Account Inquiry via the Delinquency window (F23 or click the lookup button next to the Deli  More...

In general, we try to ensure that we log things that directly affect (a) what a member sees/can do or (b) how the system processes something. So for example, a config that alters rates or dividend servicing settings, or that changes a member’s permissions or their personal info, that sort of thing, would definitely be written to a log. However, while many of our configurations do log to file maintenance, there are some configs that are simply informational-only codes, with free-form te  More...

The process can vary a bit according to the vendor, but here's a discussion about how it works for credit unions on the CO-OP network, as an example. In most cases, debit card authorizations create a Misc. Secured Shares record on the member's account to hold the funds. When the actual transaction comes in, this record is automatically deleted. (There are exceptions to this rule, such as gas purchases.) A little history: In the past, debit card authorizations would add a hold to an ind  More...

If you pull credit reports using the CU*BASE online credit bureau access system, credit report data is stored online and can therefore be mined for opportunities. There are a couple of ways you can find this information: Use Tool #976 Where Your Members Borrow This tool pulls trade line data from stored credit report files, showing other financial institutions with whom your members do business. This tool lets you make a direct comparison between your credit union and a competitive FI. F  More...

Prior to the 16.10 release, the SSA began using multiple Company IDs, and it was recommended that credit unions consider using Automated Funds Transfers (AFTs) to handle distributions. Beginning the 16.10 release a new cross-reference system will be implemented that will automatically funnel all incoming company IDs from the Social Security Administration and treat them as if they came from one, consistent company ID we’re referring to as the “Primary ID.” With the changes ma  More...

To analyze Member Trackers, simply run a report in Tool #664 Print Member Trackers . When configuring Tracker Type ( Tool #277 Configure Tracker Types ) and Memo Type ( Tool #260 Configure Memo Type Codes for Trackers ), you created specific codes that track these types of records. Tool #664 allows you to generate a report based on multiple search criteria, including Tracker Type and Memo Type, as well as date range, and Employee ID. Additional options are available to analyze Sales Trackers via  More...

Prior to the 16.10 release, the SSA began using multiple Company IDs, and it was recommended that credit unions consider using Automated Funds Transfers (AFTs) to handle distributions. Beginning with the 16.10 release a new cross-reference system will be implemented that will automatically funnel all incoming company IDs from the Social Security Administration and treat them as if they came from one, consistent company ID we’re referring to as the “Primary ID.” With the chang  More...

ABC Credit Union is trying to reconcile the number of suppressed statements on the Statement Reconcilation Analysis (dashboard). To do this, they need to add the number of statements that were not mailed, either because they were set to archive (see below) or because they had the wrong address flag checked. (Removing duplicate entries in both groups is also necessary.) In addition, they need to consider accounts that were closed in the statement period. Here is the math to reconcile the Le  More...

Using CU*BASE to Comply with New Rules for Tracking Beneficial Ownership FinCEN has issued new rules under the Bank Secrecy Act that require financial institutions to identify and verify the identity of the beneficial owners of all legal entity members (corporations, etc.). Under the final rule, credit unions are required to have written procedures to identify and verify beneficial owners of legal entity members who open new accounts on or after May 11, 2018. In addition to identifying and coll  More...

This report uses the field called Disbursed Amount in the MEMBER5 or MEMBER6 data file. This is an accurate representative total of the amount that was added to your loan portfolio. Other reports, such as the Contingent Liability Analysis Report (Tool #280), use the Disbursement Limit to derive the amount of contingency balance by subtracting the current balance from the disbursement limit.