SAP S/4HANA Cloud for Finance: Balance Reporting – Part 1: Introducing balance types and consumption types

This blog series explains the different capabilities and important configuration steps to meet your business needs for balance reporting in finance:

Balance types:

Business typically uses 3 types of balances: a moving balance contains all line items that are posted within a time interval without the balance carry forward. This can useful when reporting only the movements of a quarter or a different time interval, but it can also be used for a year to date balance for accounts that do not have a balance carry forward, like profit & loss account or cost center reporting. The year to date balance contains all line items that are posted within the fiscal year and that include the balance carry forward that is done for balance sheet accounts. This can be useful for year reporting on GL Account balances for both balance sheet and P&L and Profit Center reporting. The cumulated balance over time allows you to display the balance evolvement over time units like date, period or quarter. With this the ending balance of period 1 will be taken over as the starting balance of period 2. An example for this sort of balance can be seen in the app Trial Balance when you drill down by Fiscal Year Period. Since this calculation requires to assign all posting of period 1 to the other periods as well, this calculation can be more time consuming than a year to date balance.

Fig 1: Cumulated balance reporting with the app ‘Trial Balance’

Consumption types:

The blogs cover the options to do a balance report according to the balance categories moving balance, year to date balance and cumulative balance for the most used front-ends of SAP S/4HANA Cloud: SAP S/4HANA delivered standard reports and standard APIs, SAP S/4HANA Custom Reports in Fiori Launchpad as well as consumption in SAP Analytics Cloud and Excel. In addition, they will explain important technical configuration steps to achieve the expected outcome.

Stay tuned for the next blog on SAP S/4HANA Cloud: Standard reports and standard APIs for balance reporting.

For more information on SAP S/4HANA Cloud, check out the following links:

SAP S/4HANA Cloud release info: http://www.sap.com/s4-cloudrelease
Sven Denecken’s 1902 blog on SAP News here
Best practices for SAP S/4HANA Cloud here
SAP S/4HANA Cloud Customer Community: here
Feature Scope Description here
What’s New here
Help Portal Product Page here

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Product Information

SAP S/4HANA Cloud for Finance: Balance Reporting – Part 1: Introducing balance types and consumption types

Assigned Tags