Support Center

Accessing, Managing and Generating Reports

Last Updated: Jun 10, 2015 09:58PM CEST

 

General information

Portfolio Report

Organization Report

Earnings Report

Cashflow Report

Outreach Report

Outreach Report

Create a new Indicator report

Edit Indicator reports

Delete Indicator reports

 

───────────────────────────────────────────────────────────────────────────────────────

 

General information

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, not only you can 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.

Additional Reading: Managing Users and Permissions

 

────────────────────────────────────────────────────────────────────────────── Back to top

 

Portfolio Report

This section allows you to quickly understand the overall size and structure of your organization's loan and savings portfolio. You can see the number of accounts and their accumulated balance, and more importantly, how they have changed across time.

To generate the reports. Select a branch, Start and End dates, daily or weekly interval - Click "Generate Report".

The information is divided in three sections - Overview, Accounts and Historical.


Overview Report

This section is, as the name implies, an overview of your organization mainly regarding its size and account distribution.

The report is divided in three sections, at the header there are some general indicators that will give you a quick at-a-glance view of your organization, and below you will have a visualization of your account growth and distribution by number of accounts and balances.


Accounts Report

Three interactive graphs will show you the evolution of your accounts portfolio:  Created Accounts, Disbursed Loans, Written off Loans.




Historical Report

The different changes across time on several interactive graphs: Loans by status, Capital Structure, Portfolio Risk, and Average Loan Balance.


 

────────────────────────────────────────────────────────────────────────────── Back to top
 

Organization Report

This section will let you see how your organization stands in terms of Branches and Credit Officers and will let you measure how many loans per each of them.

To generate the report. Select Start and End dates and between daily or weekly interval - Click "Generate Report".




────────────────────────────────────────────────────────────────────────────── Back to top
 

Earnings Report

This report gives you a comprehensive view of revenues and expenses related to your financial products, showing their Growth, Distribution and Mix for each product and per branch.

To generate the report. Select a branch, Start and End dates, daily or weekly interval - Click "Generate Report".





────────────────────────────────────────────────────────────────────────────── Back to top
 

Cashflow Report

This is an interactive view where you can generate see the cash movements per branch related to your financial products on Mambu.

With this report you will have a more detailed view over the figures and operations of your organization, as you can see in the example below.

To generate the report. Select a branch, Start and End dates, daily or weekly interval - Click "Generate Report".

 

 


 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 Cashflow 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 that 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

 

Outreach Report

Here you will be able to see how your organization is progressing regarding its effect on the communities your company affects. You will be able to see the number of clients and groups, divided between borrowers and savers, as well as the percentage of female borrowers.

 


────────────────────────────────────────────────────────────────────────────── Back to top


Risk Report

More information on the Risk Report can be found in a separate article under the Managing Risk section. 


────────────────────────────────────────────────────────────────────────────── Back to top

Create a new indicator report

If you need to create a report from scratch you can choose from different types of report and a list of indicators that are available.

There are 5 types of indicator reports:

Branch
Deposit Product
Loan Product
Centre
Center Manager

To generate a new report, go to Reporting - Indicators > click on Create New Report > select a type of report > choose the indicators for the report >  click on Add Indicator after each one you choose to include > Save Changes.


 

 

────────────────────────────────────────────────────────────────────────────── Back to top

 

Edit indicator reports

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

 

Delete indicator reports

To delete an indicator report, choose the report > click on Delete > Confirm the deletion.

 

────────────────────────────────────────────────────────────────────────────── Back to top

 

support@mambu.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete