Unrealized gains and losses from foreign currency translation are included in

Currency gains and losses are based on exchange rate fluctuations that occur on transactions that involve more than one currency. Two types of gains and losses exist:

Unrealized gains and losses are calculated on unpaid invoices the open portion of partially paid invoices at the end of a fiscal period, whereas realized gains and losses are calculated at the time of receipt.

16.1.1 Realized Gain/Loss Calculations

To calculate realized gains and losses, you must post receipts. Realized gains and losses are based on exchange rate fluctuations that occur between transactions that involve a foreign or alternate currency receipt. When you post receipts, the system calculates gains and losses based on whether the exchange rates changed from the date of the invoice to the date of the receipt. If exchange rates changed, the system creates journal entries for the gains and losses.

Realized gains and losses are calculated when you apply receipts to the invoices, but they are recognized in the general ledger when you post the receipts. To calculate the gain or loss, the system determines if the exchange rate changed between the invoice date and the receipt date as described:

  • The invoice date is the date that was used to retrieve the exchange rate to calculate the invoice amounts.

    The invoice date can be either the DGJ (Invoice GL Date) or the DIVJ (Invoice Date) in the F03B11 table. You set a processing option in the P03B0011 Master Business Function to specify which date is used when you create an invoice.

  • The receipt date is the date in the DGJ (Receipt GL Date) field in the F03B14 table.

    This is the date on the receipt detail item that the invoice was paid.

To summarize, the system determines which invoice date (DGJ or DIVJ) was used when the invoice was created and uses that as the invoice date to calculate the gain or loss.

For foreign currency receipts, the potential exists for a standard gain or loss. To calculate the gain or loss, the system multiplies or divides the invoice amount by the difference in the exchange rate from the time the invoice was entered and the time the payment was received.

If an alternate currency receipt is involved, the potential exists for two gains or losses on a transaction:

  • Standard gain/loss. An amount based on exchange rate differences between the foreign (transaction) currency and the domestic currency from the transaction date to the receipt date.

  • Alternate currency gain/loss. An amount based on exchange rate differences between the alternate (receipt) currency and the domestic currency. This gain or loss is the difference between:

    • The amount calculated by converting the alternate currency receipt directly to the domestic currency (this is the amount that is actually deposited to or paid from the bank account)

    • The amount calculated by converting the alternate currency receipt to the foreign currency to the domestic currency

16.1.1.1 Example: Realized Gain/Loss on Foreign Currency Invoices and Receipts

In this example, a British company enters an invoice in U.S. dollars (foreign currency) and receives payment in USD (foreign currency).

Because of the exchange rate risk, the potential exists for one gain or loss, based on the fluctuation of exchange rates between the domestic currency and the foreign currency at the time payment is received.

DescriptionCurrencyAmountExchange Rate January 1Exchange Rate February 1Invoice (domestic)GBP303.60Invoice (foreign)USD500.001 USD = 0.6072 GBPReceipt (foreign)USD500.001 USD = 0.6081 GBPStandard gain/lossGBP+ 0.45

The foreign currency invoice on January 1 is 500.00 USD, which is 303.60 GBP in the domestic currency.

500.00 USD × 0.6072 = 303.60 GBP

The foreign currency receipt on February 1 is 500.00 USD.

16.1.1.2 Standard Gain/Loss

The standard gain/loss is + 0.45 GBP. This amount is based on exchange rate fluctuations from the invoice date to the receipt date.

500.00 USD × 0.6081 (exchange rate on receipt date) = 304.05 GBP

500.00 USD × 0.6072 (exchange rate on invoice date) = 303.60 GBP

304.05 − 303.60 = + 0.45 GBP

16.1.1.3 Example: Realized Gain/Loss on a Foreign Invoice and Alternate Currency Receipt

In this example, a French company enters three invoices in Canadian dollars (CAD) and receives payment in Japanese yen (JPY).

When the receipt is entered, the receipt amount (JPY) is compared to the foreign and domestic invoice amounts to determine whether the debt has been satisfied. Because the three currencies involved in the transaction fluctuate against one another, the potential exists for:

  • Standard gain/loss between EUR and CAD.

  • Alternate currency gain/loss between JPY, CAD, and EUR.

    DescriptionCurrencyAmountExchange Rate January 1Exchange Rate February 1Invoice (domestic)EUR356.34Invoice (foreign)CAD500.001 CAD = 0.71268 EURReceiptJPY38,8501 CAD = 0.70882 EUR

    1 JPY = 0.009163 EUR

    1 JPY = 0.01287 CAD

    Standard gain/lossEUR–1.93Alternate currency gain/lossEUR+ 1.57

The foreign currency invoice on January 1 for 500.00 CAD, which is 356.34 EUR in the domestic currency. The EUR amount is calculated as follows:

  • 500.00 CAD × 0.71268 = 356.34 EUR

    The alternate currency receipt on February 1 is 38,850 JPY.

    The foreign currency amount applied to the invoice is 500.00 CAD.

  • 38,850 JPY × 0.01287 = 500.00 CAD

    The domestic currency amount applied to the invoice is 354.41 EUR.

  • 500.00 CAD × 0.70882 = 354.41 EUR

    The domestic currency amount of the receipt is 355.98 EUR

  • 38,850 × 0.009163 = 355.98 EUR

16.1.1.4 Standard Gain/Loss

The standard gain/loss is –1.93 EUR. This amount is based on exchange rate fluctuations from the invoice date to the receipt date.

500.00 CAD × 0.70882 (exchange rate on receipt date) = 354.41 EUR

500.00 CAD × 0.71268 (exchange rate on invoice date) = 356.34 EUR

354.41 − 356.34 = –1.93 EUR

16.1.1.5 Alternate Currency Gain/Loss

The alternate currency gain/loss is + 1.57 EUR. This amount is calculated using exchange rates on the receipt date. It is based on the difference between converting the alternate currency directly to the domestic currency and converting the alternate currency to the foreign currency to the domestic currency.

What is unrealized gain or loss on foreign exchange?

Unrealized gains or losses are the gains or losses that the seller expects to earn when the invoice is settled, but the customer has failed to pay the invoice by the close of the accounting period.

What is foreign currency translation gains or losses?

A foreign currency exchange gain or loss is the gain or loss realized due to the change in exchange rates between the booking date and the payment date of a transaction involving an asset or liability denominated in a nonfunctional currency.

How are translation gains and losses accounted for?

The gains and losses arising from foreign currency transactions that are recorded and translated at one rate and then result in transactions at a later date and different rate are recorded in the equity section of the balance sheet.

Where are foreign exchange transaction gains or losses reported in the financial statements?

The foreign currency gain is recorded in the income section of the income statement.