Losing the Love - Balance Changes

Screen ID:  ICLOMBR-01
Screen Title: Patterns in Balance Changes
Panel ID: 6013
Tool Number: 132
    Click here to magnify

Access this screen by selecting "Find Patterns in Balance Changes" on the entry screen.

About this Screen

NOTE: On the first day of the month this screen may be blank. The analysis is run during EOD on the first day of the month.

Create full-color PDFs of the data on the screen – PDF Exports

Learn about downloading data to Excel or a comma delimited file

Dashboard Tips – Questions to Ask When Comparing a Dashboard with Another Dashboard or Report

This screen compares balance changes for the ten previous months (as data is available) from the month selected on the entry screen based on the filters selected on the entry screen and those made on this screen.  You may find that some months do not have data, and this may mean that the account was closed during that month.  Scroll down the screen to view data in all columns. Scroll down the screen to view data in all columns.

Using this Screen

Enter a balance amount in the "Show warning signs on balance changes" or a percent in the "% amount" field and use Enter to view accounts that had that amount or percentage change in adjacent months.  (You can select to show movement in balances changes that are upward moving, downward or both.)  Then use the "Show Warning Signs (F6) button to view only accounts that fit the balance or percent change parameters for that number of times entered in the "occurrences" field.  (The times do not necessarily have to be adjacent to each other.

  • Example: 1 is entered in the "balance changes at least x thousand $" field and "down" is selected for "Show balance changes."  Upon using Enter, all accounts that have decreased $1,000 from on month to the next are shown on the screen, including those that dropped $1,000 the month they closed.  The number 3 is entered in the "occurrences" field (the default).  Upon using the "Show Warning Signs" (F6) button, only accounts that have decreased $1,000 in adjacent months three times are shown on the screen, for example June to July, September to October, and October to November.

Use the other filters and buttons to filter the selections, export the data, or compare these selections to open memberships.  Sort the columns ascending and descending by clicking on the header row.    

Analysis at Top of Screen

The top of the screens shows a changing analysis based on the accounts analyzed.

Filter

Description

Show data through the end of

Shows month selected on entry screen.

Member count

Shows number of accounts being analyzed

Deceased

Shows number and percentage of deceased members being analyzed

Warning signs

Shows number and percentage of accounts being analyzed that meet the warning signs. (See explanation of warning signs above.)

Dormant

Shows number and percentage of accounts being analyzed that are dormant.

Filters

Use the filter, then use Enter to view the change in results.

Filter

Description

Show warning signs on balance changes at least x thousand $ or x % when comparing adjacent periods AND at least x occurrences

Enter a number in one of the field provided (thousand dollar change or percentage change) to find a change across all months.  The direction (up, down or both) is made in the "Show balance changes" field.

See example above for use of the "Show Warning Signs" (F6) button.

 

 

Show balance changes

Select which way (down, up, or both) you wish to view balance changes.

Balances between x and x (thousand $)

Filter the results to show only accounts with balances of this amount (in whole dollars/thousand dollar amounts).  This amount can be in any of the months analyzed. (Whether loans, savings or both is used is dependant on the selection made in the "Balance Selection" button below.)

Net change between x and x (thousand $)

Filter the accounts to show only accounts with a net change of the entered amount across all of the months analyzed (in whole dollars/thousand dollar amounts).  This amount can be across any of the months analyzed. (Whether loans, savings or both is used is dependant on the selection made in the "Balance Selection" button below.)  

  • NOTE: An account will show in the listing if the last month prior to closing the membership had at least this amount.  In this case, the membership is included since it reduced that amount when the account was closed.

Select Data to View

This button reveals a screen that allows you to select the way the data on the screen is sorted and controls what data is listed in the left hand column.

 

Totals and Percentages at the Bottom of the Screen

Below is an explanation of the totals and percentages listed in the bottom section of the screen.

Totals

There are ten (10) totals at the bottom of the screen, one total for each end of month (EOM).  The totals alternate in height to allow the dashboard to show more information on the screen.

  • These totals represent the total balances of accounts as of the end of each of their respective months.

  • Example: If you are using data through April 30, 2020, the total to the far left displays the EOM total balances of accounts for the month of June 2019, while the total to the far right displays the EOM total balances of accounts for the month of March 2020.

  • TIP: Go down each column's data for each month and total up the balances per month. They will match the totals displayed at the bottom of this screen in this Totals section.

Percentages

There are nice (9) percentage values at the bottom of the screen, one for each change in month. Each percentage represents the overall increase or decrease between each month's overall balance totals.

  • Example: If the first percentage is 9.0%, your balances decreased by 9.0% from the first month to the second month.

Buttons

The buttons filter the data, export the data, and compare the closed account analysis to open accounts.

Button

Description

Exclude Deceased/Show Deceased (F4)

Toggles between excluding members who are deceased and including them.  At the entry of the screen the accounts are included.

Balance Selection (F5)

Reveals a screen allowing the selection of only savings, only loans, or an aggregate of both.  At the entry of the screen the screen includes both.

Show Warning Signs/Show All Signs (F6)

Filter to show only accounts that fit the warning signs as selected above.  (This is explained further in the example at the top of this topic.)

Export (F9)

Reveals a screen allowing you to elect to export either the account numbers only (for use with Member Connect) or the entire contents of the file for use with Report Builder.

Member Connect (F10)

After creating a database file using the Export feature, use Member Connect (F10) to contact those members.

Open Mbrs/Closed Members (F11)

Toggles between showing open memberships and closed memberships. At entry of the screen defaults to show closed members.  This allows you to compare your open membership across the same parameters as your closed analysis on this screen.

Data Sources (F16)

Reveals a screen listing the fields and files used to calculate the data on the screen

Show Filters (F17)

Reveals a screen showing the filters currently used with the dashboard.

Exclude Dormant/Include Dormant (F18)

Toggles between excluding dormant accounts and including them.  At entry of the screen defaults to include them.