Overview

The MaxCollect Loan Instalment Report provides a detailed record of MaxCollect instalment loans. This report ensures that staff can effectively monitor financial instalments and track collection references across different regions. Overall, the report acts as a procedural reference for managing and auditing microfinance loan data.

Security and Access

To access this report, your user role must have the MaxCollect Loan Instalment Report option enabled under the Report section in Role Setup. Please note that the MaxCollect module must also be enabled for your legal entity, or this option will not be available.

To access the report, navigate to: Reporting > MaxCollect > MaxCollect Loan Instalment Report.

Report Filters

The report offers extensive filtering options to help you pinpoint the exact information you need:

General

• Branch: (Optional) Generate the report for MaxCollect loan instalments created at a specific branch.

• Region: (Optional) Generate the report for MaxCollect loan instalments created in a particular region.

• User: (Optional) Generate the report for MaxCollect loan instalments created by a specific user.

• File Format: (Required) Choose your desired output format: XLS or XLSX.

Client

• Client Number Start: (Optional) Define the beginning of a client number range for the report.

• Client Number End: (Optional) Define the end of a client number range for the report.

• Status: (Optional) Filter the report for MaxCollect loan instalments where the clients have a specific status.

• Employer Search: Use an asterisk * to list all employers. You can also type a full or partial employer name and click Search to display results in the employer dropdown list.

• Employer Name: (Optional) Generate the report for instalments of clients associated with a specific employer.

Loan Instalment

• Due Date Start: (Optional) Define the beginning of a due date range for MaxCollect loan instalments.

• Due Date End: (Optional) Define the end of a due date range for MaxCollect loan instalments.

• Status: (Optional) Filter the report for MaxCollect loan instalments with a specific status.

• Payback Type: (Optional) Generate the report for MaxCollect loan instalments with a specific payback type.

• MaxCollect CSP: (Optional) Generate the report for a specific MaxCollect CSP (Client Service Provider).

Available Buttons

• Cancel: Select this button to cancel your request and return to the previous page.

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

Sorting and Display Order

The report is primarily sorted by Loan instalment due date, then by Client number, and finally by Loan number.

Output Format

You have several options for viewing and exporting the report:

• View Online: You can view the report directly within the system.

• Print: Print a physical copy of the report.

• Email: Email the report to a specified user. Ensure the necessary email address setups are complete for this functionality.

• Spreadsheet (XLS/XLSX): Click the "XLS: MaxCollect Loan Instalment Report" hyperlink (or the XLSX equivalent depending on your format selection) to open the report in a spreadsheet workbook (e.g., Microsoft Excel or OpenOffice Calc). Once the information is in this format, you can easily sort it to meet your specific business needs.

Columns/Details

The report displays the following detailed information:

Client

• Client Number: The customer's unique number in the system.

• CSP Client No: The customer's CSP client number.

• Client Surname: The customer's surname.

• Client Initials: The customer's initial(s).

• Client First Name: The customer's first name.

• Branch: The branch where this customer is set up.

• Salesperson: The salesperson associated with this customer.

• Employer: The name of the employer.

Banking

• Bank Name: The name of the bank.

• Account Number: The customer's bank account number.

Loan Instalment

• Date Due: The due date of this specific loan instalment.

• Loan Instalment Status: The status of this specific loan instalment.

• Instalment No: The instalment number of this specific loan instalment.

• Amount Due: The amount due on this specific loan instalment.

Payback Instruction Instalment

• Tracking Date: The tracking date of the payback instruction instalment.

• Payback Instruction Instalment Status: The status of the payback instruction instalment.

• CSP Reference No.: The reference number of the CSP.

• MAXCOLLECT Reference No.: The reference number of MaxCollect.

Loan

• Loan No: The loan number.

• CSP Loan No.: The CSP loan number.

• Payback Type: The payback type for this specific contract.

Record Details

• Loan Record User: The user who recorded this specific loan.

• Loan Record Date: The date when this specific loan was recorded.

• Loan Record Time: The time when this specific loan was recorded.

• Payback Instruction Instalment Record User: The user who updated this specific payback instruction instalment.

• Payback Instruction Instalment Record Date: The date when this specific payback instruction instalment was updated.

• Payback Instruction Instalment Record Time: The time when this specific payback instruction instalment was updated.