Overview

The Future Instalments Paid Report allows you to view all early payments received for loans. This report specifically identifies installments that have a future due date but are already marked with a "paid" status.

Access and Security

• Accessing the Report: Navigate to Reporting > Loan > Future Instalments Paid Report.

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

• Watch Video: For a visual guide, please refer to: https://youtu.be/mJbL5Av8Qos

Filters and Selections

The report provides various selection options, allowing you to refine information by branch, salesperson, date, and more. The following filters are available:

General

• Branch: Generate the report for loans created in a specific branch or all branches.

• Region: Generate the report for loans created in a specific region or all regions.

• User: Generate the report for loans created by a specific user or all users.

Client

• Client Number Start: Specify the starting client number for the report range.

• Client Number End: Specify the ending client number for the report range.

• Status: Generate the report for loans associated with clients of a specific status or all statuses.

• Frequency: Generate the report for loans on clients with a specific payment frequency or all frequencies.

• Bank: Generate the report for loans on clients with a specific bank or all banks.

Loan

• Loan Number Start: Select the starting loan number for the report range.

• Loan Number End: Select the ending loan number for the report range.

• Date End: This field is required. Enter the date in dd/mm/yyyy format. This generates the report for future installments within the specified date range up to this end date.

• Loan Product: Generate the report for specific loan products or all loan products.

• Receipt Type: Generate the report for loans with a specific receipt type or all receipt types.

• Salesperson: Generate the report for loans created by a specific salesperson or all salespersons.

Employer

• Employer Search: Use an asterisk (*) to list all available employers. You can then select a specific employer or all. Alternatively, type the full or partial employer name and click the Search button; the result(s) will appear in the employer drop-down list.

• Employer: Generate the report for future installments of clients associated with a specific employer.

• Classification: Generate the report for future installments of clients where the employer has a specific classification.

• Economic Sector: Generate the report for future installments of clients where the employer has a specific economic sector.

Sorting and Display Order

The report can be sorted and displayed by the following criteria:

• Due Date

• Client Number

Output Format

The report can be generated in the following formats:

• XLS: Future Instalment Paid Report (Spreadsheet Workbook): Click on the hyperlink "XLS: Future Instalment Paid 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: Setup > Security > Users (complete the necessary email address on the user profile).

    • The Cash Box Setup must also be configured: Setup > Branches > Cash Box (select the specific user by E-mail).

Columns and Details

The following information is displayed on the report:

• Client Number

• Client Surname

• Client Name

• Loan Number

• Loan Payback Type

• Loan Custom Reference

• Number of Instalments

• Instalment Number

• Date Due

• Amount Received

• Record User

• Record Date

• Record Time

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 send this report via email to the configured recipient.