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
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.
- Define Compliance Reports app (Define compliance reports)
- Set up Compliance Reports (Setting up your compliance reports)
- Run Compliance Reports app (Run compliance Reports)
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
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.