Overlooked Reports

System Management System Management Overlooked Reports

This document provides an overview of commonly overlooked reports available within the FLEX system. The FLEX system offers over 400 reports, many of which can be automated for End of Day (EOD) or End of Month (EOM) processing.

Report Generation and Defaults

  • Saving Report Defaults: For reports generated regularly, you can save default settings to streamline future generation.
    • Fill out the report parameters as desired.
    • Click “Save As” at the top of the screen.
    • Once saved, the report will be available in the “Defaults” drop-down menu for quick access.

Commonly Overlooked Reports Categories

The following sections detail various reports categorized by their functional area.

Audio Reports

These reports provide insights into call activity.

  • Calls by Time of Day:
    • Breaks down calls by time.
    • Includes: Number of calls, percentage of total calls, and total call time.
  • Calls by Duration:
    • Breaks down calls by duration intervals.
    • Includes: Number of calls, percentage of total calls, and percentage of total time.
  • Count by Date Range:
    • Provides aggregate counts for various activities within a specified date range.
    • Includes:
      • Total number of accounts
      • Total number of calls
      • Total number of inquiries
      • Total of all exceptions
      • Total number of dollar transactions
      • Total of all transactions
  • Action Code Usage:
    • Details the usage of action codes by members.
    • Includes: Action code, description, count, and percentage of total usage.

Certificates Reports

These reports focus on certificate accounts.

  • Certificate Listing:
    • Allows filtering by various parameters: type, group, balances, etc.
    • Lists all certificates meeting the set parameters.
    • Includes: Account number, suffix, type, member name, current balance, open date, maturity date, last renewal date, next interest pay date, last interest calculation date, and rate.
  • Maturing Certificates Used as Collateral:
    • Identifies certificates used as collateral that are approaching maturity.
    • Displays: Account number, type, member name, maturity date, dollars pledged, loan account, dollars pledged on loan, loan description, and current loan balance.

FLEX Teller Reports

These reports provide data related to FLEXTeller usage and activity.

  • Logons by Time:
    • Breaks down FLEXTeller logons by time.
    • Includes: Number of logons, percentage of total logons, and total logon count.
  • Summary by Account:
    • Shows the usage summary per account.
    • Includes: Social Security Number, account number, member name, total logons, number of dollar transactions, and amount of transactions.
  • Inactive User Report:
    • Lists members who have been inactive on FLEXTeller.
    • Worksheet: Provides: Inactive user list, account number, tax ID, member name, date and time of last login.
    • Update Functionality: Can switch users within a specified date range to “Active FLEXTeller User=N,” locking them out due to inactivity.
  • Attempts by Accounts Not Setup:
    • Lists members who attempted to log on to FLEXTeller but are not set up in FLEXTeller Maintenance.
    • Includes: Account number, Social Security Number, member name, date, and time of attempt.

Internal Audit Reports

This report assists with internal auditing processes.

  • Transactions to Bad Address Accounts:
    • Lists members who have had transactions on accounts flagged with a bad statement address.
    • Includes: Account, suffix, name, transaction date, description, reference number, teller, branch, previous amount, transaction amount, and inactive date.

Loan Application Reports

These reports provide insights into loan application processes.

  • Apps by Officer Tiered:
    • Parameters: Application status, open or completion dates, sort by type or status.
    • Displays: Loan officer, application number, status code, loan type, completion date, posting date, account number, member name, and loan amount.
  • Apps by Purpose and Score:
    • Parameters: Detail/summary, application status, approval analysis, approval status code, and denial status code.
    • Displays: All applications with corresponding purpose codes, status code, application number, credit score, dollar amount, and totals.
  • Statistical Summary Report:
    • Compares started applications versus completed applications.
    • Displays: Loan type, description, applications started count/amount, and applications completed count/amount.

Loans Reports

