Member Trial Balance (3)

Screen ID: 

Screen Title: 

Panel Number:

Report Name:

images\kb_closed_shg.gif

LMBRTS-03

Member Trial Balance Selection

4618

LMBRT

Click here to magnify

 

Depending on the entry in the first Trial Balance Listing screen, you may access this from the first or second Trial Balance Listing screen.

Helpful Resources

Learn how to create, change, and delete report automation settings.

How Do I Save/Retrieve My Report Settings?

This report can be used with the “Report Scheduler,” a time-saving automation feature that allows you to select and save the filters you use to run several commonly used reports and then set these reports to be run automatically by our operations staff on the first of the month.  Or you can save the settings and run them manually by yourself at any time.  Learn more about using Report Scheduler with this report.

This screen is used to specify which members should be included on the report based on specific attributes of their current accounts. There are three choices for all of the attributes:

Options 

Selection

Description

N/A (default)

The attribute does not matter; accounts will be included whether or not they have the attribute, according to all of the other selection criteria you specify elsewhere

N = Exclude

Specifically exclude accounts that have this attribute

Y = Include

Include only accounts that have this attribute

 

See below for a description of each attribute and how it is determined from your member records. When ready, use Enter to proceed to the balance and date criteria selection screen.

Field Descriptions

Attribute

Description

Individual accounts

Memberships marked as individual (Member Type ‘MI’).

Organizational accounts

Memberships marked as organizational (Member Type ‘MO’).

Custodial accounts

Memberships marked as Custodian account on the MASTER record.

Accounts with wrong address

Memberships marked as Wrong address on the MASTER record. It is a good idea to exclude these to avoid having mail returned as undeliverable.

Passbook accounts

Membership has a Passbook Process ID indicator associated with it.

Accounts with payroll deduction

Members that have a payroll distribution record (looks at the PDIND flag on the MEMBERx record). Remember this is different from ACH.

  • CU*TIP: If you want to get a list of members that don’t have any payroll deduction, you could choose “Exclude.” here.

Accounts with auto transfer

Members that have an AFT or CFT record on their account.

  • Remember that 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 labels program only looks at those accounts to see if AFT/CFT records exist.

  • CU*TIP: If you want to get a list of members that don’t use AFT/CFT, you could choose “Exclude” here

Accounts with uncollected $

Members that have uncollected funds balance of greater than zero on their accounts (looks at the UNCOLL field in MEMBERx).

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

Accounts with write-offs

Members that have loan accounts where the Write-off flag is set to 1 (for a written-off loan).

  • IMPORTANT: In order for this to work properly, an Application Type of either LN or OC must be entered on the General Account Criteria selection screen.

Frozen accounts

Members that have any freeze indicator other than 0 on any of their accounts.

  • Remember that 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 labels program only looks at those accounts to see if AFT/CFT records exist.

 

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#LMBRTS-03.htm