All Collections
Reports
Consolidate Multiple Organisations
Elimination Entries for Consolidations
Elimination Entries for Consolidations

Use Account Trees to group and eliminate intercompany accounts or use a manual org to do a traditional elimination entry.

Mick Devine avatar
Written by Mick Devine
Updated over a week ago

If you consolidate multiple organisations and have a requirement to eliminate intercompany transactions this can be achieved either by using Account Trees with a Summary Only Header or by adding a manually created organisation in Calxa where you can then enter the eliminations entries.


Use Account Trees for Eliminations

If you have specific accounts for intercompany transactions, you can group them together with an Account Tree and the values will naturally contra each other. Using the Summary only option ensures they'll be displayed as a single row and thus only displayed if there is some discrepancy.

For more advanced scenarios like partial eliminations check the next heading on using a manual organisation for eliminations.

  1. First you will want to Create an Account Tree for the group.

  2. Now click ADD -> Header to create a header with the Summary only option is toggled on. This ensures accounts allocated to this group will only be displayed as a single row on reports.

    Other properties like location and name are a personal preference.

  3. Now map your intercompany accounts to this header as per the Mapping Accounts help article.

  4. Now when running consolidted reports using this Account Tree you'll find that all the accounts allocated to this header will be summarised into a single row on the reports. If they sum or consolidate to a zero value then the report criteria can hide zero rows all together.

    Show zero values

Use Manual Organisation for Eliminations

The Account Tree method above may not be suitable in all cases. For example if you need to partially eliminate some accounts then you may need to consider adding another entity in Calxa where you can enter the elimination entries.

  1. Then edit the chart of accounts to include the accounts required for eliminations

  2. Map your accounts from the manual organisation into the groups Account Tree to ensure the accounts merge and eliminate correctly.

  3. Include this new entity in the Organisation Groups for consolidated reporting.

  4. Enter the elimination values required as Actuals or Budgets.

Did this answer your question?