Creating Balance Sheets and Income Statements

Financial statements, including the balance sheet and income statement, provide essential information to stakeholders such as accountants, auditors, and tax authorities.

Dedicated apps generate these statements for different charts of accounts, including operational, alternative, and international versions. The reports allow access to specific G/L account line items, and customer and supplier line items.

Depending on the user authorizations, different additional features are available to the users:

• Full balance sheet or profit and loss statement for several company codes
• Display of additional currencies, if customized in the system
• Drill down to the accounts grouped by a node
• Display of profit centers and segments
• Display of zero-balance accounts
• Display of alternative account numbers
• Application of a financial statement version for a key date

Also, depending on the user authorizations, it is possible to navigate to other apps, for instance to the Display G/L Line Items and the Display G/L Balances apps.

The financial statements can also be downloaded to different formats, depending on the app that is used. There are two main apps to execute the balance sheet and income statement reports in SAP S/4HANA:

• Balance Sheet/Income Statement
• Balance Sheet/Income Statement (Multidimensional)

The following table compares the different features between the two apps:

Carlo is now ready to explore the use of the Balance Sheet/Income Statement app. To execute a report in the Balance Sheet/Income Statement app, Carlo will need to be aware of a few key points:

The header filter requires the completion of the following mandatory fields to execute the report:

• Company Code
• Ledger
• Financial Statement Version
• Statement Type
• End Period and Comparison Period
• Currency

You can further customize the report by adding optional filter fields using the Adapt Filters button, such as:

• Account Display: To enable the display of alternative accounts
• Financial Statement Version Key Date: To select the FSV valid at one given date
• Including Zero-Balance Accounts: To enable this option
• Including Segment / Including Profit Center: To enable their respective reporting

When the mandatory fields are completed, the report can be executed. Several tabs are then available to retrieve: All Accounts, Balance Sheet, Profit & Loss, Unassigned Accounts, and Notes.

Please note that the Balance Sheet/Income Statement app supports exporting the data to a PDF format file only.

Let’s practice the execution of a balance sheet and income statement report.

The Balance Sheet / Income Statement multidimensional app enables the retrieval of balance sheets and income statements for various companies using the operational, local, and global chart of accounts. These reports are produced instantly by querying all relevant line items. These reports also allow Carlo to access the line items of a specific G/L account for further detailed insight.

For a more comprehensive evaluation and distribution of the financial statements, reports can be exported to Excel and PDF formats.

The app further offers comparison functionalities for different fiscal years, varying ledgers, and actual data versus planned data for the financial statement version.

Compared to the classic app, the multidimensional Balance Sheet/Income Statement app presents some key differences:

• Possibility to export to *.PDF, *.CSV, and *.XLS formats
• Multiple dimensions available
• Hierarchy time dependency unavailable
• Ledger comparisons available
• Business transaction types available
• Analytical engine features available

Once the mandatory fields in this report are completed, the report can be executed. It is possible to include additional selection criteria using the Adapt Filters button.

When the report is executed, the Panel Settings pane on the left side of the report enables the search and selection of measures to be included in the rows or columns of the report. Additionally, there are several buttons that allow data filtering, sorting, hierarchy management, navigation to other apps, and data exporting.

Let’s have a closer look at the Balance Sheet and Income Statement - Multidimensional app: