Multi Currency / Result / Report

10.0. Multi Currency Report

Re-Valuing Bank Amount

Note that the Local Amounts shown for your Foreign Bank Balance, Balance Sheet, and other reports are calculated based on your document transactions exchange rates. Hence, it should NOT be taken as the current valuation. As exchange fluctuates over time, you may have to do a revaluation based on current exchange rate.


Alert
STEPS:
  1. Click REPORT activity
  2. Click FINANCIAL
  3. Click BANK BALANCE module
  4. ACCOUNT select Bank USD
  5. DATE FROM select 1 Jan 12
  6. DATE TILL select 30 Jun 12
  7. BALANCE ACC check for SGD2,288.84
    Notice the SGD value is 11,592 which is based on 1.288
    Assuming the current rate is now 1.2 and you would like to do a re- valuation.
    Take note the rate is SGD2,288.84 divide by USD1,777.05= Exchange rate is 1.288



Alert
STEPS:
  1. Click SETUP activity
  2. Click ACCOUNTS
  3. Click CURRENCY module
    Details Add:
  4. DATE FROM select 01 Apr 12
  5. DATE TO select 30 Jun 12
  6. EXCHANGE RATE enter 1.2 You have to update the exchange table with new rate.




Alert
STEPS:
  1. Click ADJUSTMENT activity
  2. Click ADJUSTMENT
  3. Click JOURNAL ENTRY module
  4. DATE select 30 Jun 12
  5. SUBJECT enter Bank Revaluation Select date as per the day you would like to revalue.
  1. Details Line 1:
  2. ACCOUNT select Bank USD
  3. CREDIT enter 9000
  4. EXCHANGE RATE enter 1.288 Line 1, you have to temporarily credit out the total foreign amount.
    For exchange rate, enter the rate you have calculated earlier.
  1. Details Line 2:
  2. ACCOUNT select Bank USD
  3. DEBIT enter 9000
  4. EXCHANGE RATE enter 1.2
    Line 2, the total amount is debit back. But a different exchange rate is entered.
    TOTAL check for -792.00 
     Notice that entry may look balance in foreign currency; it is not in local currency. There is a difference of SGD792.
  1. Details Line 3:
  2. ACCOUNT select Bank Revaluation
  3. expense account
  4. DEBIT enter 792
  5. CURRENCY select SGD
    TOTAL check for 0 This will post the difference to the expense account, and hence balance this journal entry.

Unrealised Exchange Gain or Loss



Alert
STEPS:
  1. Click ADJUSTMENT activity
  2. Click CLOSINGS
  3. Click UNREALISED EXCHANGE module
  4. Click NEW
  5. DATE select cut-off MONTH Dec & YEAR 2012
  6. UNREASLISED EXCHANGE A/C select
  7. EXP1200 Note. Depending on your management preference, for Unrealised Exchange A/C to post to, you can select between a Cost, Expense or Capital Account.
    Details
    For Code, you may add as many
  8. CODE select Bank USD
  9. EXCHANGE RATE enters the exchange rate as of the date of cut-off date.
  10. CLICK ADD
    accounts as you would like to valuate.
    E.g. Trade Debtors, Trade Creditors, Bank accounts, etc.

Applying Unrealised Exchange Gain or Loss on Profit & Loss Statement



Alert
STEPS:
  1. Click REPORT activity
  2. Click FINANCIAL
  3. Click Profit/Loss module
  4. DATE FROM select 1 Jan 12
  5. DATE TO select 31 Dec 12
  6. UNREASLISED EXCHANGE click Tick
  7. Click REFRESH Depending on the period selected, the system will automatically apply the appropriate Unrealised Exchange scenarios you have created earlier.
  8. Click PRINT UNREALISED REPORT This will list out the accounts that have been re-valuated and how the unrealised amount is derived.
  9. Close module
    Note. During the process of generating the Unrealised Exchange scenarios, if you have selected a Capital/Owner Equity Account instead, you will need to go to Balance Sheet to view the Unrealised Exchange value.

    • Related Articles

    • 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 ...

    • 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 ...

    • 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 ...

    • 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 ...