What reporting does MFI management need?
At a minimum, reports must: • Compare expected loan payments with actuals on a payment by payment basis (broken out by branch, field officer). • Develop derivatives of the above data that provide a portfolio aging report and the statistics on arrearages or late payments. • Show exceptions that indicate which branch, which product and which field officer are falling behind in targets for client retention, savings deposits, and non-payments. • Aggregate summary reports that allow accounting entries to be made at the head office – expected loan disbursements next week, expected loan payments, total owed in interest on savings, etc. Additionally, examples of additional reports may: • Identify duplicate borrowers – people who take loans out from two branches • Allow loan officers to move from branch to branch and for productivity reports to be tied to those movements. • Track loan limitsi.e., any loan can be up to 50% of the groups balance.
