Objective
You have acquired data from SAP S/4HANA accounting and external systems but that data does not include net income and current year retained earnings. Therefore, you need to run a task to calculate net income and current year retained earnings.
Let’s learn more about this below.
Reported financial data is usually collected with an initial imbalance in the balance sheet and income statement. The initial imbalance of the balance sheet must correspond to the imbalance of the profit and loss statement (or income statement). This imbalance includes data released from accounting and may also include imported data.
To correct the imbalance, the Calculate Net Income task has to be run.
The system posts the annual net income and current year retained earnings when you run the task. This ensures that the balance sheet and the profit and loss statement are consistent. Once the adjustment is posted, the two statements (balance sheet and profit and loss statement) balance again.
In the data monitor, you calculate net income and retained earnings every period by running the Calculate Net Income task. The annual net income is calculated and written to the current year retained earnings FS item in the balance sheet and the annual net income FS item in the income statement.
The Calculate net income and current year retained earnings figure below illustrates an example of calculating net income:
In this example, the initial imbalance of the balance sheet (-100) corresponds to the imbalance of the income statement (100).
Note
The system calculates the annual net income using the same document type as the reported data. For data that is released from accounting, the system calculates the annual net income using document type 05. Also, in the delivered chart of accounts, current year retained earnings is in the 317000 FS item and annual net income is in the 799000 FS item.
At ABC Corporation, you've imported data from a file and released data from accounting. The financial data now needs to have the annual net income and current year retained earnings calculated and recorded.
The financial data now needs to have the annual net income and current year retained earnings calculated and recorded.
Note
In this exercise, you’ll complete the following tasks:
Use the Data Monitor tile to run the Calc Net Income task for the World.
Go to the Consolidation Data Preparation group.
Choose the Data Monitor tile.
Right-click on the intersection of World and Calc Net I.
Choose Update.
The built-in Calc Net I task is run and the Display Archived Audit Trail page appears.
Verify the net income and retained earnings calculation results. You should get the following results:
| FS Item | New value / local | New value / group |
|---|---|---|
| 317000 Net Income | 76.995,00- | 76.995,00- |
| 799000 Net Income/loss | 76.995,00 | 76.995,00 |
| FS Item | New value / local | New value / group |
|---|---|---|
| 317000 Net Income | 195.780,00- | |
| 799000 Net Income/loss | 195.780,00 |
| FS Item | New value / local | New value / group |
|---|---|---|
| 317000 Net Income | 285.052,00- | 285.052,00- |
| 799000 Net Income/loss | 285.052,00 | 285.052,00 |
| FS Item | New value / local | New value / group |
|---|---|---|
| 317000 Net Income | 78.520,00- | 78.520,00- |
| 799000 Net Income/loss | 78.520,00 | 78.520,00 |
| FS Item | New value / local | New value / group |
|---|---|---|
| 317000 Net Income | 178.310,00– | 231.803,00- |
| 799000 Net Income/loss | 178.310,00 | 231.803,00 |
On the Display Archived Audit Trail page choose Expand.
Note
Group currency values for Canada weren't imported during the file upload.
Note
Current year retained earnings were booked into the balance sheet account 317000 - Net Income .
Net income was booked into the income statement account 799000 - Net Income/loss.
Choose the 
icon to return to the SAP Fiori Launchpad Home Page.
Open the Group Data Analysis tile.
Go to the Analytics for Group Reporting group.
Select the Group Data Analysis tile.
Confirm the following selections:
| Field | Selection |
|---|---|
| Version | U## (U## Act EUR GC) |
| Consolidation COA | Y1 (Consolidation Chart of Accounts) |
| Fiscal Year Period | 012.2025 |
| Consolidation Group | World |
| Period Mode | PER (Periodic) |
| Key Date | December 31, 2025 |
| Consolidation Unit Hierarchy | $ |
| Profit Center Hierarchy | $ |
| Segment Hierarchy | $ |
Confirm the selections as shown in the table.
Use your Cons Unit by FS Item ## bookmark.
Next to <No Bookmark Loaded>, choose the drop-down.
Select Cons Unit by FS Item ##.
Add the Consolidation Unit dimension to the filter section of your report and restrict it to CA##. Execute your report.
On the right, choose Adapt Filters.
In the Adapt Filters dialog, select 
Consolidation Unit.
Choose OK.
In the Filter section of the report, enter CA## as Consolidation Unit .
Choose Go.
Add the amount in group currency to the columns. If needed, collapse the hierarchy. Expand the +BS_PL top node by one level.
On the left, in the Navigation Panel, expand Measures.
Right-click Amount in Group Crcy and choose Measures → Add Measure to Display.
If needed, right-click FS item → Hierarchy → Collapse All.
In the report choose +BS_PL in order to re-expand the top node of the hierarchy by one level.
| Field | Value | Value |
|---|---|---|
| Measure | Amount In Local Currency | Amount in Group Crcy |
| Consolidation Unit | CA## | CA## |
| FS Item | ||
| –-BS_PL | 0,00 CAD | 0,00 EUR |
| +BS | 0,00 CAD | 0,00 EUR |
| +PL | 0,00 CAD | 0,00 EUR |
Note
Now that net income and retained earnings have been booked, the balance sheet and income statement are both in balance.
Turn the FS Item hierarchy off. Display the ID and Description (Non-Compound key) for the FS Items. Finally, return to the SAP Fiori Launchpad Home Page. Close any extra tabs in the web client.
Right-click FS Item and choose Hierarchy→Disable Hierarchy.
Right-click FS Item and choose Display→ID and Description → Non-Compound Key.
Note
The Group Currency values are all zero because currency translation hasn’t been run yet.
Choose the icon to return to the SAP Fiori Launchpad Home Page.
Close any extra tabs in the web client.