Built-in Standard Reports

Built-in Mifos Report Templates

Mifos ships with a set of five report templates that have been built using BIRT, a GUI tool used to design reports. Users can use these report templates as is, they can edit templates to suit their own needs by changing the layout or adding/removing fields, or they can build their own reports. Report templates are grouped into categories that can be defined and edited by users with the appropriate permissions. A user can attach permissions to a report to specify who can view, edit, and categorize the report.

Generate a report. A user generates a report by selecting it from the Reports tab. The data included in the report is based on the user’s data scope and the parameters entered when generating the report. The report is displayed in PDF format, which can be downloaded. Accessing and using these reports does not require that BIRT (Business Intelligence and Reporting Tools) be installed. More information regarding the generation of each built-in Mifos report is provided later in this section.

Edit a report category. Mifos ships with a standard set of report categories that are used to organize report templates. These can be viewed, edited, deleted, and added to from the Admin tab. Report templates are assigned to categories and displayed under these categories on the Report tab.

Build a new report. Users can design and build their own report templates using either Java or SQL. They first need to download and install BIRT. For step-by-step instructions on how to build a report template in BIRT, see http://www.mifos.org/developers/wiki/HowToCreateBIRTReport.

Customizing Built-in Reports

MFIs can customize reports that ship with Mifos in the following ways:

  • Add/remove data fields displayed on reports
  • Add permanent field-level filters to the reports. For example, exclude a particular loan product from all loan portfolio calculations
  • Add filters to an existing field. For example, for a data field that displays the total outstanding loan amount, an MFI can add a filter so that the field displays the total outstanding loan amount for women clients. Users can also use custom fields as a way to filter information in a report.
  • Change the report layout by, for example, switching from a horizontal to vertical orientation or adding organizational logos or changing the report title.

MFIs can also hide reports that are not used, so that they do not appear on the Reports tab.

The report templates that ship with Mifos are described in the following paragraphs.

Overview of the Standard Reports

  • Collection Sheet Report: Helps Loan Officers organize and prepare for their repayment collection meetings with clients and groups.
  • Branch Cash Confirmation Report: Assists management and accounting in tracking daily cash inflows and outflows.
  • Branch Progress Report: Helps management monitor office progress.
  • GL Report (Mifos 1.6.x): Lists transactions by GL code
  • Detailed Aging Portfolio at Risk (Mifos 1.6.x):

You generate reports from the Reports tab. To change how the reports appear on the Reports tab or to edit the appearance of the reports themselves (by editing or creating your own reports templates), use the View report templates and Upload report templates links under Manage Reports on the Admin tab.

Collection Sheet Report

Loan officers use collection sheets, generated through the Mifos reporting feature, to identify the amount to be collected in the field from each client/group on meeting day or scheduled payment day. Information for the collection sheets is stored in a table listing the amounts that need to be collected from each client, including loan repayments, fees, penalties, recommended savings amounts, and any other dues that need to be collected. The reports also provide the amount of money that should be disbursed to each client at the meeting. The sheets are generated by selecting the Collection Sheet Report link from the Reports tab, and then selecting the branch, loan officer, and loan product for the report.

The repayment figures on a collection sheet cannot be updated after the meeting day. If a collection sheet is generated for a past meeting day, the system will still display the status of each account prior to collections made at the meeting.

To generate a Collection Sheet Report:

  1. On the Reports tab, click Collection Sheet Report.
  2. Select values for Branch, Loan Officer and Center.
  3. Enter the date of the meeting for which you want to run a report.
  4. Click Generate.

To create your own Collection Sheet Report template:

  1. On the Admin tab, click View report templates under Manage Reports.
  2. To use the default Collection Sheet Report as a starting point for creating your own template, click the Download link for Collection Sheet Report.
  3. Save CollectionSheetReport.rptdesign locally.
  4. Open the above file in BIRT RCP Designer and give it a new name, thus preserving a backup.
  5. Edit your version of the .rptdesign file in BIRT.
  6. In Mifos, use the Upload link under Manage Reports on the Admin tab to upload your new report template.

Branch Cash Confirmation Report

