The 5 categories that come up for elimination:
Current accounts (RC verhoudingen)
Loans & interest (leningen & rente)
Revenue & expenses (omzet & kosten)
Debtors & creditors (debiteuren & crediteuren)
Participations (deelnemingen)
[Holding only] Participations and Result participations (Deelnemingen & resultaat deelnemingen);
[Subsidiaries only] All equity items, apart from Result and Prior year result, these are system-generated. Often these are Nominaal kapitaal, Agio, Onverwerkt resultaat, Reserves
Reasons why you may not get to 100% elimination:
Not clear which accounts or transactions should be eliminated (e.g. not knowing what accounts have IC transactions)
Internal documentation on how IC transactions have been recorded
Ask accountant for consolidation overview ("consolidatiestaat") on account-level as per annual accounts. These are the accounts that should be (partially) eliminated
Check the Eliminations page within the Entries menu in Finstack
% IC Relations column
Naming of account (e.g. do they contain the name of the counter-entity, or have “IC” in the name?)
Go through Chart of Accounts and take into account the 5 IC categories above
Helpful: get the person in charge of entering IC transactions into the administration to join the onboarding process
Administration not correct or not up to date
Use IC reconciliation overview to pinpoint differences. The time filter can be used to pinpoint the time frame in which the differences came to exist
Not comparing apples and apples
Time frame of account values may differ from time frame of document used for comparison
Other:
Please note that Finstack generates elimination accounts as you eliminate. These accounts should be mapped in order for the balance sheet to balance
Typically there are two ways to map these accounts:
Map them to a general line-item like “Other equity”. This will ‘hide’ any residual value resulting from elimination differences, if any
Create a new line-item called “Elimination reserve” on your balance sheet under Equity and map the account to this line-item. This will make any residual value resulting from eliminations explicit