The Monthly Reconciliation Report helps you effectively track and analyze loan performance, identify trends, and ensure accurate reporting.

MaxMoney Setup

Resources

Access to this report is controlled by the Security option, which can be configured under Report -> Monthly Reconciliation Report within the Role Setup.

How to Access the Report

In MaxMoney, go to Reporting -> Loan -> Monthly Reconciliation Report.

Report Filters

You can refine your report results using the following filters:

General

• Loan 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.

• Start and End Date: Generate the report for a specific monthly period.

Buttons (Filter Page)

• Finish: Select this button to generate the report.

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

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

Buttons (Output Page)

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

• Back to Filter Option: Select this option to go back to the report filter page.

• Email Report: Select this button to receive this report via email. Users who can 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 report displays the following information:

Loan

• Date: The date when the loan agreement or application was created.

• Number: The total number of loans created during the selected month.

• Loan Amount: The total loan amount disbursed during the month.

• Interest: The total interest accrued on loans during the month.

• Initiation Fee: The total initiation fees collected during the month.

• Service Fee: The total service fees collected during the month.

• CPI Fees: The total CPI fees collected during the month.

• VAT: The total VAT amount collected on initiation, service, and CPI fees.

• Total: The total loan amount repayable by customers.

Payments

• No of Payments: The number of loan payments received during the month.

• Amount: The total amount of loan payments received during the month.

Arrears

• No of Loans: The number of loans in arrears at the end of the month.

• Amount: The total amount of loans in arrears at the end of the month.

• Percentage: The percentage of loans in arrears at the end of the month.