● Overview

● Clients

● Groups

● Loan Accounts

● Deposit Accounts

● Chart of Accounts

● Chart of Accounts

● Data for Reference Only

● ID Associations

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

Overview

The Excel template that you download for the migration process has different fields corresponding to the information you are trying to import into Mambu. In the bottom you can see that there are ten different sheets - Clients, Groups, Accounts, Chart of Accounts, Branches, Credit Officers, Centres and Products - to structure the data you'll enter. This is a quick reference guide that will help you making sure your data is exactly where it should be.

 All the custom fields for clients and groups that you've entered in Mambu before downloading this template will be displayed in the correspondent sheets so that you can also fill in that information.

Important! The format of the data must be Text or Number, no Formulas in the cells. For instance, the Date cells should be 03.04.2001 and not =DATE("2001,3,4")

You can only upload XLS files. Some newer versions of excel convert the files to XLSX format when you save them, so if this happens you should save it as XLS before uploading it to Mambu.

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

Clients

Here you'll find all the fields you need to fill in with your clients data, including the custom fields you've created before.

* = Mandatory Field

Client ID *: is the Alphanumeric code with the existing ID of the client.

Group ID: is the Alphanumeric code that corresponds to the group that client is a member of.

Branch ID: is the Alphanumeric code that corresponds to the branch that client is assigned to.

Centre ID: is the Alphanumeric code that corresponds to the centre that client is assigned to.

Credit Officer ID: is the Alphanumeric code that corresponds to the Credit Officer that client is assigned to.

Date Joined (DD.MM.YYYY): The day, month and year the client joined your organization. Must follow the format: 2 digits for day, dot, 2 digits for month, dot and 4 digits for year.

First Name *: the given name.

Last Name: the surname.

Date of Birth (DD.MM.YYYY): The day, month and year the client was born. Must follow the format: 2 digits for day, dot, 2 digits for month, dot and 4 digits for year.

Gender (M/F): M-male or F-female.

Address 1, Address 2, City, Zip, State/Province/Region, Country: contact information used to locate the client.

Mobile/Cellphone: mobile phone number that can be used to contact the client.

Phone: the land line phone number that can be used to contact the client.

Notes: any additional comment you want to add.

Group Loan Cycle: The number of group loans the client has already completed.

ID Type: Examples could be passports, ID card, or any other official document.

ID Number: the number of this document.

ID Authority: the authority that issued the document (police, government).

ID Valid Until (DD.MM.YYYY): the expiration date of the document.

Custom Fields: the last columns will contain the custom information fields you created before in Mambu. If it’s a Selection field you have to write the same values you chose in the Mambu Settings.

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

Groups

* = Mandatory Field

Group ID * : Alphanumeric code that you can customize for your groups.

Branch ID: Alphanumeric code of the branch that group is assigned to.

Centre ID: Alphanumeric code of the centre that groups are assigned to.

Credit Officer ID: Alphanumeric code of the credit officer that group is assigned to.

Group Name * : Name which identifies that group.

Date Joined (DD.MM.YYYY): The day, month and year the group joined your organization. Must follow the format: 2 digits for day, dot, 2 digits for month, dot and 4 digits for year.

Address 1, Address 2, City, Zip, State/Province/Region, Country: contact information used to locate the group.

Notes: any additional comment you want to add.

Group Loan Cycle: The number of loans the group has already completed.

 Only Pure Groups can be imported using the excel template. Both Hybrid Groups and loan accounts fo Hybrid Groups need to be created manually in Mambu after importing the individual clients.

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

Loans Accounts

* = Mandatory Field

Account ID *:  Alphanumeric code which you can customize and that is unique for each loan account.

Client ID * : Alphanumeric code of the client the account is for.

Client Type * : C-Client or G-Group, depending on whom the ID refers to. If you leave this empty, it will be Client by default.

Product ID * :The string code of the loan product the acount is associated with. The product ID is defined when you create the products.

Date Applied * : Date when the client applied for the loan.

Date Approved * : Date when your organization approved the loan account.

Date Disbursed * : Date when the loan account was disbursed.

Repayment Start Date * :The day of the first loan repayment.

# Grace Installments: the number of installments in which the loan repayments don't include interest

