Previous  Next          Contents  Index  Navigation  Glossary  Library

Cross Currency Exchange Gain/Loss Report

Use this report to review detailed information about your cross currency settlements.

This information includes:

You can run this report from the Print Account Reports window.

Attention: To run this report, you must set up Receivables to use cross currency settlements. See: Setting Up Cross Currency Receipts.

Report Parameters

Enter report parameters to determine the content of your report. When you request this report, Receivables lets you specify the following options:

Customer Name: To include only receipts for a specific customer in this report, enter a customer name. Leave this field blank to include receipts for all customers.

Location: If you entered a Customer, enter a customer site to include only receipts for that site (optional). Leave this field blank to include receipts for all of this customer's sites.

From Receipt Date: To include only specific receipts in this report, enter the receipt creation date from which you want to include receipts. Leave this field and the To Receipt Date field blank to include receipts in this report regardless of their creation date.

To Receipt Date: If you entered a From Receipt Date, enter the last date for which you want to include receipts in this report. Leave this field blank to include all receipts entered through today's date.

Receipt Currency: To include only receipts denominated in a specific currency in this report, enter a currency.

Exchange Rate Type: Enter the exchange rate type to use as the system cross currency rate in the Rate Reconciliation section of this report (optional). This parameter specifies the conversion rate used to convert the receipt currency to the transaction currency.

If you do note enter an Exchange Rate Type, the Rate Reconciliation section will not appear in this report. The Rate Reconciliation section lets you view the gain or loss that you would have incurred for this application if you had used the cross currency rate maintained in your general ledger instead of the rate used by your customer.

Report Headings

Report headings provide general information about the contents of your report, such as report title, report date and time, and your set of books name.

Customer: The name of the customer whose data this report includes. If you specified a customer in the report parameters, the report displays information for only this customer; otherwise, the report displays information for all customers.

Site: The customer site whose data this report includes. If you specified a site in the report parameters, the report includes information for only this site; otherwise, the report displays information for all sites.

Receipt: The receipt number.

Date: The receipt creation date.

Amount: The amount of this receipt.

Receipt Currency: The currency of this receipt.

Rate Type: The rate type used to convert your receipt currency to the currency of the transaction. If you do not enter a Rate Type, the report does not include the Rate Reconciliation section.

Column Headings

When you run this report, Receivables provides the following information for each invoice matching your selection criteria.

Transaction Section

Transaction Number/Date/Currency: The number, creation date, and the entered currency for this transaction.

Amount Applied: The amount applied to this transaction in the transaction currency.

Amount Applied Base: The amount applied to this transaction converted to your functional currency on the date of the application.

Actual Application Section

Allocated Receipt Amount: The amount applied to this transaction in the receipt currency.

Allocated Receipt Amount - Base: The amount applied to this transaction converted to your functional currency on the date of the receipt.

Cross Currency Rate: The exchange rate used to apply the receipt to this transaction. This is the exchange rate as of the receipt date (for the selected rate type).

Exchange Gain/Loss: Measured in your functional currency, the exchange gain or loss incurred on this receipt application. These gains or losses arise from changes in the exchange rates between the receipt and the transaction currency. Receivables uses the following formula to calculate this amount:

Allocated Receipt Amount (Base) - Amount Applied (Base) = Exchange Gain or <Loss>

Rate Reconciliation Section

Attention: If you did not enter a Rate Type in the report parameters, the report does not include this section.

Absolute Difference: The absolute difference between the exchange gain or loss in the Actual Application section and the Rate Reconciliation section. This is expressed as a positive number.

Allocated Receipt Amount: The portion of this receipt that was applied to the transaction in the receipt currency.

Allocated Receipt Amount - Base: The portion of this receipt that was applied to the transaction in your functional currency.

Exchange Gain/Loss: The gain or loss you would have incurred on this application if you had used the cross currency rate maintained in your general ledger (see System Cross Currency Rate, above).

System Cross Currency Rate: The exchange rate maintained in your general ledger (with the selected rate type) between the transaction and receipt currency on the receipt date.


         Previous  Next          Contents  Index  Navigation  Glossary  Library