Use this report to review unrealized gains and losses on foreign currency invoices. An unrealized gain or loss occurs on an unpaid foreign currency invoice when the exchange rate changes.
You usually calculate unrealized gains and losses at the end of an accounting period. You may also want to submit this report whenever there is a large movement in the value of a foreign currency as compared with your ledger currency.
Payables orders this report by currency and supplier. The report provides you with a total for each currency and a total for all the currencies. Payables prints suppliers names alphabetically within each currency.
Exchange Rate Type. Enter the type of exchange rate for which you want to calculate unrealized gains and losses.
Spot
Corporate
User
User-defined type
Exchange Date. The date for the Exchange Rate Type you specify.
Summary Option.
No. Submit the Unrealized Gain/Loss Report in detail. The report prints detail supplier information.
Yes. Submit the Unrealized Gain/Loss Summary Report.
Supplier Name. If you want to submit the report for only one supplier, enter the supplier name. Otherwise, leave this field blank.
Unrealized gain/loss as of. Exchange date you specify when you submit the report. Payables uses the exchange rate for this date to calculate the unrealized gain or loss on foreign currency invoices for a supplier.
Invoice Amount Remaining. Total amount remaining on foreign currency invoices for a supplier, as expressed in your ledger currency.
If exchange rate information is not available for the exchange rate type on the exchange date you specify, Payables prints <-NO RATE INFORMATION-> in this column. You can enter an exchange rate in the daily rate table for the exchange date you specify and resubmit the report.
Unrealized Gain/Loss. Total unrealized gain or loss for a supplier's foreign currency invoices. The unrealized gain or loss is the difference between the invoice amount as of the GL date of the invoice and the invoice amount as of the exchange date you specify, in your ledger currency.
Number of Invoices Excluded. Number of invoices with missing exchange rates. If an invoice is missing an exchange rate, Payables does not include it in the total amount or the unrealized gain and loss amount. You can submit the Unaccounted Transactions Report to identify specific invoices with missing exchange rates.