home

Accounts Receivable

Zuora BillingZuora PaymentsZuora PlatformZuora CPQZephrZuora RevenueAccounts ReceivableRelease NotesBasicsEntitlementsSupport and policies
Zuora BillingZuora PaymentsZuora PlatformZuora CPQZephrZuora RevenueAccounts ReceivableRelease NotesBasicsEntitlementsSupport and policies

Welcome to Zuora Product Documentation

Explore our rich library of product information

Show Contents

thumbnailAccounts Receivable

Foreign currency conversion for data source exports

Currency conversion fields added to the export

The foreign currency conversion fields that are automatically added to the data source export

The following table describes the foreign currency conversion fields that are automatically added to the data source export. The "Field Name" column gives the names of the fields as they appear when you create the export using the SOAP API. If you create the export from the Zuora UI, the field names are formatted differently. For example, "Invoice.AmountHomeCurrency" would instead be "Invoice: Amount (Home Currency)".

Field name

Description

<Object>.AmountHomeCurrency

The amount in your home currency.

Note that the name of this field differs depending on the base object. For example, for the Invoice Item object, this field is called "InvoiceItem.ChargeAmountHomeCurrency".

<Object>.AmountCurrencyRounding

Rounding difference in the amount.

  • With an inverse rate: [Rounding difference] = [transaction amount] * [exchange rate] - [home currency amount]

  • With an non-inverse rate: [Rounding difference] = [transaction amount] / [exchange rate] - [home currency amount]

<Object>.ExchangeRate

The exchange rate used to convert the transaction currency into your home currency.

<Object>.ExchangeRateDate

The date used to determine the exchange rate.

<Object>.HomeCurrency

The home currency configured on your tenant.

<Object>.ProviderExchangeRateDate

The exact date used to get the rate from the exchange rate provider.

For example, you use the monthly rate and set the day of month to 1. For a transaction with the date "2015-10-15", the Exchange Rate Date is "2015-10-15" while the Provider Exchange Rate Date is "2015-10-01".

<Object>.TransactionCurrency

The currency used by the customer.

RatePlanCharge.BookingExchangeRate

The exchange rate used to convert the transaction currency into the home currency.

Zuora determines the value of the Booking Exchange Rate Date field based on the Original Order Date field.

This field is only available for the Rate Plan Charge object.

RatePlanCharge.BookingExchangeRateDate

The date used to determine the RatePlanCharge.BookingExchangeRate.

This field is only available for the Rate Plan Charge object.

RatePlanCharge.BookingProviderExchangeRateDate

The exact date used to determine the rate from the exchange rate provider.

This field is only available for the Rate Plan Charge object.

Last updated: October 10, 2025