Establishing the Account Analysis Rates

The Account Analysis Rates window lets you establish and maintain credit union-level rates, such as earnings rate and reserve rate, to be used for all Account Analysis plans. Once all Account Analysis rates, pricing and plans have been defined, you can designate system defaults for creating new plans on the Account Analysis Pricing Plans window or Account Analysis Pricing Plan Information window or when setting up members on the Account Analysis dialog box. You can also define a rate for calculating the negative interest expense for a member.

Each month-end, the previous month's rates are copied by the system and applied to the new month. If you want to use rates different than the previous month's, you must change the rate(s) on the Account Analysis Rates window. The system will display up to 12 rolling months of rate history, but changes are only allowed to the current or previous month's rate.

To access the Account Analysis Rates window, click General Operations from the Operations menu on the Portico Explorer Bar. On the General Operations menu bar, click Account Analysis, point to Administration, then click Rates.

Account Analysis Rates

The Account Analysis Rates window displays a rolling twelve months of rate history. The previous month’s rate will automatically populate the current month as a result of month-end processing. You can modify the current month’s rates at any time. Previous month’s rates can be modified only if the adjustment days defined on the 398 Report Rules have not expired.

How do I? and Field Help

To modify the Account Analysis rates, complete the following information in the Rates grid:

Column	Description
Month	The month and processing year associated with the rates going across the screen. This is a rolling 12 months. The most current month will be listed first.
Earnings Rate	Enter the earnings rate used to calculate the Earnings Credit Allowance. Changes are only allowed for the current month, or for the previous month if within the days specified in the Adjustment Days field. This percentage may be associated with the Treasury Bill Rate. Length: 6 numeric including decimal Keyword: ER
Rerun	Select the Rerun check box to rerun the Account Analysis Preliminary Report 899 for members on Account Analysis when a rate change has occurred after the month-end date. A rerun cannot be performed if the days specified in the Adjustment Days field have expired. Once you select the Rerun check box and click Save, clearing the check box will not unschedule the 899 Report.
Reserve	Enter the reserve percentage used to calculate the required balance to support the cost of services. This percentage may be associated with the Federal Reserve requirement for non-earning liabilities. Length: 5 numeric including decimal Keyword: RE
Use Reserve	Select the Use Reserve check box to consider the reserve percentage in the required balance calculation. If not selected, the Reserve field can be blank. Keyword: UR
Negative Balance Amount	Enter the rate for negative balance accruals. Changes are only allowed for the current month or for the previous month if within the days specified in the Adjustment Days field. This rate is used to calculate the expense for pricing code 115. Length: 6 numeric including decimal Keyword: NB

Complete the following information to set up the default plan information.

Field	Description
Plan	Click the Plan down arrow to select a default Account Analysis plan. Keyword: PL
Officer/Branch	Click the Officer down arrow to select a default officer. Keyword: OF
Share Draft	Click the Share Draft down arrow to select the default share type that will be used for when setting up new members on the Account Analysis dialog box. Keyword: SD
Adjustment Days
Charge Type	Click the down arrow to select Soft Dollar, Flat Fee or Hard Dollar. Flat fee - All event driven activity is captured and accumulated for a potential analysis fee. For example, a stop pay set up charge will not be assessed, instead the event will be passed to an analysis pricing record for counting. The actual charge will be considered as part of the overall cost of the services for the member on Account Analysis. If the earnings credit allowance is less than the total cost of services provided, the member will be charged the flat fee amount regardless of the total cost of the services incurred. The flat fee can be overridden at the member-level on the Account Analysis dialog box. Soft dollar fee - All event driven activity will be captured and accumulated for a potential analysis fee. For example, a stop pay set up charge will not be assessed, instead the event will be passed to an analysis pricing record for counting. The actual charge will be 'soft dollar' charged through Account Analysis if the earnings credit allowance is less than the total costs of services provided. If the total cost of services exceeds the maximum fee allowed, then the maximum fee is the amount debited from the member's master share draft account. Hard dollar fee - 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 the daily Portico processing. If the member is set up on Account Analysis during the current month, they will continue to be hard dollar charged until the following month regardless of whether the Charge Type field is Flat fee or Soft dollar. Keyword: TC
Flat Fee	The default flat fee amount. If the calculated Earnings Credit Allowance is less than the total cost of services provided and the charge type is flat fee, then the flat fee is debited from the member's Account Analysis master share draft account. The Flat Fee amount must be greater than zero, if the Charge Type field is Flat fee. Length: 6 numeric Keyword: FF
Max Fee	The maximum fee amount to be charged to the member's account for Account Analysis fees incurred. If the charge type is soft dollar, the earnings credit allowance is less than the total cost of services provided, and the maximum fee amount is less than the cost of services (less the earnings credit allowance), then the amount in the Max Fee field is the maximum amount that will be debited from the member's Account Analysis master share draft account. If the maximum fee amount is greater than the final cost of services (i.e. less the earnings credit allowance), then the total costs of services will be debited from the member's Account Analysis master share draft account. Length: 6 numeric Keyword: MX
GL Account	The general ledger that will be credited the fee income generated from the Account Analysis plan. The GL account will be credited as a result of the final cutoff run of Account Analysis. Length: 6 numeric Keyword: GL

The Adjustment Days field indicates the number of days after month-end processing that the user may make changes to the rates before the final Account Analysis cutoff statement is generated. If the number of adjustment days have expired, the user cannot make any changes to the previous month rates or previous month Shares – Account Analysis tab. The Adjustment Days field will be populated based on the value in the Next Date field on the 398 Report Rules. The Adjustment Days field cannot be less than 01 or greater than 10.

Click Save to save your changes. The Last Changed field indicates the last date that the rate information was changed.

General Ledger Effects: none

Related Reports:

Account Analysis Rules Changes Report 991
Account Analysis Preliminary Combined Report 899
Account Analysis Preliminary Detail Report 898
Account Analysis Statement Report 398

Portico Host: AAR