NCUA Share Insurance Report

Screen ID: 

Screen Title: 

Panel Number:

Report Name:

LSHINSS-01

NCUA Share Insurance Report

3538

LSHINS1

Click here to magnify

 

 

Access this screen by selecting Tool #545: NCUA Share Insurance Report.

For more information, check out the NCUA Share Insurance Booklet.

You can mask a specific number of SSN/TIN digits for display on the detail reports by entering the number in the "Mask the first x digits of the SSN/TIN #" field.

The CU*BASE Share Insurance Report provides you the uninsured amount of your deposits aggregated by SSN/TIN broken down by the following account ownerships:

  1. SINGLY-HELD ACCOUNTS (no joint owners)  (Except for "special" Membership Designations selected in #4and #6 below.)

  2. JOINTLY-HELD ACCOUNTS (one or more joint owners) (Except for "special" Membership Designations selected in #4and #6 below.)

  3. IRA ACCOUNTS (Regular/Roth/Roth Conversion excluding Coverdell Education Savings IRAs

  4. REVOCABLE TRUSTS by Membership Designation code (When printing the report, you define which Membership Designation codes you use for trusts so that they will be separated and included only on this section of the report.)

  5. COVERDELL EDUCATION IRAS (formerly Education IRA savings accounts)

  6. BUSINESS ACCOUNTS by membership designation code

  7. GOVERNMENT ACCOUNTS by membership designation code

  8. EXCLUDED MEMEBERSHIP DESIGNATIONS (When printing the report, you define any "special" Membership Designations you consider not eligible for this insurance, and these memberships are excluded from all other sections. This would include non-natural-person accounts or irrevocable trusts you need to exclude from the other sections.)

There will be a separate Summary Report with totals from the various sections (singly-held, jointly-held, IRA accounts, etc.) This page will be particularly helpful when filling out your 5300 Call Report.

There will be a special line item on the summary for Joint Owners without SSN/TIN to identify places where we didn't have complete SSN/TIN information for a joint owner (meaning that CU*BASE has a name on file but no SSN/TIN for that particular secondary names record).

How Do I Save/Retrieve My Report Settings?

For more details on setting up this feature, refer to the Automating Reports and Queries booklet, available on the CU*BASE Reference page. 

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.

To save your report settings, first select your filters, including printer (can be a physical printer or the HOLDxx or MONTHxx OUTQs).  Then select Save Settings (F24).  On the next screen name your settings (we recommend adding your name!), and designate whether you wish to run this manually or if you wish for operations to run the report.  At a later time, use Retrieve Settings (F23) to populate the screen with the settings you have saved.  You can also edit your settings using Retrieve Settings (F23).  All saved settings can be viewed on the Report Automation: Standard Reports screen.

Field Descriptions

Field Name

Description

Corp ID

Corporation ID

Reporting period

Select the Reporting Period by MMYYYY

Report type

Detail (D) - All accounts per SSN/TIN are displayed.

Summary (S) - One line per SSN/TIN is displayed. You will not get detail on all the accounts per TIN.

Include members

All (A) - Information will display for all of your members.

Only Members w/ Uninsured Funds (O) - Information will display for only the members with uninsured funds. Uninsured funds are the amount over theNCUSIF coverage amount not covered by the NCUA share insurance.

Mask the first x digits of the SSN/TIN #

Enter a number to mask a specific number of SSN/TIN digits for display on the detail reports.

Export member information for excess share insurance reporting

Check the box to export information for members that have uninsured funds to a file. The file includes the information listed below for all ownership types combined (using the same calculations as the report output).

  • Account base

  • Account type

  • Application type

  • SSN

  • Ownership type

  • First/Last name

  • DBA Name (if applicable)

  • Address (Street, City, State, Zip)

  • Aggregate account balance

  • Excess amount  

  • Co-owner SSN

  • Co-owner account base

  • Co-owner account type

Revocable trusts:  membership designations to include

Select member designations to include on the Trust report. Use the Select button to move to a screen where you can select multiple items by holding down the Ctrl key. Then use Select to return to this screen. The number that displays tells you the number of membership designations selected to identify revocable trusts.

Note: Generally, this is membership designation TR.

Business accounts: membership

Select member designations to include on the business account report. Use the Select button to move to a screen where you can select multiple items by holding down the Ctrl key. Then use Select to return to this screen. The number that displays tells you the number of membership designations selected to identify business accounts.

Government accounts: membership designations to include

Select member designations to include on the government account report. Use the Select button to move to a screen where you can select multiple items by holding down the Ctrl key. Then use Select to return to this screen. The number that displays tells you the number of membership designations selected to identify government accounts,

Excluded member designations

Select membership designations to exclude from the singly/jointly held reports. Use the Select button to move to a screen where you can select multiple items by holding down the Ctrl key. Then use Select to return to this screen. The number that displays tells you the number of membership designations selected for exclusion.

  • Note: These are the membership designations that you consider not eligible for insurance. Accounts with these membership designations will appear on the Excluded Membership Designations Report.

NCUSIF Coverage

This section gives you the flexibility to select the coverage amount to report – i.e. $100,000 or $250,000.

 

Select button

Below is a sample of the pop-up that appears when you hit the Select Button for ‘Exclude member designations from the singly/jointly-held reports’ or ‘Include member designations in the Trusts section’.

To select multiple membership designations, hold down the Control key.

images\3539intopicg_shg.gif