Eliminate Inter-company Accounts & Transactions


When consolidating together multiple entities it is often necessary to eliminate inter-company balances & transactions.


Using BI4cloud there are a number of ways to achieve this, choosing the best method will depend on how you identify and account for inter-company transactions within your accounting system:

  1. Simple - Eliminate Inter-company GL Account Balances
  2. Eliminate Inter-company transactions (Sales & Purchases)
  3. Create a new entity to record Elimination Journals

 1. Simple - Eliminate Inter-company GL Account Balances

If you use a separate GL account to capture Inter-company Sales, Purchases and loan balances you will want to simply eliminate or exclude these GL accounts from the consolidation. 

Using Bi4Cloud you can allocate each Inter-company GL account a tag e.g. "Interco" using GL Custom Lists, then simply set a filter to exclude all accounts labeled as "Interco".


This method will work well for inter-company loan balances.

2. Eliminate Inter-company transactions (Sales & Purchases)

If your sales and purchases to related entities are mixed in with other external sales and purchase transactions then you will need to first identify then eliminate just the inter-company transactions.

  • Tag each inter-company transaction using Analysis codes e.g. a Job or Category called "IC"





Was this article helpful?
0 out of 0 found this helpful

Articles in this section

Ask the BI4 Community
Need help using this report or feature?