Describing Consolidation Processes

Objective

After completing this lesson, you will be able to explain the key process steps of group reporting

An Intermediate Business User's Responsibilities

The image illustrate a person working at a desk. To represent the person on the text bellow.

Last month, you (Anthony) started a new job as an intermediate consolidation consultant. Your new assignment is to perform consolidation tasks as part of the corporate close.

Your new responsibilities involve:

  • Acquiring Data
  • Preparing Data
  • Matching and Eliminating Intercompany Transactions
  • Consolidating Investments
  • Reporting Consolidated Data
  • Running Balance Carryforward

You need foundational knowledge about how to perform these tasks using SAP software. Let's ask my manager (Peter) for guidance on where to start.

The image illustrate a person standing holding a tablet . To represent the person on the text bellow.

Hi there, Anthony! Congratulations on your new assignment. Let's go through the business scenario.

ABC Corporation recently implemented group reporting. All of the configuration is complete and now the system is ready to use. You will run and monitor closing tasks in SAP S/4HANA to consolidate financial data for ABC Corporation. You’ll also use group reports to analyze and confirm the results.

Note

  • SAP offers a cloud product SAP S/4HANA Cloud for group reporting and an on-premise solution, SAP S/4HANA Finance for group reporting. This course covers both and you can assume all functionality described is equivalent for both.
  • If you are completely new to SAP S/4HANA Cloud for group reporting, please check the introductory learning journey.

Group Reporting Key Concepts

The following summary of the most important group reporting concepts are useful when you perform the month-end closing:

  • The preparation ledger populates group reporting fields in the ACDOCA table and uses accounting substitution rules to derive consolidation units. For example, company code U.S. and profit center PC1 are used to derive consolidation unit USPC1.
  • Posting levels track data by key process steps such as, reported data, standardized data, eliminated data, and consolidated data. Each document type is assigned to one posting level and is used to determine document numbers, reversal behavior, and permitted key figures.
  • Version Consolidation version distinguishes actual from plan data, selects group currency, and determines the source accounting ledger. Special versions provide version-dependent configuration and sharing of objects among versions. Use extension versions for multiple group currencies You can stack extension versions for restatements and simulations.
  • Currency translation translates from local to group currency or retains existing group currency values.
  • Intercompany eliminations are automated for intercompany dividends, accounts payable/receivable, profit in inventory, and revenue and cost.
  • Report logic dynamically determines elimination entities by using the first-common-parent for each hierarchy node to provide a consolidation view. For example, the consolidation view shows total revenue by entity along with an elimination entity for each consolidation unit hierarchy node. Alternatively, the contribution view displays revenue net of eliminations by entity.
  • Matrix consolidation provides legal and management accounting reports without data redundancy.
  • Consolidation of investments automate postings for acquisitions, step acquisition, capital increase/decrease, divestitures, transfers, and mergers. Both the purchase and equity methods are supported. The rule-based and activity-based solutions are available.
  • Reporting: You can report with SAP Fiori apps, SAP Analysis for Office (Microsoft Excel), as well as SAP Analytics Cloud. The SAP Fiori apps include the Group Data Analysis app, which is used for routine reporting requirements. You can use Review Booklet app as a one-stop-shop for a variety of financial statements. You can use the Group Data Analysis With Reporting Rules app for special reporting requirements such as cash flow and comprehensive income.

The following image includes a few of the most important components in group reporting as well as the data flow from the ACDOCA table to the ACDOCU table.

The figure illustrates the flow of data from Consolidation Groups, Units, and FS Items to Global Parameters, which then feed into the Data/Consolidation Monitor. The monitor processes data for Group Reports and Data Release, interacting with ACDOCU and ACDOCA.

The global parameters are used to set your filter criteria for:

  • Consolidation Group
  • Consolidation Unit
  • Consolidation Version
  • Consolidation Chart of Account
  • Year
  • Period

Use global parameters to provide default filter values when accessing the data monitor, consolidation monitor, and reports. You use global parameters throughout the consolidation process.

Note

In the ACDOCU table, posting level is blank for data release records. In the ACDOCA table, consolidation unit and FS item contain values because the preparation ledger is activated as part of the course scenario.

Describing the Consolidation Process

Before you begin running tasks for the corporate close at ABC Corporation, there are a few setup activities:

  • Check the master data of your organizational units. This includes possible changes to existing, as well as newly acquired, consolidation units. For example, perhaps a consolidation unit becomes integrated in period 1 of 2024 because the underlying company code is now in accounting. In addition, all changes to the consolidation group structure are performed at this point.
  • Check the financial statement (FS) items master data. This primarily includes updates to the mapping of new G/L accounts to FS items.
  • Update exchange rates. This includes the update of group reporting-specific exchange rates.
  • Set your global parameters to the closing year and period.
  • Open the period in the data monitor.

When the month-end closing data processing begins, you’ll prepare the data for consolidation in the data monitor.

After the data monitor tasks are complete, the consolidation monitor is used to perform consolidation tasks such as intercompany eliminations and investment eliminations. Throughout the process, you can cross-check your processed data using delivered reports.

Learn more about the key steps in the consolidation process in the following video.

In summary, the group reporting process consists of six main steps:

The group reporting process consists of six steps.

  1. Data collection: Release data from SAP S/4HANA Finance and import from outside sources into group reporting.
  2. Data preparation: Calculate net income and retained earnings, perform currency translation, adjust the data to align with corporate accounting standards, and validate the data.
  3. Intercompany: Reconcile and match intercompany transactions. Eliminate intercompany activity.
  4. Investment eliminations: Record ownership data and run the investment and equity elimination.
  5. Reporting: Analyze the results with SAP S/4HANA reporting options or with SAP Analytics Cloud.
  6. Balance carryforward: In the new year, open the period and carryforward balance sheet items into the new year.

Note

Reporting takes place continuously through each process step. After the closing is completed, the final balance sheet, income statement, and cash flow reports can be viewed.

Reviewing the Ownership Structure

Ownership Structure for ABC Corporation

In the following animation, you’ll learn about the ownership structure that we’re using for the course scenario as well as the types of intercompany transactions we need to address. In addition, you'll learn about the ownership eliminations that we need to perform as well as the U.S. GAAP and IFRS reporting requirements.

Log in to track your progress & complete quizzes