...
Logo of concellens GmbH
Contact us

SAP Group Reporting Data Collection (GRDC)

Efficient data collection for modern companies
Contact us

SAP Group Reporting Data Collection: Functions and advantages

Companies working with SAP S/4HANA Finance for Group Reporting are often faced with the challenge of achieving the required data quality and data depth for accurate and audit-proof consolidated financial statements. The Group Reporting Data Collection (GRDC) offers a solution for this: it not only enables data integration between SAP and non-SAP systems, but also supports the entire data collection process.

 

SAP Group Reporting Data Collection App
- Display start page of the GRDC web interface - Display of 6 tiles with different functions - From left to right -> Manage packages, define ad hoc items, manage forms, enter package data - Below two further tiles o Left to right Define data assignment, execute data assignment

What is the SAP Group Reporting Data Collection (GRDC)?

SAP Group Reporting Data Collection (GRDC) enables form-based data entry. This means that input masks can be created to enter data yourself. In Group Reporting, access to current information is crucial. The Data Collection also offers a display of real-time data that has already been posted to the database. The forms can be structured with formulas and other display options as required.

Practical example: Types of movement and mirror information

In order for consolidation to be carried out correctly, the data requires a certain level of detail. This requires, for example, a statement of changes in fixed assets with the various transactions. If this information is available in the upstream system, it can be transferred directly to Group Reporting.

However, this data is often missing in non-SAP systems. GRDC enables this information to be enriched manually and uses forms to ensure that the corresponding movements are assigned and mapped correctly.

- Representation GRDC form for correction of net deviation and redistribution to correct movement type. - The period 2027.2 and the company CON00 are shown at the top left - Presentation table with various items in column A - Column E shows the offsetting entries for the transaction 915 - Net variance - Column F shows the calculated variance between the value to be distributed and the distributed value - Columns G to R show the possible transaction types. o 900 - Opening balance o 901 - Incoming units o 904 - Equity cons. changes o 906 - Dividends o 909 - Change in balance sheet and valuation method o 925 - Increase in depreciation/amortization o 930 - Decrease/decrease o 935 - Decrease in amortization and o 925 - Increase in depreciation o 930 - Decrease/disposal o 935 - Decrease in depreciation o 940 - Capital increase/decrease o 950 - Reclassification o 955 - Fair value o 980 - Translation difference - Column S shows the sum of columns G to R
What can the SAP Group Reporting Data Collection be used for? - Display of the GRDC web interface in the Enter package data app - A folder structure with all available forms is displayed on the left-hand side. o Top Level Ordner Actual Reported Data  Neuer Ordner S0-I10 – Bestandskonten detailliert nach Bewegungsarten • Formulare o S0I1100 - Finanzanlagen o S0I1200 - Anlagen o S0I1300 - Umlaufvermögen o S0I1400 - Langfristige Vermögenswerte o S0I1500 - Finanzielle Verbindlichkeiten o S0I1600 - Rückstellungen o S0I1700 - Current liabilities o S0I1800 - Non-current liabilities o S0I1900 - Capital  New folder S0-I20 - Inventory accounts detailed by partner  New folder S0-I30 - Profit and loss account  New folder S0-I40 - Inventory profit  New folder S0-I50 - Queries  New folder o New top level folder ESG Data - Environmental, Social and Governance Data  New folder o New top level folder ESG Data - Environmental, Social and Governance Data  New folder S0-I70 - Environmental, Social and Governance Data Transfer - Form S0I1100 - Financial assets is displayed on the right-hand side o Column A items with the following lines  172100 - Investments in subsidiaries, JV and ass. Subsidiaries, JVs and ass. companies, BW  172190 - Investments in subsidiaries, JVs and ass. Subsidiaries, JV and ass. sub, impairment  172200 - Other fin. Assets at FVTOCI, non-current  172300 - Derivatives, non-current  172400 - Fin. Assets at fair value through profit or loss, non-current  172500 - Other financial assets at AC, non-current  Other financial assets at AC, non-current  Total other non-current financial assets   141100 - Other fin. Assets at FVTOCI, current  141200 - Derivatives, current  141300 - Fin. Assets at fair value through profit or loss, current  141400 - Loans and cash advances, current, gross  141490 - Loans and cash advances, current, impairment  141500 - Other financial assets at AC, current  Total financial assets at AC, current  Assets at AC, current  Total Other current financial assets o Column C to H following transaction types  900 - Opening balance  909 - Change in balance sheet and valuation method.  915 - Net deviation  920 - Increase/full consolidation  925 - Increase in depreciation/amortization  930 - Decrease/disposal

What can the SAP Group Reporting Data Collection be used for?

GRDC is provided by SAP as a public cloud application to enable efficient and, above all, rapid group consolidation. To this end, companies connect their systems to the software, which acts as an additional data integrator. Data enrichment can be carried out via form-based entries. In this way, users are guided safely through the process without relevant information (such as transaction types) falling by the wayside. Data can thus be recorded faster and largely error-free, which is particularly useful for fast-close processes and tight time frames.