Revaluation of Foreign Currency accounts

Revaluation of Foreign Currency accounts

During the normal course of transactions Foreign currency accounts accounting values may not not match your book rate.
Doing a revaluation will set back the accounting value to match your book rate.

In the system you can use the Unrealised Exchange Module to do revaluation.
Adjustment -> Closing -> Unrealised Exchange.

Select the account to post the difference to.
under 'code'
select the accounts you want to reevaluate ( in my example it is the UOB USD account)
you can tick 'exclude currency' to prevent certain currency to be included in the revaluation (this is usefully when using Trade Debtor/Creditor accounts)
Click 'Post' Button.


*Do not use 'Post reverse' button if you have mistake in your exchange rate.
Adjust the rate and use the 'Post' Button. 
'Post Reverse' Button will post an entry in on the first day of the next month ( 'Post Reverse' button is not a undo button)

Before doing the revaluation, you can generate the 'Unposted Unrealised exchange entries'
After the revaluation, you can generate the 'Posted Unrealised Exchange entries' to view the calculations.



    • Related Articles

    • 4.0. Currency Exchange Rate Table

      Different Ways of entering Exchange Rates STEPS: DATE FROM enter 1 Jan 12 DATE TO enter 31 Jan 2012 Effective date range EXCHANGE RATE enter 0.015397 To enter an exchange rate of 1 JPY = 0.015397 SGD MULTIPLY select 1 DIVISION click Un-Tick By ...

    • 7.0. Accounts Receivable in Foreign Multi Currency

      Issue an Invoice in Foreign Multi Currency When Rates are not available STEPS: Click SALES activity Click INVOICE module Click NEW DATE select 15 Dec 11 CUSTOMER create & select EveryDay Customer Pte Ltd CURRENCY select USD EXCH. RATE Notice the ...

    • 9.0. Accounts Payable in Foreign Multi Currency

      Making a USD deposit to Supplier STEPS: AMOUNT enter 1,000 USD BANK RATE check if it’s 1 PAYMENT AMOUNT check for 1,000 Click ADD Close module STEPS: Click REPORT activity Click AR/AP Click STATEMENT OF ACCOUNT module BUSINESS PARTNER select ...

    • 3.0. Currency Registration

      Understanding Multi Currency Registration STEPS: Click SETUP activity Click ACCOUNTS Click CURRENCY module Click NEW CODE Unique Code ISO CODE This code is mainly use for IAF data generation Name Currency Name use in Amount in words translation ...

    • 6.0. Exchange Gain or Loss

      Realised Exchange Gains or Loss Accounting for foreign currency transactions has two parts. The first part is recording the original transactions. The second part is recording when you pays or receives the money in a foreign currency. Base on the ...