Operational Reporting
LMS has a series of reports to aid reconciliation and audit of various processes. These operational reports are available via the “Reports” filter on the left pane in the LMS. The following reports exist as of today. The user can pick any report from the dropdown and can see the details on the screen. Additionally, these reports are downloadable in excel format with more information.
Loan Earnings Report
This helps the lender know its earnings during a given time period. This report will run across all the loans in the system and publish the earnings generated from those loans during the period that the user has specified.
Borrower Follow-up Report
This report helps the lender to retrieve the list of all the loans on which follow-up is required and when it is required along with other information.
Loan in Collections Report
This report contains the loans that are delinquent and also housed in different stages of Collections. Please note that a loan will be housed in the Collection Stage while restructuring the loan manually through the Modify Loan action menu in the LMS portal.
ACH Instruction Report
This report contains a list of all loans for which ACH/payment instructions were created. At present LMS creates ACH/payment instructions. An ACH file contains multiple instructions. However, 1 instruction for 1 payment on 1 loan. A single loan may have multiple payments being pulled on the same day; in such a case 1 loan can have multiple instructions in a day. At present this instruction is created by a task, which runs once a day.
Payments Report
This report contains a list of all loans for which payments were recorded during a time period. Payments can be initiated by the system via ACH, or through alternate payment rails (such as Cash, Check or any other). We need to record all payments from all sources and methods. This report is meant to give a consolidated view of all payments, on all loans on which payment activity was recorded.
Re-attempt Report
This report contains a list of all loans for which ACH/payment instructions were failed or unsuccessful, and of those which were re-attempted or not. At present LMS creates ACH/payment instructions. If an ACH payment is rejected, then LF will re-attempt based on the re-attempt product parameter. The system gets notified once an instruction is rejected for any reason, with a return code. Each return code has a description. Currently the system re-tries the payment automatically if there is a NSF failure(Non-sufficient funds), a re-attempt may be initiated on the following business day or next scheduled ACH task creation time (in case such tasks are set up to run multiple times a day). This report is used to track # of re-attempts, reject code for each failure so that necessary corrective actions can be taken by the Tenant.
Note: Additional BI reports can be configured on as needed basis or LF user can use our Add on service for BI reporting.
Updated 27 days ago
