Gains Losses and Revaluations Detail Report

If you use multiple currencies, you can use the Gains/Losses and Revaluations Detail report to review and audit gains and losses resulting from the Gains/Losses and Revaluations process.

Contents

For the period that you specify, the report shows the unrealized gains and losses calculated by the Gains/Losses and Revaluations process for unpaid foreign currency accounts payable and accounts receivable transactions and for foreign-denominated account balances.

In addition to the gain or loss amount in the functional currency, the report also displays the current account balance or transaction amount in the original currency and in the functional currency, the prior balance or transaction amount in the functional currency, and the exchange rate used to calculate the gain or loss.

The report does not include the following:

• Realized gains and losses resulting from accounts payable payment processing or the posting of cash receipts for foreign currency accounts payable or accounts receivable transactions
• Cash-basis entries for revaluation gains and losses for foreign-denominated accounts for which Update Cash Basis during Revaluation is selected on the Overview tab of the Accounts form (Settings > General Ledger > Chart of Accounts).

Generate the Report

You can generate the Gains/Losses and Revaluations Detail report in the following ways:

• Select it in Reporting (My Stuff > Reporting).
• Click Print Report on the Actions bar of the Gains/Losses and Revaluations form (Accounting > Gains and Losses). Then, on the Gains/Losses and Revaluations dialog box, select the report options and click Apply.
• Run the Gains/Losses and Revaluations process. When the Gains/Losses and Revaluations Detail dialog box opens automatically at the end of the process, select report options and click Apply. (If you run the Gains/Losses and Revaluations process as a scheduled process, this option to run the report immediately after the process is not available.)

Sorting and Grouping

At the highest level, this report is sorted and grouped into the following sections:

• Foreign Denominated Accounts
• Accounts Receivable
• Accounts Payable

However, you can use Sections to Include options on the Options tab of the report settings to include or exclude each of these sections.

In addition, you can sort and group data within those sections based on the values in the following columns:

• Transaction Currency
• Project/Vendor Number (does not apply to the Foreign Denominated Accounts section)
• Bank/Invoice/Voucher Number
• Account
• Post Period
• Post Seq

Multiple Companies

If you use multiple companies, only gains and losses for the active company are included in this report.