Consolidate Multiple Company Files

Save Time by Combining Multiple Company Files Together

Currently you can use Business Intelligence to combine:

  • Profit and Loss data from the GL (Full Trial balance is coming soon)
  • Sales 
  • Jobs
  • Receivables
  • Payables

Works best if you use consistent codes in all of your Company files:

  • GL Account Codes
  • Item Codes
  • Customer Card ID
  • Supplier Card ID

 

Consolidation Elimination Entries
To record Consolidation Elimination entries you have two options:

  1. Create a new MYOB Company file called Consol Entries, enter all elimination entries as journals in this one Company file.  Then add this company as another company in Business Intelligence and include it in your you Group Companies.  The Consol entries will appear in your reports as a separate Column along with each of the other companies and the Total Group column will include the result of any Elimination entries.

    or

  2. Export your Consolidation report to Excel from Business Intelligence where you can insert an extra column and enter in any Elimination entries.

Note regarding currency:
Data in all reports will appear in the the raw local currency, so to do any FX translation you would need to export the reports to excel and translate to the one single currency as needed using the appropriate average or historical exchange rates.

Multi User Licence 
To access the Consolidation feature you will require a Multi User BI Licence. A 3 User BI Licence will allow you to have 3 Users and let you access 2 Company files + the Group Company (2+1=3) for example.

Enabling Consolidation

Login to your BI Cloud account with the BI Admin login and password i.e. The one you signed up with

1. Select Organisation from the top menu and then scroll until you see the checkbox Advanced Database. Set this to Yes

Screen_Shot_2017-03-13_at_3.03.01_pm.png

 

2. Select Group Companies when back on the Companies tab

Screen_Shot_2017-03-13_at_3.03.44_pm.png

 

3. Next Tick Companies to include in the Consolidated Group.

You can only create one Consolidated Group so we suggest you Tick all companies at this step.

Later when creating reports in BI you can then Filter to include only some companies or maybe creat multiple consolidation groups.

Screen_Shot_2017-03-13_at_3.04.29_pm.png 

 

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.

Powered by Zendesk