Skip to main content
Solved

Consolidation


Hi all - does anyone consolidate entities whihc are not 100% owned and how do yu deal with non-controlling interests?

Best answer by Gabriel Michaud

@purwandaruw47 thanks for tagging me in the post. It is definitely something that we can handle with Velixo

@dcarman90 are all the entities you’re looking to consolidate using Acumatica? Here’s how we did it in the past with a client using Velixo:

  • Setup one connection per entity
  • Define how accounts/subaccounts should be consolidated (this can be skipped if all entities share a common chart of accounts)
  • In your report, define the % of ownership of each entity
  • In the income statement and balance sheet, report the income, expenses, assets and liabilities as desired

Since Velixo gives you full control on the formulas at the cell level, it becomes very easy to add together data from many entities, each with different percentages and report them at a consolidated level.

While not specific to Velixo, this article explains how non-controlling interests should be handled in consolidations: Non-Controlling Interest in Consolidations - eCapital Advisors

I’ll be happy to discuss this in greater detail, you can send me a private message if desired.

 

View original
Did this topic help you find an answer to your question?

3 replies

purwandaruw
Freshman II
Forum|alt.badge.img
  • Freshman II
  • 29 replies
  • April 23, 2022
dcarman90 wrote:

Hi all - does anyone consolidate entities whihc are not 100% owned and how do yu deal with non-controlling interests?

Hi,

 

Seems that the possible way using Velixo to handle outside Acumatica with that questions. I have same case also with my prospect in Indonesia. 

Or @Gabriel Michaud can create some function on Velixo for further improvement?

 

Thanks. 


Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • April 25, 2022

Hi @dcarman90 

Can you please elaborate your requirement. I guess you want to bring in part of entity numbers (to the extent of controlling interest) in to consolidation tenant?

Can you use a Branch/Company within such entity and only use that data for consolidation?

Regards,


Gabriel Michaud
Captain II
Forum|alt.badge.img+10

@purwandaruw47 thanks for tagging me in the post. It is definitely something that we can handle with Velixo

@dcarman90 are all the entities you’re looking to consolidate using Acumatica? Here’s how we did it in the past with a client using Velixo:

  • Setup one connection per entity
  • Define how accounts/subaccounts should be consolidated (this can be skipped if all entities share a common chart of accounts)
  • In your report, define the % of ownership of each entity
  • In the income statement and balance sheet, report the income, expenses, assets and liabilities as desired

Since Velixo gives you full control on the formulas at the cell level, it becomes very easy to add together data from many entities, each with different percentages and report them at a consolidated level.

While not specific to Velixo, this article explains how non-controlling interests should be handled in consolidations: Non-Controlling Interest in Consolidations - eCapital Advisors

I’ll be happy to discuss this in greater detail, you can send me a private message if desired.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings