Establishing standards for effective management information systems for MFIs

A good MIS is absolutely necessary for MFIs to manage the interface with clients and conduct activities/processes in a manner that is efficient, effective and transparent

Understanding the state of management information systems (MIS) in Indian microfinance institutions (MFIs) is very important for all stakeholders involved in Indian microfinance, and many of the issues that came up in the 2010 crisis concerned data, or the lack of it. Therefore, it is especially critical for the proposed microfinance development and regulation bill to ensure that MFIs meet certain minimum MIS standards in order to get accredited and/or licensed.

So what then are the various aspects that need to be emphasized as part of the minimum MIS requirements in the proposed microfinance bill?

Let us first understand why MIS is very important in microfinance. At the MFI level, building an efficient/effective MIS helps to manage data, information processes and activities and this is especially crucial given that microfinance involves a large number of clients with small loans with miniscule and highly repetitive repayments. An appropriate MIS also helps the institution better understand client needs, and thereby enables it to serve them with appropriate products, tailored to their cash flows. A good MIS is, therefore, absolutely necessary for the MFI to manage its interface with clients and conduct its activities/processes in a manner that is efficient, effective and transparent.

While many MFIs claim that they have an appropriate MIS in tune with global best practices, there are examplesi  to the contrary, and I quote Anna Somos Krishnan, a seasoned microfinance professional, who wrote in a candid article (21st August 2010), soon after the first Indian microfinance IPO:

"Interestingly, the authorities, this time, have given the green signal for an entity that can't prove its operational strength beyond, perhaps, its head office and a couple of system generated reports. Let's face it. SKS, till date, manually reconciles the majority of its 2,000-odd branches data and its seven million clients at the end of each month, despite the unprecedented IT investment that it made four years ago. These are the three-four years when we see the largest scale of growth in an entity. What is thought-provoking, though, is the virtually non-existent digital and automated management information systems (MIS) for trustworthy record-keeping (this means that, with one or two exceptions, MFIs have no IT systems to reliably track customer transaction data)."ii 

If what Anna Somos Krishnan has written is indeed true, then, the situation is very serious. It certainly merits the attention of various stakeholders, including the Reserve Bank of India (RBI), which is to become the sole regulator of microfinance. Without question, the regulators/supervisors would need to analyze and understand the actual state of MIS in Indian MFIs-as they are intermediating increased sums of money and dealing with a larger number of clients-in order to prevent crisis situations in the future. The key questions that need to be asked in this regard are:

1.    Given that microfinance involves large numbers of small repetitive transactions, how are Indian MFIs currently managing data and information on their clients, products, processes and activities?

2.    Do they have a fully automated MIS, or are they still completely manual, or are they using hybrid systems? Are there differences between larger and smaller institutions, for profit and not-for-profit institutions, etc? Are there challenges that Indian MFIs face with regard to implementation of robust MIS systems? What are these and how can these be addressed?

3.    Are management information systems (in Indian MFIs) integratediii  in real time across products, processes, client segments, branches and functions (like accounting and portfolio data)? If yes, how do these systems perform in real time in terms of reliability and validity of data used/generated as well as time taken for analysis and production of reports? If no, how are the MFIs, and especially those with a large number of clients and rapid growth rate, managing the crucial integration and the reliability/validity of their integrated data?

4.    Are all features/aspects of all products, for all clients in all locations available in the MIS (manual or computerized or hybrid)? What is the reliability and validity of this primary data and/or analyzed information in terms of reflecting the ground reality (accuracy mainly)? For example, there were news reports in November/December 2010 that the Andhra Pradesh government claimed, that one of the MFIs was supposedly charging 60.5% and the MFI replied saying this could have been due to an error in the conversion of data. This concerns the reliability and validity of the MIS.

5.    Is the data provided (or information/reports generated) by the MIS sufficient (for various stakeholders) in terms of content, frequency and timeliness, so as to give a meaningful picture of the MFIs' true financial position/condition and prospects? Is it suitable for decision-making and risk management from an institutional perspective?

6.    Is the data/information/reports in the MIS comparableiv  to that in other institutions and as per good practices (as well as regulator/supervisor) norms?

7.    Is data from the MIS consistent with financial and other statements that the MFI generates and uses internally to measure, manage and monitor its portfolio and other risks?

8.    Is the data from the MIS consistent with the financial and other statements that the MFI generates and files with concerned regulators on a periodic basis?

9.    Do the management information systems of Indian MFIs have transparent business rules in line with good practices, as well as regulator/supervisor norms in critical areas such as (but not limited to) :

  • Asset classification and provisioning-Including methods for determining quality of (loan) assets and related indicators (portfolio at risk, provisioning ratios, etc). Some relevant aspects here are.

 Transparency and verification must be possible with regard to the sequence of appropriation of client repayments, which needs to be as per good practices standards and regulator norms. The sequence in which client repayments must be appropriated should always be as follows - fines first (if applicable), then penal interest (if applicable), interest overdue, then interest due (if due on the date on which repayment comes in), then principal overdue and lastly, principal. If principal is appropriated first, then, while portfolio quality would appear better, the yield on portfolio would reduce and so would the profitability/sustainability of the MFI.

 The method of calculating age of a past due loan, should be through recommended best practice proceduresv .

