v14: How do I record a bank transfer payment from two accounts in different currencies with a specific fixed exchange rate?
2 Answers
Like this:
Assumptions:
you have $500 in your US bank account
you have €0 in your EURO bank account
your EURO account is setup with as the Currency on the Journal
Your Bank Balances would then show like this:
First, you will record an INTERNAL TRANSFER of funds OUT of your USD Account:
Next, you will record an INTERNAL TRANSFER of funds INTO your EURO Account:
Your balances at this point will be:
Note: because Odoo has not yet been given the exchange rate the bank used, it will not show the same amount. You rectify this during Bank Reconciliation. Just like a Customer Payment you have not yet verified, the Internal Transfer amount has not yet been verified (so doesn't show up in your GL yet).
Reconcile your USD Bank Account:
Reconcile your EURO Bank Account:
Note: You need to show and populate the Amount Currency and Foreign Currency amounts. You only need to do this for transfers between accounts - and only for the part of the transfer needing to be converted to a different FX amount than Odoo would have done (if left blank, Odoo would book this at €84.18)
Balances after both Bank Statements have been reconciled:
Balance Sheet:
Journal Entry from the Bank Reconciliation process on the EURO account:
Hi Ray,
I'm confused on the transfer of funds between bank accounts / cash journal. In your above example after doing two internal transfers both amounts (100USD & 84.18EUR) are sitting in the Liquidity Transfer account 101701.
Don't we have to reconcile them with each other to make sure that Liquidity Transfer account zeroes out?
My understanding of doing funds transfer between bank accounts (as well as cash journals) is following: (transfer fund from A account to B account)
1) Send money from account/journal A
2) Receive money at account/journal B
3) Reconcile the Liquidity Transfer account entries with outstanding payment and receipt accounts
4) Record the Bank Statement (or cash book) at account/journal A with negative value
5) Record the Bank Statement (or cash book) at account/journal B with positive value
6) Reconcile the Bank Statement entry at account A
7) Reconcile the Bank Statement entry at account B.
Are we doing it right, or overly complicating transaction records.
Kind regards,
Alaubek
In my example, a $100 debit from the first Internal Transfer (out of USD Account) and a $100 credit from the second Internal Transfer (into the EURO account) are sitting in the Liquidity Transfer account 101701. So following my steps (you probably made a small mistake) the account will always balance and reconciliation is up to you (not required). Your list of steps is restating my example (apart from step 3) so you have the correct procedure.
Dear Ray, thank you very much for a rapid reply and explanation!
In version 15, For example, my system currency is MMK. When I transfer MMK to USD. The two journals will be create automatically. It's ok but the second journal date is current date. I think it should be the same the first journal date. Next, when i setup the usd currency on the USD account, it can't be post that the occur " The account selected on your journal entry forces to provide a secondary currency. You should remove the secondary currency on the account.". When I removed the currency in USD account or journal, i can go through the transfer successfully. But the journals will show the system currency and Amount in Currency. So, In general ledger, it is show the MMK only. I think it is not correct.