Skip to main content

Multi-Currency Planning in Assortment Plan

How to plan in multiple currencies in Assortment Plan — set unit costs and retail prices per cluster currency, with automatic exchange rate conversion across metrics and reporting.

Overview

Assortment Plan now supports multi-currency planning, following the same capability previously available in Merchandise Plan. The key difference is that in AP, currency is applied at the choice level — specifically, you can store unit cost, unit retail, unit ticket, and unit receipt cost in the dedicated currency for each cluster you're planning for.

For example, if you're selling into a European region, you may want unit retail and unit ticket planned in euros. If you're selling into Canada, you'd plan in Canadian dollars. Currencies are matched to locations at the cluster level, so each cluster can be configured with its own currency.

Prerequisites

Before using multi-currency in AP, make sure the following are in place:

  1. Feature flag enabled — Multi-currency in AP is controlled by a feature flag. Contact your Toolio admin or customer success manager to turn it on.

  2. Clusters configured with currencies — Each cluster that should plan in a non-organization currency needs to have that currency assigned.

  3. Custom exchange rates set up — AP uses the same custom exchange rate functionality built for Merchandise Plan. You can define exchange rates for future time frames so that conversions reflect your planned rates rather than a static rate.

Setting Unit Cost, Retail, and Ticket per Currency

Once your clusters and exchange rates are configured, you input currencies at the choice level via the Offering Set:

  1. Open a choice and navigate to its Offering Set.

  2. Set your unit cost, unit retail, and unit ticket values. The default starting view is Cluster Currency, which shows each offering in the currency of its assigned cluster — you'll see multiple currencies listed if your choice spans multiple clusters.

  3. If you want to view in a specific currency instead (e.g., USD or Canadian dollar), you can switch the currency selector from 'Cluster Currency'. The numbers will update based on the configured exchange rate.

  4. Your stored values remain tied to the cluster currency — switching the display currency does not change what's stored, only how it's shown.

Forecasts and generate receipts use these cluster currency values as their inputs.

Viewing Currencies in Metrics

In the Metrics tab, you can view financial data in any currency. Because exchange rates can vary over time, you may see values shift week over week if a rate change falls within your planning horizon. For example, if your euro exchange rate changes on a week, the ticket price for that week will reflect the updated rate — you might see on the week the new rate takes effect.

Viewing Currencies in Reporting

The Reporting view surfaces the same data as your line plan. You can control which currency you're viewing and see rolled-up figures with exchange rate conversions applied.

Important Notes

  • All data is stored in organization currency internally. Toolio converts values back to organization currency under the hood to keep all metrics and rollups consistent. Example, if your organization currency is USD, what you enter in euros or Canadian dollars is stored as the USD equivalent.

  • Moving a launch date does not change the input value. If you entered a unit retail in euros, that value remains the same regardless of whether you shift the launch date. However, because exchange rates are time-based, the converted value you see in metrics will reflect the rate applicable to the new date.

  • Currency is set at the cluster level. Each cluster can have its own currency — you don't configure currency per choice or per assortment.

Did this answer your question?