Difference between revisions of "Loan Loss Projection/Past Due Borrower Report"

From Documentation
Jump to navigation Jump to search
(Created page with "=='''Overview of IL485'''== Category:Loans Reports")
 
Line 1: Line 1:
 
=='''Overview of IL485'''==
 
=='''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.
 +
 +
 +
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:
 +
 +
 +
[[File:IL485.png]]
 +
 +
 +
The following fields are available on this screen:
 +
 +
 +
{| class="wikitable"
 +
|-
 +
! '''Field''' !! '''Description'''
 +
|-
 +
| '''Base date''' || Example
 +
|-
 +
| Example || Example
 +
|-
 +
| Example || Example
 +
|-
 +
| Example || Example
 +
|-
 +
| Example || Example
 +
|}
 +
  
  

Revision as of 11:42, 21 June 2013

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.


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:


IL485.png


The following fields are available on this screen:


Field Description
Base date Example
Example Example
Example Example
Example Example
Example Example