If your Cube uses Currencies by Subsidiary, you can define a custom currency code to apply a different exchange rate to the same currency pair for a specific entity, rather than one shared rate across every entity using that pair.
Required permission: Currency Management. This permission is available to Cube admins by default. Users with basic currency permissions can work in enabled currencies but can't add custom currency codes or upload rates.
Why you'd need this
Some ERPs, including NetSuite, let different subsidiaries hold different exchange rates for the same currency pair and period. For example, two subsidiaries might both convert GBP to USD, but each uses its own rate because their parent entities set rates independently in the source system.
Cube's standard currency codes (USD, GBP, EUR, and so on) assume one rate per pair, per period. If Cube receives two different rates for the same pair and period from different subsidiaries, it can't resolve which one applies, and you'll see an error similar to:
There were differing Current rates found for GBP -> USD in [period]. For subsidiaries "[Subsidiary A]" and "[Subsidiary B]", the rates were [rate 1] and [rate 2]. Please check for conflicting rates for the same period in your NetSuite Exchange Rates file and confirm the mapping is correct.
A custom currency code resolves this by giving each entity's rate its own identity, so both rates can exist side by side without conflicting. For example, if a fictional entity called Acme Holdings needs its own EUR rate, you'd create a custom currency code like EUR-AH and assign it only to that entity.
Note: If only one subsidiary in a conflicting pair actually needs its own rate, and the rest can share a common rate, you may be able to exclude that subsidiary from your Consolidated Exchange Rates saved search in NetSuite instead of creating a custom currency code. Use a custom currency code when you need to preserve and report on more than one legitimate rate for the same pair and period.
Steps for Adding a Custom Currency
Add a custom currency for each entity
- Navigate to the Currencies page and select the Currencies tab.
- Select Manage Currencies.
- In the modal, select the dropdown icon, then select Add custom currency.
- Complete the fields in the Add custom currency modal:
- Currency Name: CCC-XX
- Currency Code: CCC-XX
- Description: "CCC rate for [Entity Name]"
- Symbol: the entity's local currency symbol
Note: CCC is the standard currency code being converted (for example, EUR or JPY), and XX is the subsidiary's initials. For example, a fictional entity named Acme Holdings using its own EUR rate would use the currency code EUR-AH.
Load rates for the new custom currencies
Once all the needed custom currencies have been added, retrigger a rates sync from NetSuite so Cube pulls in rates for the new currency codes.
Note: If you're not on NetSuite, or the sync doesn't bring in rates for a custom code, upload the rates manually from the Exchange Rates tab on the Currencies page instead.
Apply the custom currencies to entities
- Navigate to the Currency by Entity tab on the Currencies page.
- Select Edit.
- Assign the matching custom currency to each subsidiary that uses that rate.
Note: If the rates sync or upload continues to fail after adding the custom currencies, confirm there isn't still a naming or mapping mismatch between the Currency Code in Cube and the corresponding code in your NetSuite Exchange Rates file.
What updates automatically
- Cube applies the assigned entity's custom rate instead of the shared currency-pair rate for every fetch, drilldown, and rollup involving that entity going forward.
- Parent-level rollups continue to convert and consolidate correctly, since each entity still resolves to a single rate; only the rate source is now entity-specific rather than shared.
Note: A custom currency code only affects conversion going forward. If you need historical periods to reflect the corrected, entity-specific rate, you'll need to re-import or re-publish the affected data after setting up the custom code and its rates.