Analyzing Fee Refunds by Employee

Screen ID:  IFWREFND-01
Screen Title: Fee Refunds by Employee
Panel ID: 6033
Tool Number: 370
    Click here to magnify Click here to magnify

Access this screen by selecting Tool #370: Fee Refunds History by Employee.

This analysis shows fees refunds (credits to fee income G/L accounts) being posted by your employees via Account Adjustments.

The Fee Refunds Analysis lets you review fee refunds posted by your employees on member accounts. Data is gathered by pulling together all transactions that had a negative effect on an income G/L account and were posted under Origin Code 08, which includes account adjustments and transaction reversals.  Since this could potentially include other types of reversals, the screen has many different filtering options to narrow down your results.

Upon entering the screen, the date range will default to the prior full calendar month, but you can change it to use a different range for which transaction history exists. Use the Select buttons to narrow your results by member and teller branch, employee ID, and G/L account. Use the Containing search box to search for a transaction description containing a specific word or phrase.

  • 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.

  • NOTE: Data is shown for memberships that are still opened. Refunds on memberships that are closed are not presented on this dashboard. The General Ledger will include these postings.

    • If auditing employee activity, this dashboard may not include a small segment of refunds in that employee's totals.

    • If attempting to reconcile with General Ledger data, totals may not match data on this dashboard. For this reason, it is not recommended that you develop incentive programs or other programs that require and exact data match.

    • If analyzing financial impact of refund to the credit union, understand that this dashboard does not include the amounts that were refunded on memberships that are now closed. For some financial analysis projects, focusing on the General Ledger data instead may be a better approach.

Summary Totals vs. Detail      

When the screen first appears it shows a summary, with only two columns: Transaction Description and Amount.  In this summary view the system sorts by the description, then groups matching descriptions to calculate a total.  (The * asterisk at the beginning of the description denotes a total, which adds clarity when the screen is expanded to the Detail view.) 

CU*TIP:  Remember that these descriptions are manually entered by an employee when the adjustment is posted.  Therefore, the more consistent your employees are with their entries, the more effective this dashboard will be at summarizing similar types of refunds. 

Use the Show Detail button to expand the screen to show all of the individual refund transactions under each of these groupings, with details about each transaction such as employee ID, date, teller and member branch, and G/L account.  Assuming the list is sorted by Transaction Description, subtotals will appear under each group (note the * at the beginning of the subtotal lines).  Use the Show Totals button to toggle back to the initial summary view.

While in the Detail view, account #s and names that represent insiders (employee and board members, etc.) will be highlighted in yellow. (Subtotals will also be highlighted, but remember these only appear when the list is sorted by Transaction Description.) From the Detail view you can also export data for use with Member Connect or Query, view the Common Bonds suite of analysis dashboards,

Filters

Filter

Description

Date range from/to

The date range selected for the current inquiry. This will default to the prior full calendar month.

Containing

The dollar amount of the refund. If the screen is sorted by the transaction description, this column will include a subtotal for each unique transaction description.

Member branch

Use the Select button to narrow results by the branch/location that is associated with the member record.

Teller branch

Use the Select button to narrow results by the credit union branch associated with the teller employee ID.

Employee ID

Use the Select button to select from CU employee IDs.

G/L account

Use the Select button to narrow results by the income G/L account affected.

Explanation of Columns

Column Header

Description

Transaction description

The transaction description as it appears on the member account. If sorted by this column, a subtotal of each transaction description will be included in a separate line, highlighted and marked with an asterisk (*).

These are entered by the employee at the time the refund is posted.  Only identical descriptions will be summarized, so the more consistently your employees enter these descriptions, the more useful these summary totals will be.
Amount

The dollar amount of the refund. If the screen is sorted by the transaction description, this column will include a subtotal for each unique transaction description.

Transaction Date

The date of transaction as it appears in the member’s account history.
Tlr Br

The branch associated with the employee that performed the transaction.

Account #

The member’s account base.
Typ

The member’s account suffix.

Member Name

The member’s last name.
G/L Account

The income G/L to which the refund was posted.
G/L Account Description

A portion of the description of the G/L account.

Buttons

 Button

Description

Show Detail / Show Totals (F5)

Use this to toggle the display between showing summary totals by transaction description, and showing all of the individual refund transaction details.  

Export (F9)

Appears in the Detail view only.  Use this to export this list of members to either a list of account numbers for use with Member Connect, or export the entire list as it appears on the screen to a database file for use with Query.  The standard Exporting Data window will appear.

Member Connect (F10)

Appears in the Detail view only.  After exporting the file, you can use this to access the Member Connect Marketing Tools feature and contact the members immediately via email or other channel.

Common Bonds (F12)

Appears in the Detail view only. Use this to view the suite of Common Bonds dashboards to analyze this group of members based on what they share in common, including memberships traits, account composition, credit history trends, or Tiered Service

Show Insiders / Show All Accts (F14)

Use this to toggle between showing all accounts and showing only accounts that are flagged as insiders (employee and board member accounts, etc.) via an Employee Type/Insider code.

Employee Summary Totals (F15)

Access a summary of fee refunds by the employee that performed them.

Clear Filters (F16)

Removes and selection criteria entered and refreshes the list.