Foreign Currency Gains and Losses (2024)

Last updated
Save as PDF

Prerequisites

Your Home Currency must be configured before you can use this feature.

What Are Foreign Currency Gains and Losses?

When you sell products or services tocustomers in a foreign currency, the value of that currency changes based on the exchange rate. If the value of the currency goes up or down after youinvoicea customer but before youcollectpayment, then you have made a foreign currency gain or loss on that invoice.

Trial Balance

The following sections describe the Foreign Currency Exchange data in the Balances tab of an accounting period.

See Accounting Period Balancesfor information about the other sections in the Balances tab.See Foreign Currency Conversion for more information about currency conversion in Zuora.

Realized Gains and Losses

A gain or loss is "realized" when the customer pays theinvoice.For example, let's say your Home Currency is USD, and you post an invoicefor 100GBP to a British customer.On the Invoice Date,100 GBP is worth 150USD. On date that the customer pays the invoice, the value of100 GBP has risen to 155 USD. Therefore you make a realized gain of 5 USD.

The following table summarizes the realized gain/loss.

Invoice Amount	Exchange Rate on Invoice Date	Exchange Rate on Payment Date	Realized Gain/Loss
100 GBP	1.50 (100 GBP = 150 USD)	1.55 (100 GBP = 155 USD)	5 USD

Unrealized Gains and Losses

A gain or loss is "unrealized" if the invoice has not been paid by the end of the accounting period.For example, let's say your Home Currency is USD, and you post an invoicefor 100GBP to a British customer.On the Invoice Date,100 GBP is worth 150USD. The invoice has not been paid by the end of the current accounting period.On the last day of the current accounting period, the value of100 GBP has dropped to 145 USD. Therefore, as of the end of the current accounting period, you have an unrealized loss of 5 USD.

The following table summarizes the unrealized gain/loss.

Invoice Amount	Exchange Rate on Invoice Date	Exchange Rate on Last Day of Accounting Period	Unrealized Gain/Loss
100 GBP	1.50 (100 GBP = 150 USD)	1.45 (100 GBP = 145 USD)	(5 USD)

Viewing Your Foreign Currency Exchange Data

After yourun a trial balance or closean accounting period, you can view the Balances tab for data about your Foreign Currency Exchange balance for that period.

Foreign Currency Exchange data is availablein the Balances tab for accounting periods with a start date on or after 01-01-2015. Accounting periods before this date will not have Foreign Currency Exchangedata.

You can view the following:

Foreign Currency Exchange Summary
Realized Gain/Loss Detailed Report
Unrealized Gain/Loss Detailed Report

Each of these is described in detail below.

Note that additional source transaction types and transaction types are only available if you enable the Invoice Settlement feature and the Invoice ItemSettlement feature.

The Invoice Settlement feature is generally available as of Zuora Billing Release 296(March 2021).This feature includes Unapplied Payments, Credit and Debit Memos, and Invoice Item Settlement. If you wantto have access to the feature, see Invoice Settlement Enablement and Checklist Guidefor more information.After Invoice Settlement is enabled, the Invoice Item Adjustment feature will be deprecated for your tenant.

Viewing Consolidated Balancesor Balances forIndividual Currencies

To view a consolidatedForeign Currency Exchange Gains / Lossesbalance for all currencies,select "Consolidated View" from the Currency drop-down menu. Note that if you select Consolidated View, the foreign currency gain and loss information is displayed in the Accounts Receivable section of the Balances tab.

You can also select individual currencies from the drop-down menu to view the balances for that currency only.

Foreign Currency Exchange

To viewyour Foreign Currency Exchange balance on the Zuora UI, navigate tothe accounting period, select theBalancestab, select theforeign currency that you wish to view from the Currency drop-down menu, and then scroll down to the Foreign Currency Exchangesection.

Note that Zuora does not currently provide foreign currency gain and loss data for Credit Balance. Click [Download all Credit Balance Adjustments] to download a preconfigured data source export that can help you manually calculate foreign currency gains and losses for your Credit Balance.

Realized Gain/Loss DetailReport

The Realized Gain/Loss detail report provides a list of transactions with their realized foreign currency gains and losses for the accounting period.

Download from the ZuoraUI

Navigate to the Foreign Currency Exchangesummaryand click [Download Gain / Loss Detail]. A dialog box is displayed. Select Realized Gain / Loss and click ok.

Download Through a URL

