New/Refinanced Loan History

Screen ID: 

Screen Title: 

Panel Number:

Report Name:

images\kb_closed_shg.gif

LNDBSC-01

New/Refinanced Loan History

4622

LNDB

Click here to magnify

Access this screen by selecting Tool #554: New/Refinanced Loan History Report.

Helpful Resources

Visit Show Me the Steps for easy instructions on how to use CU*BASE to complete tasks related to modifying existing loans.

Visit Show Me the Steps for easy instructions on using Automated Reports to create, change, and delete report settings.

Screen Overview

This report gives you a picture of your credit union’s loan disbursements for a period of a month, including overdraft protection transactions.  You can select to filter this report to exclude your lines of credit transactions to view only new money coming into the credit union.  Other filters allow you to view loans with or without insurance premiums, or to view only transactions from a specific branch, specific loan category (such as mortgages) or specific transaction origin (such as teller or online banking).  You can even narrow down the transaction date range to period of time shorter than the selected month and view only those transactions. 

Two report types can be selected.   Selecting Detail, prints the Detail report followed by the Summary Report; selecting Summary only prints the Summary report.  The Detail Report lists all transactions with member information, while the Summary Report summarizes the number of disbursements by type of transaction. 

Use the “Export report to file” checkbox to export the report listing for use with Report Builder or Member Connect.

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

Enter process date required

Enter the month and year of the process date (MMCC) (required). Defaults to current month.

Exclude insurance premiums

Select whether to exclude loans with insurance premiums attached to them. Check the box to exclude these accounts

Exclude line of credit

Select whether to exclude transactions associated with lines of credit. This allows you to view only new money coming into the credit union, not transactions for existing ones. Check to exclude

Corp ID

Corp ID

Transaction Branch

Select to only include a transactions made at a specific branch. (optional)

Date range

Select a date range for the transactions to include in the report. Enter a beginning date and an ending date. (MMDDYYCC). This allows you to select a range within the selected month. (optional)

Member Branch

Select to only include transactions from a specific branch. (optional)

Loan Category

Select to only include transactions from loans with a specific loan category. (optional)

  • NOTE: Use this selector to, for example, view only transactions associated with mortgages.

  • SEE ALSO: Configuring Loan Categories Codes.

Transaction Origin

 

Select to view only one transaction origin code: the origination point for the transaction; in other words, the process that posts the transaction (for example: online banking, teller or a tool. (optional)

Report Type

Two report types can be selected.   Selecting Detail, prints the Detail report followed by the Summary Report; selecting Summary only prints the Summary report.  The Detail Report lists all transactions with member information, while the Summary Report summarizes the number of disbursements by type of transaction. 

Export report to file

Check the check box next to Export report to File to move to a screen that allows you to export the data for use with Member Connect or CU*BASE Report Builder (Query).

 

Report Samples

Detail

images\804rpt_shg.gif

Summary

images\804rpt2_shg.gif

 

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