Revalue Supplier in Foreign Curr

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).
The difference will go to unrealised gain and loss accounts in the Profit and Loss Statement.



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)

: Revalue customer,supplier and general ledger in foreign currency


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)




Next, go to the Topic : Revalue GL in foreign currency
Back to the topic:       Revalue Customer in foreign currency



Related Topics

Preset Unrealised Gain/Loss in Exchange in Company Profile - Account Settings


Exchange Gain / Loss account in Chart of Accounts


FAQ Can I revalue only at the end of the year?


Supplier Aging





Watch all videos:

Realtimme Training Portal