IN THIS SECTION

• Overview
• Managing Eliminations
  • How to Eliminate Accounts
  • Partial Eliminations
  • Removing Eliminations
  • Elimination Sets
• Downloading Accounts with Elimination Status

Overview

The Eliminations tab on the Settings page allows you to exclude, or partially exclude 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 "Eliminated" or "Partially Eliminated" and this prevents them from being displayed on any of the reports. You can also create Elimination Sets which are groups of account eliminations which can be quickly applied when running reports.

Managing Eliminations

You can 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.

By default Joiin will remove the eliminated accounts from all reports.  

NOTE that when an account is Eliminated it is simply removed from all reports. Joiin does not match eliminated accounts between entities or calculate any adjustments required due to things such as FX differences. You will need to ensure that the accounts being eliminated contra each other so that reports balance.

For example, if you had a group with two companies, one in USD and one in GBP, with inter-company accounts - you could ensure all transactions were posted on each side, calculate the F/X difference and post this via a reversing journal to one of the ledgers.

Or you can add adjustments manually to the downloaded Excel report - or manually add a company to add an adjustment company.

How to Eliminate Accounts

To add or remove Eliminations select the Eliminations page from the Settings menu at the top right.  A list of accounts that are currently being eliminated for the selected Elimination Set will be displayed.

NOTE: Hovering over each 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 Elimination button to eliminate an account(s).

Select the account(s) you wish to eliminate 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 eliminate, click on the Eliminate button to eliminate them

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

Partial Eliminations

Alternatively you can partially eliminate an account - that is, you can choose to eliminate it for a single company or companies. To do this, click on the Partially Eliminate button after selecting the accounts.

Select the companies you wish to eliminate this account for and click on Eliminate for selected.

A partially eliminated account will show in the list with a list of the Companies it has been eliminated for.

You can change a partially-eliminated account to be eliminated across all entities by clicking on the three-dot menu to the right and select Eliminate for all companies.

Alternatively, you can change the companies an account is eliminated from by clicking on the three-dot menu to the right and select Eliminate for selected companies.

Also, if an account is fully eliminated, you can change it to be partially eliminated by selecting Eliminate for selected companies. The companies, whose Chart of Accounts contain that account will be pre-selected.

Removing Eliminations

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

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.