Cancelled Loans

Cancelled Loans

Periodic Financial Summary Report: Cancelled Loans

Overview

Designed to streamline internal operations across multiple branches, this report provides a comprehensive breakdown of cancelled loans for a selected timeframe.

Related Documents

Filter Logic vs. Detailed Loan Report: Unlike the Detailed Loan Report—which filters by loan creation date when selecting "Cancelled" status—this report filters strictly by the cancellation date. It includes only loans that transitioned from Active to Cancelled (excluding initial Application cancellations) within the specified period.

Access & Security

Permissions: Security options are managed under Role > Report Section > Periodic Financial Summary Report: Cancelled Loans.
Navigation: Access via Reporting > Management > Periodic Financial Summary Report: Cancelled Loans.

Report Filters

General: Branch Selection, Loan Creation Start Date, Loan Creation End Date.
Other: Loan Status, All Loans Created in Period (Cancelled Status), Group by Description Column (Loan Products).
Export Formats: Available in .xlsx, .csv, .pdf, and .html.

Report Columns & Calculations

Column Heading	Description & Calculation Logic
Description	Alphabetical list of Loan Products used during the period. Grouped and summed per product.
Count	Total number of cancelled loan agreements per product within the period.
Avg Capital	`Total Capital of Loan Product ÷ Count of Loans per Product`
Total	Sum of Loan Total per product.
Capital	Sum of Total Capital per product.
Interest	Sum of Total Interest Amount per product.
VAS	GroupsRUs MAXUP only (MAXUP Inception Date = Loan Agreement Date). Sum of MAXUP Product Total Monthly Fees per product.
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	Sum of VAT from Initiation Fee + Service Fee + In Default Service Fee.
Change	Fixed value: `0`.

Note: A Grand Total row is appended at the bottom of the report for each calculated column.

MAXMONEY Developed by MYCOMAX MICROFINANCE SOLUTIONS. Novamesh 03/09/2026