The Branch Cash Confirmation Report lists a branch's daily cash inflows and outflows and is used to tally the day's accounting books. This report is typically used by management as well as accounting departments. 

The report is filtered by branch office and lists total per loan product of amounts for principal, interest, fees, and total, and the same for what's due and what's in arrears for a certain date. 

To generate a Branch Cash Confirmation Report:

  1. On the Reports tab, click Branch Cash Confirmation Report.
  2. Select a Branch.
  3. Enter a date.
  4. Click Generate.

To create your own Branch Cash Confirmation Report template:

  1. On the Admin tab, click View report templates under Manage Reports.
  2. To use the default Branch Cash Confirmation Report template as a starting point for creating your own template, click the Download link for Branch Cash Confirmation Report.
  3. Save BranchCashConfirmationReport.rptdesign locally.
  4. Open the above file in BIRT RCP Designer and give it a new name, thus preserving a backup.
  5. Edit your new .rptdesign file in BIRT.
  6. In Mifos, use the Upload link under Manage Reports on the Admin tab to upload your new report template.

Note: Currently this report is hardcoded to extract data from a database named 'mifos'.  If you have changed the name of the Mifos database, the report needs to be updated with the correct database.

Branch Progress Report

 

This branch-level report is consumed by the management and serves as a valuable aid in monitoring the progress of the office and making forward-looking decisions. It can be generated for any data in the past allowing comparative studies and trend analyses. It consists of a summary of active members and PAR, a detailed PAR analysis showing those loans at risk and in arrears, a breakdown of total funds disbursed and collected across our portfolio of loan products, and finally an assessment of staff based on number of clients handled, loans disbursed, and amount in arrears.

Mockup/Spec: Branch Progress Report Mockup

Sample PDF: Sample Branch Progress Report

To generate a Branch Progress Report:

  1. On the Reports tab, click Branch Progress Report.
  2. Select a Branch.
  3. Enter the date as of which you want information.
  4. Click Generate.

To create your own Branch Progress Report template:

  1. On the Admin tab, click View report templates under Manage Reports.
  2. To use the default Branch Progress Report template as a starting point for creating your own template, click the Download link for Branch Progress Report.
  3. Save BranchProgressReport.rptdesign locally.
  4. Open the above file in BIRT RCP Designer and give it a new name, thus preserving a backup.
  5. Edit your version of the .rptdesign file in BIRT.
  6. In Mifos, use the Upload link under Manage Reports on the Admin tab to upload your new report template.

 

Detailed Aging Portfolio at Risk Report

This report lists all loans that match the selected parameters and are in Active bad standing.

A user with the appropriate permissions selects this report from the Reports tab. The user then specifies the parameters for the report, including the Branch Office, the Loan Officer, and the Loan Product. The choices displayed for the Loan Product include all loan products that exist for the entire MFI, including inactive ones, since there can still be active loan accounts for inactive products. The choices available for Branch Office and Loan Officer depend on the user’s data scope, as follows:

  • If the user is a loan officer, then the Branch Office defaults to the user’s branch and the loan officer name defaults to the name of the user.
  • If the user is a branch manager, the Branch Office defaults to the user’s branch and the Loan Officer defaults to All; the user can then select a specific Loan Officer from the list.
  • If the user belongs to the head office, he/she must first select a Branch Office. Once selected, the Loan Officer choices consist of that branch’s loan officers. The default is All.

When the user clicks Generate, a report in PDF format is generated that displays all loans for the selected branch that are in active-bad standing, per loan product if one has been specified. If there are no loans in Active-bad standing, the error message “No results found” is displayed.

Mockup / Spec: 

Sample PDF: Detailed Aging Portfolio at Risk Report (.pdf)

 

General Ledger Report

This report is defined at the branch level.  The output is a daily summary of the financial transactions to the each of the GL accounts, including a breakdown of the debit and credit transactions to each account.  When running the report, the user specifies the branch and a date range for which to run the report.  The report will provide a summary for each day in that date range.  

The user can then take this report and manually enter the summarized general ledger transactions into their accounting software. 

Mockup / Spec:

Sample PDF: General Ledger Report (.pdf)

 

0
Your rating: None
Posted by edcable on August 24, 2010 at 11:52am