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.
