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.