Unrealized Forex Gain/Loss Report

The Unrealized Forex Report in Odoo helps companies evaluate exchange rate differences on open foreign currency transactions and generate adjustment entries for accurate financial reporting.

Companies that operate internationally often record transactions such as customer invoices, vendor bills, payments, or bank transactions in foreign currencies. When these transactions are first recorded, the system converts the foreign currency amount into the company’s base currency using the exchange rate available at that time.

However, exchange rates fluctuate over time. If a transaction remains open (for example, an unpaid invoice or bill), its value in the company’s base currency may change. This difference between the original recorded value and the current value based on updated exchange rates is known as an Unrealized Foreign Exchange Gain or Loss.

At the end of a financial period or financial year, companies typically review these differences to ensure their financial statements reflect the most accurate valuation of foreign currency balances. The Unrealized Forex Report helps users identify these differences and generate the necessary adjustment journal entries.

Below are the key features and steps to use the report.

1. Configure Gain and Loss Accounts

Before generating adjustment entries, users must configure the accounts used for recording currency differences.

The report provides a configuration section where users can specify:

• Unrealized Forex Gain Account

• Unrealized Forex Loss Account

These accounts will be automatically used when the system generates the adjustment journal entries.

Steps:

1. Navigate to Settings → General Settings → Invoicing.

   

2. Select the appropriate Gain and Loss Accounts.

   

3. Save the configuration.
   

2. Generate Unrealized Forex Adjustment Entries

The report calculates the difference between:

• The original exchange rate used when the transaction was posted, and

• The current exchange rate used for financial reporting.

Users can directly generate the adjustment journal entry from the report.

Steps:

1. Open the Unrealized Forex Report.

   

2. Select the date or financial period for the evaluation and add the current suitable exchange rate for the foreign currencies.

   

3. The Unrealized Forex Report can be viewed as an Excel or PDF Report as well.

   1. Excel View:

      

   2. PDF View:

      

4. Review the calculated unrealized gains or losses.

   

5. Click Create Adjustment Entry.

   

6. Review the adjustment entry details and then click “Create” to create and post the adjustment JE in the system

   

7. The system automatically generates the journal entry using the configured gain/loss accounts.

   

This adjustment ensures the company’s financial statements reflect the latest exchange rate valuation.

3. Reversing the Adjustment in the New Financial Year

Since these adjustments are created only for financial reporting purposes, they are typically reversed at the beginning of the new financial year.

This ensures that the original transaction values remain unchanged and the system can correctly record the actual realized gain or loss once the transaction is settled.