EXISTING MCIX CUSTOM REPORTS LIST
Please check out the existing MCIX Custom Reports list below. If the report you want is not included in this list, you can also request a new report to MCIX Team.
Existing Custom Reports
#001 - Percentage of borrowers who have only one loan within the organization
Description
For the requested MFI, the percentage is calculated as borrowers with one loan/all borrowers within the organization.
Output:
-
Total # of borrowers
-
Total # of non-overlapped borrowers
-
Percentage
#002 - Overlap Details Report
Description
Shows the details of clients’ information with two or more overlapped loans by township within the organization for the requested MFI.
Output:
-
Reporting
-
ThitsaID
-
NRC
-
Original NRC
-
Township Code
-
Township
-
MFI Name
-
MFI Count
-
Loan Count by MFI
-
Total Loan Count
#003 - Overlap Loan Details Report
Description:
Shows the details of clients and loans information with two or more overlapped loans by township within the organization for the requested MFI.
Reporting
Output:
-
Reporting
-
ThitsaID
-
NRC
-
Original NRC
-
Division
-
Township Code
-
Township
-
Ward/ Village
-
Address
-
MFI Name
-
Client Name
-
Gender
-
Father Name
-
DOB
-
Loan GUID
-
Fund Source
-
Disbursed Date
-
Loan Status
-
Days In Delay
-
Principal WriteOff Amount
-
WriteOff Date
-
Delinquent Status
-
Active
-
Delinquent
-
Overlap
-
WriteOff
Existing Reports List
These are the existing reports list which are already provided in the MCIX portal. If the report you want is not included in this list, you can also request a new report to MCIX Team.
#001 - Credit Report
Description
Shows a list of borrowers’ loan information (past and present information of the borrowers) as a report format according to the reciprocal rule, only the data of the field you uploaded will be displayed. (grouped by MFI)
Output:
-
Loan Information
-
Write-off Loan Information
-
Credit Score
-
User Trend
#002 - Overlap Notifications
Description
Shows a list of your clients with three or more overlapped loans
Output:
-
Full NRC
-
ThitsaID
-
Institution
-
Updated – updated month
-
Location
-
Note
#003 - Risk Notifications
Description
Shows a list of your active clients recently written off at other MFIs
Output:
-
Full NRC
-
ThitsaID
-
Institution
-
Updated – updated month
-
Location
-
Note
#004 - Writeoff Notifications
Description
Shows a list of your written-off clients who recently took new loans at other MFIs
Output:
-
Full NRC
-
ThitsaID
-
Institution
-
Updated – updated month
-
Location
-
Note
#005 - Overlap Summary
Description
Shows the number of overlapped loans count and percent by township
Output:
-
Loan counts
-
MFIs Name
#006 - Overlap Details
Description
Shows the details of clients with three or more overlapped loans by township
Output:
-
6 digits of NRC
-
Total – Loans counts
-
Overlapped MFIs Name
#007 - Overlap Trend
Description
Shows the overlapped summary as trend, the number of overlapped loans count and rate by township
Output:
-
Loan counts
-
Institution
-
Months
-
Percent
#008 - Upload (Active)
Description
Shows the number of active borrowers, difference between last month and current month of each MFIs
Output:
-
Institution
-
Number of borrowers
-
Months
#009 - Upload (Writeoff)
Description
Shows the number of write-off borrowers, difference between last month and current month of each MFIs
Output:
-
Institutions
-
Number of records
-
Months
#010 - Upload (Problematic)
Description
Shows the list of MFIs that are having problems with uploading the data
Output:
-
Institutions
-
Division
-
Township
-
Number of borrowers (stated)
-
Number of borrowers (uploaded)
-
Percentage
-
Is Problematic
#011 - Number of Searches (per user)
Description
An internal audit shows how many NRCs that a user searches for inquiry within the range of township
Output:
-
Number of searches
-
Number of inquiries
-
Username
#012 - Number of Searches (per month)
Description
An internal audit shows how many NRCs are being searched for the month within the range of township by the organization.
Output:
-
Number of searches
-
Number of inquiries
-
Year Month
#013 - Adjusted Penetration Rate
Description
Shows the adjusted penetration rate based on household list of MIMU and borrower data on MCIX by divisions within a certain month
Output:
-
Month
-
Division
-
Township
-
Borrowers
-
Households
-
Adjust Penetration Rate
#014 - Search Audit Overview
Description
Shows the number of searches of all users in the organization within a certain period, the number of regular and off-hour searches for NRCs and townships
Output:
-
User ID
-
Total # of NRC searched
#015 - Search Audit Details
Description
Shows the details for the number of searches of all users in the organization within a certain period, the number of regular and off-hour searches for NRCs and townships
Output:
-
Searched Date
-
Searched Time
-
Searched NRC
#016 - Company Profile Statistics
Description
Shows aggregate information/trend, where you can review the records to see if the data uploaded is actually entered or not
Output:
-
Month
-
MFI
-
Active borrowers (stated)
-
Active borrowers (uploaded)
-
Active townships (stated)
-
Active townships (uploaded)
-
Total principal write-offs (stated)
-
Percentage