|Top Previous Next|
This topic require you to have fairly good accounting knowledge. You may want to seek your accountant for assistance.
Revaluation of foreign currency only affects the unpaid balances of the suppliers' accounts.
For example a supplier is owed with US1,000.00 in March this year and was book in to the account @ 1.300 or SGD1,300.00.
If this amount remains unpaid in April this year and the rate falls to 1.2000, the same USD1,000 will be worth (or equivalent) SGD1,200.00
Similarly, if the rate rises to 1.3200, the same USD1,000 will be worth SGD1,320.00.
To report the debt (owing by the company) in the Balance Sheet, the debt must be translated to the base currency based on the exchange rate in the month that you are reporting your financial statement.
So if you are reporting your Balance Sheet in April, you must report the debt as SGD1,200.00( x'rate @ 1.2000) or SGD1,320.00 (x'rate @ 1.320).
It has the effect of reducing the purchase from SGD1,300.00 to SGD1,200.00 so that the purchase will not be overstated (if the rate falls from 1.3000 to 1.2000)
Likewise, it has the effect of increasing the purchase from SGD1,300.00 to SGD1,320 so that the purchase will not be understated (if the rate increase from 1.3000 to 1.320)
To auto-generate unrealised exchange gain / loss in Suppliers’ foreign currency account
Exercise: Assuming the month end rate of USD as at April 2020 is 1.3800. Check you currency rate table
Step 1: Set all foreign currency rates as at month end
Step 2: Click [A/C Entry] --> [Revalue Accounts] --> [Add] ,
System will take closing rate of all currencies as at 30/04/2020 set out in the currency rate setting table
(Take note the Ref No#. is sharing the reference number of Journal Posting)