Grace periods (in terms of days or number of installments) and the specific processvi  used by the MIS for calculating various portfolio quality indicators (like 'portfolio at risk' or PAR) must be clearly discernable and/or transparently stated, if hard-coded in the MIS. For example, client repayment could be over 46 installments across a 52-week loan term-this means that at any time, a client could have skipped six installments and still not be classified as a past due account. This has serious implications for asset classification and provisioning and it needs to be recognised. Therefore, unusually long grace periods, or repayment moratoriums, must be stated upfront in a transparent manner.

There must be standard good-practice procedures for regular monitoring and management of past, due or impaired assets/credit relationships, evaluating the adequacy of credit (loan) loss provisionsvii  and credit (loan) loss allowances, etc.

  •    Accounting policies and practices - The policies and practices followed in the MIS must be as per good practices standards prescribed by the regulator. The integrationviii  of the accounting, portfolio and other modules must also be done through a transparent process and as per regulator norms.
  • Total cost to client - The total cost for various products (interest rates, fees, all forced conditions, including credit insurance, etc) must be transparently available in MIS and capable of being compared with actual portfolio yield and/or earnings of the MFI. This will help to highlight any hidden interest charges and costs that clients often claim to pay to MFIs - an issue that has come up regularly during the 2010 micro-finance crisis
  •  Other aspects - There must be clarity and transparency in MIS with regard to risk-management aspects, including controls, ALMix  issues, exposure norms across products/regions/sectors/clients etc

10.    Given all these aspects, what are the minimum MIS standards that have to be set for enabling accreditation, and/or licensing of MFIs as per the proposed microfinance development and regulation bill?

Without question, there is a critical need to establish minimum standards for certain non-negotiables like MIS, in Indian MFIs. The Union Ministry of Finance (MoF) and the RBI should utilize this opportunity to draft the microfinance development and regulation bill to enable the microfinance industry to 'arrive' in terms of having transparent, integrated and comprehensive management information systems that really work on the ground. This indeed is a crucial first step, even before we talk of a national credit bureau, as only then would the proposed credit bureau be able to have reliable and valid (MIS) data, so necessary for reducing the occurrence of multiple, ghost and over-lending by Indian MFIs.

  iThe example of SKS is being used for illustrative purposes and I would like to state that from my own knowledge of MIS in the Indian micro-finance industry, the SKS MIS is perhaps one of the better operating systems in the Indian microfinance industry.
 iii From the perspective of users of information and enabling them to make meaningful evaluations/decisions, information from MIS should be comprehensive in terms of aggregation, and consolidation and assessment of information across products, processes, client segments, geographies and activities.
  ivData/information needs to be compared across institutions and over time. Hence, standardized procedures must be used to develop the MIS and standard definitions of indicators, and standard methods for calculating the same must be rigorously followed. This does not imply loss of flexibility, but rather suggests standard use of best practices-oriented indicators and methods for portfolio quality measurement. This is often reflected in the methodology of developing the business rules.
  vWhere age of past due loan = date of calculating age - earliest unpaid overdue (in days). Using the installment method of ageing requires adjustments to be made as this method understates age of past due loan, after the loan term and overstates age of past due loan within the loan term.
 vi While selecting past due loans for calculating portfolio at risk (PAR) of any age, the reference point is to choose every loan that has either fines, or interest, or principal overdue. Technically, it is possible to have past due loans with 'zero' principal overdue and some interest/fines overdue, and hence, using only principal overdue to determine aggregate loan outstanding of the past due loans could actually understate the risk in the portfolio
 vii In case of ageing with weekly/daily installments, define age categories based on number of installments skipped, rather than in days. This is to ensure appropriate provisioning. For example, in a weekly payment model, < 30 days past due could actually be 4/5 installments skipped. For example, the traditional 10% provisioning would not be appropriate here and a much higher provisioning may be required, depending on the context and actual ground situation.
  viiiEnsure automatic integration of portfolio and accounting modules, in that data entered in one, for example loan disbursement through the portfolio module, automatically gets reflected in the other, as loan outstanding under assets in the balance sheet. This is very critical.
  ixAsset and Liability Management

(The writer has over two decades of grassroots and institutional experience in rural finance, MSME development, agriculture and rural livelihood systems, rural/urban development and urban poverty alleviation/governance. He has worked extensively in Asia, Africa, North America and Europe with a wide range of stakeholders, from the private sector and academia to governments.) 

1 decade ago
MFIs have failed / failing because of greed and not because of not having a good a MIS. MFIs have attitude problem.
Free Helpline
Legal Credit