Consolidating multiple companies into a unified, consolidated set of financial statements is an art form. In SAP, two common ways of producing consolidated financials are EC-CS (Enterprise Controlling – Consolidation System) and through reporting in BW (Business Warehouse). This post deals primarily with EC-CS.
EC-CS gives you a means of rolling up multiple company codes into a unified set of books. If you use multiple charts of accounts, the best option is to create Group Chart of Accounts and map your other charts to it. Your Group Chart of Accounts can then feed into your Consolidation Chart of Accounts.
Features of EC-CS
- Consolidate multiple company codes
- Import data from the General Ledger to cons units
- Manual and automatic eliminations between Consolidation Units (cons units are tied to a Company, which is tied to a Company Code(s))
- Eliminations within a cons unit
- Reclassifications
- Database viewer to view imported records, elimination/reclass records, and manual journal entry records
- Upload data from Non-SAP systems (set up this feature in: CXCC). I'm not familiar with the capabilities of this function
- Report Painter reporting (GR55)
You can report your consolidated financials either through BW or through Report Painter reports (T-code: GR55). For Report Painter, you will need to create a reporting Library (T-code: GR21), utilizing table FIMC. You'll also need to specify your consolidations ledger while building your reports in GRR1 (or GR52).
Basic T-codes for EC-CS
CX16 – Consolidation Chart of Accounts – Hierarchy Change - allows you to build your Consolidation Chart of Accounts within a hierarchy
CXCD – Data Montior - allows you transfer financial data from the SAP General Ledger into the consolidations ledger
Database Listing of Records - In CXCD, click Goto/Database Listing of Records. This allows you to view the items imported from the General Ledger as well as manually posted items. You can limit by Posting Level which indicates the type of record being viewed.
CX20 – Consolidation Monitor - The Consolidation Monitor allows you to:
- Eliminate inter-unit payables and receivables
- Eliminate inter-unit sales
- Eliminate investment income
- Perform manual eliminations
- Consolidate investment income
- Perform manual reclassifications
- Validate consolidated data
No comments:
Post a Comment