Overview

The Loan Instalment Detail Report provides a comprehensive list of all loan instalments within a specified date range. This report is crucial for detailed financial tracking and analysis of loan repayment schedules.

MaxMoney Setup

Resources

To access this report, ensure the following resource is enabled under the user's role:

• Setups > Security > Roles > Loan Instalment Detail Report

How to Access the Report

To generate the Loan Instalment Detail Report, navigate to:

Reporting > Loan > Loan Instalment Detail Report

Report Filters

The report offers various selection options to refine the data, allowing you to drill down information to specific criteria. The following filters are available:

• Report Type: Select the desired level of detail: Lite, Detail, or MIS.

• Branch: Generate the report for instalments of loans associated with a specific branch.

• Region: Generate the report for instalments of loans linked to a specific region.

• User: Generate the report for instalments of loans created by a specific user.

• Add Monthly Summary: Select this checkbox if you require an additional sheet in the report providing a summary per month.

CLIENT

• Client Number Start and End: Generate the report for instalments of loans belonging to clients within a specified client number range.

• Client Status: Generate the report for instalments of loans of clients with a specific status.

• Client Frequency: Generate the report for instalments of loans of clients with a specific payment frequency.

• Bank: Generate the report for instalments of loans of clients associated with a specific bank.

• Bank Account Type: Choose whether the bank filter should apply to the client's payout account or payback account.

LOAN

• Loan Number Start and End: Generate the report for instalments of loans within a specific loan number range.

• Instalment Date Due Start and End: Generate the report for instalments with due dates falling within a specified period.

• Loan Status: Generate the report for instalments of loans with a specific loan status.

• Loan Product: Generate the report for instalments of loans belonging to a specific loan product type.

• Payback Type: Generate the report for instalments of loans with a specific payback type.

• Salesperson: Generate the report for instalments of loans associated with a specific salesperson.

• Show Detailed Values: Select this if you wish to see a breakdown of the loan amounts (e.g., capital, interest, fees).

EMPLOYER

• Employer Search:

  • Use an asterisk (*) to list all employers.

  • To search for a specific employer, type the full or partial name and click the Search button. The result(s) will appear in the employer dropdown list.

• Employer: Generate the report for instalments of clients employed by a specific employer.

• Pay Point: Generate the report for instalments of clients associated with a specific employer pay point.

• Employer Classification: Generate the report for instalments of clients whose employers have a specific classification.

• Employer Economic Sector: Generate the report for instalments of clients whose employers belong to a specific economic sector.

Report Columns

The generated report will include the following columns:

CLIENT

• Client Number

• Initials

• Name

• Client Status

• Client ID Number

• Client Salesperson

• Client Home Branch

• Client Employer

CLIENT BANK

• Bank Name

• Branch Code

• Bank Account No.

• Bank Account Type

LOAN

• Loan Branch

• Payment Frequency

• Loan Agreement No. (Loan No.)

• Custom Reference

• Loan Status

• Loan Product

• Loan Payback Type

• Auth Type (Applicable to DebiCheck)

• Agreement Date

• Loan Salesperson

• Creation User

• Creation Date

• Creation Time

LOAN INSTALMENT INFO

• Instalment Number

• Instalment Date

• MaxCollect Reference Number

• Tracking

• Pre Days

• December Tracking

• December Pre Days

• Instalment Amount

• Amount Received on Instalment

• Outstanding on Instalment

• Date instalment was paid up.

DETAIL Loan Amount Breakdown (if "Show Detailed Values" is selected)

• Loan Amount = Loan total

• Capital Amount

• Interest Amount

• Initiation Fee

• Initiation Fee VAT

• Service Fee

• Service Fee VAT

• CPI = Credit Life Insurance