Use the following URL, where you replace{accountingPeriodId} with the ID of the accounting period for which you want to view realized gain/loss data:

https://www.zuora.com/apps/AccountingPeriods.dox?method=downloadFXRealizedGainLossDetail&id={accountingPeriodId}

If you want to download or exporta large CSV file, Zuora recommends you to usetext editors other than Microsoft Excel to open the file. The maximum row number that Excel supportsis 1,048,576.

To find the accounting period ID, navigate to Zuora Finance > Accounting Periodsand click onthe accounting period. On the accounting period page,copy the sequence of letters and numbers after id=at the end of the URL, for example, 8a8081ae4b9a132a014bfc6721861190.

Fields in the Realized Gain/Loss Detail Report

The following table describes the fields that are included in the Realized Gain/Loss detail report.

Field	Description
Customer Account Number	Customer account number associated with the transaction.
Customer Account Name	Customer account name associated with the transaction.
<Customer Account Segments>	If you have configured anysegmentsrelated to customer accounts, the segment namesappear here as column headings. The segments are arranged in alphabetical order. SeeFields Supported bySegmentsfor information about which customer account fields are supported on segments.
Customer Account Currency	Currency of the customer account.
Home Currency	Home currency set on your tenant.
Source Transaction Type	Transaction type of the source transaction. Can be the following values: Invoice Invoice Item Credit Memo(only available if you enable the Invoice Settlement feature) Debit Memo(only available if you enable the Invoice Settlement feature) Debit Memo Item(only available if you enable the Invoice Settlement feature) Unapplied Payment(only available if you enable the Invoice Settlement feature) Credit Memo Item(only available if you enable the Invoice Settlement feature) Invoice Payment (future application) An Invoice Payment (future application) occurs when the Payment Date is earlier than the Invoice Date.
Source Transaction Date	Transaction date of the source transaction.
Source Transaction Number	Transaction number of the source transaction.
Source Transaction Exchange Rate Date	Exchange rate date of the source transaction. For example, if the source transaction is an invoice, then the value of this field will be whichever is earlier of theInvoice Date and Posted Date. SeeHow Zuora Calculates Values for the Foreign Currency Conversion Fields for more information.
Source Transaction Exchange Rate	Exchange rateon the Source Transaction Exchange Rate Date.
Transaction Type	Transaction type of the applied amount.Can be the following values: Invoice Invoice Payment Invoice Payment Refund Transaction type of the applied amount.Can be the following values: Invoice Invoice Payment Invoice Payment Refund Payment Application (only available if you enable the Invoice Settlement feature) Refund Application(only available if you enable the Invoice Settlement feature) Credit Memo Item Application(only available if you enable the Invoice Settlement feature) Payment Application Item(only available if you enable the Invoice ItemSettlement feature) Refund Application Item(only available if you enable the Invoice ItemSettlement feature)
Transaction Date	Date when the transaction occurred.
Transaction Number	Transaction number, such asP-00000001for an Invoice Payment.
Applied Amount (Transaction Currency)	The applied amount in the transaction currency.
Transaction Exchange Rate Date	Exchange rate date of the transaction. For example, if thetransaction is an Invoice Payment, then the value of this field will be the Payment Date. SeeHow Zuora Calculates Values for the Foreign Currency Conversion Fields for more information.
Transaction Exchange Rate	Exchange rateon the Transaction Exchange Rate Date.
Source Applied Amount (Home Currency)	Value of the applied amount in your home currencyon theSource Transaction Exchange Rate Date.
Source Applied Amount Currency Rounding	The discrepancy caused by rounding the source applied amountduring currency conversion. Accurate to nine decimal places.
Applied Amount (Home Currency)	Value of the applied amount in your home currencyon theTransaction Exchange Rate Date.
Applied Amount Currency Rounding	The discrepancy caused by rounding the applied amountduring currency conversion. Accurate to nine decimal places.
FX Gain / Loss	Realized foreign currency gain or loss for the transaction. For an Invoice, calculated as follows: `FX Gain / Loss= Transaction Exchange Rate * Applied Amount (Transaction Currency) - Source TransactionExchange Rate * Applied Amount (Transaction Currency)` For an Invoice Payment (future application), calculated as follows: `FX Gain / Loss = Source Transaction Exchange Rate * Applied Amount (Transaction Currency) - Transaction Exchange Rate *Applied Amount (Transaction Currency)`
FX Gain / Loss Currency Rounding	The discrepancy caused by roundingthe GX Gain / Loss amount. Accurate to nine decimal places.

