The Detailed Loan and Payment Report provides a comprehensive breakdown of loan performance and payment history. This report builds upon the standard Detailed Loan Report by incorporating five additional fields for more granular financial analysis. The report is built for Variable Charges type loans.

Accessing the Report

To view this report, you must have the "Detailed Loan and Payment Report" resource assigned to your user profile. To generate the report, navigate to Reporting > Loan > Detailed Loan and Payment Report.

New Data Fields

In addition to the standard loan data, this report includes the following five columns:

• Total Monthly Instalment : Calculated as Loan Total / Number of Instalments.
• Number of Instalments Paid : The count of instalments for each loan currently in a PAID status.
• Total Capital Paid : Calculated using conservative methodology.*
• Total Fees Paid : Calculated using conservative methodology.*
• Total Interest Paid : Calculated using conservative methodology.*
• Last Receipt Amount
• Last Receipt Capital: Calculated using conservative methodology.*
• Last Receipt Fees: Calculated using conservative methodology.*
• Last Receipt Interest: Calculated using conservative methodology.*

*Note: For a full breakdown of the logic used for the three financial fields above, please refer to the Conservative Calculation method.

Report Customization & Filters

You can refine the data generated in this report by applying one or more of the following filters: Loan Branch, Region, User, Client Branch, Client Number range, Client status, payment frequency, bank, loan number range, loan date range, loan status, loan product, payback type, salesperson, employer, employer classification and economic sector.