Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
Showing results for 
Search instead for 
Did you mean: 
Product and Topic Expert
Product and Topic Expert
This blog series explains the different capabilities and important configuration steps to meet your business needs for balance reporting in finance:

  1. This blog: Introducing balance types and consumption types 

  2. Blog: SAP S/4HANA Cloud: Standard reports and standard API for balance reporting

  3. Blog SAP S/4HANA Cloud: Custom report creation for balance reporting

  4. Blog SAP S/4HANA Cloud: Custom report consumption

  5. Blog Summary

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:

Follow us via @SAP and #S4HANA, or myself via @HaukeUlrich and LinkedIn.