If NetSuite is your connected source system, rates are automatically imported during imports. To manage exchange rates or custom rates, follow the steps outlined below.
If you're using NetSuite as your source system, see this article.
Edit exchange rates
View and edit exchange rates coming from the Open Exchange Rates API (OXR) from the Currencies page. Click the Exchange Rates tab to view the table, and click Edit Rates to make modifications.
Use the year tabs to see the rates assigned based on your Cube base currency and foreign currencies added.
Learn more about adding and removing currencies.
Import custom exchange rates
Manage custom currencies or rates on an account-by-account and time-period-by-time-period basis by uploading a rate file directly to Cube. You can generate your own file or use a file exported from Cube as a starting point.
If your Cube has custom time dimensions, the dates in the file must match the end dates of your custom time dimensions.
From your Workspace, click Export under Export Conversion Rates.
This will generate a rate file with the current mappings and set rates. Use the exported rate file to overwrite existing rates and then reupload the file under Import Conversion Rates.
Click Upload to open the guided experience for uploading your conversion rates.
This process will confirm the mapping for each column in your file and validate all of the entries against the data type our system expects. After all rows are validated, click Upload to submit your conversion rate file to Cube.
When the rate conversion process is complete, you will receive an email confirming that the rates were successfully uploaded to Cube. Wait to perform any fetches referencing the new rates until you receive this email.
After rates are uploaded and assigned, transactions sent to Cube in a foreign value will be converted to Cube values using the exchange rates shown.
New rate files must be added monthly. If not, Cube will default to the current rates from the Open Exchange Rate API (OXR).
Learn more about adding and removing currencies.