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 ( ).
Generate the Report
You can generate the Gains/Losses and Revaluations Detail report in the following ways:
- Select it in Reporting ( ).
- Click Print Report on the Actions bar of the Gains/Losses and Revaluations form ( ). 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.
- Related Topics:
- Gains Losses and Revaluations Detail Columns & Groups Tab
Use the Columns & Groups tab to organize and group data and to select the columns to display on your report. - Gains Losses and Revaluations Detail Options Tab
Use the Options tab to select report options for the Gains Losses and Revaluations Detail report. - Gains Losses and Revaluations Detail Layout Tab
Use the Layout tab to choose the types of formatting properties and visual characteristics to be displayed on your report. - Columns for Gains Losses and Revaluations Detail Report
You can select the columns to display on your report.