This report provides a comprehensive list of all loans, including their payment to client information, for a specified period. You can print, view, or email the report.

MaxAdmin Setup

There is no specific setup required in MaxAdmin for this report.

MaxMoney Setup

Resources

To enable access to this report, navigate to Setups > Security > Roles and ensure the Payment to Client resource is enabled for the relevant role.

How to Access the Report

In MaxMoney, go to Reporting > Loan > Payment to Client Report.

Report Filters

You can refine your report results using the following filters:

General

• Branch: Generate the report for loans created at a specific branch.

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

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

• File Format: Choose between XLSX and XLS formats for the report output.

Client

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

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

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

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

Loan

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

• Loan Date start and end: (Required field) Enter the starting and ending dates in DD/MM/YYYY format to generate the report for loans written off within that specific date range (based on the Bad Debt Written Off Date).

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

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

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

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

Employer

• Employer Search: Use an asterisk (*) to list all employers. You can select a specific employer or all. Type the whole name or part of the employer's name and click the Search button. The result(s) will display in the employer drop-down list.

• Employer: Generate the report for loans of clients with a specific employer.

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

• Employer Classification: Generate the report for loans of clients based on a specific employer classification.

• Employer Economic Sector: Generate the report for loans of clients belonging to a specific employer economic sector.

Report Generation and Output

Once you've set your filters, click the Finish button to generate the report.

Processing Status

This report will be generated under Processing Status.

1. Click on the hyperlink to navigate to the Processing Status page.

2. Wait until the report status is Completed. You can refresh the Processing Status page by clicking the Submit button.

3. 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 XLSX format. Click on the hyperlink to open or download the report.

Report Columns

The report displays the following information:

Client

• Client No: The client number.

• Client Initials

• Name

• Surname

Loan

• Loan No.

• Loan Payback Type: The method the borrower will use to repay the loan.

• Total Loan Capital: The amount borrowed from the credit provider.

• Payout to Client: The amount paid directly to the client.

• Exported: Indicates if the loan has been exported to a payout file.

• Payout to 3rd Party: The amount paid to a third party.

• Agreement Date: The loan date.

• Payment Source Description: A description of the payment to client event.

Bank

• Bank: The name of the borrower’s bank.

• Branch: The branch number.

• Account No.: The bank account number.

• Account Type: The type of bank account.

Record Creation

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

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

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

Loan Activation

• User Activated Loan: The user who activated the loan, determined from the Loan Log table's Update User.