Pentaho Reports in Mifos

With Mifos 2.0.x and above, Mifos supports reports in Pentaho.

Management Reports

Operational Reports

Management Reports

MFI Progress

This report shows a comparison of 2 months specified by the user of the MFI's metrics, arrears, loan balances, etc.  This report can be run down to the branch office level as well.  This report is useful in providing information on progress at the MFI - for example, if they are expanding their outreach at a certain pace, or if their PAR has increased or decreased.  This report can also help the MFI see if certain branch offices are doing better or worse than others.

PDF Sample - MFI Progress Report (.pdf)

Loan Officer Detailed

This report allows the MFI to see detailed metrics per Loan Officer, such as the branch offices they have been at, the number of centers they manage, and arrears and loan portfolio information.  This report should be used to assess a LO's performance, and also see key statistics about their management.

PDF Sample - Loan Officer Detailed Report (.pdf)

Client Exit

This report lists all clients that have been changed to a Closed status in Mifos for a particular branch office or group level, their closed status, reason, notes, and # of loans they had.

PDF Sample: Client Exit (.pdf)

PPI Data Dump

This report is an export in CSV format that lists all clients with PPI data, details about client, and their PPI scores and likelihoods relevant for their country.

.CSV Sample - PPI Data Dump (.csv)

Operational Reports

 

Loan Officer Performance Summary (cumulative)

This report allows the MFI to compare Loan Officers by certain measures such as arrears amounts, PAR, etc.  This report helps the MFI assess Loan Officer's performance.  Data shown in this report is cumulative as of end date of report.

PDF Sample - Loan Officer Performance Summary (cumulative) (.pdf)

Loan Officer Performance Summary (during period)

This report allows the MFI to compare Loan Officers by certain measures such as arrears amounts, PAR, etc.  This report helps the MFI assess Loan Officer's performance.  Data shown in this report is for during the period stated.

PDF Sample - Loan Officer Performance Summary (during period) (.pdf)

Balance Outstanding

This report shows outstanding balances of loans or savings accounts based on filters selected, such as office, loan officer, product, and account status, as of a certain date.  It is also possible to group the accounts by group, LO, or branch office, and get totals for each.

PDF Sample: Balance Outstanding (.pdf)

Savings Accounts

Field Definition
Account ID Short Mifos ID of Account
Client Name Name of Client the Account belongs to
Balance Amount Balance of Savings Account as of the date the report was run
Saving Status Account Status
Date of Opening Date the Account became Active
Gender Gender of Client the Account belongs to
Group Name Name of Group the Client belongs to
Loan Officer Loan Officer as of date

Loan Accounts

Field Definition
Account ID Short Mifos ID of Account
Client Name Name of Client the Account belongs to
Loan Amount Amount of Loan Disbursed
Balance Amount Outstanding Balance of Loan Account as of the date the report was run
Loan Status Account Status
Disbursal Date Date the Account became Active
Gender Gender of Client the Account belongs to
Group Name Name of Group the Client belongs to
Loan Officer Loan Officer as of date
Source of Funds Source of Funds for Loan Account

 

Balance Outstanding by Source of Funds

This report shows balance outstanding and other figures per source of funds in Mifos.  This report helps the MFI give figures to their Funders on loans sourced by that fund.

PDF Sample: Balance Outstanding by Source of Funds (.pdf)

Branch Expected Cash Flow

This report shows expected in and out cash flow for branch per day for the period specified.  This report includes Principal, Interest, Loan Fees, and any Client, Group, or Center Fees (under Client Fees).  This report does not include savings.

PDF Sample: Branch Expected Cash Flow (.pdf)

Center Collection Sheet

This collection sheet is optimized for centers, and for MFIs that collect only at meetings. MFIs from India would typically use this collection sheet.

PDF Sample: Center Collection Sheet (.pdf)

Group Collection Sheet (MPESA)

This collection sheet report is optimized for groups and also for MFI's that may collect between meetings, through a system like MPESA (mobile payments) where payments are imported into Mifos before the meeting occurs.  Collected columns are populated with prepayments for loans. This report would typically be used in regions like Kenya where the center model is not used. 

