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.



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:




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.





You can follow the same procedure while uploading other documents as well.