Loan Maturity Report

Screen ID: 

Screen Title: 

Panel Number:

Report Name:

images\kb_closed_shg.gif

LMTLN-01

Loan Maturity Report

5234

LMTLN

Click here to magnify

 

Access this screen by selecting Tool #467: Loan Maturity Analysis Report.

Helpful Resources

Learn how to create, change, and delete automated report settings.

Ask the AnswerBook: Why does the Loan Maturity Report not match the Selective Loan TB for the number and amount of loans reported for the 5300 Call Report?

Screen Overview

This report monitors the credit union’s loan portfolio by G/L until the loans mature. This report can be used to monitor the loan income as it matures.

You can select the "Calculate length of time to maturity date from" not only the current date, but also the loan’s original term or review date (next adjustment date).  This flexibility of date selection for the matured calculation better meets NCUA requirements for reporting loans outstanding on the real estate loan schedule of the 5300 Call Report.

The results on the report are shown by configurable ranges. These ranges are defaulted to: 1-3 months, 4-6 months, 7-12 months, 13-24 months, and over 24 months.  

How Do I Save/Retrieve My Report Settings?

For more details on setting up this feature, refer to the Automating Reports and Queries booklet, available on the CU*BASE Reference page. 

This report can be used with the “Report Scheduler,” a time-saving automation feature that allows you to select and save the filters you use to run several commonly used reports and then set these reports to be run automatically by our operations staff on the first of the month.  Or you can save the settings and run them manually by yourself at any time.

To save your report settings, first select your filters, including printer (can be a physical printer or the HOLDxx or MONTHxx OUTQs).  Then select Save Settings (F24).  On the next screen name your settings (we recommend adding your name!), and designate whether you wish to run this manually or if you wish for operations to run the report.  At a later time, use Retrieve Settings (F23) to populate the screen with the settings you have saved.  You can also edit your settings using Retrieve Settings (F23).  All saved settings can be viewed on the Report Automation: Standard Reports screen.

Field Descriptions

Field Name

Description

Calculate length of time to maturity date from

This allows selection of the “length of time to maturity from” not only the current date, but also the loan’s open date or review date (next adjustment date).  This flexibility of date selection for the matured calculation better meets NCUA requirements for reporting loans outstanding on the real estate loan schedule of the 5300 Call Report.

Process date

Enter the month’s data you wish to use for calculation. Entering a previous month will require that a backup tape be loaded.

Loan balances to include

Select to view All loans, or just the credit union portion, or just the investor portion.

Business Unit

(Optional)  To include only accounts with a specific business unit code on the report, use the Select button to reveal a screen to select one or more loan security codes. SEE ALSO:  Filter and selection directions.  When you return to the screen, the count of the items selected with appear next to the button. Learn more about Business Unit codes.

Loan category code

(Optional)  To include only accounts with a specific loan category code on the report, use the Select button to reveal a screen to select one or more loan category codes. SEE ALSO:  Filter and selection directions.  When you return to the screen, the count of the items selected with appear next to the button.

Loan purpose code

(Optional)  To include only accounts with a specific purpose code on the report, use the Select button to reveal a screen to select one or more loan purpose codes. SEE ALSO:  Filter and selection directions.  When you return to the screen, the count of the items selected with appear next to the button.

Loan security code

(Optional)  To include only accounts with a specific security code on the report, use the Select button to reveal a screen to select one or more loan security codes. SEE ALSO:  Filter and selection directions.  When you return to the screen, the count of the items selected with appear next to the button.

G/L account

(Optional) To include only accounts with a specific G/L account associated with the loan, use the Select button to reveal a screen to select one or more G/L account. SEE ALSO:  Filter and selection directions.  When you return to the screen, the count of the items selected with appear next to the button.

Export report to file

Use “Export report to file” go to the screen where you can choose to create a file that lets you use Member Connect to communicate instantly with these members via email and online banking messages, set up a marketing outreach via mailing labels and selective statement inserts, and track the responses via a telemarketing Tracker. This file will contain account base only. Or choose to export more data to use with CU*BASE Report Builder.

Include written off loans

Check this box to include written-off loans in the results. Leave this unchecked if you wish to exclude written-off loans in the results.

Loan lease balloon flag

Allows the selection of N/A, Balloon, General, or Leases only.  

Loan open date period used for Call Report YTD totals

(Optional) Enter a date range to generate a separate section in the report that will total the balance, disbursement limit, and number of loans based on the date range entered. This function is helpful for completion of your 5300 Call Report.

Report Sample

     RUN ON   7/12/13                                   LOAN MATURITY REPORT                                         USER ESTEBANC

                                                   TIME TO MATURITY FROM  7/12/13

 

                                                                                MATURITY AGING

 G/L #  DESCRIPTION                       1 TO 3 MON      4 TO 6 MON    7 TO 12 MON   13 TO 24 MON   25 TO 999 MON            TOTAL

 70180  FREDDIE MAC LOANS                        .00             .00            .00            .00    4,380,013.20     4,380,013.20

 70190  FANNIE MAE LOANS                         .00             .00            .00            .00  118,259,648.62   118,259,648.62

 70268  SIMPLY PLATINUM                     2,227.35          135.21       1,711.72       3,475.00    6,645,374.37     6,652,923.65

 70510  MASTERCARD CLASSIC                  6,134.87             .00            .00            .00    1,129,549.21     1,135,684.08

 70520  MASTERCARD GOLD                       377.63        1,350.94            .00            .00      769,190.54       770,919.11

 70530  VISA CLASSIC                       69,849.34       14,820.84            .00      11,922.80    5,682,950.62     5,779,543.60

 70540  VISA GOLD                                .00             .00            .00            .00   12,879,862.69    12,879,862.69

 70560  VISA PLATINUM                     162,197.07             .00         830.50       4,939.32   11,861,450.28    12,029,417.17

 

      TOTAL AMOUNT OF LOANS             2,898,215.28    1,215,398.98   6,249,939.13  14,077,171.53  298,084,560.91   322,525,285.83

      TOTAL # OF LOANS                         1,367             610            877          2,351          17,225           22,430

 

 LOANS W/OPEN DATES 012012 TO 122012

                             BALANCE      394,930.90      266,256.52     185,962.82   2,428,753.80  118,666,669.23   121,942,573.27

                  DISBURSEMENT LIMIT      544,962.37      548,003.61     286,314.25   3,308,580.91  128,065,009.53   132,752,870.67

                          # OF LOANS             219             181             89            582           4,935            6,006

 

 

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#LMTLN-01.htm