|
● General information
● Current Data
● Financial Reports
● Historical Analysis
● Create a new Indicator report
● Edit Indicator reports
● Delete Indicator reports
● Imported Reports
───────────────────────────────────────────────────────────────────────────────────────
Mambu measures your organization's data daily, so that you can always rely on the reporting system to know exactly how you are performing.
Here you can not only find information about your organization's current numbers and financial situation, but also create and print reports with the indicators you choose and analyze your data retrospectively.
All the information you find here can be used for internal purposes but you can also choose to share it with third parties like donors, investors or any other entities who can be interested in accessing it. This is made simple in Mambu, as you can just create an account for that entity and set a View Only permission, as seen in the article Managing Users and Permissions.
Aditional Reading: Managing Users and Permissions
────────────────────────────────────────────────────────────────────────────── Back to top
This is a static view where you can quickly grasp your organization's numbers and get a feeling of its current state.
To make this more effective the information is divided in three sections - Customer Summary, Portfolio Summary and Organization Summary.
────────────────────────────────────────────────────────────────────────────── Back to top
To create a new financial report, click on the first dropdown menu to set the starting date > click on the second dropdown menu to choose the closing date for the report > click on Generate Report.
This is an interactive view where you can generate the financial statements of your organization.
With these reports you will have a more detailed view over the figures and operations of your organization, as you can see in the example below.
 They will be particularly helpful if your organization has more than one branch, as it will provide you a detailed report of each of the branches' performance. You will then be able to identify and take action upon issues that could otherwise remain hidden for too long.
Indicators in the Financial Report
Income
- Interest from loans: The amount of paid interest of all repayments.
- Fees from loans: The amount of paid fees of all repayments.
- Loan Penalties: The amount of penalties paid of repayments.
- Interest on Deposits: The value can be positive (interest was charged) or zero. It's the amount of interest applied to deposit accounts.
- Fees on Savings: Sum of the amount of all fees that have been applied or adjusted to the deposit accounts during that period.
Expenses
- Interest paid on deposits: If the value is negative, means that interest was charged. In that case it's calculated as described above for Interest earned on deposits
- Extraordinary Write-off: The sum of (Principal Due - Principal Paid) of all loan accounts thet have been written-off during this period.
Balance Changed
- Principal Collected: Amount of principal of all repayments.
- Principal Disbursed: Amount of principal that has been disbursed.
- Change in Portfolio (Assets): Principal Disbursed - Principal Collected
- Change in Deposits (liabilities): AMount of all deposit transactions during that period.
────────────────────────────────────────────────────────────────────────────── Back to top
Here you will be able to see how your organization is progressing towards its strategic goals.
Mambu will provide you this information in the form of charts that you can then zoom in to see in detail.
You can also select the time period and the frequency of the information you want to retrieve. To do so, click on the first dropdown menu to choose the starting date > click on the second dropdown menu to select the closing date > select the time interval you wish > click Update.
You will then be able to see the charts corresponding to your institution's Customer Summary, Portfolio Summary and Organization Summary.
If you click on the magnifying glass at the top right of every chart you will see the detailed view with the date and number of borrowers (individuals, groups borrowing and borrowers in groups)
In the example, the Customer Summary chart.
────────────────────────────────────────────────────────────────────────────── Back to top
If you need to create a report from scratch you can choose from a list of categories and indicators that are available under Indicator Reports.
Each report can also be filtered by branch or credit officer, for instance, if you need to compare performances or have more detailed reports.
To generate a new report, go to Indicator Reports > click on Create New Report > select one of the filters (optional) > choose a category from the dropdown menu > from the other dropdown menu choose the indicators you want to include > click on Add Indicator after each one you choose to include > Save Changes.
────────────────────────────────────────────────────────────────────────────── Back to top
You can make changes to your reports at any time. To edit a report, go to the reports list > click on the report you want to change > click on Edit > make the changes > click on Save Changes.
In case you want to remove one or more indicators that were being used in that report, you just need to click on the delete icon next to the indicator.
────────────────────────────────────────────────────────────────────────────── Back to top
To delete an indicator report, choose the report > click on Delete > Confirm the deletion.
────────────────────────────────────────────────────────────────────────────── Back to top
If you need reports with specific formats, graphics, tables and more flexibility in the information captured, you have the option to create them using an external tool, iReports, and then upload the file to Mambu.
Import Reports
Once you have created the reports you need in iReports, you can start importing them to Mambu and work with your data.
To import a new report to Mambu, go to Reporting > Imported Reports > click on Import a Report > enter the report's name > click on Choose File to select the report you want to upload > click on Send > add a description (optional) > Save Changes.
The report will now be stored in Mambu and you can preview it and export to any of the formats available - PDF, DOCX, XLSX or XML.
Edit a Report
If you need to make changes in an imported report, you should do it directly in iReport and then upload the report to Mambu again.
To upload the report with the changes, go to Imported Reports > click on the report you want to make the changes > click on Edit > click on Choose File to upoad the new report > click on Send > Save Changes.
Delete imported reports
If you need to delete a report, you can do it at any point in time. To do so, just go to Imported Reports > click on the report you want to delete > click on Delete > confirm.
────────────────────────────────────────────────────────────────────────────── Back to top
Related Items
|
