Previous  Next          Contents  Index  Navigation  Glossary  Library

Unrealized Gain/Loss Report

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 functional 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.

Report Submission

You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.

Selected Report Parameters

Exchange Rate Type. Enter the type of exchange rate for which you want to calculate unrealized gains and losses.

Exchange Date. The date for the Exchange Rate Type you specify.

Summary Option.

Supplier Name. If you want to submit the report for only one supplier, enter the supplier name. Otherwise, leave this field blank.

Selected Report Headings

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 functional 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 functional 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 Posting Hold Report to identify specific invoices with missing exchange rates.

See Also

Foreign Currency Transactions

Entering Daily Rates

Posting Hold Report

Common Report Parameters

Common Report Headings


         Previous  Next          Contents  Index  Navigation  Glossary  Library