About the GL Revaluation report
Revalue foreign currency transactions, such as inter-entity transactions, using the General Ledger (GL) revaluation report. For example, before foreign currency inter-entity journal entries are paid, you need to account for unrealized gains or losses due to currency exchange fluctuations. Instead, Intacct provides the option to automatically create a draft journal entry for the unrealized gains or losses due to currency exchange fluctuations.
To access revaluation, go to General Ledger > All > Reports, then select General Ledger revaluation.
Before you revalue: Enable multi-currency transactions in General Ledger.
-
Go to Company > Admin > Subscriptions.
-
Next to General Ledger, select Configure.
-
On the Configure General Ledger page, scroll down to Multi-currency management and select Enable multi-currency subscription.
| Subscription |
General Ledger, Multi-Entity |
|---|---|
| Regional availability |
All regions |
| User type | Business |
| Permissions |
Run GL Revaluation report General Ledger revaluation report |
Who typically needs this report
Typically, you'll want to revalue foreign currency transactions as part of your month-end close before running a consolidation.
For example, depending on your business needs, your month-end close could look something like this:
-
Reconcile bank accounts.
-
Record accrual entries.
-
Record revaluations (GL, AP, AR).
-
Reconcile inter-entity transactions.
-
Tie the subledger to General Ledger.
-
Consolidate.
-
Review and close General Ledger.
What's in this report?
The default GL revaluation report includes the following columns:
| Report Column Heading | Description |
|---|---|
|
Account number |
The account number associated with the account. |
|
Account |
The name of the account. |
|
Posted date |
The date on which the transaction was posted to the journal. |
|
Description |
A text description of the transaction that was posted. |
|
Line |
The line number for the entry in the journal. |
|
JNL |
The name of the journal such as CDJ or GL, for example. |
|
Department |
The department with which the transaction is associated. |
|
Location |
The location for the transaction. |
|
Txn currency |
The currency for the transaction. |
|
Transaction type |
Indicates whether the transaction is a debit or credit. |
|
Txn amount |
The amount of the transaction when posted. |
|
Base currency |
The operating and reporting currency of the entity or location where the transaction posted. |
|
Base amount |
The value of the transaction in the base currency of the entity using the relevant exchange rate at the time the transaction posted. |
|
Reval rate |
The current rate of exchange between the transaction and base currencies. Use the Intacct Daily Rate or a custom rate depending on your business needs. |
|
Revaluation amount |
The revalued transaction amount in the base currency, as calculated by multiplying the revaluation rate by the transaction amount. |
|
Gain |
The difference between the base amount and revaluation amount if the fluctuation resulted in a gain. |
|
Loss |
The difference between the base amount and revaluation amount if the fluctuation resulted in a loss. |
|
Grand total |
The total gains in one column and the total losses in another column of all the transactions in the report. |
|
Net gain or loss |
The net gain or loss as calculated by subtracting the smaller number from the larger number. |
You can select any link to drill down to the details.