Overview

The Detailed Loan Lite report provides a comprehensive list of all loans created within a specified date range.

Report Columns

The report includes the following columns:

• Loan Agreement Date

• Client No (File No)

• Client Surname

• Client Initials

• Loan No

• Loan Status

• Cash Box (Paypoint)

• User (Operator)

• Payment to Client (Description)

• Loan Total (Repayable)

• Loan Capital Amount

• Interest Amount

• Fees (Cost): This includes Admin Fee, Prep Bus Fee, SF, IF, and Variable Charges Fees (excluding VAT).

• VAT

• Insurance: This includes GLP, CPI, and Variable Charges Insurance (excluding VAT).

• Default Charges (Late Interest): This includes Default Interest, Default Services Fees, and Variable Charges - In Default (excluding VAT).

Setup

• MaxMoney Setup:

• Resources: To enable this report, navigate to Setups > Security > Roles and enable the Detailed Loan Enhanced Report resource.

How to Access the Report

You can access the Detailed Loan Lite report in MAXMONEY through two methods:

1. Go to Setups > Reporting Scheduled Report Setup.

   • Select Detailed Loan Lite report.

   • Choose the desired Loan statuses: Active, Paid, Non-performing, and Written Off.

2. Go to Reporting > Loan > Detailed Loan Report - Enhanced.

   • Select Lite Report.

File Format

You can generate the report in the following formats:

• Xlsx

• Pdf

• Html

• CSV

Report Filters

The report offers various selection options to refine your search and drill down into specific information.

Lite Report

• Lite Report: Select this option to display only the columns relevant to the Lite report.

Loan Branch

• Loan Branch: Generate the report for loans associated with a specific branch.

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

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

Client

• Client Branch: Generate the report for loans of clients associated with a specific home branch.

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

• Client Status: Generate the report for loans of clients with a specific 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 specific bank.

Loan

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

• Loan Date Due Start and End: Generate the report for loans due within a specified period.

• 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: To list all employers, use a star (*). You can select a specific employer or all of them. To search, type the full or partial employer name and click the Search button. The results will appear in the employer drop-down list.

• Employer: Generate the report for loans of clients associated 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 with a specific employer classification.

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