Currency Reports

The Currency reports contain a list of reports that provide insights into your foreign currency transactions and the impact of exchange rate fluctuations across sales, purchases, and payments.

Note Users in custom roles can perform actions and access modules only based on the permissions enabled for them.

Realized Gain or Loss

The Realized Gain or Loss report provides insights into the actual foreign exchange gains or losses incurred from your sales and purchase transactions involving foreign currencies. It includes transactions such as Invoice Payments, Payments Made, and other payments where exchange rate differences are realized. This report helps you understand how currency fluctuations impact your business finances over a selected period.

Scenario A finance team handles multiple customer and vendor payments in foreign currencies. Since exchange rates change between the transaction date and the payment date, they want to track the actual gain or loss realized due to these fluctuations. By using the Realized Gain or Loss report, they can review transaction-level exchange differences and assess the overall impact on profitability.

Here’s how you can view this report:

Navigate to Reports on the left sidebar.
Select Sales in the Report Category pane.
Click Realized Gain or Loss.

When Is Gain or Loss Considered ‘Realized’

A gain or loss becomes realized only when:

A customer payment is received for a foreign currency invoice.
A vendor payment is made in a foreign currency.

Exchange rate changes on outstanding invoices are not realized and do not affect this report.

This reports includes the following columns:

Date: The date on which the transaction was recorded or settled.
Transaction Type: The type of transaction that caused the realisation of gain or loss.
Currency: The symbol of the foreign currency used in the transaction.
Exchange Rate: The exchange rate applied at the time of payment.
Realized Amount: The transaction amount that was paid, converted to the base currency using the applicable exchange rate.
Gain or Loss: The difference between the exchange rate used when the transaction was originally recorded, and the exchange rate used at the time of payment. Positive value indicates a realized gain and negative value indicates a realized loss.
Total Realized Gain: This value represents the net realized gain or loss in the base currency, calculated by summing all individual gains and losses shown in the report.

Unrealized Gain or Loss

The Unrealized Gain or Loss report provides insights into the potential foreign exchange gains or losses on outstanding foreign currency balances as of a specific date. These gains or losses are considered unrealized because the related transactions have not yet been paid. This report helps you evaluate the impact of exchange rate fluctuations on outstanding receivables, payables, and foreign currency bank balances.

Scenario A finance team has open customer invoices, vendor bills, and bank balances in foreign currencies. Since exchange rates fluctuate over time, they want to understand the potential gain or loss if these balances were settled at the current rate. By using the Unrealized Gain or Loss report, they can assess currency exposure and make informed financial decisions.

To view this report:

Navigate to Reports on the left sidebar.
Select Currencies in the Report Category pane.
Click Unrealized Gain or Loss.

You can generate this report for the foreign currencies used in your business at a time. To generate:

Click on + Add Exchange Rate at the top left.
Select the As of date.
Enter the Exchange Rate for each foreign currency.
Click Save.

When Is Gain or Loss Considered ‘Unrealized’

A gain or loss is considered unrealized in cases like:

A foreign currency invoice is issued but not yet paid
A vendor bill is recorded but not yet settled
A foreign currency bank balance is still held

Once the transaction is paid, the unrealized gain or loss becomes realized and appears in the Realized Gain or Loss report.