For example, a transaction is conducted in EUR through Zuora Billing, but the home currency for your Zuora tenant is USD. You use Oanda as the exchange rate provider.

• The Invoice Date for this transaction is January 1, 2019, where the exchange rate is 0.75.

• The Invoice Post Date for this transaction is December 31, 2018, where the exchange rate is 0.77.

After you have completed the configuration to sync exchange rates from Zuora Billing to Zuora Revenue, the transaction line in Zuora Revenue is as below:

Without the preceding Zuora Billing settings and Zuora Revenue profile being correctly configured, no exchange rate is synced. Zuora Revenue populates the exchange rate on the invoice date during data transformation. If the exchange rate on the invoice date is not available in the system, Zuora Revenue uses the last available exchange rate.

In this case, the data that is synced to Zuora Revenue Pre-staging tables is as follows:

After data transformation, the exchange rate is populated automatically. The corresponding transaction line in Zuora Revenue Staging tables is as follows:

Because Zuora Billing uses 0.77 as the exchange rate, the billing data mismatch occurs between Zuora Billing and Zuora Revenue. Therefore, it is recommended that you sync the exchange rate from Zuora Billing into Zuora Revenue. By doing so, Zuora Revenue uses the same exchange rate as Zuora Billing, which avoids the data discrepancy between the two systems.