Skip to Content
Technical Articles
Author's profile photo Ildar Murzenkov

Creating a new Balance sheet and Profit and Loss (P&L) using Advanced Compliance Reporting

This blog post describes how to create a new Balance sheet and Profit and Loss (P&L) report on the SAP S/4HANA Cloud using Advanced Compliance Reporting.
For example, you wish to create a Balance sheet and Profit and Loss (P&L) report for a country, for which it is not available as a part of the standard delivery.

Note: To fulfill the legal requirements in an effective way, Advanced Compliance Reporting provides a selection of standard reports that can be re-used for extensibility purposes, in case it is not available as standard delivery. For the Balance sheet and Profit and Loss (P&L) a generic report definition GENC_FINSTMNT_RET is available and can be extended and configured based on your local or company-specific requirements (for example relating to the form layout or calculation algorithm).

Prerequisites

You have administrative access to SAP S/4HANA Cloud and implementation experience on the system. You are also familiar with the implementation of Advanced Compliance Reporting on SAP S/4HANA Cloud.

Authorizations

Business Role Business Role ID
Administrator  SAP_BR_ ADMINISTRATOR
Configuration Expert – Business Process Configuration  SAP_BR_BPC_EXPERT
General Ledger Accountant SAP_BR_GL_ACCOUNTANT

Let’s get started

Implementation of the new report is across the following apps and configuration steps (SSCUI), and these are available on the SAP Fiori overview page.

Creating a new Report Definition

Create a new report definition in the Define Compliance Reports app. You can do so by navigating to the Define Compliance Reports App from the Advanced Compliance Reporting group on the SAP Fiori overview page. Create the new report definition using the Enhanced Report mode. You can choose the GENC_FINSTMNT_RET as a reference Report Definition.

Note: The advantage of enhancing an existing report is that you are assured that any updates that come for the standard report, will reflect in your new report. In this way, for example, you avoid the inconsistencies that might occur at a system upgrade.

There are seven steps to be accomplished to complete the report definition. For detailed information on these steps, you can see in the blog Defining a Localized Version of a Withholding Tax Report.

Please pay special attention to step 4 – The standard generic Balance sheet and Profit and Loss (P&L) report provide 3 ALV document definition outputs:

  • Balance Sheet / Income Statement – All Accounts
  • Balance Sheet
  • Income Statement

Document%20definitions

Document definitions

You can adapt these documents or create new ones (ALV, XML, TXT, JSON, PDF, XBRL) according to your local or legal requirements.

To run a new report, we need to define a new report category and define the reporting entity that submits those reports to the government or other stakeholders.

Creating a Reporting Category

In the Define Compliance Reports App:

  • Create a new Report Category
  • Assign existing Organizational units such as company code
  • Assign Report Definition which was created o previous steps

For detailed information about Report Category creating see documentation Creating a Report Category

Creating a new Reporting Entity

Select the following under Manage Your Solution app:

  • Finance as the Application Area
  • Statutory Reporting as the Sub Application Area

Select Configurations from the list of configuration steps and set up your compliance reporting

  • Assign created Reporting Category to a new Reporting Entity
  • Assign Organization Unit to the Reporting Entity

Assign the organizational units that make up this reporting entity. You can enter one or several, but you must mark one as the leading organizational unit. The system takes data from the leading organizational unit master to fill some fields in the report documents created for the government.

Creating a new Financial Hierarchy

Select the following under Manage Your Solution app:

  • Finance as the Application Area
  • General Ledger as the Sub Application Area

Select item chart of account and the following configuration from the list of configuration steps:

  • Define Financial Statement Versions
    You can create new or copy existing Financial Statement Version

Run Compliance Report

Implementation of the Run Compliance app is as per standard guidelines.

In the Run Compliance report app chose created report Category or Reporting Entity. You will see available for creating reports.

Thank you for reading this blog post. With these steps, you are now able to adapt your Balance sheet and Profit and Loss report on the SAP S/4HANA Cloud using Advanced Compliance Reporting.

Please leave your comment and feedback below. Further information and more find in the series of blogs under Run Compliance Reports. Further information on extending localization is available here.

 

 

 

 

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo . Bao .
      . Bao .

      May I ask, it is only possible to use app, not GUI for ACR?