Advanced Multi-Currency

Advanced Multi Currency

This module allows revaluation of foreign currency and unrealized gain/loss in foreign currency.

Go to Tools > Program Control > Module Setting

Check the checkbox of Advanced Multi Currency to enable it.

Add A/R Invoice with Foreign Currency

Before all, let's say I have added an A/R Invoice for USD 4,000 (at the rate of 3.5000).

Go to G/L > Journal Of Transaction

Define filter options,

Click on Inquiry,

Go to G/L > Ledger Reports,

Define filter options and click on Inquiry,

Foreign Currency Revaluation

This is to revaluate all outstanding transaction in foreign currency, and to find out if there is any unrealized gain/loss according to current exchange rate. Each revaluation will auto generate journal entries should there is unrealized gain/loss. The last revaluation rate will be recognised and compared with subsequent revaluation or payments.

Go to G/L > Foreign Currency Revaluation

Click on New,

Click on Yes

Key in Description, assign G/L accounts and journal type,

Confirm the date and revaluation currency rate,

Click on Start Revalue...

Description: define description for journal entries

Unrealized Account/Journal Type: assign respective G/L account for posting purpose.

Journal Voucher No: this number is auto-run. However you may click on the field to key in any voucher number.

Date: date of revaluation

Revalue Currency: key in the latest rate on the date of revaluation

Start Revalue: click on this button to execute the revaluation

Main tab: this page will list down related bills info and amount of unrealized gain/loss (right-most column) based on revaluation date and rate. Only outstanding bill will be listed, those already knocked off will not be listed.

G/L Accounts tab: this page will list down foreign-currency accounts (general ledger accounts), home balance and amount of unrealized gain/loss (right-most column) based on revaluation date and rate.

After Saved;

(1) The revaluation is not allowed to edit. You may only view, print or delete the revaluation.

(2) Journal Entry will be auto-generated should there was unrealized gain/loss.

(3) Not allowed to edit or delete transactions (in foreign currency) prior to the date of revaluation.

(4) The revaluation rate will be recognised as the last currency rate, and will be referred to:

- in subsequent revaluation to compare with the current rate, to derived at another unrealized gain/loss (if any).

- in subsequent payment to compare with the exchange rate, to derived at the Gain/Loss on Foreign Exchange.

Click on Save, Close...

Go to G/L > Journal Of Transaction

Define filter options,

Click on Inquiry,