Toolio’s Multi-Currency Support empowers global retailers to plan in multiple local currencies while maintaining a unified company base currency. This article covers how exchange rates are handled across actualized and future data, how to configure exchange rates in settings, and how currency views work in Merchandise Plan.
Contact your CSM if you like to start using Multi-Currency support in MP.
Actualized Data Conversion: Weekly Exchange Rates
Toolio uses a hierarchical approach to determine the most accurate exchange rate for each week:
Customer-Provided Exchange Rates (preferred):
Uploaded via sale or inventory imports as defined here.
For each import:
Identify unique exchange rate pairs (e.g., USD 0.64, EUR 0.40).
If multiple values for the same currency exist, it uses the maximum.
If sale data is missing, fallback to inventory import.
Currency Scope Assumptions:
Retail and Cost exchange rates are assumed to be the same.
System relies on the retail exchange rate for conversions.
Fallback - Third-party API:
If no user-supplied rates are available through imports, Toolio uses weekly exchange rates from a third-party API.
Future Data Conversion: Settings-Based Exchange Rates
For planned metrics (i.e., future data), users must define exchange rates manually in Settings > Custom Exchange Rate.
Adding Exchange Rates:
Navigate to Settings > Custom Exchange Rate
Click Add to open the exchange rate dialog.
Input the following details:
Example:
Local Currency | Company Currency | Exchange Rate | Start Date |
GBP | USD | 1.2 | 01/01/2025 |
EUR | USD | 0.9 | 01/01/2025 |
GBP | USD | 1.22 | 04/01/2025 |
EUR | USD | 0.94 | 04/01/2025 |
Toolio applies exchange rates based on Start Date. In the example above, 1.2 and 0.9 apply until 04/01/2025, then 1.22 and 0.94 take effect.
To edit:
Right-click a row > Edit.
Make changes in the dialog and click Save.
Changes take effect from the new Start Date onward.
To delete:
Right-click a row > Delete.
Confirm deletion.
If the deleted rate had a previous rate before its timeframe, Toolio reverts to the earlier rate.
If no prior rate exists, Toolio does not apply any exchange rate for the affected timeframe.
Changing View Currency
Users can toggle their view currency directly within the plan module.
How to Change Currency View:
Go to Merchandise Plan
Click Currency Selector > Currency
Choose a currency from the list of configured exchange rates.
Please note that if you did not configure a custom exchange rate, your exchange rate will not appear on the currency exchange selector
The plan gets updated as it is converted all metrics using the relevant exchange rate.
Note: Relative Exchange Rates are the currencies defined in the custom exchange rate setting page.
Editing Plan Data in Local Currencies
Toolio allows edits in a selected currency while saving values in the company’s base currency.
How it works:
For example, a user sets Sales = AUD 1,000
The UI reflects values in AUD
Upon saving:
Toolio converts the value using the weekly custom exchange rate (e.g., 1 AUD = 0.61 USD)
Stores the result as 610 USD in the database