29 Calculate Unrealized Gains and Losses
This chapter contains the topic:
29.1 Overview
From General Accounting (G09), choose Revaluation and Restatement
From Multi-Currency Processing (G11), choose Monthly Valuation
From Multi-Currency Monthly Valuation (G1121), choose Monetary Account Valuation
If you use monetary accounts, you will need to periodically calculate and post the unrealized gains and losses on monetary (currency-specific) accounts. Generally, you run the Monetary Account Valuation program at period-end, prior to running financial statements, to do the calculations.
This DREAM Writer program prints a report that lists:
-
Domestic and foreign ledger balances
-
Current domestic value of the foreign currency
-
Unrealized gain or loss amount
Figure 29-1 Monetary Account Valuation Report
Description of "Figure 29-1 Monetary Account Valuation Report"
You can use this report as a trial balance that displays both foreign and domestic amounts. For that reason, you can set the level of detail in a processing option.
If the report includes more than one currency, the total for the foreign ledger balance column is a hash total and, therefore, meaningless.
29.1.1 Before You Begin
-
Verify that the Currency Exchange Rates table (F0015) contains current information. See Section 35.7, "Working with Exchange Rates for Detailed Currency Restatement."
-
Verify that AAI items GVxxx, GWxxx, and GR are set up correctly.
29.1.2 Example: Journal Entry for Unrealized Gain or Loss
The following shows a journal entry for the sample report. The program generates this journal entry if you set the related processing options.
29.1.3 What You Should Know About
| Topic | Description |
|---|---|
| Monetary accounts | If you are using monetary account valuation over accounts that are designated by currency, use version XJDE0001. |
| Non monetary accounts | Use version XJDE0002 if you want to perform monetary account valuation on accounts not designated as monetary accounts, and you are posting balances by currency. |