Interest Accruals - Loans (Daily Accruals by GL)

Screen ID:  IINTALN-01
Screen Title: Interest Accruals - Loans, Daily Accruals by GL
Panel ID: 6601
Tool Number: 1170
    Click here to magnify

Access this screen by selecting Tool #1170 Loan Interest Accruals Dashboard from the CU*BASE home page, then selecting a date and Show GL/Day.

This dashboard function will sort the daily interest accruals by GL.

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

Field Name

Description

GL Account

The specific G/L account referenced.

Date

The calendar date of the accrual.

Accrued Interest

Starting Balance

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

   New

The amount of interest accrued for the specific day in question, for all G/Ls selected.

 Ending Balance

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

Account Balance

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

The average value of interest gained. This weighted average rate is the percentage of the gains on the total sum of loans, within the day selected, for the year.

Annualized Value

This field lists the calculated value credit union is expected to earn in interest for the year, based on the average yield  and account balance at this snapshot moment in time.

Count

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

 

Functions and Buttons

Link Name

Description

Show Br GL/Day

Select a day and this link to view the various accrual GL entries for the specific day.

Show Br All Days

Select an entry and this link to view the various accrual GL entries for branches on multiple days.

Show Linked Loan Categories

Select an entry and this link to view the loan categories attached to the specific GL in question.

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.