Loan Loss Projection/Past Due Borrower Report
Jump to navigation
Jump to search
Overview of IL485
The Loan Loss Projection/Past Due Borrower report is a custom report designed for BCE, geared specifically towards how they do business.
This report REQUIRES that the following code sets be configured:
- Code Set 0636 - IL485 Loan Loss Projection Past Due Categories
- Code Set 0637 - IL485 Loan Loss Projection Sale Costs Categories
The basis of this report is the concept of the Past Due Borrower:
- For each borrower, examine their active loans to determine if any of the loans have been flagged as delinquent
- If a borrower has any delinquent loans, all loans will be reported as a group in the past due category of the most delinquent loan
Loan Loss Reserve Projection report
- This report is created in a multi-worksheet XML format
- Six of the worksheets reflect a past due category
- The last worksheet is a summary worksheet of totals from the six past due category worksheets, as well as additional information
Past Due Borrower Report
- This report uses information gathered for the "Loan Loss Reserve Projection" report
- Borrowers having any delinquent loans will have all loans reported in the past due category of the most delinquent loan
- Only delinquent loans will be included for a borrower – current loans will not be included on this report
To generate this report:
- From the DDI-Connect main menu, double-click Financial Services
- Double-click Loans
- Double-click Reports
- Double-click 485 Loan Loss Projection/Past Due Borrower Report. The parameters screen will launch:
The following fields are available on this screen:
Field | Description |
---|---|
Base date | Enter the date you wish to use. You can type it in mm/dd/yyyy format or click the calendar icon to select the date |
Loans to report individually | If you wish to include separate information regarding a specific loan or loans, you can do so here. Type the loan number or numbers, separated by commas, or click the list icon to select from a list of loans within the system. The loan number or numbers entered here will have a separate summary of their information included in the report output |
Non-accrual loan types | If left blank, report will not specify non-accrual loan types. If you wish to include non-accrual loan types, type the code or codes, separated by commas, or click the list icon to select from a list of active loan type codes within the system |
Include loan loss projection report | If you select this option, an additional field will appear, allowing you to specify the network path and file name to be used for the loan loss projection report. This report is output into xml format |
Include past due borrower report | If you select this option, an additional field will appear, allowing you to specify the sort mode you wish to use for the past due borrower report. Click the drop down to select the sort method to be used |
Print Options
After clicking the Print Options button you will see the following options. Choose the desired options and click OK to return to the report parameters screen.
Option | Description |
---|---|
Printer | Click the drop down arrow to select from a list of available printers. DDI Connect uses your default printer unless told otherwise |
Format | Click the drop down arrow to select from a list of available formats. Select paper size, number of columns, and number of rows for printing. Each report has built-in format defaults. Select “Use Defaults” to use the built-in report defaults. The number of rows and columns controls the print size and amount of information per page |
Memo | If you wish, you can add a memo to the output of the report. NOTE: It is recommended that Word documents be saved with the .docx extension |
View Report | This option generates a pdf file that is displayed on the screen when the report is generated |
Archive Report | If this option is selected, the system will archive the report in the DDI Connect report archives. For information on working with archived reports, please reference this page: Archived Report Viewer |
Print Report | If selected, the system will generate the report output to your default printer. NOTE: You will also receive a pdf version of the report, displayed on your screen |
Print via PDF | Prints directly to your printer. |
This option allows you to send a .pdf attachment of the report to the indicated users' email addresses. When OK is clicked, a dialog box will open requesting a recipient | |
Duplex/Top | Prints the report on both sides of the paper in landscape style. The printer must be capable of printing on both sides or an error will occur |
Duplex/Side | Prints the report on both sides of the paper in portrait style. The printer must be capable of printing on both sides or an error will occur |
Green bar | Adds shaded, horizontal bars to the report, making it easier to read across columns |
No dialog | Selecting this option means that no ‘Report Completed’ dialog will display after the report has been generated |
Extra copies | If you want extra copies of the report generated, type the number in this field |
Click Start. The system will generate the report based on the parameters you selected, and display the results. Click below to view a sample of this report.