Import Group Journal Entries
Application component: S/4HANA for Group Reporting
App type: Transactional
Line of business: Finance
Leading industry: Cross Industry
Solution capability: Corporate Close (S/4)
Description:  With this app, you can post multiple manual journal entries into the system all at once, to adjust the reported financial data, standardizing entries, and consolidation entries to the requirements of the group. Depending on the posting type (Unit-Dependent Adjustments, Two-Sided Elimination, or Group-Dependent Adjustments), you download a template file that contains the relevant fields to make the postings, enter the required information, and upload the completed file back to the app. The data will be verified and updated into the database. 
An application to import group journal entries.
Key features:  Download a Template File Choose the right template depending on the posting document type you want to use.  Template 01 Unit-Dependent Adjustments is used for posting adjustment entries or standardizing entries to the reported financial data. The relevant document types are:  01: Manual correction of universal journal (0C)  02: Manual correction of reported data (01) 11: Manual standardizing in local currency, deferred tax, no automatic reversal in the subsequent period (10) 12: Manual standardizing in local currency, deferred tax, automatic reversal (10) 13: Manual standardizing in local currency, no deferred tax or automatic reversal (10) 14: Manual standardizing in local currency, no deferred tax, automatic reversal (10) 16: Manual standardizing in group currency, deferred tax, no automatic reversal (10) 17: Manual standardizing in group currency, deferred tax, automatic reversal (10) 18: Manual standardizing in group currency, no deferred tax or automatic reversal (10) 19: Manual standardizing in group currency, no deferred tax, automatic reversal (10)   Template 02 Two-Sided Elimination is used for posting two-sided eliminating entries for consolidation unit pairs. The relevant document types are:  21: Manual elimination correction, automatic reversal (20)  22: Manual elimination correction, no automatic reversal (20)  Template 03 Group-Dependent Adjustments is used to post group elimination entries. The relevant document types are:  31: Manual consolidation adjustments, automatic reversal (30)  32: Manual consolidation adjustments, no automatic reversal (30) 39: Group shares (30)  Note The numbers in parenthesis denote the posting level for each document type. For more information about document types, see Document Types and Posting Levels.  Enter Data in the File The file is divided into Header Data and Line Items sections. Below is a list of the required fields, which vary depending on which template type you choose: Header Data  Journal Entry ID: A temporary identifier used to differentiate journal entries in the file. Input a positive integer following an increasing sequence. Note that rows with the same journal entry ID should have identical header data.  Document Type: Input a two-digit number. See the above list of supported document types. Ledger: Enter the relevant consolidation ledger, for example, Y1. Consolidation Chart of Accounts: Y1.  Consolidation Version: Enter the relevant actuals version, for example, Y10. Fiscal Year (4 digits) and Posting Period (3 digits). Consolidation Unit: Input the ID of the consolidation unit for which you are making the manual posting. This field moves to Line Items part in the template 02 Two-Sided Elimination. Consolidation Group: Only relevant for the document types 31 and 32.  Line Items  Line Item: A 6-digit number identifies a single item of a journal entry. Each row should have a different ID.  Financial Statement Item: The identifiers of financial statement items. See Define FS Items for the list of your configured financial statement items. Partner Unit: Only required in the template 02 Two-Sided Elimination. Rows with the same journal entry ID should have the same pair of consolidation units. Value in Local Currency: Only available in the template 01 Unit-Dependent Adjustments. Value in Group Currency: A required field except for document types 02, 11, 12, 13, and 14.  When filling out the file, do not change its layout or format except for document type 39 (Group shares), which is based on quantity and the base unit Percentage. When entering data with document type 39, you need to first unhide the technical name row (row 6) and replace the column text AmountInGroupCurrency with QuantityInBaseUnit, then enter the group share percentage for the relevant consolidation unit/group in data area of this column. Changing the description row (row 7) from *Value in Group Currency to *Quantity is optional.  Verify Data After uploading the completed file, choose the Check button to verify the uploaded data. If the system detects errors, you can choose the relevant row to navigate to the Post Group Journal Entries app and correct the data on header or line item level.  Post When the data is verified, choose Post to post the journal entries into the database. This will check and update the status of the following tasks in Data Monitor and Consolidation Monitor depending on which document type you selected during importing:  Data collection  Manual posting with posting level 10 Manual eliminations with posting level 20 Manual eliminations with posting level 30  After that, you can view the details of each posting by choosing Show Log to navigate to the Task Logs app.Note The imported journal entries are first added to the Post Group Journal Entries app as drafts with the Draft Entry Source: 1 (Imported from File). Only after you successfully post these draft entries or you upload a new file, these drafts are removed. 
Business roles: Group Accountant| External Auditor - Group Reporting| General Ledger Accountant - Group Reporting
General Ledger Accountant - Group Reporting : 
Ensures adherence of local data to group quality standards.

External Auditor - Group Reporting : 
Ensures adherence of group data to legal accounting standard and process governance standards.

Consolidation Specialist : 
Is responsible for the Consolidation setting, processing for the FI or other business data from subsidiaries. Generates the legal & management consolidated reports.

Group Accountant : 
Executes and monitors group processing tasks, such as data adjustment, and inter-company elimination.