Member Trial Balance Selection (4)

Screen ID:

Screen Title:

Panel Number:

Report Name:

LMBRTS-04

Member Trial Balance Selection

4619

LMBRT

$images\3495g_shg.gif$

Click here to magnify

In many cases, these criteria will not work unless you choose an appropriate Application type setting on the General Account Criteria selection screen. (See below for specific instances where this is true.) Also, depending on the types of accounts you have already selected on previous screens, some of these parameters will not even apply. (For example, if including only members with checking accounts, the Maturity Date setting is irrelevant.)

Field Descriptions

Field Name	Description
Account Balance Selection For these fields, specify both a low and high amount to include only members whose balances fall within those ranges.
Current balance	To include members with a certain balance range, from the current balance field (CURBAL) on the MEMBERx account record. If an Application type was selected on the General Account Criteria screen, or if you also selected a dividend application, CD type or loan category on the Sub-Account Criteria screen, the program will only look at the balances of those accounts. If those criteria are not used, the program will look at balances for all MEMBERx accounts.
Uncollected balance	To include members with a certain amount in the Uncollected field (UNCOLL) on the MEMBERx account record (savings and checking accounts only). IMPORTANT: In order for this to work properly, an Application Type of IR, SH or SD must be entered on the General Account Criteria selection screen.
Secured balance	To include members with a certain amount in the Secured field (SECBAL) on the MEMBERx account record (savings and checking accounts only). This contains both Misc. Secured Shares and shares pledged toward a loan. IMPORTANT: In order for this to work properly, an Application Type of SH, SD, CD, IR, or TX must be entered on the General Account Criteria selection screen.
Minimum balance	To include members with a certain amount in the Minimum balance for dividend period field (MINBAL) on the MEMBERx account record. IMPORTANT: In order for this to work properly, an Application Type of SH, SD, IR, or TX must be entered on the General Account Criteria selection screen.
Year-to-date dividends	To include members that were paid a certain amount of dividends on share accounts during the current year. This looks at a total of the four quarterly dividends paid fields (DIV1, DIV2, DIV3 and DIV4) on the MEMBERx record. IMPORTANT: In order for this to work properly, an Application Type of SH, SD, CD, IR, or TX must be entered on the General Account Criteria selection screen.
Year-to-date interest	To include members where YTD interest paid on loans falls within this range. This looks at the YTD Interest (ANNINT) field on the MEMBERx record. IMPORTANT: In order for this to work properly, an Application Type of LN or OC must be entered on the General Account Criteria selection screen.
Date Selection For these fields, specify both a low and high date to include only members whose accounts fall within those date ranges.
Year of birth	To include only members born during certain years, based on the Birth year field (BRTHYR) on the MASTER record. CU*TIP: In most cases you should use either birth year or birth month, but not both. For example, if you enter a year range of 1930 to 1932, and a month range of 12 to 12, you will get all members born between December 1, 1930 and December 31, 1932. (Not just members born during December in the years 1930, 1931, and 1932.) NOTE: This field only looks at the last two digits of the birth year. If you are including year near to the current year, it is possible that members over 100 years might appear on your data results.
Month of birth	To include only members born during a certain month. For example, if you want to include all members born in January, enter 01 in both the Low and High fields. CU*TIP: In most cases you should use either birth year or birth month, but not both. For example, if you enter a year range of 1930 to 1932, and a month range of 12 to 12, you will get all members born between December 1, 1930 and December 31, 1932. (Not just members born during December in the years 1930, 1931, and 1932.)
Date account opened	To include only members with an account opened during a certain date range (looks at the date on the MEMBERx record). This should generally be used in conjunction with a selection on the previous screen to define a dividend application, certificate type, or loan category. Otherwise the system will include the member if any of his or her accounts were opened within this period.
Maturity date	To include only members with a loan or certificate. That has a maturity date within a certain date range. IMPORTANT: In order for this to work properly, an Application Type of CD, LN, or OC must be entered on the General Account Criteria selection screen.
Last transaction date	To include only members with any account that shows a last transaction date within a certain date range (looks at the date on the MEMBERx record). This should generally be used in conjunction with a selection on the previous screen to define a dividend application, certificate type, or loan category. Otherwise the system will include the member if any of his or her accounts with last transaction dates within this period.
Date of death	To include any members with a date of death within a certain date range. Credit unions can use this to review deceased members’ accounts monthly for ACH activity and for other communication purposes.