These reports cover various aspects of loan management.

  • Balance Compared to Expected:
    • Requires minimum amount of difference to report (difference between current and expected balance).
    • Allows exclusion of up to 5 loan types.
    • Displays: Account number, original balance, current balance, expected balance, difference, loan open date, first pay date, due date, actual payment, calculated payment, frequency, and number of payments.
  • Interest Exceeds Payment:
    • Lists loans where interest due is greater than the scheduled payment.
    • Displays: Member name, account, suffix, interest due, scheduled payment, difference, last interest calculation date, payment due date, current balance, and loan type.
  • Loan Analysis Report:
    • Sort options: Security/rate, security code, purpose/rate, purpose code, payment method, payment frequency, loan type, loan officer, or credit grade.
    • Displays: Count, percentage of count, balance, percentage of balance, weighted rate, and maturity in months.
  • Loan Maturity:
    • Parameters: Detail/summary, current/last EOM or EOD data, absolute or relative periods, time periods, report errors, balloon loans, V-group loans, L-group loans, H-group loans, loan types, and time periods.
  • Loans to Payoff this Month:
    • Based on an effective date, shows loans expected to be paid off.
    • Displays: Account number, member name, original balance, current balance, due date, payment, frequency, last transaction date, security code, purpose code, and payoff.
  • Paid Ahead Loans:
    • Based on an effective date and minimum days paid ahead.
    • Displays: Account number, member name, original balance, current balance, due date, payment, frequency, last transaction date, type code, security code, purpose code, paid ahead amount, paid ahead payments, paid ahead days, paid ahead months, and a total of all loans paid ahead.
  • Secured Loans with No Title:
    • Identifies secured loans where the “Title Held” option in Collateral Maintenance is not marked.
    • Parameters: Open date, type of collateral, or loan type(s).
    • Displays: Account number, member name, current balance, collateral description, deed, title, UCC, loan officer, loan type, and loan open date.

Managerial Reports

These reports provide high-level overviews for management.

  • Bad Address Accounts Listing:
    • Parameters: Option to include charge-offs, bankruptcy, deceased, dormant, and/or frozen accounts.
    • Displays: Accounts with bad address dates, account number, member name, address, branch, and bad address date.
  • New Accounts:
    • Parameters: Open date range, specific share/loan/certificate types, and branch codes.
    • Displays: Accounts opened within the specified date range, account number, member name, date of birth, purpose code, security code, maturity date, date opened, current balance, account branch, and member branch.
  • New Accounts by Teller:
    • Displays new accounts opened by specified teller(s) within a date range.
    • Includes: Totals for the branch and teller.

Operations Reports

These reports assist with daily operational tasks.

  • Closed Accounts:
    • Requires a specific teller number.
    • Displays: Account number, type, member name, date opened, last activity, date closed, account branch, and member branch.
  • Closed Accounts (Date Range):
    • Requires a date range (instead of a teller number).
    • Displays: Account number, member name, purpose code, security code, maturity date, date opened, date closed, and a total of closed shares, loans, and certificates.
  • Count Social Security Numbers:
    • Parameters: Joint owner options, sorting options, and type of accounts.
    • Provides totals for: SSNs on the FLEX system (can include Joint Owners), Tax IDs, and ITIDs.
  • Member Services Report:
    • Based on selected types and a product listing.
    • Shows: Account number, name, and birthday.

Shares Reports

This report focuses on IRA share accounts.

  • IRA Report over 69:
    • Shows all IRA accounts for members over the age of 69.
    • Includes: Account number, type, member name, age of member, date of birth, IRA balance, dividends paid this year, federal withholding YTD, days before 70, and transfer or check disbursement setup.

Share Drafts Reports

This report concerns share draft accounts.

  • Multiple Draft Accounts by Account Number:
    • Lists all accounts with multiple draft accounts under one account number.
    • Shows: Account number, suffixes, member name, and courtesy pay amount.

Teller Reports

These reports summarize teller transactions.

  • Summary by Branch and Teller:
    • Summarizes transactions by branch and teller.
    • Includes: Branch, teller, transaction codes, count, and total amount of transactions.
  • Summary by Branch and Time:
    • Summarizes transactions by branch and time.
    • Includes: Branch ID, time, count, and total amount.
  • Summary by Branch, Time and Day of Week:
    • Summarizes transactions by branch, time, and day.
    • Includes: Branch, day, time, count, and total amount.
  • Summary by Teller & Time:
    • Summarizes transactions by teller and time.
    • Includes: Teller, time, count, and total amount.