Skip to Content

Migration of Bank Account Balances for Company with Multiple Set of Books

Jun 03, 2017 at 09:39 AM


avatar image

Hi all,

Appreciate if anyone can help to explain on the process of migrating bank account balances for company with multiple set of books.

Currently we are using USD as default currency (set of book: 7000) and SGD as company currency (set of book: 8000) for company A.

The bank account balance is in USD. So we entered for e.g 35000 for bank currency amount in the template.

Bank Statement Balance

GL Account Balances:

When the Bank Account Balance is uploaded, system uses exchange rate to convert the amount from USD to SGD, which differs from the amount maintained in GL account balances template.

Please advise how to migrate bank account balances in SGD.

Thanks in advance.


bdswj.png (5.1 kB)
ubsan.png (2.8 kB)
m1uzz.png (5.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Annapurna Vunnam
Jun 19, 2017 at 08:13 AM

Hello DK,

It is not possible to upload bank account balances with multiple set of books. We can migrate the bank account balances with bank currency and it will convert other currencies(company currency) depends on Exchange rate that you have maintained in General Ledger work center.

You can maintain the currency conversion rate in General Ledger work center as per your requirement.

Hope this will clear your query.



10 |10000 characters needed characters left characters exceeded