Currency mapping

Knowledge Center > Zuora RevPro > Zuora Billing - RevPro Integration overview > Mapping between Zuora Billing and RevPro > Currency mapping

Currency mapping

Transactions in Zuora Billing or Zuora RevPro can be conducted in various currencies. Since multi-currency transactions are supported in both systems, it is important to understand how currencies in Zuora are mapped to currencies in RevPro.

Currency mapping between Zuora Billing and RevPro

The following table describes the currency mapping relationships between two systems:

Zuora currency type RevPro currency type Description
Rate Plan Charge currency Transactional currency

It is the currency in which the transactions are actually conducted. In Zuora Billing, it is the currency of the Rate Plan Charge and is derived from the Customer Account. 

Entity currency Functional currency It is the home currency in which either Zuora Billing entity or RevPro entity operates. 
N/A Global currency It is the reporting currency in which your RevPro entity publishes financial statements. 

Derivation of exchange rates

Although the transaction currency can be quite different, all transaction lines in RevPro must use a common currency for allocation or reporting purpose. RevPro uses the following exchange rates to convert currencies:

  • Func Ex Rate: Functional exchange rate, which is the exchange rate from the transaction currency to the functional currency.

  • Global Ex Rate: Reporting exchange rate, which the exchange rate from the functional currency to the reporting currency.

The Data Sync job populates the currency exchange rate data into exchange rate tables on a daily basis. The date used to determine the exchange rate is dependent on the data type:

  • For booking data: RevPro takes the sales order date as the exchange rate date to populate the exchange rate. 
  • For billing data: RevPro takes the billing date as the exchange rate date to populate the exchange rate.

If the exchange rate on a specific date is not available in the system, RevPro uses the last available exchange rate.

Example 

Assume that a transaction that takes place in Zuora is in a currency different from the functional currency in RevPro. The following SO line is added to the revenue contract. Note that some column headers are abbreviated as follows:

  • T.Curr: Transaction currency.

  • F.Curr: Functional currency.

  • G.Curr: Reporting currency.

SO date Subscription name Charge num Charge contractual value T.Curr Exchange rate date Func Ex Rate F.Curr Global Ex Rate G.Curr
01-Jun-19 A-100000 C-1 100 EUR 01-Jun-19 1.12 USD 1 USD

In this scenario, the revenue contract is allocated in the functional currency. Therefore, RevPro populates the functional exchange rate and the corresponding date in this SO line. The exchange rate will be used to convert the contractual value in EUR to the value in USD for allocation.

See Multi-currency contracts for more information on how RevPro handles multi-currency contracts.

Last modified

Tags

Classifications

(not set)