Unrealized Gain/Loss DetailedReport

The Unrealized Gain/Loss detail report provides a list of transactions with their unrealized foreign currency gains and lossesfor the accounting period.

Download from the ZuoraUI

Navigate to the Foreign Currency Exchangesummaryand click [Download Gain / Loss Detail]. A dialog box is displayed. Select Unrealized Gain / Loss and click ok.

Download Through a URL

Use the following URL, where you replace{accountingPeriodId} with the ID of the accounting period for which you want to view unrealized gain/loss data:

https://www.zuora.com/apps/AccountingPeriods.dox?method=downloadFXUnrealizedGainLossDetail&id={accountingPeriodId}

If you want to download or exporta large CSV file, Zuora recommends you to usetext editors other than Microsoft Excel to open the file. The maximum row number that Excel supportsis 1,048,576.

Fields in the Unrealized Gain/Loss Detail Report

The following table describes the fields that are included in the Unrealized Gain/Loss detail report.

Field	Description
Customer Account Number	Customer account number associated with the transaction.
Customer Account Name	Customer account name associated with the transaction.
<Customer Account Segments>	If you have configured anysegmentsrelated to customer accounts, the segment namesappear here as column headings. The segments are arranged in alphabetical order. SeeFields Supported bySegmentsfor information about which customer account fields are supported on segments.
Customer Account Currency	Currency of the customer account.
Home Currency	Home currency set on your tenant.
Source Transaction Type	Transaction type of the source transaction. Can be the following values: Invoice Credit Memo(only available if you enable the Invoice Settlement feature) Debit Memo(only available if you enable the Invoice Settlement feature) Unapplied Payment(only available if you enable the Invoice Settlement feature) Invoice Payment (future application) An Invoice Payment (future application) occurs when the Payment Date is earlier than the Invoice Date.
Source Transaction Date	Date when the source transaction occurred.
Source Transaction Number	Transaction number of the source transaction,such asINV00000001for an Invoice.
Source Transaction Balance (Transaction Currency)	Remainingbalance of the source transactionin the transaction currency. For example, if the source transaction is an Invoice for $100and the customer has paid $25 as of the end of the accounting period, then this field will displaythe remaining balance of $75.
Source Transaction Exchange Rate Date	Exchange rate date of the source transaction. For example, if the source transaction is an invoice, then the value of this field will be the Invoice Date.
Source Transaction Exchange Rate	Exchange rateon the Source Transaction Exchange Rate Date.
Ending Exchange Rate Date	Date used to determine the Ending Exchange Rate.The value of this field is whichever is earlier of: Date of the last day of the accounting period Date that the trial balance was run or theaccounting period was closed
Ending Exchange Rate	The exchange rate on the Ending Exchange Rate Date.
Source Transaction Balance (Home Currency)	Value of the applied amount in your home currencyon theSource Transaction Exchange Rate Date.
Source Transaction Balance Currency Rounding	The discrepancy caused by rounding the source transaction balance during currency conversion. Accurate to nine decimal places.
Ending Transaction Balance (Home Currency)	Value of the applied amount in your home currencyon theEnding Exchange Rate Date.
Ending Transaction Balance Currency Rounding	The discrepancy caused by rounding the ending transaction balance during currency conversion. Accurate to nine decimal places.
FX Gain / Loss	Unrealized foreign currency gain or loss for the transaction. For an Invoice, calculated as follows: `FX Gain / Loss = Ending Exchange Rate * Source Transaction Balance (Transaction Currency)- Source Transaction Exchange Rate * Source Transaction Balance (Transaction Currency)` For an Invoice Payment (future application), calculated as follows: `FX Gain / Loss = Source Transaction Exchange Rate * Source Transaction Balance (Transaction Currency- Ending Exchange Rate *Source Transaction Balance (Transaction Currency)`
FX Gain / Loss Currency Rounding	The discrepancy caused by roundingthe GX Gain / Loss amount. Accurate to nine decimal places.
Prior Period Reversal	This field displays a value of`Y`if you need to reverse the FX Gain / Loss from the previous accounting period. Otherwise, the field remains blank.

Journal Entries

The following section describes the FX gain and los creation for the GL entries.

Note that If the billing document remains unapplied at the end of the accounting period, the original entries are reversed at the beginning of the next accounting period.

Realized gains and losses

Journal entries for realized FX gain and loss are only available when the following configurations areset:

