Booking Group Journal Entries

After the balance sheet and income statement data is in group reporting and the reported data validation is complete, adjusting entries can be made to comply with the corporate accounting standards. For example, a local subsidiary may report inventory as finished goods but from a corporation perspective it is work in progress. One-time accounting adjustments can be performed manually with group journals or automatically with the reclassification task. These adjusting entries reside only in group reporting because they are independent from the SAP General Ledger.

Let's do a quick review of posting levels and document types.

Posting levels are used to track the origin of data by key process step. For example, reported data uses posting level 00, standardized data uses 10, eliminated data uses 20, and consolidated data uses 30. Posting levels can be used to visualize where data is coming from when running reports and therefore provide a high-level audit trail. Document types provide a more detailed audit trail. For example, data release uses document type 0F, file uploads use 00, and SAP Group Reporting data collection uses 0C. Each document type uses only one posting level but one posting level can use multiple document types.

There are several apps available to process group reporting journals.

In the following animation, learn about how to access the group journal apps.

The following apps can be used to display group journals:

-The Display Group Journal Entries app is used to display line items of posting documents without any reporting logic. Consolidation unit, profit center and segment hierarchies are not required and are not included in the output.

- The Display Group Journal Entries with Reporting Logic app is used to display line items of posting documents with reporting logic. The reporting logic is used to dynamically display elimination entity values by applying the first-common-parent rule to hierarchies selected at run-time. Consolidation unit, profit center and segment hierarchies are required and are included in the output.

In the following animation, see how to use the Post Group Journal Entries app.

You can reverse individual journal entries by selecting the journal to be reversed and choosing Reverse. The system reverses the journal entry and updates the records in the database.

You can also reverse multiple journal entries (also called documents) in the Mass Reversal app. While doing so, you select and reverse manually posted documents by various criteria, for example, by organizational unit, version, time, task, or subassignment.

When posting a new Group Journal, follow these steps for the General Data fields:

1. Select the Document Type.
2. Enter the Posting Period.
3. Enter the Fiscal Year.
4. Enter the reason for the adjusting entry.
5. Enter the Consolidation Unit.

Note

Depending on the document type, the posting information fields are dynamically determined by the system. The Extension Versions field can be used to post adjusting entries related to prior-period restatements

In the following animation, see how to maintain line items in group journal entries.

In the example, there is a debit to 131500 finished goods and a credit to 585000 other expense. As you enter the FS items, the subitem values are derived from the breakdown category assigned to each FS item.

After you specify line item details and choose the Create button, automatic lines are generated to make sure the balance sheet and income statement are balanced.

Before a group journal entry is posted, the system performs checks to make sure that the data is complete and correct. Substitution and validation rules can be used to automatically substitute or validate field values, based on pre-defined preconditions and rules. You can use the Manage Substitution/Validation Rules app to define such substitution and/or validation rules for postings for the business context GR Journal Entry Item.

For example, you could use a substitution rule to fill the profit center field with a default if it is blank. A validation rule could be used to ensure that partner unit is filled for intercompany FS items. If the rule fails, the group journal entry cannot be posted.

Note

Group reporting substitution and validation rules apply to:

• Manual group journal entries
• File imports
• Data released from accounting

Note

When creating a new group journal, you can copy from an existing journal entry or line item.

In situations where the same group-dependent manual journal should be posted to multiple consolidation groups, you can increase the efficiency by creating a manual group journal entry for multiple consolidation groups.

To create a manual group journal entry for multiple consolidation groups, enable a multi-value field for consolidation group on posting level 30 for consolidation-group-dependent postings. You can create bundled journals for the selected consolidation groups and manage bundled journals together in subsequent activities, such as copies or reversals.

In the Post Journal Entry app, you can post on your primary group (the first consolidation group that is selected), as well as on additional groups.

For every selected consolidation group, separate documents are posted. To track these documents, the system assigns a document bundle number to every group journal entry, which posts to multiple consolidation groups. You can use the document bundle number for the reversal process, and you can also filter the document bundle number in the Post Group Journal Entries app and in the Display Group Journal Entries app. This allows you to search for the corresponding bundle based on this number.

Get more information on group journal entries posting to multiple consolidation groups.

In the following animation, see how to post to multiple versions in a group journal.

In this video, you will see how to post a group journal entry with an extension version in a restatement scenario.

• Selected items are default FS items used to keep the income statement and balance sheet in balance.
• Selected items automatically generate balancing line items when triggered.
• The trigger can either be manual or automatically generated line items that affect the income statement and balance sheet at the same time.