Importing exchange rates that have an Effective Date in the past will not update historical records. Importing rates with different Effective Dates will add new rows to the table. As long as the Effective Dates are the same, the new rates will override the old rates in the table. While you currently can't delete exchange rates directly from the table, if you find an error or need to add, update, or remove any, you can import a new CSV file. If you are using Kantata Insights, the exchange rate table is limited to 400 pairs. It can be on a daily or monthly basis.Ī Source Currency and a Target Currency makeup a currency pair. Effective Date-The date the exchange rate takes effect.Exchange Rate-The value of one currency when converted to another.Target Currency-The project currency, or the currency you are converting to.Source Currency-The currency you are converting from.The exchange table consists of the following columns:

At a glance, you can see what currencies you are using, the exchange rate, and when that rate is in use. If you haven't added an exchange table yet, the Default Exchange Table will appear empty. The Exchange Table contains all of your foreign exchange information. Please note that you must first belong to an Access Group that has the ability to access and view the foreign exchange table. To access the exchange table, go to Settings > Foreign Exchange. When coupled with Kantata Insights, you'll gain in-depth reporting on how your project fees compare to converted fees, giving you a better understanding of your business' global financial health. With Kantata's Foreign Exchange feature, you can import a currency exchange table from a CSV file, track expenses in other currencies, and convert them to the project's currency. OverviewĮxpenses in multiple currencies are a part of doing business in the global economy. They must be added to a group with Foreign Exchange permissions.

Account Administrators do not have Foreign Exchange access by default. To use Kantata OX's multi-currency functionality, you must first enable Access Groups, and then configure the appropriate Foreign Exchange settings.

Exchange rate on a certain date