UNREALIZED GAIN LOSS

This is the same as Foreign Currency Revaluation, which is to evaluate all the outstanding transactions in foreign currency and to find out if there is any unrealized gain/loss according to the current exchange rate.

The difference is: each revaluation will also auto-generate the journal entries should there is unrealized gain/loss, but the entries will be reversed on the next day; which means the original (initially traded) exchange rate will remain and be recognized and compared with the subsequent revaluation or payments.

First, go to G/L > Next, click on Unrealized Gain/Loss

Then, click on New,

After that, click on Yes,

Then, key in Description, assign G/L accounts and journal type,

Now, confirm the date and unrealized currency rate,

Last, click on Start Unrealized…

(please note that the date is 15/01/2018)

Description: define a description for journal entries

Unrealized Account/Journal Type: assign the respective Gain/Loss Accounts for posting purpose (sales/purchase ledger). Both G/L Gain/Loss Accounts are used for G/L Accounts tab (general ledger accounts).

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

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

Date: the date of unrealized.

Reverse G/L Account Posting: this is an option to reverse the posting entries on the following day for related accounts under G/L Accounts tab. Earlier, only related accounts under Main tab (AR or AP related accounts) will be reversed automatically on the following day.

Unrealized Currency: key in the latest rate on the date of unrealized

Start Unrealized: click on this button to execute the unrealized

Main tab: this page will list down related bills info and amount of unrealized gain/loss (right-most column) based on unrealized 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 unrealized date and rate.

After Saved;

(1) (for one day) the unrealized 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. The reversed entries will be auto-generated on the following day. The original exchange rate will be restored.

Click on Save, Close…

Go to G/L > Journal Of Transaction

Define filter options, (filter the date till 15/01/2018)

Click on Inquiry,

Define filter options, (filter the date till 16/01/2018)

Reversed entries is generated..

Go to G/L > Ledger Reports,

Define filter options and click on Inquiry,

(filter the date till 15/01/2018)

(filter the date till 16/01/2018)

Subsequent Revaluation

Let say the subsequent revaluation took place after one week, and the currency rate for USD is: 4.4000 ;

First, go to G/L > Then, click on Unrealized Gain/Loss

Then, click on New, Yes,

Next, key in Description, assign G/L accounts and journal type,

After that, confirm the date and unrealized currency rate,

Click on Start Unrealized…

(please note that the date is 22/01/2018)

Now, click on Save, Close…

Go to G/L > Journal Of Transaction

Define filter options, (filter the date till 22/01/2018)

Click on Inquiry,

Define filter options, (filter the date till 23/01/2018)

Reversed entries is generated..

Go to G/L > Ledger Reports,

Define filter options and click on Inquiry,

(filter the date till 22/01/2018)

(filter the date till 23/01/2018)