How to Consolidate Financial Data in S/4HANA

Presented by Orpheus Birch

The SAP S/4 HANA Finance Group Reporting module is SAP’s latest financial consolidation reporting tool which streamlines month-end close processes by unifying operational entity and financial consolidation group close processes. The new group reporting logic was implemented as of S4 HANA 1909. The new group reporting logic includes a set of features to support legal and management consolidation

This webcast discusses how to utilize Group Reporting to generate legal financial consolidation and financial reports for organizations with multi-level ownership structure.

Watch this recorded session with S4HANA Finance/Group Reporting Expert, Orpheus Birch, to gain insight into the following:

- Overview of key Data Model configuration settings for legal consolidation.
- Legal Consolidation Process.
- How to configure legal consolidation structure for automatic elimination of investments.
- How to create legal consolidation for organizations with multi-level hierarchy.
- How to use Manage Global Hierarchy to produce reports or alternative reporting hierarchies.
- How to execute consolidation reports based on the new group reporting logic concept.
- Reporting options for consuming Group Reporting financial accounting data.
- Best Practices and learned from previous Group Reporting implementations.
- Demo.

Q&A

Q: How can Group Reporting consolidate plan or forecast data from SAC Planning? 

A: To consolidate plan or forecast data, create a plan or forecast version in data model for Group Reporting. The data should be retracted from SAC Planning to ACDOCP and released to ACDOCU universal journal in Group Reporting.

Q: Is there a standard delivered Statement of Changes in Cashflow available in Group Reporting? If so, where it is available?

A: Yes, Group Reporting content includes cashflow flow reporting. The report is available in Manage Global Hierarchies App as a reporting Item.

Q: What are the SAP reporting tools used to consume consolidated data?

A: Consolidated can be consumed by:

a. Fiori Embedded Analytics. There are standard Fiori Apps such as “Group Data Analytics Design Studio” and Group Data Analytics with Reporting rules.

b. Analysis for Office which can access the consolidation CDS views. Analysis for office useful for creating customize reports and utilize native excel functions at the same time.

c. SAC Analytics. This is useful for dashboarding and analytics

About the Presenter:

Orpheus Birch is an SAP S/4HANA Finance/Group Reporting Solution Architect with over 20 years of experience implementing SAP Finance across various industries. He is an expert in SAP consolidation products, including EC-CS, SEM-BCS, BPC, and Group Reporting. He is the CEO of OB Consultech, Inc, a boutique SAP consulting company firm and a leading expert in S/4HANA Finance, SAP Business Planning and Consolidation, Group Reporting, and SAC Planning and Analytics.