Overview

The Loan Handover Report provides a comprehensive list of all loans that have been written off within a specified period. This report is essential for tracking bad debts and facilitating the handover process for recovery or further action. You have the flexibility to print, view, or email the generated report.

MaxMoney Setup

Resources

To access this report, the relevant security option must be enabled under the Report Section of the user's Role:

• Report -> Loan Handover Report

How to Access the Report

To generate the Loan Handover Report, follow these steps:

1. Navigation: Go to Reporting -> Loan -> Loan Hand Over Report.

Report Filters

The report offers various selection options to refine the data, allowing you to drill down information, for example, to a specific branch level. The following filters are available:

GENERAL

• Branch: Generate the report for loans originated from a specific branch.

• Region: Generate the report for loans created by branches linked to a specific region.

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

TRANSACTION

• Default Start Date:

  • Required Field.

  • Format: dd/mm/yyyy.

  • Use this to define the beginning of the date range for loans written off (based on the Bad Debt Written Off Date).

• Default End Date:

  • Required Field.

  • Format: dd/mm/yyyy.

  • Use this to define the end of the date range for loans written off.

Buttons

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

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

Processing Status

After clicking "Finish," the report will be generated under Processing Status.

1. Monitor Status: Click on the hyperlink to view the processing status.

2. Refresh: Refresh the processing status page by clicking the Submit button until the report status changes to Completed.

3. Download Report: Once the report status is "Completed," click on the report name to navigate to the next page where you can download the report.

Output

The report will be generated in the following format:

• XLSX: Click on the hyperlink to open or download the report in Excel format.

Output Page Buttons

• Back to processing status: Select this option to return to the processing status page.

• Back to Filter Option: Select this option to return to the report filter page for this specific report.

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

  • Prerequisites: Users who are to receive reports via email must be set up in advance under Setups -> Reporting -> Reports Email Setup. Additionally, these users must have valid email addresses configured in their user setup under Setups -> Security -> Users.

Report Columns

The generated report will include the following columns:

CLIENT

• Client No: The unique client number.

• Client Branch: The home branch associated with the client.

• Client Name: The first name of the client.

• Client Initials: The initials of the client.

• Client Surname: The surname of the client.

• ID Number: The client's identification number.

• Home Tel. No.: The client's home contact number.

• Cell Phone No.: The client's cell phone number.

• Work Tel. No.: The client's work contact number.

• Physical Address: The client's physical address (e.g., Section 129 HomeTown).

• Physical Address Code: The physical address code (e.g., Section 129 Home Code).

• Postal Address: The client's postal address.

• Postal Address Code: The postal code.

• Email Address: The client's email address.

EMPLOYER

• Employer Name: The name of the client's employer.

• Employer No.: The employer code.

• Employer Address: The physical address of the client's selected employer (as per payslip).

• Employee Code: The client's employee number (as per payslip).

• Occupation: The client's occupation under Employment.

• Department: The client's department under Employment (as per payslip).

• Gross Salary: The client's gross salary under Financial (Payslip Basic Salary).

• Net Salary: The client's net salary under Financial.

BANK

• Bank Name: The name of the client's bank.

• Account No.: The client's bank account number.

PAYMENT

• Last Payment Date: (Currently displays incorrect value).

• Loan No.: The unique loan number.

• Loan Product: The type of loan.

• Loan Date: The Loan Agreement Date.

• Payment Frequency: The frequency setup on the client's payback information.

• Payment Day of Month/Week: The payment date setup on the client's payback information.

• Interest Rate: The monthly or annual interest rate of the loan.

• No. of Instalments: The total number of repayments on the contract.

IN DEFAULT

• Default Date: (Currently displays incorrect value).

• Written Off Date: The date when the loan was officially written off.

• Days in Arrears: Calculated as (End Date of Report) minus (Due Date of first unpaid instalment). This is also derived from the Loan Final Instalment Agreed date plus Grace Days, representing the highest date of the loan transaction on the client (most recent receipt on the client).

• Original Loan Amount: The initial capital loan amount disbursed to the client.

• Loan Total: The total repayment amount (Capital + fees + interest).

• Outstanding Amount: The Loan Total minus the Amount Received on the Loan.

RECORD

• Record User: The user who created the loan application.

• Record Date: The date on which the loan and its instalment(s) were created.

• Record Time: The time at which the loan and its instalment(s) were created.