Services Detail: Setting Up Account Analysis

The Account Analysis tab lets you set up and maintain a member's Account Analysis options.

How do I? and Field Help

Complete the following fields to set up the fee options and member information for the member.

Click the Master Share Draft Account down arrow to select the master share draft type for the member's Account Analysis plan. If the member does not have the share draft account select from the Master Share Draft Accountdrop-down list, you will be prompted to create the account.

If the Social Security number is found in the closed account file, the message Previous account closed by credit union will appear. To open the Closed Account File dialog box, click the Closed Account icon button. Then, you can use the Action Type drop-down list to temporarily suspend the cross reference check by changing the Action Type field to Suspend so you can add the new share draft account without deleting and re-adding the closed account record. Portico will reset the Action Type field back to Stop during the nightly cycle.

If the ECA does not offset the total costs of services used by the member, and if the charge type is Soft Dollar or Flat Fee, the fees will be deducted from the master share draft account. The master share draft will always be tracked for services and included for balance consideration.

Click the Plan down arrow to select the Account Analysis plan. If the Account Analysis plan or any pricing codes on the Account Analysis plan are changed after month end processing, the old Account Analysis plan and it's pricing codes will be reflected on the Shares – Account Analysis tab and any preliminary report reruns and on the Analysis Statement. The new Account Analysis plan will only apply to current month data.

Click the Officer down arrow to select an Account Analysis officer. The branch associated with the officer automatically appears.

In the Fee Options group box, click the Charge Type down arrow to select Soft Dollar, Flat Fee or Hard Dollar.

If the Charge Type field is Soft Dollar…

• All event driven activity will be captured and accumulated for a potential analysis fee.
• Select the Maximum Override check box to override the Account Analysis plan default and use the amount entered in the Maximum Fee Amount field. Then, enter the maximum fee allowed in the Maximum Fee Amount field (Length: 6 numeric including decimal). If the total cost of services exceeds the maximum fee allowed, then the amount in the Maximum Fee Amount field is debited from the member's Account Analysis master share draft account.
• The system will no longer charge hard dollar fees for any included share draft accounts listed in the Service Tracking group box.

If the Charge Type field is Flat Fee…

• All event driven activity will be captured and accumulated for a potential analysis fee.
• Select the Flat Override check box to override the Account Analysis plan default and use the amount entered in the Flat Fee Amount field. Then, enter the flat fee in the Flat Fee Amount field (Length: 6 numeric including decimal). If the calculated earnings credit allowance is less than the total cost of services provided, then the amount in the Flat Fee Amount field is debited from the member's Account Analysis master share draft account.
• The system will no longer charge hard dollar fees for any included share draft accounts listed in the Service Tracking group box.

If the Charge Type field is Hard Dollar…

• All event driven activity will be captured through the analysis process to generate an analysis for future reference.
• The member is 'hard dollar' charged at event time for regular fees/services provided through daily Portico processing.

The Charge Type field for a member added to Account Analysis in the current month will default to Hard Dollar even if Flat Fee or Soft Dollar is specified. Fees will continue to be charged through Flexible Fees or Relationship Pricing until the next month. The overdraft protection fee is the exception to the rule and will continue to hard dollar charge regardless of the member’s Account Analysis indicator.

If the account is a business account, enter the business name, phone number, fax number, and e-mail address in the Business Information group box. The business name will be used on the Account Analysis Statement Report 398 instead of the name that appears on the Contact Information tab.

Field	Description
Name	The business name of the commercial account. This name will be used on the Account Analysis statement. Length: 40 alphanumeric
Phone	The business telephone number for the commercial account. Length: 10 numeric
Ext	The business telephone extension for the commercial account. Length: 4 numeric
Fax	The fax telephone number for the commercial account. Length: 10 numeric
E-Mail	The e-mail address for the business. Click the send button to send an e-mail to the address specified. Length: 50 alphanumeric

Click Add to add the member to Account Analysis or click Save to update the member's Account Analysis options. When you add a member to Account Analysis, the Status field changes to New to Account Analysis. The Last Change field displays the date a change was last made to this member's Account Analysis settings. The Account Analysis date field displays the date the member was originally set up for Account Analysis.

To delete a member from Account Analysis, click Delete. You cannot delete a member from the system if the member is enrolled in Account Analysis. You must first delete the member from Account Analysis, then after the back-office cycle has run, delete the member from the system.

Click Close to close the Account Analysis dialog box without saving your changes.

Since the results of Account Analysis processing are based on a true calendar month-to-date process, the system will automatically populate the Account Analysis field in the Date group box with the date the member was added to Account Analysis. The system will also update the Account Analysis indicator on the Overview tab when a member is added to Account Analysis. If a member is new to analysis for the current processing month, the system will not assess fees through analysis for that month. If the member’s Date Joined date on the Contact Information tab and Account Analysis date on the Account Analysis dialog box are the same, the member may be charged for the first month according to the charge type selected.

All closed accounts are automatically removed from the Account Analysis dialog box by the back office overnight cycle (except where the closed account is the master share draft account). The credit union must manually change the master share draft account to a non-closed account on the Account Analysis dialog box. The 585 Report (exception code 22) will identify that the fee could not be posted because the master share draft account is closed. Due to regulatory requirements, the system automatically closes any accounts that are negative for greater than 45 days. These closed accounts are automatically removed from the Account Analysis dialog box by back office processing on a daily basis.

