Dividend Accruals - Certificates (Daily Accruals by GL)

Screen ID:  IDIVACD-01
Screen Title: Dividend Accruals - Certificates, Daily Accruals by GL
Panel ID: 6585
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.

This screen shows the daily accruals for the date selected on the previous screen by the individual G/L accounts, with further options to perform analysis on specific branches, G/Ls, and dates.

Search Criteria

Field Name

Description

Corp ID

Enter the Corp ID.

Dividend accrued between MMDDYYY and MMDDYYY

Enter search dates to generate dividend accrual information for that specific period.

GL Account

Select specific G/L(s) to view (up to 100) for the particular day selected.

Branches

Select specific branches to view.

 

Table Descriptions

Column Name

Description

G/L Account

This column lists the specific G/L account for the selected date.

Date

The calendar date of the accrual. When using this dashboard screen, having selected a date on the previous dashboard, these dates should all be the same.

Accrued Dividend

Starting Balance

The starting balance of the day in question, for the specific G/L listed.

  New

The amount of dividend accrued for the specific day in question, for the specific G/L account.

  Paid

 

 Ending Balance

The ending balance of the day in question, for the specific G/L account.

Principal Balance

The total balance of the G/L 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.

Average 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 and date selected, for the year.

Annualized Expense

This field lists the calculated expense credit union is expected to pay out in certificate dividends for the year, based on the COF and account balance at this snapshot moment in time.

Count

The number of certificates included in the G/L selection for that date.  

 

Functions and Buttons

Link Name

Description

Show Br GL/Day

Select an entry and this link to view the various accrual GL entries by branch, per CD type for the specific day.

Show Br all days

Select an entry and this link to view the various accrual entries by branch, for the specific GL account, for all days in the interest accrual period.

Show Linked CD Types

Select an entry and this link to view the specific CD types associated with each GL in the selection listing that makes up the day's totals.

Buttons

Export Full List (F9)

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

Analysis (F16)

Use the built in Analysis feature to review daily average accrued dividends, averages per certificate, and top general ledger accounts by balance, annualized dividend, and yield.  Analyze and trend your interest earnings like never before, brought to you by Asterisk Intelligence.

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.