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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Intercompany Elimination

Started by stutch, 24 Apr 2017 03:52:40 PM

Previous topic - Next topic

stutch

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