Overview

The Instalment Detail Daily Analysis Report provides a quick overview of all daily installments, summarizing them per day based on their Due Date.

Access and Security

• Accessing the Report: Navigate to Reporting > Loan > Instalment Detail Daily Analysis.

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

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

Filters and Selections

The report offers various selection options 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.

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

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

• File Format: This is a required selection. Two options are available:

  • XLS (Excel 2003)

  • XLSX (Excel 2007+)

Client

• Client Number Start: Generate the report for specific client numbers (starting range).

• Client Number End: Generate the report for specific client numbers (ending range).

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

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

Loan

• Loan Number Start: Generate the report for installments of specific loans (starting range).

• Loan Number End: Generate the report for installments of specific loans (ending range).

• Instalment Date Start: This field is required. Enter the date in dd/mm/yyyy format. This generates the report for installments due within the specified date range, starting from this date.

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

• Loan Product: Generate the report for loans on clients with a specific loan product.

• Instalment Status: Generate the report for loans on clients with a specific installment status (Active, Paid, Written Off, Cancelled).

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

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

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 receipts of clients associated with a specific employer.

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

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

Sorting and Display Order

The report can be sorted and displayed by:

• Day of the Week

Output Format

The report can be generated in the following formats:

• XLS: Instalment Detail Daily Analysis Report (Spreadsheet Workbook): Click on the hyperlink "XLS: Instalment Detail Daily Analysis 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 available in the report:

• Week Day

• Date

• Number of Payments: The number of payments that contribute to the values in this row.

• Capital: The capital portion of the installment in this row.

• Interest/Profit: The interest portion of the installments in this row.

• Initiation Fee: The initiation fee portion of the installments in this row.

• Service Fee: The service fee portion of the installments in this row.

• Administration Fee: The administration fee portion of the installments in this row.

• Preparation of Business Plan Fee: The preparation of business plan fee portion of the installments in this row.

• CPI Fee: The calculated portion of the Insurance premium.

• VAT: The VAT portion of the installments in this row. (If the Legal Entity VAT is not applicable, this column will not display any figures).

• Total: The total amount of the installments in this row.

• Receipts: The amount received on the installment.

• Outstanding: The difference between the Total and the Receipts.

• Credit: The amount credited due to Forced Settlements. (This amount must correspond with the Credit Column on the Sales Performance Report).

• Bad: The amount written off on the installments. (This amount must correspond with the Received / Arrears Column on the Sales Performance Report).

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.