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...

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...

Yes, CU*BASE has Employee Security features that let you monitor access to CU*BASE programs by any employee ID, whether CU*Answers or credit union employee. Every time a CU*BASE program is accessed, the system records who accessed the command and when. For CU*Answers employees, the file records the individual ID for the staff member (not the alias) so you will be able to tell who from CU*Answers was doing the work. This file (file name SECAUD) was designed to let you see what commands an emplo  More...

This is because the print session is not pointing to the correct folder location. It shoudl be pointing to the \..\PrePrint folder for eLoans and other forms, and to the \..\ToPrint folder for eReceipts. Contact a CSO team member for assistance at 800.327.3478 x266.

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.

The most likely reason is that the member did not have any activity for the month that would trigger a statement, based on the CU's configuration. Most credit unions have their statement configuration set up to print a monthly statement only if the member has a checking account, and only if there is activity on that account, saving postage costs on months when there is no activity. You can verify this by viewing his Share Draft Transaction Inquiry in Phone Operator, then compare that to yo  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...

When a device first connects to the iSeries, a virtual device is created - consider it a placeholder for that workstation or printer. Only one device can exist for each ID, which is why only one person can sign into a printer at a time. Throughout the virtual devices lifecycle, there are several different statuses that device can be in. Read below for some details! Workstations VARY ON PENDING - this is the default status of the virtual device. This status means the device is ready and wai  More...

This is how to check your current network settings. The procedure varies depending on your computer's Operating System: For Windows 2000 or XP Right -click on the Start button and select Explore . Scroll to the bottom of the left hand pane, then right -click on My Network Places and select Properties . A new window will pop up and you should see Local Area Connection in the window. Right -click that connection and, again, select Properties . A separate window should pop up and you shoul  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...

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.

There are several ways to obtain this data. To see the total number of active online banking members, use Tool #856 Tiered Svcs Monthly Comparison to display active user counts for any monthly period. (HINT: Click the Goal 4 button to display this data.) This can be done even if your credit union does not use Tiered Services for any other purpose. To print a report of usage statistics, use Tool #141 ARU/Online Banking Stats Dashboard To see online banking usage stats for a particular m  More...

The differences ultimately come down to control and cost. The online ASP system is the fastest, simplest, most inexpensive way to get started with an e-documents strategy for your credit union. With online ASP you offload the back-end service management headaches to CU*Answers. We manage, backup, secure, and patch/upgrade the eDOC servers and databases and these processes fall under our SAS 70 and third party security audits. The online ASP system consists of electronic storage of receipts, loan  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...

Yes, the Statement Mail Groups feature lets you configure up to 9 codes that can be attached to a member's account. The codes specify whether statements should be printed and archived (the standard method) or just archived only. This is used in situations such as for members with written-off loans or bankruptcy situations where the member shouldn't receive a statement, or even if you want to avoid printing statements for your own staff. Archived statements are available through CU*SPY  More...

In a nutshell, you will set up a Membership Designation Code for Representative Payee, with the label for primary name set to Beneficiary and the label for the joint owner name set to Rep Payee. Then the procedure is to open the membership in the beneficiary's name and SSN, then put the representative payee's SSN as the joint owner (type J secondary name link). TIPS: Remember that in CU*BASE the words joint owner simply are used to describe a particular record type in the Se  More...