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:
Follow us via @SAP and #S4HANA, or myself via @HaukeUlrich and LinkedIn.
- This blog: Introducing balance types and consumption types
- Blog: SAP S/4HANA Cloud: Standard reports and standard API for balance reporting
- Blog SAP S/4HANA Cloud: Custom report creation for balance reporting
- Blog SAP S/4HANA Cloud: Custom report consumption
- 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:
- 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
Follow us via @SAP and #S4HANA, or myself via @HaukeUlrich and LinkedIn.
- SAP Managed Tags:
