in implementation guides ~ read.
Salesforce Using Multiple Currencies

Salesforce Using Multiple Currencies

DOWNLOAD

First things first !
To download this implementation guide, click the download button below.
If you need more information about the implementation guide, you can read the Table of Contents below.

Download

International Organizations
Using Multiple Currencies
Salesforce Spring

salesforcedocs
Last updated January

Copyright Salesforce Inc All rights reserved Salesforce is a registered trademark of Salesforce Inc as are other

names and marks Other marks appearing herein may be trademarks of their respective owners

CONTENTS

Introduction
Using Multiple Currencies
Setup and Maintenance
Importing Data Using Multiple Currencies
Index

INTRODUCTION

Salesforce is the only online CRM solution designed from the ground up to support global organizations It provides advanced

multicurrency support for Opportunity Management Forecasting and Reporting Using this capability each international division can
track forecast and report on opportunities in local currencies while providing companywide reporting and forecasting in a single
common currency

Key Terms
Corporate Currency
The currency in which your corporate headquarters reports revenue Serves as the basis for all currency conversion rates
Conversion Rates
The currency conversion rates between the corporate currency and the multiple currencies used by your organization Your
organizations administrator maintains these rates
Personal Currency

A users default currency for reports Must be one of your active currencies Forecast and quota amounts can appear in your corporate

currency or each forecast owners personal currency
Active Currency

A currency in which your organization does business Only active currencies can be entered in opportunities forecasts and other

items
Inactive Currency

A currency that your organization no longer uses You may have existing records that use inactive currencies but you cant enter

new amounts using inactive currencies
Record Currency
The default currency for a record Every record has a Currency field that specifies the currency type for amounts in that record

Scenario

Introduction

The US VP of Sales directs managers and salespeople in the US Canada and Mexico Canadian managers and salespeople forecast

and report in Canadian dollars Mexican managers and salespeople in pesos Users can also enter opportunities in any of the organizations

active currencies for example Swedish krona The US VP of Sales can run reports to reconcile opportunities across the US Canada

and Mexico and see these reports in US dollars

The European VP of Sales uses British pounds as her personal currency She has sales managers in the UK Germany and Sweden

Salespeople are in these countries as well as in Norway and South Africa Salespeople in the UK and South Africa report to the UK Sales

Manager Norwegian and Swedish salespeople report to the manager in Sweden The European managers and salespeople all enter
opportunities in their respective personal currencies they can also use other active currencies as well for example Canadian dollars

The UK Sales Manager gets his salespeoples pound and randdenominated opportunities and forecasts rolled up to pounds The sales

manager in Sweden reports on her salespeoples krona and eurodenominated opportunities using krona Finally the European VP of

Sales gets all this data rolled up to pounds

In Asia the Japanese VP of Sales runs the entire division in yen and has a sales manager in Singapore The managers and salespeople

create opportunities and run forecasts and reports in their local personal currencies The Japanese VP of Sales has all of these roll up to

Japanese yen

The New Yorkbased CEO has visibility into every division and runs reports denominated in US dollars If needed he can drill down to

see divisional forecasts or individual opportunities in the native currencies of those items
Opportunities are typically managed within a country however there may be crosscountry collaboration on deals Each opportunity
has an associated record currency determined by the Currency field of the opportunity Opportunity amounts display in the record
currency as well as the opportunity owners personal currency

USING MULTIPLE CURRENCIES

On Salesforce Records
Every record has a Currency field that specifies the currency type for amounts in that record All currency amounts display in the
records currency and are also converted to the personal currency of the record owner based on the conversion rates entered by your
administrator Amounts in the users personal currency are displayed in parentheses
For example if you do business with Acme Inc a German company you can set the Currency field in the Acme Inc account to

EUR Euro Amounts such as Annual Revenue will display in euros as well as in your personal currency

You can set the Currency field for a record to any of your organizations active currencies If a particular currency is deactivated and
it is already in use as a record currency those records remain untouched You cannot enter any new amounts using an inactive currency

In Forecasts and Quotas
When a Salesforce admin sets up Collaborative Forecasts they choose a default forecast currency and enable one or more types of
forecasts The forecast currency is either the corporate currency or each forecast owners personal currency
To select a forecast currency for your org
From Setup enter Forecasts Settings in the Quick Find box and then select Forecasts Settings
From the Forecast Currency dropdown select a forecast currency option
Save your changes
To change the currency select a different currency from the gear Lightning Experience or the dropdown list Salesforce Classic in the
upper right of the forecasts page

In Reports
To change the currency select a different currency from the gear Lightning Experience or the dropdown list Salesforce Classic in the
upper right of the forecasts page

In List View Criteria and Report Filters
When creating list views or custom reports you can use the list view Search Criteria or filter logic in report builder to limit your data to

items with specific currencies or amounts For example create a list view of all opportunities with amounts over US dollars To

do so follow these rules

Prefix currency amounts with a currency code for example Annual Revenue greater than USD

Without the currency code all amounts are assumed to be in the users personal currency For example Annual Revenue

greater than means million US dollars assuming the users personal currency is US dollars

All amounts are converted to the corporate currency for comparison For example Annual Revenue greater than USD

finds accounts with revenue greater than million US dollars This would include an account with revenue of

million Australian dollars which is the equivalent of million US dollars assuming a conversion rate of

Using Multiple Currencies

Use the Currency field to find items with a particular currency for example Opportunity Currency equals AUD

finds opportunities with amounts in Australian dollars
From Setup enter Manage Currencies in the Quick Find box then select Manage Currencies to obtain the currency
codes

SEE ALSO

Salesforce Help Personalize Your Salesforce Experience

SETUP AND MAINTENANCE

Note If you have Enterprise Unlimited or Performance Edition you can create a complete single copy of your organization in a
separate environment to test your customizations to make sure they work the way you expect before implementing them in your
Salesforce organization See Create a Sandbox in the Salesforce Help

Setting Your Personal Currency
Your personal currency is the default currency displayed in your reports Forecast and quota amounts can appear in your personal
currency or corporate currency
From your personal settings enter Advanced User Details in the Quick Find box then select Advanced User Details
No results Enter Personal Information in the Quick Find box then select Personal Information
Click Edit and change the value of the Currency field
Click Save

Setting Corporate Currency

The corporate currency is the currency in which your corporate headquarters reports revenue A Salesforce representative initially sets

your corporate currency when activating the multicurrency feature
From Setup enter Manage Currencies in the Quick Find box then select Manage Currencies
Click Change Corporate
Choose a new corporate currency from the list of active currencies and click Save If you have not yet set up any currencies see
Activating and Deactivating Currencies
Note On the Manage Currencies page you also have the option of enabling Parenthetical Currency Conversion Turning on
parenthetical currency conversion lets users see their personal converted currency amount in parentheses on records next to the
primary or corporate currency if the two are different

Activating and Deactivating Currencies
To use multiple currencies you must specify which currencies are supported for your organization
From Setup enter Manage Currencies in the Quick Find box then select Manage Currencies
Click New in the Active Currencies related list

Select a currency from the dropdown Currencies are alphabetized using their ISO currency code

Enter the conversion rate relative to your corporate currency
Specify the number of decimal places to display when showing amounts in this currency
Click Save
To activate a currency from the list of inactive currencies click Activate next to the currency

Setup and Maintenance

To deactivate a currency click Deactivate You might want to deactivate a currency if for instance you no longer do business or have
salespeople in a particular country Deactivating a currency does not alter amounts in items that use that currency However you can
no longer enter new amounts using the inactive currency In addition deactivating a currency that is set as a users personal currency
automatically resets the users personal currency to the corporate currency
Note You can never permanently delete a currency once you activate it You can only deactivate unused currencies

Editing Conversion Rates
Your organizations administrator maintains the list of conversion rates between your active and inactive currencies and the corporate
currency You might want to update the rates monthly although your organization can decide how frequently to update them
All conversions within opportunities forecasts and other amounts use the current conversion rate Previous conversion rates are not
stored You cannot track revenue gain or loss based on currency fluctuations
To update the conversion rates
From Setup enter Manage Currencies in the Quick Find box then select Manage Currencies
Click Edit Rates in the Active Currencies or Inactive Currencies lists
Enter the conversion rate between each currency and your corporate currency
Click Save
When you change the conversion rates currency amounts within Salesforce are updated using the new rates
If Advanced Currency Management is enabled you can use dated exchange rates to map a conversion rate to a specific date range For

example the exchange rate on January was USD to AUD but on February it changed to USD to AUD Your opportunities

that closed between January and February use the first exchange rate while opportunities that closed after February
used the second exchange rate See About Advanced Currency Management

Using WebtoLead or WebtoCase
If you want to capture any currency amount information for example Annual Revenue in your WebtoLead or WebtoCase form add

the Lead Currency or Case Currency field when generating the HTML form Otherwise all amounts are captured and put

into Salesforce in your corporate currency

Changing Your Fiscal Year Start Month
If you change the start month of your organizations fiscal year the fiscal quarters shift and different months are regrouped into new
quarters This can change the forecast currency for each quarter The new forecast currency for each quarter becomes the currency of
the third month in that quarter

For example suppose that before the fiscal year change you had your Q forecast as JanuaryMarch in US dollars and Q as AprilJune

in German marks After the change the Q forecast is FebruaryApril and Q is MayJuly The forecasts for February and March were in

US dollars but the new forecast currency for Q becomes German marks because the third month in the quarter is April which was

previously in German marks

SEE ALSO

Salesforce Help Personalize Your Salesforce Experience

IMPORTING DATA USING MULTIPLE CURRENCIES

When importing accounts and contacts or leads you can import amounts in different currencies

Organization Import
When importing accounts and contacts or leads via the Data Import Wizard for your org you can specify the currency type for amount

fields by entering a currency code in the Currency ISO Code column in your import file From Setup enter Manage Currencies

in the Quick Find box then select Manage Currencies to see a list of codes
For accounts and contacts you can use an active or inactive currency code You must use an active currency code for leads
During import you cannot update the Currency field for existing accounts and contacts
Creating new accounts contacts or leads

If you do not use the Currency ISO Code column or fail to map it any amounts are imported in your personal currency For

example if your personal currency is US dollars and the value in your file is this is imported as USD

If you enter an inactive currency any amounts are converted to the corporate currency For example if your file has AUD

this is imported as USD assuming the corporate currency is US dollars and Australian dollars is an inactive currency with a

conversion rate of
Updating existing accounts and contacts
If the currency code in your import file does not match the existing currency of the record any amounts will be converted to

the currency of the record For example if the import file has GBP and the record has a currency of FIM the amount is

imported as FIM assuming a conversion rate of

If you do not use the Currency ISO Code column or fail to map it any amounts are interpreted as the corporate currency and

then converted to the currency of the record For example if your file has for a record that has a currency of FIM this amount

is interpreted as USD and then converted to FIM assuming the corporate currency is US dollars and Finnish marks has

a conversion rate of

INDEX

I

O

Importing Contacts

Organization Import

***