Loan Length (# Installments) * : the number of repayments of the account. The time unit you chose in the Loan Product will be the criteria to be followed (i.e. months, days, weeks...)

Interest Rate * : The fee in percentage that is charged by your MFI to borrowers for the use of a loan amount. When entering this information, you should only include the number. So for an interest rate of 12%, for instance, you should only enter 12.

Loan Amount * : the original amount of the loan.

Amount Paid * : how much of interest and principal has been paid.

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

Deposit Accounts

* = Mandatory Field

Account ID * : Alphanumeric code which you can customize and that is unique for each client.

Client ID * : Alphanumeric code of the client the deposit account is for.

Product ID * : The string code of the deposit product the account is associated with. The product ID is defined when you create the products.

Date Applied * : When the account was created.

Date Approved * : When the account was approved.

Overdraft Interest Rate: The interest rate charged on overdraft accounts. Can be zero.

Overdraft Limit: The maximum amount that a client can withdraw from the overdraft account.

Current Balance * : The account's balance at the point of the import, including all the interest accrued.

Notes: any additional comment you want to add.

 Only the accounts of type Regular Savings will be imported.

 The dates for last interest calculation, latest interest storage and lates account appraisal will be set as of the point of the migration event.

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

Chart of Accounts

* = Mandatory Field

GL Code * : The number used to identify the account in the General Ledger.

Account Name * : The name so that you can identify the account

Type (A/L/I/E/Q) * : select if the account is an Asset, Liability, Income, Expense or Equity

Balance: Balance of existing GL accounts.

Usage (D/H): the category of the account: Detail or Header.

Notes: any additional comment you want to add.

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

Centres

* = Mandatory Field

Centre ID * : Alphanumeric code which you can customize and that is unique for each centre.

Branch ID * : Alphanumeric code of the branch the centre is associated to.

Name * : The centre's name.

Meeting Day: The day of the week when the clients who are associated to this centre meet with the credit officer. Use the initials of the appropriate day as they are shown. So for instance, M for Monday, T for Tuesday and so on.

Address 1, address 2, city, zip, state/province/region, country: contact information of the centre.

Notes: Any comments you want to have associated to the centre.

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

Data for reference only

The following sheets contain information to be used only as a reference when you're filling the other sheets. So, for instance, when you're entering information in the Clients' or Groups' sheets, you will need to open the Branches' sheet to see which is the branch's ID that the clients are associated with.

Branches Data

This information corresponds to the data you've entered before about your organization's branches.

The branches IDs are automatically generated when you create a new branch in Mambu.

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

Credit Officers

The information in the Credit Officers' sheet corresponds to the data you entered in the system about them.

The Credit Officers IDs are automatically generated when you download the template so that you can use it as a reference.

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

Loan Products

The information displayed in this sheet corresponds to the data you entered in the system when creating your products.

Loan products' IDs are not automatically generated, so you need to define the ID when creating your loan products.

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

Deposit Products

Just like for the loan products, the information in this sheet corresponds to the one you entered before in the system.

Savings products' ID number is not generated automatically, so you also need to define it when creating your savings products.

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

ID Associations

So that the data migration is completely successful, the information in the ten sheets - Clients, Groups, Loan and Savings Accounts, Chart of Accounts, Branches, Credit Officers, Centres and Loan and Savings Products - in the template has to match. You can make sure it does by using the ID numbers, which ensure that the clients and groups will be assigned to the appropriate branch and credit officers in the system.

In the Clients sheet:

• The Group ID (for clients who are members of a group), the Branch ID, the Centre ID and the Credit Officer ID need to correspond to Group, Branch, Centre and Credit Officers IDs in the other sheets - Groups, Branches, Centres, Credit Officers.

In the Groups sheet:

• The Branch, Centre, Credit Officer ID you enter here has to be the same as the one displayed in the Branches, Centres and Credit Officers sheets.

In the Loan Accounts sheet:

• The Client ID and the Product ID must match with the fields in the Clients and Loan Products sheets. 

In the Deposit Accounts sheet:

• Just like for the loan accounts sheet, the Client ID and the Product ID need to match the fields in the Clients and Deposit Products sheets.

In the Centres' Sheet:

• The Branch ID needs to match the ID in the branches' sheet.

   

   Nor clients or credit officers need to necessarily be assigned to the same branch their group is assigned to.

   

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

   

  Related Items

  Creating a New Branch

  Creating New Clients

  Creating New Groups

  Data Migration

  Mambu Terminology