...

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 precise 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 AppSAP Group Reporting Data Collection App
- Display of the GRDC web interface start page<br />
- Display of 6 tiles with different functions<br />
- From left to right -> Manage packages, define ad hoc items, manage forms, enter package data<br />
- Below this, two further tiles<br />
o Left to right Define data assignment, execute data assignment<br />

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.

- Display GRDC form for correction of net deviation and redistribution to correct movement type.<br />
- At the top left, the period 2027.2 and the company CON00<br />
- Display table with various items in column A<br />
- Column E shows the offsetting entries for the movement 915 - Net deviation<br />
- Column F shows the calculated variance between the value to be distributed and the distributed value<br />
- Columns G to R show the possible movement types.<br />
o 900 - Opening balance<br />
o 901 - Incoming units<br />
o 904 - Equity cons.<br />
o 906 - Dividends<br />
o 909 - Change in balance sheet and valuation methods<br />
o 925 - Increase in depreciation and amortization<br />
o 930 - Decrease/decrease<br />
o 935 - Decrease in depreciation and amortization<br />
o 940 - Capital increase/decrease<br />
o 950 - Reclassification<br />
o 955 - Fair value<br />
o 980 - Conversion difference<br />
- Column S shows the sum of columns G to R<br />
What can the SAP Group Reporting Data Collection be used for?<br />
- Display of the GRDC web interface in the Enter parcel data app<br />
- A folder structure with all available forms is displayed on the left-hand side.<br />
o Top level folder Actual Reported Data<br />
 New folder S0-I10 - Balance sheet accounts detailed by transaction type<br />
- Forms<br />
o S0I1100 - Financial assets<br />
o S0I1200 - Systems<br />
o S0I1300 - Current assets<br />
o S0I1400 - Non-current assets<br />
o S0I1500 - Financial liabilities<br />
o S0I1600 - Provisions<br />
o S0I1700 - Current liabilities<br />
o S0I1800 - Non-current liabilities<br />
o S0I1900 - Capital<br />
 New folder S0-I20 - Balance sheet accounts detailed by partner<br />
 New folder S0-I30 - Profit and loss account<br />
 New folder S0-I40 - inventory gain<br />
 New folder S0-I50 - Queries<br />
 New folder<br />
o New top-level folder ESG Data - environmental, social and governance data<br />
 New folder S0-I70 - Data transfer environment, social affairs and governance<br />
- The form S0I1100 - Financial assets is displayed on the right-hand side<br />
o Column A items with the following lines<br />
 172100 - Investments in subsidiaries, JV and ass. Subsidiaries, JV and ass., BW<br />
 172190 - Participations in subsidiaries, JV and ass. Subsidiaries, value ind.<br />
 172200 - Other fin. Assets at FVTOCI, non-current<br />
 172300 - Derivatives, non-current<br />
 172400 - Fin. Financial assets at fair value through profit or loss, non-current<br />
 172500 - Other fin. Other financial assets at AC, non-current<br />
 Total other non-current financial assets<br />
<br />
 141100 - Other fin. Assets at FVTOCI, current<br />
 141200 - Derivatives, current<br />
 141300 - Fin. Assets at fair value through profit or loss, current<br />
 141400 - Loans and cash advances, current, gross<br />
 141490 - Loans and cash advances, current, impairment<br />
 141500 - Other financial assets, current, gross  141500 - Other financial assets, current, gross        Assets at AC, current<br />
 Total Other current financial assets<br />
o Column C to H following transaction types<br />
 900 - Opening balance<br />
 909 - Change in balance sheet and valuation method.<br />
 915 - Net deviation<br />
 920 - Increase/full consolidation<br />
 925 - Increase in depreciation<br />
 930 - Decrease/disposal<br />

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.