Statement Reconciliation / Analysis

Screen ID:	ISTRDBFM-02
Screen Title:	Statement Totals/Reconciliation
Panel ID:	5496
Tool Number:	825
		Click here to magnify

Access this screen by selecting the lookup next to a statement period on the first screen of the Statement Reconciliation/Analysis dashboard.

Introduction

The Statement Reconciliation/Analysis makes it easy to reconcile your statement activity to your invoice. This dashboard breaks down your statement production to see how many members qualified for a statement minus the amount suppressed to give you a total number of statements for the period. That is then broken down further to show how those statements were delivered (printed & mailed, returned to the CU, or as eStatements). This information will be handy when your auditors ask to verify statement activity compared to your invoice.

Not only is this dashboard great for reconciliation, but it can be used by your marketers and management team to see how statement activity is trending. Are more statements being printed month-to-month? How many statement inserts should be order? What months did we request inserts?

Data is available on this screen for:

• Regular statements

• Credit card statements

• Mortgage statements

Using this Screen

There are so many opportunities for further exploring, analyzing, and using this data from this screen.  Review the listing below for more information.

1. (Selection required) Select the type of statement to view at the top of the screen

   • At the top left of the screen, use the Statement type selector to view only regular, credit card, or mortgage statements. Press Enter to refresh.

2. (Optional) For regular statements, select the Statement format to view only monthly or quarterly statement runs. Leave the field blank for all.

   • For credit card and mortgage statements, no selection is required.

3. (Optional) Enter a period end date to start with a previous statement period.

   • If left blank, the system will automatically start with the most recent statement period for which data exists.

   • The file used for this dashboard began populating data September 2013. New data is accumulated monthly, typically on the first of the month for the previous statement period.

   • There is currently no plan to purge data; until further notice, data will be held indefinitely.

4. Compare up to 8 statement periods on the screen at once. 

   • The dashboard will place the most recent statement period on the left and display up to 8 statement periods to compare side-by-side.

5. Use the   (lookup) buttons next to the statement period to view additional information about that statement period on the second screen.

   • To view information about statement inserts, click the lookup button and then Style/Insert (F9) on the second screen.

How Values Are Calculated

The data that is displayed in this screen comes from the statement recon file (STMRECON) accessible only be CU*Answers staff since all credit union data is collected in a single file. At this time, this data is stored indefinitely, so you will be able to use this dashboard to see statement information as far back as September 2013 (the first statement period we began collecting data). Below, we've detailed how each of those records is calculated by the system.

Member counts:

(A) Open memberships: This is the total number of open memberships that qualified for a statement during that statement period. Qualification is determined by your statement configuration, which can be reviewed in the View Reg E Triggers for Stmts.

(B) Closed memberships: This is the total number of memberships that qualified for a statement that were closed during the statement period. If a membership was both opened and closed during that statement period, they will only be counted once as an open membership. For example, for your February monthly statement period, if a membership was opened February 2nd and then closed on the 15th, the statement generation process will count this as an open membership.

(C) Total members qualifying: (A + B) This is the total number of open memberships and closed memberships that qualified during the statement period. Since this count is for members who qualified for a statement based on your statement configurations, this will not be indicative of the total number of members on file.

(D) Less suppressed statements: Of the members that qualified to receive a statement, these are the members with a statement mail group code greater than 0, that is also configured to be Archive only. One example of these might be individuals under bankruptcy that the credit union has elected to suppress their statement.

(E) Total members receiving a statement: (C - D) This is the Total members qualifying minus the Less suppressed statements values. This indicates the total members for which a statement was generated during the statement period.

Statement counts:

(F) Statements printed and mailed: Of the members that received a statement, this indicates the number of members for which a print statement was generated and mailed to the member (statement mail group code = Print/Archive/Mail).

(G) Statements returned to CU: Of the members that received a statement, this indicates the number of members for which a print statement was generated and mailed to the CU (statement mail group code = Print/Archive/Do not mail).

(H) Total printed statements: (F + G) The combined total of Statements printed and mailed and Statements returned to the CU.

(I) E-statements: Of the members that received a statement, this indicates the number of members enrolled in eStatements.

(J) Less eStatements w/ print copy: Of the members that received a statement, this indicates the number of members that received both an eStatement and printed statement. Since they had a printed statement generated as well, this number is subtracted to prevent those members from being counted twice.

(K) Total eStatement only: (I - J) This is the E-statements value minus the Less eStatements w/ print copy value. This will provide you with an indication of how many qualified members only received an eStatement.

(L) Total statements: (H + K) This total comes from adding the Total printed statement and Total eStatements only. For regular statements (MN/QT), this will match Total Members Receiving Statement in the top section.

Special Note for Credit Card and Mortgage Statements:

Member counts - For open and closed counts for credit card/mortgage statements, these numbers provide information on the number of memberships that had a qualifying open/closed credit card/mortgage account during the statement period. For example, if the credit union had 10 credit cards closed during the statement period, but 2 of those were for a single member, the screen will reflect a total of 9 members with closed credit cards.

Member counts vs. Statement counts - With regular statements, Total members receiving a statement will match with Total statements since each member can only have one regular statement per statement period. With credit cards and mortgages, members may have more than one account, and the system generates a separate statement for each account of those types. The member counts will reflect the number of memberships with a qualifying mortgage/credit card. The statement counts will reflect the total number of accounts that qualified for a statement.