The Realized Exchange Rate Gains and Losses report is used to get the realized gain and loss by transaction for a given period of time. Each source transaction, related payment transaction, and realized gain or loss for the transaction reported in base currency are all presented in the report. Drill down the report to get the source invoice, vendor bill, and applied payment from the report. The impact on the general ledger can be seen by drilling down from the transaction detail.
The transaction audit trail with realized gain or loss for the period is available for month-end processes. The Realized Gain/Loss account is included as Other Expense on the Income Statement. It lists the transactions that have been closed and that posted a difference to the Realized Gain/Loss account. Only the revaluation of currency amounts on paid transactions is reflected in this report. This report groups transactions by Accounts Payable and Accounts Receivable, and then by entity name in alphabetical order. The transaction order within each entity name group is chronological by posting date for the realized gain/loss.
The following columns are standard:
- Name – Name of the entity (customer, vendor, or project)
- Subsidiary – Subsidiary for the transaction
- Source Trans Number – The number of the source transaction (invoice, vendor bill, or journal that functions as a bill or invoice). For vendor bills, the number shown is the reference number if the bill has one. If the bill does not have a reference number, the internal ID is displayed.
- Source Accounting Period – The period in which the source transaction was posted
- Source Trans Date – Date of the source transaction
- Source Trans Type – Invoice, vendor bill, or journal that functions as a bill or invoice
- Source Account – The account to which the source transaction posted
- Source Exchange Rate – The exchange rate on the source transaction
- Pmt Trans Number – The number of the payment transaction (bill payment, payment, credit memo, customer deposit, or journal applied as a payment)
- Pmt Accounting Period – The Period in which the payment transaction posted
- Pmt Trans Date – Date of the payment transaction
- Pmt Trans Type – Bill payment, payment, credit memo, customer deposit, or journal applied as a payment
- Pmt Exchange Rate – The exchange rate on the payment transaction
- Transaction Currency – The currency of the source and payment transactions
- Applied Amount – The payment amount applied to the source transaction in the transaction currency
- Applied Amount (Base) – The payment amount applied to the source transaction that is converted to the base currency using the payment exchange rate
- Realized Gain/Loss Trans Number – The number of the transaction that includes the posting for realized gain or loss.
- Realized Gain/Loss Posting Period – Period in which the realized gain or loss posted
- Realized Gain/Loss Posting Date – Date of the realized gain/loss transaction
- Realized Gain/Loss – Amount of the realized gain or (loss) in the base currency
To see the Realized Exchange Rate Gains and Losses report:
- Go to Reports > Financial > Realized Exchange Rate Gains and Losses.
- Adjust the values for Period, From, and To as needed.
- Adjust other filters if needed.
- Click Refresh.