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’
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: