Overview

The Loan Expected Income Report allows you to generate a list of expected loan income and actual received loan income over a selected period.

Access and Security

• Accessing the Report: Navigate to Reporting > Loan > Loan Expected Income Report.

• Security: The security option for this report is available under the Report Section of the Role Setup > Reporting > Loan Expected Income Report. This setting controls user access to the report.

Filters and Selections

The following selections are available on this report:

• Branch: You can generate the report for a specific branch.

• Region: You can generate the report for loans within a specific region.

• No of Months: This is a required field. Enter the number of months for which you want to see the expected loan income.

Report Columns

Monthly Breakdown

The report provides a monthly breakdown with the following columns:

• Month and Year

• Amount Receivable: This is the sum of "Amount Due" for installments within the (loan installment Due) date range, considering loan installment statuses such as Active, Paid, Non-Performing, and Written Off.

• Amount Received: This is the sum of "Amount Received" for installments within the specified date range.

• Capital of Instalments: This sums the "Capital Amount" of the installments within the date range. The Capital amount is calculated conservatively using the formula: (Instalment Amount Agreed) * (Loan Capital) / (Loan Total).

Sorting and Display Order

The report is sorted in Monthly Chronological order.

Output Format

You can print, view, or email the Loan Expected Income Report.

• XLSX: Expected Loan Income Summary Report (Spreadsheet): Click on the hyperlink "XLSX: Expected Loan Income Summary Report" to download the report in this format. This allows you to open the report in Excel or OpenOffice for further analysis and customization, making it easy to sort information according to your specific business needs.

• Email: The report can also be emailed to a specific user.

  • Email Setup Requirements:

    • The recipient's email address must be configured in their user profile: Setups > Security > Users (complete the necessary email address on the user's profile).

    • The user must be selected to receive report emails in Setups > Reporting > Reports Email Setup.

Displayed Information

The report displays the following key information:

• Month / Year: The month and year as selected in the filters.

• Amount Receivable: The expected income for the month.

• Amount Received: The actual amount received for the month.

Report Buttons

The following buttons are available for interaction with the report:

• Finish: Select the Finish button to generate the report based on your selected filters.

• Cancel: Select the Cancel button to cancel the report generation request.

• Back to Filter Option: Select the Back to Filter Option button to cancel the current request and return to the previous page to modify filter criteria.

• Email Report: Select the Email Report button to receive this report via email.