Unrealised Currency Gain/Loss Report Function in Odoo18

Odoo18 tracks unrealised currency gains and losses to capture the effects of exchange rate changes on open invoices and foreign currency balances. helps businesses ensure that their financial statements appropriately reflect the value of their payables and receivables on a given reporting date. These unrealised adjustments ensure compliance with accounting standards by highlighting the potential impact of exchange rate variations on financial performance. Odoo uses the current exchange rates to automatically calculate these gains or losses at period closings. This tool enhances visibility into currency risk, which helps make better financial decisions.

Unrealised Currency Gain & Loss Report Function in Odoo18

Odoo18 supports multi-currency transactions for global business needs. while maintaining accurate financial records in the company’s base currency. Currency rates can be manually established or updated automatically through linkages with web exchange rate providers to guarantee proper conversions. This competency supports international operations, accurate reporting, and compliance with international accounting standards.

Now let’s look at how the Unrealised Currency Gain & Loss report function in Odoo18 works. For the purposes of this discussion, let’s assume that there is an Indian client. The user generated an invoice and set the customer’s payment date one month after the invoice date. Therefore, there may be some changes to the currency exchange rate within a month. Odoo18 uses these Unrealised Gain & Loss reports to handle these changes.

Make a fresh invoice. To do so, select the Invoice option from the Customer menu. Details such as the Invoice Number, Customer, Invoice date, Due date, Tax included, Total, and Status are displayed for each invoice. Click the New button to add a new invoice.

Customers-> Invoices-> New

Include the client; in this case, the client is from UAE. AED is the currency used for invoicing. The invoice date is April 16th, and the payment is due on June 16th, which is two months from now.

One quantity of Acoustic Bloc Screen, priced at $750.00 per unit, or 3384.40 AED, was added to the invoice line. Verify the invoice first.

The Unrealised Currency Gain & Loss report function in Odoo18 should be examined. The Reporting menu contains the report. It is also part of the Management Report.

How Odoo18 Displays Foreign and Company Currency Balances

The Unrealized CurrencyGain & Loss report provides a detailed breakdown of the transactions conducted in various currencies. The invoice’s transaction amount is displayed here under the Balance in Foreign Currency. Then the Balance at the Operation Rate shows the transaction amount in company currency.

So users can update exchange rates automatically. From the Configuration menu, select Settings for that. Automatic Currency Rates is an option under Currencies. Update the currency rate and select the interval.

Click on the Currencies from the Configuration to see the most recent rate. A list of currencies will show; choose the required one on the list. The Rates tab displays the most recent rate. 4.78163195.. is the latest rate unit per USD.

The bill has not been settled yet. Let’s settle the bill first. To do that, select the generated invoice once more. Click the Pay button to complete the payment.

Within the payment, the date of payment will be displayed. The date of payment is displayed as June 16, 2025.

This invoice was generated on April 16, 2025. The exchange rate was 4.51253195.. units to the US dollar on that date. The exchange rate for the payment date, however, has been raised to 4.78163195.. units per USD, and the payment date is June 16, 2025.

Now Let’s take another look at the Unrealised Currency Gain & Loss report function in Odoo18. A few updates have been made. Examine them. The information following the currency rate update is displayed in the screenshot below.

How Odoo Displays Invoice Amounts in Dual Currencies

As previously stated, the invoice transaction amount is displayed in the Balance in Foreign Currency, and the company currency transaction amount is displayed in the Balance at the Operation Rate. The Acoustic Bloc Screen product is actually sold for $750.

The current exchange rate, following an update, is 4.78163195.. units per USD. Therefore, the adjustment is the difference between the balance at the operation rate and the balance at the current rate. The balance at the current rate is computed as follows: (Balance in Foreign Currency / Current rate).

Current Rate of Balance = 3384.40 / 4.78163195.. = 707.79 707.79 – 750.00 = (- 42.21) is the adjustment.

Manual exchange rates can be added by users. As seen in the screenshot below, exchange rates are displayed at the top of the screen.

The Unrealised Gain & Loss report of Odoo18 helpsyou to track the impact of exchange rate changes on ongoing transactions. It ensures compliance with Odoo18 accounting regulations by accounting for any gains or losses brought on by currency changes at a specific reporting date. By providing businesses with the information they need to effectively manage currency risk, this report enhances financial transparency.

Want to optimize your UAE business global financial processes and mitigate currency risks? With Odoo 18’s financial management capabilities you can simply overcome these headaches. Contact us today As your Trusted Odoo81 certified Silver partner in UAE for a personalized Odoo consultation and get know how Transines Solutions can help your business succeed in a multi-currency world.