Invoice Settlement is ON. For more information, seethe Invoice Settlement migration checklist and guide.
Create FX Gain Loss GL Entries are set to Yes. For more information, seeConfigure Accounting Rules.

A gain or loss is "realized" inthe following cases if:

Paysthe Invoice or Debit Memo
Credit Memo is applied to Debit Memo or Invoice
Refund is generated to Credit Memo or Payment

For example, let's say your Home Currency is USD, and you post an invoice for 100 GBP to a British customer. On the Invoice Date (1 Jan 2023), 100 GBP is worth 150 USD. On the date (10 Jan 2023) that the customer pays the invoice, the value of 100 GBP has risen to 155 USD. Therefore you make a realized gain of 5 USD.

Considering the FX rates for GBP to USD as follows:

1 Jan 2023 (Invoice Date) - 1 GBP = 1.5 USD
10 Jan 2023 (Payment Date) - 1 GBP = 1.55 USD

Journal Entry Transaction Type - Payment Application (External/Electronic, depending on the payment method).

Debit	Credit
Bank Account - 155 USD Accounts Receivable - 5 USD	Accounts Receivable - 155 USD Realized FX Gain - 5 USD

Scenario for payment unapplied from invoice.

If the same payment (dated 10 Jan 2023) is unapplied from the invoice (dated 1 Jan 2023), then it would be a Realized gain of 5 USD.

Considering the FX rates for GBP to USD as follows:

1 Jan 2023 (Invoice Date) - 1 GBP = 1.5 USD
10 Jan 2023(Payment Date) - 1 GBP = 1.55 USD

Debit	Credit
Accounts Receivable - 155 USD Realized FX Gain - 5 USD	On Account - 155 USD Account Receivable - 5 USD

Similarly, when a Credit Memo (dated 10 Jan 2023) of 100 GBP is applied to a Debit Memo of 100 GBP and on the Debit Memo date (1 Jan 2023), 100 GBP is worth 150 USD, while on the Credit Memo date, it has fallen to 145 USD. Therefore, it is a realized loss of 5 USD.

Considering the FX rates for GBP to USD as follows:

1 Jan 2023 (Debit Memo Date) - 1 GBP = 1.5 USD
10 Jan 2023(Credit Memo Date) - 1 GBP = 1.45 USD

Journal Entry Transaction Type - Credit Memo Application Item.

Debit	Credit
On Account - 145 USD Realized FX Loss - 5 USD	Accounts Receivable - 145 USD Accounts Receivable - 5 USD

Next, if the Credit Memo of 100 GBP is refunded and on the Credit Memo date (1 Jan 2023) 100 GBP is worth 150 USD while on the refund date (10 Jan 2023), it has fallen to 145 USD, it is a realized gain of 5 USD.

Considering the FX rates for GBP to USD as follows:

1 Jan 2023 (Credit Memo Date) - 1 GBP = 1.5 USD
10 Jan 2023 (Refund Date) - 1 GBP = 1.45 USD

Journal Entry Transaction Type - Refund Application (External/Electronic depending on the refund method).

Debit	Credit
Customer Cash on Account - 145 USD Customer Cash on Account - 5 USD	Bank Account - 145 USD FX Gain 5 USD

Unrealized gains and losses

Journal entries for unrealized FX gain and loss are only available when the following configurations areset:

Invoice Settlement is ON. For more information, seethe Invoice Settlement migration checklist and guide.
Create FX Gain Loss GL Entries are set to Yes. For more information, seeConfigure Accounting Rules.

A gain or loss is "unrealized" if the invoice/DM/unapplied credit memo/Unapplied Payment has not been paid/applied by the end of the accounting period.

For example, say your Home Currency is USD, and you post an invoice for 100 GBP to a British customer. On the Invoice Date (1 Jan 2023), 100 GBP is worth 150 USD. The invoice has yet to be paid by the end of the current accounting period. On the last day of the current accounting period (31 Jan 2023), the value of 100 GBP has risen to 155 USD. Therefore, as of the end of the current accounting period, you have an unrealized gain of 5 USD.

Considering the FX rates for GBP to USD as follows:

1 Jan 2023 (Invoice Date) - 1 GBP = 1.50 USD
31 Jan 2023 (Last AP Date) - 1 GBP = 1.55 USD

The following table summarises the unrealized gain/loss:

Debit	Credit
Accounts Receivable - 5 USD	Unrealized FX Gain - 5 USD