Reports & Analytics

Reading and interpreting the FX Gain/Loss report

Understand what each column and figure in the FX report means and how to spot trends.

Jul 11, 2026

The FX Gain/Loss report tracks the financial impact of exchange rate fluctuations. Understanding its columns and calculations helps you assess currency risk and report accurate results to management or regulators.

What the report shows

Realized vs. unrealized gains/losses:

  • Realized: Gains or losses from transactions that have been completed (e.g., a payment made, an invoice settled). These affect your current period's profit or loss.
  • Unrealized: Gains or losses from open balances (receivables, payables, cash) still held in foreign currency. These change as exchange rates move and are often adjusted at period-end for reporting.

Key columns

ColumnMeaning
Transaction/Balance DateThe date when the transaction occurred or the balance was recorded.
Currency PairThe foreign currency and your base currency (e.g., USD/AFN).
Amount in Foreign CurrencyThe original amount in the foreign currency.
Exchange Rate at TransactionThe rate used to record the transaction.
Exchange Rate at Report DateThe current rate used to calculate the unrealized gain/loss.
Original Balance (Base Currency)The amount in your base currency when the transaction was first recorded.
Current Balance (Base Currency)What that amount is worth today at the current exchange rate.
Gain/LossThe difference (positive = gain, negative = loss).

How it works in Usystems

  • Each transaction in a foreign currency is recorded at the rate on that date.
  • At each reporting period, the system recalculates open balances using the current rate.
  • The difference is the unrealized gain or loss for that period.
  • When a transaction settles (e.g., you receive payment in the original currency), it becomes realized.

Tips for interpretation

  • Focus on net exposure: Sum all gains and losses by currency pair to understand your overall FX position.
  • Watch for concentration: Large amounts in a single currency or account may indicate significant exposure to one currency's movements.
  • Compare periods: Trends in gains/losses across months show whether volatility is increasing or your currency exposure is changing.
  • Balance sheet vs. P&L impact: Unrealized gains/losses appear on the balance sheet; realized ones flow through profit and loss.

Was this helpful?

More like this