PDF Sample - Group Collection Sheet (MPESA) (.pdf) 

 

Due vs Collected by Branch

This report shows what was due and collected for loan repayments for one or more branches.  This report should be run frequently to verify amounts that were collected.  This report can also help the MFI determine if collections were under or over what was expected for the branch.

PDF Sample: Due vs. Collected by Branch (.pdf)

Field Definition
Principal Due Principal due for that branch's loan repayments on the repayment date specified - does not take into account prepayments or arrears
Interest Due Interest due for that branch's loan repayments on the repayment date specified - does not take into account prepayments or arrears
Principal Arrears Due Principal that was overdue for that branch's loan repayments on the repayment date specified
Interest Arrears Due Interest that was overdue for that branch's loan repayments on the repayment date specified
Principal Collected Principal that was paid (both due and overdue) for that branch's loan repayments on the repayment date specified
Interest Collected Interest that was paid (both due and overdue) for that branch's loan repayments on the repayment date specified

Due vs Collected by Center

This is the same report as Due vs Collected by Branch, except it can be filtered further by Center.  This report helps to see what a specific center collected versus what was due.

PDF Sample: Due vs. Collected by Center (.pdf)

Due vs Collected by Loan Officer

This is the same report as Due vs Collected by Branch, except it can be filtered by Loan Officer.  This report helps to see what a specific Loan Officer collected versus what was due.

PDF Sample - Due vs. Collected by Loan Officer (.pdf)

Funds Movement

This report shows loan accounts by source of funds, and information about each of them such as Loan Disbursal Dates, # of Installments, etc.  This report can help the MFI see details of loan accounts for a specific source of funds.  This report can be run to drill down into any problem loan accounts associated with a source of fund.

PDF Sample - Funds Movement (.pdf)

Loan Classification by Product

This report displays metrics by loan product.  This report helps to differentiate each product the MFI offers, and helps the MFI assess if any changes should be made to their loan products based on the metrics.

PDF Sample - Loan Classification by Product Report (.pdf)

Filter Description
Date Range Period to run report for
Office Head Office down to Branch Office selected
Field Definition
Product Name Name of Loan Product
# of Loans Disbursed (During Period) Number of Loans disbursed during date period specified
Amount Disbursed (During Period) Amount of Loans disbursed during date period specified
# of Loans Disbursed (Cumulative) Number of Loans disbursed cumulative by end of period for that loan product
Amount Disbursed (Cumulative) Amount of Loans disbursed cumulative by end of period for that loan product
Amount Outstanding (End of Period) Principal Outstanding at end of period for that loan product
Arrears (End of Period) Principal in Arrears at end of period for that loan product
PAR (End of Period) Portfolio at Risk at end of period for that loan product
# of Active Loans (End of Period) Number of Active Loans (Active in Good or Bad Standing Status) at end of period for that loan product
% of Portfolio Amount (End of Period) Principal outstanding at end of period for this loan product divided by total principal outstanding * 100

Loans Pending Approval

This report shows all loans that are in pending approval status for a particular period, and also by loan officer and loan product.

PDF Sample - Loans Pending Approval (.pdf)

Loans To Be Disbursed

This report shows all loans that have been approved, but not yet disbursed, for a particular period, and also by loan officer and loan product.

Loans To Be Disbursed (.pdf)

Mifos Transactions - Detailed

This report can be run at the end of day to display all transactions made in Mifos that day.  This report shows each detailed transaction.  This report is useful for reconciliation with accounting.

PDF Sample - Mifos Transactions - Detailed Report (.pdf)

Mifos Transactions - Summary

This report is similar to the Mifos Transactions - Detailed report, except it groups transactions by Receipt ID, and shows totals for each group of transactions by Receipt ID.  This report is useful if reconciliation at the MFI is by Receipt ID.

PDF  Sample - Mifos Transactions - Summary (.pdf)

 

0
Your rating: None
Posted by kchau on January 23, 2011 at 6:17pm