Overview

The Opportunity Variance Report allows microlenders to analyze whether a borrower was undersold. It aggregates specific loan details alongside client profiles and financial metrics to provide a comprehensive view of potential vs. actual loan values.

Accessing the Report

The Opportunity Variance Report can be generated on-demand or automated as part of your scheduled reporting suite.

• On-Demand Generation: Available under Reporting > Loans > Opportunity Variance Report.
• Scheduled Reports: To automate this report, navigate to: MAXMONEY > Setups > Reporting > Scheduled Reports

Permissions

The user will need the “Opportunity Variance Report” resource on his role.

Report Behavior and Formatting

• Data Structure: The report displays one entry per loan within the selected date range. No grouping is applied, meaning a client will appear multiple times if they have multiple loans within the period.
• Output Formats: The report can be generated in XLSX, HTML, and CSV formats.

Filter Criteria and Parameters

When running the report, please note how the following parameters behave:

• Date Range: Filters data based on the Loan Agreement Date.
• Branch & Sales Person: Filters based on the Client's assigned branch/salesperson, rather than the loan's origin.

Report Columns

The report includes the following information: Client No.,Client ID No.,Client Name,Client Surname,Client Status,Client Branch,Client Sales Person,Client Gross Salary,Client Net Salary,Available For Instalment Amount,Employer,Agreement/Application Date,Agreement No.,Loan Status,No. of Payments,No. of Interest Periods,Frequency,Loan Product,Loan Amount,Total,Instalment Amount,Record User,Record Date,Record Time.