Shares Tab

The Shares tab on the Account Analysis dialog box lets you designate which of the member’s share draft accounts will be included or excluded for activity tracking for a combined Account Analysis. You can also include or exclude other share account balances in the earnings credit allowance calculation.

1. On the Shares tab, click the Service Tracking down arrow to choose whether to include all, exclude all, include specified, or exclude specified share drafts. The master share draft will always be tracked regardless of the option selected.
   1. I - Include the specified shares drafts for share service tracking
   2. E - Exclude the specified shares drafts from share service tracking
   3. A - Include all the member's share drafts for share service tracking. No specific share types can be listed.
   4. X - Exclude all the member's share drafts from share tracking. No specific share types can be listed. System default.
2. If you selected the Include Specified Share Drafts or Exclude Specified Share Drafts option, click the Select a Share Draft Account down arrow to select a share draft account. Then, click Add. The share draft account will appear in the grid. To delete a share draft account from the grid, select the Delete check box next to the account.
3. In the Balance Consideration group box, click the down arrow to select include all, exclude all, include specified, or exclude specified shares.
   1. I - Include the specified shares for share balance consideration
   2. E - Exclude the specified shares from share balance consideration
   3. A - Include all the members shares for share balance consideration. No specific share types can be listed.
   4. X - Exclude all the members shares from share balance consideration. No specific share types can be listed. System default.
4. If you selected the Include Specified Shares or Exclude Specified Shares option, click the Select a Share Account down arrow to select a share account. Then, click Add. The share account will appear in the grid. You can specify up to 22 share accounts to be included or excluded in Account Analysis. The month end average collected balance(s) will be considered in the calculation of the earnings credit allowance. To delete a share account from the grid, select the Delete check box next to the account.
5. Click Add. The Status field changes to New to Account Analysis.

When a member is flagged for analysis, the system will start accumulating activity for all of the member’s share draft accounts from the date added. You can select share drafts to be included in the process at any time during the month; however, the data is available only from the Account Analysis date. If the member has not been on Account Analysis for a full month, the average collected balances could be distorted and the accumulations of pricing records will only be from the Account Analysis date until the end of the month. The balances of new share accounts added during the month for existing Account Analysis members will reflect the averages as of the date added to the system. If existing certificates or share accounts are added to the list for balance consideration, they will reflect averages from the beginning of the month. This also applies for cross members, if the member was already listed but not if the cross member is newly added.

 

Certificates Tab

The Certificates tab on the Account Analysis dialog box lets you include or exclude the member’s certificate account balances in the earnings credit allowance calculation.

In the Balance Consideration group box, click the down arrow to select include all, exclude all, include specified, or exclude specified certificates.

• I - Include the specified certificates for balance consideration.
• E - Exclude the specified certificates from balance consideration.
• A - Include all the member's certificates for balance consideration. No specific certificates can be listed.
• X - Exclude all the member's certificates from balance consideration. No specific certificates can be listed. System default.

If you selected the Include Specified Certificates or Exclude Specified Certificates option, click the Select a Certificate Account down arrow to select a certificate account. Then, click Add. The certificate account will appear in the grid. You can specify up to 24 certificate accounts to be included or excluded in Account Analysis. The month end average collected balance(s) will be considered in the calculation of the earnings credit allowance.

The Balance Consideration grid lists the member's certificate accounts that will be included or excluded in the earnings credit allowance calculation. To delete a certificate account from the grid, select the Delete check box next to the account. Click Update or Save.

 

Cross Member Tab

The Cross Member tab on the Account Analysis dialog box lets you include or exclude the share and certificate account balances of other member’s in the earnings credit allowance calculation. A member may only be added for ECA consideration to one Account Analysis member. If a member is used in a cross member relationship for analysis, they may not be added to Account Analysis until the cross relationship is deleted.

1. Click Add to add a new line to the Included Members grid. In the Member Number field, enter the member number to include. Click the Member Lookup icon to open the Member Search dialog box and locate the member. Then, press ENTER.
2. Click the Share Balance Consideration down arrow to select include all, exclude all, include specified, or exclude specified share accounts. If you selected the Include Specified Shares or Exclude Specified Shares option, click the Share Accounts down arrow to select a share account. Then, click Add. You can specify up to 7 share accounts to be included or excluded in Account Analysis. The month end average collected balance(s) will be considered in the calculation of the earnings credit allowance.
3. Click the Certificate Balance Consideration down arrow to select include all, exclude all, include specified, or exclude specified certificate accounts. If you selected the Include Specified Certificates or Exclude Specified Certificates option, click the Certificate Accounts down arrow to select a certificate account. Then, click Add. You can specify up to 5 certificate accounts to be included or excluded in Account Analysis. The month end average collected balance(s) will be considered in the calculation of the earnings credit allowance.
4. Click Update or Save.

To delete a account from the grid, select the Delete check box next to the account.

General Ledger Effects: none

Related Reports:

• Account Analysis Transaction Register Report 021
• Non-Financial Transaction Register Report 030 (when a member is set up with Account Analysis or when a member is deleted from Account Analysis)

Portico Host: 1AA

Click Next to continue with the next the step of the application or click Save/Release to save the application for completion at a later date. Click Back to move back to the previous tab.

Click Finish to complete the application.