Membership Analysis Report

Screen ID: 

Screen Title: 

Panel Number:

Report Name:

MSRECAP-01

Membership Analysis Report

5114

MSRECAP10


Click here to magnify

 

Access this screen by selecting Tool #520: Membership Analysis Report.

How does your credit union track membership counts? Is it by primary share type? Is it by SSN or TIN counts? How many memberships do you actually have per SSN or TIN? What valuable statistics are you missing because collecting and calculating the information is just too tough?

With the CU*BASE Membership Analysis Report, you can get a consistent and reliable count on the key statistics you need for your board packet, regulator reports, and management decision benchmarks. From a breakdown on individual versus organization memberships to an analysis of membership ages, this report gives you the details you need at the touch of a button.

Whether you run it once for an analysis of all types of memberships, or monthly to see the members who joined or left the credit union during the month, this report is key for your next meeting.

You may choose to include only Active memberships, New memberships that were added during the month selected, or memberships that were Closed during the month selected. Leave this field blank to include all memberships.

The complete report (see the sample below) will consist of 3 pages for each corporation: one for all Active memberships (including any new memberships opened within the month selected), one for just New memberships, and one for Closed memberships..

Membership Analysis Report and the Membership Summary Comparison: Intertwined Tools

For an online, graphical inquiry showing this same data, with a side-by-side comparison of two different periods, use the Membership Analysis Inquiry feature (Tool #525 Membership Summary Comparison). Note that the configurations most recently used in this tool (Tool #520) will also be applied to the Membership Summary Comparison tool (Tool #525). Be sure to verify your configurations before making comparisons between the report and the summary comparison.

Understanding This Report

This Knowledge Base item describes the methods of compiling the data displayed on this report, and how to support comparisons between the configurations of this report: We ran the membership analysis report out of Tool #520 Membership Analysis Report, and the totals were off when comparing different months to our known net change. What could cause this?

Field Descriptions

Field Name

Description

Corporate ID

Use this to include memberships from a single corporation; enter 00 to include all corporations.

Month/Year to Process

Enter the month and year for which data should be shown.  Normally three previous months are available.  To run a report using month-end data prior to the months held online, contact a Client Services Representative.  (There is a charge if this service is requested.)

Accounts to include

Use this optional field if you wish to see only select memberships on the report; leave the field blank to include all members.

Active (A) -Results include all memberships from the MASTER file for the selected report month.

New (N) - Results only consider memberships with an open date (DTOPN) from EMSmmyy (MASTER) in the selected report month.

Closed (C) - Results only consider memberships with a closed date (CLOSDT) from EAHmmyy (MSHIST) in the selected report month.

Report option

Select whether to include written off loans in the totals or separately.

Select from:

  • Report written off loans separately (Results do not consider written-off status.)

  • Include written off loans in totals (Results do include loans in written-off status.)

Data Sources:

Library location for all end-of-month files is FILExxE. xx = your credit union ID. mmyy = month, year.

EMSmmyy = MASTER end-of-month copy, mmyy = month, year

EAHmmyy = MSHIST end-of-month copy, mmyy = month, year

EMBmmyy1-6 = MEMBER1-6 end-of-month copies, mmyy = month, year

EAHmmyy1-6 = ACHIST1-6 end-of-month copies, mmyy = month, year

ELNOmmyy = LNWRTOFF end-of-month copy, mmyy = month, year

Report Sample

images\959rpt1_shg.gif

images\959rpt2_shg.gif

Under Age Breakdown in Report

ACTIVE MEMBERSHIPS

TOTAL MEMBERSHIP ANALYSIS (000 SHARE ACCOUNTS)

Report Line

Description

Organizational Accounts

Number of memberships coded as Organizational. Excludes any which hold at least one active (still open) written-off loan.

Account Bases from EMSmmyy where MASTYP equals ‘MI’. Remove any records where the same Account Base is found with WOSTATUS equals ‘A’ in ELNOmmyy.

Total Memberships/000 Accounts

Count of all 000 accounts held by members. Excludes any where the same membership has at least one active (still open) written-off loan.

EMBmmyy1 where ACTTYP equals 000. Remove any records where the same Account Base is found with WOSTATUS equals ‘A’ in ELNOmmyy.

Positive Balance Memberships

Count of only 000 accounts which have a current balance greater than $0.00. Excludes any where the same membership has at least one active (still open) written-off loan. Balances of any non-000 sub-accounts on the same membership are not considered.

EMBmmyy1 where ACTTYP equals 000 and CURBAL is greater than 0.00. Remove any records where the same Account Base is found with WOSTATUS equals ‘A’ in ELNOmmyy.

Negative Balance Memberships

Count of only 000 accounts which have a current balance less than $0.00. Excludes any where the same membership has at least one active (still open) written-off loan. Balances of any non-000 sub-accounts on the same membership are not considered.

EMBmmyy1 where ACTTYP equals 000 and CURBAL is less than 0.00. Remove any records where the same Account Base is found with WOSTATUS equals ‘A’ in ELNOmmyy.

Zero Balance Memberships

Number of 000 accounts which have a current balance of $0.00. Excludes any where the same membership has at least one active (still open) written-off loan. Balances of any non-000 sub-accounts on the same membership are not considered.

EMBmmyy1 where ACTTYP equals 0 and CURBAL equals 0.00. Remove any records where the same Account Base is found with WOSTATUS equals ‘A’ in ELNOmmyy.

Memberships W/Written Off Loans

Number of memberships with at least one active (still open) written off loan.

Account Bases from ELNOmmyy where WOSTATUS = A.