...

Intercompany elimination when counter company is unknown Guideline

by user

on
Category: Documents
1

views

Report

Comments

Transcript

Intercompany elimination when counter company is unknown Guideline
Guideline
Intercompany elimination when
counter company is unknown
Product(s): IBM Cognos Controller 8x
Area of Interest: Modeling
Intercompany elimination when counter company is unknown
2
Copyright
Copyright © 2008 Cognos ULC (formerly Cognos Incorporated). Cognos ULC
is an IBM Company. While every attempt has been made to ensure that the
information in this document is accurate and complete, some typographical
errors or technical inaccuracies may exist. Cognos does not accept
responsibility for any kind of loss resulting from the use of information
contained in this document. This document shows the publication date. The
information contained in this document is subject to change without notice.
Any improvements or changes to the information contained in this document
will be documented in subsequent editions. This document contains
proprietary information of Cognos. All rights are reserved. No part of this
document may be copied, photocopied, reproduced, stored in a retrieval
system, transmitted in any form or by any means, or translated into another
language without the prior written consent of Cognos. Cognos and the
Cognos logo are trademarks of Cognos ULC (formerly Cognos Incorporated)
in the United States and/or other countries. IBM and the IBM logo are
trademarks of International Business Machines Corporation in the United
States, or other countries, or both. All other names are trademarks or
registered trademarks of their respective companies. Information about
Cognos products can be found at www.cognos.com
This document is maintained by the Best Practices, Product and Technology
team. You can send comments, suggestions, and additions to
[email protected] .
IBM Cognos Confidential Information
Intercompany elimination when counter company is unknown
3
Contents
1
INTRODUCTION ............................................................................................ 4
1.1
1.2
1.3
PURPOSE .............................................................................................................. 4
APPLICABILITY ....................................................................................................... 4
EXCLUSIONS AND EXCEPTIONS .................................................................................... 4
2
INTERCOMPANY ELIMINATION ALTERNATIVE PROCESS (NO COUNTER
PARTY DETAILS)....................................................................................................... 4
2.1
2.2
2.3
2.4
2.5
INTERCOMPANY ACCOUNT SET UP ................................................................................ 4
SET UP DUMMY AND/OR HOLDING COMPANY .................................................................. 4
DATA LOAD ........................................................................................................... 4
SET UP THE INTERCOMPANY CONTROL TABLE .................................................................. 5
VERIFY THE INTERCOMPANY ELIMINATION ...................................................................... 6
3
INTERCOMPANY RECONCILIATION PROCESS ............................................. 7
3.1
RUN THE RECONCILIATION REPORT.............................................................................. 7
IBM Cognos Confidential Information
Intercompany elimination when counter company is unknown
4
1 Introduction
1.1
Purpose
The intercompany elimination requires that the counter party to be identified.
However, there are circumstances that exist when the counter party is not
known and the intercompany transactions are required to be eliminated. This
document will show you an alternative to loading intercompany balances
when the counter party is not known.
1.2
Applicability
IBM Cognos Controller 8.1 or higher
1.3
Exclusions and Exceptions
N/A
2 Intercompany Elimination Alternative Process (no
counter party details)
2.1
Intercompany Account Set up
1. Set up appropriate payables and receivables in your account structure. All
intercompany accounts need to be identify with either an I-Code
(Intecompany without Transaction Currency) or J-Code (Intercompany
with Transaction Currency)
2.2
Set up Dummy and/or Holding Company
1. Set up a dummy and/or hold company in your company structure. The
company should be at the top level.
2. The company should be set up as a subsidiary company and should have
a number like 9999.
2.3
Data Load
1. The intercompany accounts details will need to be assigned to the
dummy/holding company (see Step 2.2).
IBM Cognos Confidential Information
Intercompany elimination when counter company is unknown
2.4
Set up the Intercompany Control Table
IBM Cognos Confidential Information
5
Intercompany elimination when counter company is unknown
2.5
Verify the intercompany Elimination
1. Group/Run the consolidation By Steps/Currency Conversion
2. Group/Run the Consolidation By Steps/Automatic Journals –
Intercompany Balances
3. Group/Reports/Trial Balance with Drill Down
IBM Cognos Confidential Information
6
Intercompany elimination when counter company is unknown
3 Intercompany Reconciliation Process
3.1
Run the Reconciliation Report
1. Run the reconciliation report (Group/Reconcile/Intercompany Balances)
IBM Cognos Confidential Information
7
Intercompany elimination when counter company is unknown
2. Review the difference and make any adjustments that are require, i.e.
adjusting journals, review with subsidiaries, etc.
IBM Cognos Confidential Information
8
Intercompany elimination when counter company is unknown
IBM Cognos Confidential Information
9
Fly UP