# Fund Mapping

\
The **Fund Mapping** page enables you to map the sources of funds to loans in bulk.

Beginning at the main screen, select **Admin,** then **Organization** from the drop down menu. This will launch the **Organization** menu.

Select **Fund Mapping** to set the preferences.&#x20;

![](https://mifosforge.jira.com/wiki/download/attachments/90243210/fundMapping.png?version=1\&modificationDate=1552929757329\&cacheVersion=1\&api=v2)

This will launch an **Advance search** page.          &#x20;

![](https://mifosforge.jira.com/wiki/download/attachments/90243210/adhocQueary.png?version=1\&modificationDate=1552930084269\&cacheVersion=1\&api=v2)

Using Adhoc query search, one can search for loans with different aspects. You can search by;

* Loan Status
* Product
* Office
* Approval/Creation/Disbursement - Date
* Loan outstanding percentage
* Loan outstanding amount

### **Searching by Loan Status**

![](https://mifosforge.jira.com/wiki/download/attachments/90243210/fundbyLoanStatus.png?version=1\&modificationDate=1552987748540\&cacheVersion=1\&api=v2)

The options include;

* All - Searches loan with all status.&#x20;
* Active - Searches only loan with Active status.
* Overpaid - Searches only loan with Overpaid status.
* Closed (obligations met) - Searches loan Closed (obligations met).
* Closed (written-off) - Searches loan Closed (written-off).

### **Searching by Product**

This is a filtered search based on Products. That is clicking on a particular product or by holding the control button and selecting two or more products and then search. &#x20;

<div align="left"><img src="https://mifosforge.jira.com/wiki/download/attachments/90243210/searchByproduct.png?version=1&#x26;modificationDate=1553065658619&#x26;cacheVersion=1&#x26;api=v2" alt=""></div>

### **Searching by Office**

This is a filter search based on the Office.&#x20;

<div align="left"><img src="https://mifosforge.jira.com/wiki/download/attachments/90243210/searchbyOffice.png?version=1&#x26;modificationDate=1553067124230&#x26;cacheVersion=1&#x26;api=v2" alt=""></div>

You can click on a particular office or many by holding the control button and selecting the offices.

### **Searching by Approval/Creation/Disbursement-Date**

This is a filter search based on the type of date. This can be Approval date, Creation date, and Disbursement date.

![](https://mifosforge.jira.com/wiki/download/thumbnails/90243210/6.png?version=1\&modificationDate=1431328757204\&cacheVersion=1\&api=v2\&width=600)

You can be provided a range of dates within which you want your results to be based.

### **Searching by Loan Outstanding Percentage**

By default, it will have the check box checked for Loan outstanding percentage. If you don't want to use this filter,  un-check the box and then search. &#x20;

By default, it will be a between search. However, you may select another option from the drop-down and then select the range of dates.&#x20;

![](https://mifosforge.jira.com/wiki/download/thumbnails/90243210/8.png?version=2\&modificationDate=1431334035807\&cacheVersion=1\&api=v2\&width=779)

### **Searching by Loan Outstanding Amount**

By default, this section will have the check box checked for Loan outstanding amount. If you don't want to use this filter, un-check the box and then search. &#x20;

By default, it will be a between search. However, you may select another option from the drop-down and then select the range of dates.&#x20;

![](https://mifosforge.jira.com/wiki/download/thumbnails/90243210/9.png?version=2\&modificationDate=1431334183145\&cacheVersion=1\&api=v2\&width=849)

Click the ![](https://mifosforge.jira.com/wiki/download/attachments/90243210/10.png?version=1\&modificationDate=1431329293972\&cacheVersion=1\&api=v2) button to execute your filtered search. &#x20;

Related articles

* Page:[Entity To Entity Mapping](https://docs.mifos.org/mifosx/user-manual/for-administrators-mifos-x-platform/administration/system/entity-to-entity-mapping)
* Page:[Fund Mapping](https://docs.mifos.org/mifosx/user-manual/for-administrators-mifos-x-platform/administration/organization/fund-mapping)
