IN THIS SECTION


Overview


The Eliminations tab on the Settings page allows you to exclude, or eliminate accounts from reports.  In any inter-company consolidation it can be important to exclude certain accounts such as inter-company loans to ensure the totals accurately represent a true picture of the consolidated entity.  You can do this in Joiin using Eliminations.  You can mark certain accounts as "Excluded" which will mean that account will not appear on any reports. You can also create Elimination Groups where accounts between two specific Entities can be eliminated and, if required, netting adjustments created.


You can group your exclusions and elimination groups into Elimination Sets so that you can quickly control which sets are applied to which reports.


Managing Eliminations

You can exclude and eliminate accounts through the Eliminations page.  Marking accounts as eliminated will mean that the accounts and their balances will be removed from all reports.


NOTE: You can change the way Eliminations are treated when you run a report by changing the eliminations setting on the report page - you can choose whether to remove eliminations, retain only eliminations, retain all accounts or display eliminations in a separate column - see Running Reports article for more information.




How to create Elimination Groups

Elimination groups contain accounts between two specific entities that are part of an inter-company transactions such as an inter-company loan.


To add or remove Elimination Groups select the Eliminations page from the Settings menu at the top right.  A list of elimination groups and exclusions for the selected Elimination Set will be displayed. Exclusions will be marked with an E icon, Elimination Groups will be marked with a G icon.




Click on the Add Elimination Group button to create an Elimination Group.




  • Enter the name for the Elimination Group.
  • Select the first company for one side of the Elimination. A list of accounts from that company's Chart of Accounts will be available for selection in the Accounts dropdown to the right.
  • Select the account(s) that are to be eliminated for that entity - you can search for accounts by code or name.
  • Repeat for the second company.
  • The account balances on either side of the inter-company should net off - e.g. one side might contain a Liability account and the other side an Asset account - so combined, they net off.
  • Choose whether a Netting Adjustment is to be added (see below).
  • Click Create Elimination Group button to create the elimination group.


The group will appear in the list of eliminations and will be eliminated from reports if that option is selected when Running Reports.


Editing Elimination Groups


Removing Eliminations


To remove an elimination group from the elimination set, simply click on the three-dot menu to the right and select Remove elimination group.


Netting Adjustments

When you enable the Add Netting Adjustment option for an elimination group, Joiin will automatically add an adjustment line to reports to account for any discrepancies between the balances on either side of the intercompany group. While these balances should typically cancel each other out, factors like foreign exchange differences can cause small mismatches. The Netting Adjustment corrects for these differences, ensuring your reports remain balanced and accurate.




How to Exclude Accounts


Exclusions are used when you wish to eliminate a single account from all entities on all reports. For inter-company eliminations and more accurate reporting it is recommended to use an Elimination Group rather than an Exclusion.


To add or remove Elimination Groups select the Eliminations page from the Settings menu at the top right.  A list of elimination groups and exclusions for the selected Elimination Set will be displayed. Exclusions will be marked with an E icon, Elimination Groups will be marked with a G icon.




NOTE: Hovering over each excluded account will display a number to the right, indicating how many companies have that account in their Chart of Accounts. Hovering over that number will show the list of companies.



Click on the Add Exclusion button to exclude an account(s).


Select the account(s) you wish to exclude from the list. You can search for accounts by name or code to filter the list.


Once you have selected the accounts you wish to exclude, click on the Exclude button to exclude them


The account(s) will appear in the list of eliminations and will be excluded from reports if that option is selected when Running Reports.




Removing Eliminations


To remove an exclusion from the elimination set, simply click on the three-dot menu to the right and select Remove exclusion.



Elimination Sets


You can create Elimination Sets which are groups of eliminated accounts which can be applied when running reports. By default there is a single Default Elimination Set. To add another or change the name of the set click on the dropdown at the top of the list.



Click on the Add Elimination Set button to add a new elimination set.


Click on the pencil icon to edit the name of the elimination set.


Click on the delete icon to delete the elimination set. WARNING - if you delete an elimination set all the account eliminations associated with it will be removed.


Click on the Clone icon to make a copy of the elimination set.


To switch between elimination sets select the desired set from the dropdown.


Downloading Accounts with Elimination Status

You can download a list of accounts with a column showing their eliminated status through the Chart of Accounts page.