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.
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
#004 - Market Research Report
Description:
​
​Shows the market research of the existing MFIs in the respective township.
Output:
​
-
Date
-
Division
-
Township
-
Institutions
-
Institution Name
-
Borrowers
-
Households
-
Adjusted penetration rate
Built-In 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