New Loans
Periodic Financial Summary Report: New Loans
Overview & Purpose Designed
to streamline operations across multiple branches, this report provides a
comprehensive breakdown of loan book activities for a selected
timeframe.
System Setup & Navigation
Permissions: Access the
security option via the Report section under
Roles: Access Path: Navigate to
Export Formats: Cross-Report
Verification: Values can be cross-checked against the Detailed Loan Report.
Note that the Detailed Loan Report
displays the "In Default Service Fee" inclusive of VAT,
whereas this report requires it exclusive of VAT.
Report Filters General: Branch Selection, Loan Creation Start
Date, Loan Creation End Date.
Other: Loan Status: All loans created in the period
(Active, Paid, Non-Performing, Written
Off). Group by Description Column (Loan
Products).
Report Field Mapping & Calculation Guide
Data is grouped and aggregated alphabetically by Loan
Product.
Periodic Financial Summary
Report: New Loans.MAXMONEY > Reporting >
Management and select Periodic Financial Summary
Report: New Loans.XLSX, CSV, PDF, and HTML.
Column Heading
Description & Calculation
Logic
Description
Alphabetical list of all Loan Products used during the
selected period.
Count
Total number of loan agreements created per loan product
within the period.
Avg
Capital
Sum(Total Capital per Product)
/ Count of Loans per Product
Total
Sum
of Loan Total per product.
Capital
Sum
of Total Capital disbursed per product.
Interest
Sum
of Total Interest Amount per product.
VAS
Applicable to GroupsRUs MAXUP
(where MAXUP Inception Date = Loan Agreement Date): Sum of MAXUP Product
Total Monthly Fee per product. < /FONT >
Insurance
Sum
of GLP Total Premium (incl. VAT) per product.
In Default
Interest
Sum of Total InDefaultInterestAmount per
product.
In Default Service
Fee
Sum of Total InDefaultPeriodServiceFees per product (excl.
VAT).
Initiation
Fee
Sum of Total Initiation Fee per product (excl.
VAT).
Service
Fee
Sum of Total Service Fee per product (excl.
VAT).
VAT
Total VAT calculated as: VAT(Initiation Fee)
+ VAT(Service Fee) + VAT(In Default Service Fee).
Change
Static value: 0.
Totals
A
grand total row aggregating values for each column across all loan
products.