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.   


TABLE OF CONTENTS


Use Account Trees for Eliminations



  1. First you will want a Common Account Tree setup for all organisations in the group.

  2. Now create a header account and make sure 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 name and the category location are a personal preference. If there is a discrepancy in the elimination amounts this row will show up on the reports with the name and in the category location that you specify here.
     Summary Only
  3. For each organisation make sure the detail accounts used for intercompany transactions are allocated to this same header account.

  4. Now when running consolidation 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. First you should Add a Manually Created Organisation

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

  3. Copy any Account Tree used in the group to ensure the accounts merge and eliminate correctly

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

  5. Enter the elimination values required as Actuals or Budgets