This report provides a list of future fees that are yet to be charged on Active loans, based on their contracted amounts.

MaxMoney Setup

Resources

To enable access to this report, go to Setups > Security > Roles and enable the Loan Future Outstanding Fees resource for the relevant role.

How to Access the Report

In MaxMoney, go to Reporting > Loan > Loan Future Outstanding Fees.

Report Filters

This report does not have any filters.

Buttons (Filter Page)

• Finish: Select this button to generate the report.

• Cancel: Select this button to cancel this request.

Processing Status

This report will be generated under Processing Status.

1. Click 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 the report name to navigate to the next page where you can download the report.

Output

The report will be generated in the following formats:

• XLSX: Click the hyperlink to open or download the report.

• HTML: Click the hyperlink to open or download the report.

• PDF: Click the hyperlink to open or download the report. You can view your PDF document in the Mozilla Firefox browser (version 124.0.1 or newer).

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 return 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:

Client

• Client No: The client number.

• Client Name and Surname

Loan

• Loan Agreement Date: The date on which the loan was activated and the payment was distributed to the borrower.

• Loan Agreement No.: The unique loan number on the entity.

• Loan Status: The current status of the loan.

• No of Payments: The number of installments.

• No of Interest Periods: The loan term in months.

• Frequency: The payment frequency (e.g., Monthly, Weekly, Fortnightly, Cycle, or By Schedule).

• Loan Product

• Loan Amount: The capital amount.

• Contracted Initiation Fee, Incl VAT: The initiation fee as per the contract.

• Initiation Fees Already Charged: Initiation fees already recorded through loan transactions.

• *Future Initiation Fees: The difference between the contracted fee and the already charged fee.

• Contracted Service Fee, Incl VAT: The service fee as per the contract.

• Service Fees Already Charged: Service fees already recorded through loan transactions.

• In Default Service Fees: Service fees charged if the loan is in default.

• *Future Service Fees: The difference between the contracted service fee (plus in default service fees) and service fees already charged.

  • Formula: (Contracted Service Fee Incl VAT) + (In Default Service Fees) - (Service Fees Already Charged)

• Contracted Interest Amount: The interest amount as per the contract.

• Interest Already Charged: Interest already recorded through loan transactions.

• In Default Interest Amount: Interest charged if the loan is in default.

• *Future Interest Amount: The difference between the contracted interest amount (plus in default interest amount) and interest already charged.

  • Formula: (Contracted Interest Amount) + (In Default Interest Amount) - (Interest Already Charged)

• Contracted GLP: GLP (Gross Loan Portfolio) as per the contract.

• GLP Already Charged: GLP already recorded through loan transactions.

• *Future GLP Charges: The difference between the contracted GLP and GLP already charged.

• Loan Branch