Solved

Bank reconciliation with multiple cash accounts and one bank account

  • 13 February 2023
  • 4 replies
  • 311 views
J
Rank
Userlevel 5
Badge

We have two companies in Acumatica, but both use the same bank account.

 

We have created two cash accounts (one representing each company) in Acumatica, both using the same GL account but different branches/companies.

 

Are we still able to use the bank reconciliation feature?

I would expect both bank recs to have a large difference but should net each other out (in a perfect world) once fully reconciled - However seems like the reconciling task will get confusing/complicated as you are not sure whether a transaction is truly missing (& requiring a payment/invoice) or whether it was posted to other company.

 

Does anyone run bank recs in a similar situation? Does it work for you?

Or should we go down the path of opening a separate bank account for each company account?

icon

Best answer by BethKesser24 13 February 2023, 22:06

View original

4 replies

aaghaei
Rank
Userlevel 7
Badge +9

It is against accounting principles to have such practice because of the ownership/control over the assets unless the companies are making up a joint venture. You definitely will need to have separate bank accounts. If needed you can transfer funded between the companies as interco transactions.

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
BethKesser24
Rank
Userlevel 3
Badge +1

You cannot do this in Acumatica (if these companies are in the same tenant).  It is also recommended that you setup a separate bank account for each company.  

Laura02
Rank
Badge +18

Hello,

I agree with the above posters but will state this another way:  If you have one account at the bank, then one bank account should be set up in Acumatica.  Consider use of Acumatica inter-company features, to manage one account that pays bills and receives payments for two companies/branches.  Please see this related post for additiona information and suggestions that may help you:

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ AUG Forums Episode130 ~
aaghaei
Rank
Userlevel 7
Badge +9

Although it can work to use one company’s bank account for processing bills and payments/receipts of other companies and post transactions through interco, as someone who has worked in accounting for 25 years, I definitely advise against it because 

1- it will create thousands or millions of unnecessary transactions as you will need to post everything to the company with bank account.

2- will drastically increase data entry errors as users constantly should be mindful of items branch’s and of course extra work.

3- you will face audit issues with IRS (in US) or CRA (in Canada) as you will need to rationalize the cost posted, why the invoices are addressed to different entity …

I can make a long list if disadvantages and issues   But I think is pretty obvious. If companies are legally different entities they will need to have their own bank accounts. If they are not separate entities then should have been setup as branch not company.

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved