This question has been flagged
2 Replies
22453 Views

I am using Odoo Enterprize 9 editions having multi-company architecture. I created multiple Bank accounts into it. My queries are below:

1- When i am trying to transfer any amount from X accounts to Y accounts, odoo permits me to do so even i have zero balance into my X accounts.

2- While Transferring the amount from X account to Y account, it gives me an warning that please set Secondary Currency of the account and when i remove the currency from the X account, it allows me to do the same.

What settings, i am missing into accounting. Logically is it correct to transfer the amount from zero balance account ?

Avatar
Discard

I am also unable to figure this out.  Anyone have an answer to intercompany bank transfers?

+1, Having the same issue

Best Answer

Inter company transactions are best handled via the Transfer of funds through a DUE TO / DUE FROM Account (or Accounts).

  • it closely matches the steps in the real world.

  • it follows accounting best practices many Book-keepers, Accountants and Controllers will be familiar with. 

  • a transfer can be printed as a check, in case funds need to be moved this way

  • no AP or AR is involved.

  • no special account types are needed.

  • a reconcilable Journal Entry for each Bank Account involved is created to match the bank statement withdrawal / deposit activity. 

  • bank statements (no lines needed, just starting balances) can be created to compare and record the end of period balance in the DT/DF account(s).

  • bank statements (lines manually added) can be used to reconcile each DT/DF account. 

  • you can show the DT/DF account balance(s) anywhere on the Balance sheet.


Some businesses have two accounts. For a given Company A, the first account - DUE TO B - is a liability account that represents the money Company A owes to Company B.  The second account - DUE FROM B - is an asset account that represents the money Company B owes to Company A.

Some businesses have one account.  Company A would create a liability account DUE TO / DUE FROM B to represent both things.  A positive balance means Company B owes Company A money.  A negative balance means Company B owes Company A money.

My example will use a single account.

1. Setup the Accounts in each Company.  Here, we have two companies - PARENT and SUBSIDIARY.



2. Setup a Journal in each Company. 

The Parent Journal is named "Subsidiary" to indicate the flow of funds to and from the subsidiary:


The Subsidiary Journal is named "Parent" to indicate the flow of funds to and from the Parent:



3. For each funding transaction, transfer funds in both Companies:


In the Parent, fund the Subsidiary:


In the Subsidiary, receive the funds from the Parent:



The partial Parent Balance Sheet after funding:


The partial Subsidiary Balance Sheet after funding:


The Consolidated Balance Sheet after funding - note the cash sent / received and liability / asset [negative liability] cancel each other out:



Journal Entries that were created:



Notes:  

You may wish the create a Payments Menu (perhaps below a Parent Menu of Inter Company in between Sales and Purchases in the Accounting App) to make these transactions easily available.

Hide the new Journals if there will be no reconciliation or matching of these transactions.

Name the new Journals "Transfer to/from Subsidiary" and "Transfer to/from Parent" if money will be moving in both directions between Companies.

Avatar
Discard
Best Answer

Hi Chainika, 

1) It is an intended behavior that you are able to send money out of an account that has a null balance. Some companies can have agreements with their bank allowing them for instance to go negative.

2) Multi currency bank accounts/journals: if you want to manage a bank journal into another currency, you should set that very currency both on the journal as well as on the account linked to that journal. More here https://www.odoo.com/documentation/user/9.0/accounting/others/multicurrencies/how_it_works.html


Hope this helps.

Avatar
Discard