You can eliminate accounts (such as accounts containing inter-company transactions) through the Eliminations page, under settings. For more information on Charts of Accounts and Eliminations, read our support document.
Note: You can change the way Eliminations are treated on reports, see the section 'Managing Eliminations' below. You can also create 'Elimination sets' see bottom of page.
If you would prefer to watch a video guide on managing your eliminations, you can do so here.
Tagging accounts
To select the accounts you would like to eliminate:
1. Click the settings cog in the top right of your screen and choose Eliminations.
2. Find the accounts you would like to eliminate by clicking 'Add Elimination' and using the search accounts option.
3. Choose whether to Eliminate from all companies with the blue 'Eliminate' button or to eliminate from selected companies using the 'Partially Eliminate' button.
These accounts will now (by default) not appear in your reports.
On-screen Elimination views.
You can change the way Eliminations are treated on a report by report level - you can choose whether to remove eliminations, show only eliminations, show all accounts or display eliminations in a separate column.
To configure your eliminations:
1. Click the 'elimination configuration' box in the top right screen of any financial report (as pictured below)
2. Then choose from the drop-down how you would like your eliminations to be displayed/ handled.
Joiin will then present your eliminations as you have instructed.
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, you can have multiple 'Sets' to give you flexibility when reporting.
To manage Elimination Sets in Joiin, click the settings cog and select the "Eliminations" page.
To add a new Elimination set
1. Click on the dropdown at the top of the list.
2. Click on the "Add Elimination Set" button.
3. Enter a name for the new set and click "Save."
You can then begin adding accounts to this set of eliminations, using the instructions at the top of this article.
To switch between Elimination Sets
When running a report, you can choose which set of eliminations you would like to attribute to the report. To do this:
1. Click the Eliminations box in the top right of the screen
2. Choose One of the eliminations options
3. Choose the 'Set' using the drop-down
Eliminating a Part of an Account
In some cases, intercompany transactions are stored in the same GL account as other regular transactions. To eliminate these intercompany transactions, an adjustment can be posted to eliminate the value of the intercompany transactions. To do so:
1. Go to the companies page by clicking Companies on the left side toolbar
2. Click the 3 dot menu beside the name of the company
3. Select Adjustments from the drop down menu
4. Click the Add adjustment Account button
5. Search for the account that you would like to adjust using the search bar
6. Click the name of this account and then the Add button to add the adjustment
7. Enter the relevant values to adjust for the intercompany transaction
8. Once the figures have been entered, click Update Adjustment to save your work
Ensure that you make the adjustment to both sides of the group.
For a manual company, the adjustments feature is not available as figures can be edited at any time by clicking the name of the company. In this case, the figures in the manual company can be adjusted directly.