Lenders needing to produce a principal reduction report for GAP analysis can generate it based on either a one- or five-year period.  This report(s) may be found by:
 

• Hovering over Data in the menu at the top of the screen. Click Reports in the submenu that appears.
• Use the search field to search for the report titled Payments: Loan Principal Projections
• You can choose from a one year or five year period for the report. Click the name of the report you want to run

Timing is critical to ensure accurate balances, and we are working toward automating this report to run on the final evening of each month. Until that automation is in place, users should run the report before any payments are posted at the beginning of the month.

Currently, the report reflects the full loan amount. If a lender needs to calculate only their portion, as defined in the ownership module, they will need to copy the report, add the Payment Account: Guaranty % field, and apply the appropriate calculation after exporting the data to Excel. Ventures plans to enhance the reporting functionality to support this calculation natively in a future update.

The criteria for loans to generate to this report are as follows:

• Loan Out of Portfolio is NOT true and
• Payment Account Boarded is true