If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Intercompany Elimination  (Read 6003 times)

stutch

  • Guest
Intercompany Elimination
« on: 24 Apr 2017 03:52:40 pm »
Hi all,
I am just wondering if it was possible in Cognos Controller to produce a consolidated trial balance that either:
  • Showed an entity trial balance after intercompany eliminations; or
  • Showed an entity trial balance and the intercompany eliminations that are relevant to each company.
Right now, when a consolidated trial balance is run it is shown as below:

Entity A   Entity B   Entity C   Eliminations   Group Total
10                10     10                 5                25
 
Is it possible to either show it as:

1. Entity trial balance after intercompany eliminations; or

Entity A   Entity B   Entity C   Group Total
10               8                 7       25
 
2. Entity trial balance and the intercompany eliminations that are relevant to each company

Entity A    |    Entity A Elimination    |    Entity B    |    Entity B Elimination    |    Entity C    |    Entity C Elimination    |    Group Total
10                            -                          10                      (2)                             10                    (3)                                   25
 
Thanks