How to setup Multi-Currency Eliminations
There are two ways to account for eliminations in Fathom.
In 'Step 3' of the setup for a consolidated group, there is an 'Eliminations' feature. This allows you to quickly filter inter-company accounts from the consolidated group, to enable a more accurate view of consolidated performance. In most cases, these inter-company accounts contra each other out.
For multi-currency consolidations, additional elimination adjustments are often required, to balance the balance sheet. The reason for this is that movements in exchange rates cause the intercompany related accounts to no longer contra each other out, after these amounts are translated using the current exchange rate.
This method enables you to import an excel spreadsheet which details specific elimination adjustments, which are applied to the consolidated financials only.
Detailed instructions for both types of eliminations can be found here, in this Guide:
Guide to Consolidations in Fathom (see pages 25-28).
To add elimination adjustments, go to "Add a company", then select "Excel" as the source, then import a spreadsheet, it will appear as another "company" in Fathom. We refer to this as "Eliminations Co".
The financials of this entity should include only the journal adjustments that you wish to make to the consolidated group. The import spreadsheet MUST include the word "eliminations" in it's name (Cell B1).
You should then add this "company" to your consolidated group. Click on "Manage group" in 'Step 1' of the setup for the group.
Fathom will recognise the adjustments contained in this import file in the eliminations column of your reports. For examples, when viewing the Excel report called "Multi-currency consolidated financial results, including eliminations ", you will see data for "Eliminations Co." shown in the Eliminations column only.
In your reports and analysis this entity will not be shown, however the adjustments from this entity will be reflected in the eliminations column of your consolidated financial statements.