Dividend Accruals - Certificates (Daily Accruals by GL and Branch)

Screen ID:  IDIVACD-02
Screen Title: Dividend Accruals - Certificates, Daily Accruals by GL and Branch
Panel ID: 6586
Tool Number: 1165
    Click here to magnify

Access this screen by selecting Tool #1165 Certificate Accrual Dashboard, then selecting a date and the link for Show GL/Day, then selecting a GL and the link for Show Br GL/Day or Show Br all days.

This screen will show either the daily accrual figures for a specific date as selected in the previous screen, OR will show the specific branch information for all dividend calculation days, based on the selection made on the previous screen.  

Search Criteria

Field Name

Description

Corp ID

The Corp ID as previously selected.

Dividend accrued between MMDDYYY and MMDDYYY

The search dates as previously selected.

G/L Account

The G/L account as selected on the previous screen.

G/L description

The description assigned to the G/L account.

 

Table Descriptions

Column Name

Description

Branch

This column lists the branch information.

Accrued Dividend

   CD Type

This column lists the specific CD Type.

   Starting Balance

The starting balance of the day in question, for all G/Ls selected.

   New

The amount of dividend accrued for the specific day in question, for the specific branch and CD Type in the selected G/L account.

   Paid

 

   Ending Balance

The ending balance of the day in question, for the specific branch and CD Type selected.

Account/Principal Balance

The total balance of the G/L for the branch and CD Type at the time of calculation for this dashboard. Note that these figures are in real time, and the G/L total balance can change when a member makes a payment, etc.

COF

The average cost of funds. This weighted average rate is the percentage of the costs of paying on the total sum of certificates, within the G/L, CD Type, branch, and date selected, for the year.

Annualized Expense

The total cost of paying the dividends on the selected CD Type for the year.

Count

The number of certificates that make up the totals for the accruals.

 

Buttons

Button Name

Description

Export Full List (F9)

Select this function to export the dashboard list to a file in your credit union's QUERYxx library.

Data Source (F19)

The Data Sources screen displays the Tables (files) and Columns (fields) that are used to generate the data on the selected dashboard.