Advance Currency - GL Module

Created by Ka Chun, Modified on Fri, 25 Feb, 2022 at 12:06 PM by Ka Chun

Scenario 

 

A very useful feature for companies that has oversea banks.

By using this feature, user is able to reevaluate the bank foreign currency with the current currency rate.

Adjustments (differences due to the currency rate change) will then be posted to the Unrealize Forex Gain / Loss account.

Making it easy for business owners to evaluate their overseas business performance for future planning.

 

Solution 

 

  1. Files > Modules

  1. Tick Advance Currency

  1. Maintenance > Default Interface Accounts.

  1. Notice two additional settings

  1. General Ledger > Chart of Accounts. Notice two additional accounts also

  1. Create a new bank account

Enter GL account code and bank name. Currency as USD. Tick Revaluation Required. Save

  1. Create a Receipt Voucher. Deposit to PBB USD

  1. View GL Transaction.

The debit and credit is RM 40,000 as the currency rate is 4.0

  1. Maintenance > Currencies > USD.

Set the Currency Rate By Periods
 
example the currency rate is 4.3 for December 2021


  1. When next month, need to reevaluate the currency rate.

Go to Advance Currency > Auto Revaluation – GL

Enter date and account. Click Generate.

Notice the Adjustment amount after Revaluation

  1. GL > Bank Reconciliation. Notice that Debit Foreign is still remain as RM 10,000

  1. Advance Currency > GL Multi Currency Report. Enter Date and Account. Click Preview.

  1. Notice there is RM 3,000 of adjustment

 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article