> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.refrens.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to add forex conversion rate while bulk uploading documents?

If you're uploading documents with foreign currency amounts, you can include a forex conversion rate in your bulk upload file. This will automatically convert the amounts to your business currency.

Let's see how to do this:

In your bulk upload file, add a new column named any one of these  - "forexrate", "exchangerate", "conversionrate".

For example, I have added a new column called "forexrate" in the bulk upload file I am going to upload.

![](https://storage.crisp.chat/users/helpdesk/website/ae3b9d3904018000/2d17ec16-b4e0-4477-ab41-5df945_p3l8g5.png =800x166)

In this newly added column, you can add the forex conversion rate you want to apply. ( ***Note:***  *if you keep this column empty, the system will automatically apply the current conversion rate applicable.*)

Once done, you can follow the standard steps to finish your bulk upload.

As you see in the image above, I have mentioned the forex rate only for one invoice. For the other invoice, I have kept the field empty.

Let's see how this will impact the forex rate in the invoice generated.

**1. Invoice with forex rate added**

As you see, the system will apply the rate that you mentioned:

![](https://storage.crisp.chat/users/helpdesk/website/90b33f56b2b93000/921393e6-1673-4a92-a3dc-15bf46_1rix9j3.png =800x306)

**2. Invoice with empty forex rate**

As you see, if you keep the force rate field empty, the system will automatically apply the current conversion rate applicable.

![](https://storage.crisp.chat/users/helpdesk/website/2088ac8d930a6e00/641d5d28-93f7-4ed0-a7db-19e37c_1ciwgwr.png =800x295)
You can follow the same procedure while uploading other documents as well.

In case you still have questions reach out to us at care@refrens.com or contact us via chat support for quicker assistance.