3684919 - Trial Balance app & restrictions for profit & loss / retained earnings accounts in sap S/4hana cloud public edition

You use Trial Balance Fiori app with P&L Statement accounts or Retained Earnings accounts and set the reporting period across multiple fiscal years. You notice that the balances displayed are not in line with expectations. 

SAP S/4HANA Cloud Public Edition

1. Run Trial balance app
2. Enter company code and date period across multiple fiscal years
3. View results. Account balances are not as expected

Reporting with the trial balance app across multiple fiscal years is designed for balance sheet accounts where balances are carried over to the next fiscal year. 

If you want to see P&L statement accounts or retained earnings accounts in the 'Trial Balance' app, it is recommended to limit the reporting period to a single fiscal year. If you start the Trial Balance app with P&L Statement accounts/Retained Earnings accounts and set the reporting period across multiple fiscal years the following issues can occur:

• Opening balances displayed in the report differ from the actual starting balances of the P&L Statement accounts
• Totals of starting/ending balance do not match the sum of starting/ending balances of the displayed accounts 

1. As mentioned above, while viewing P&L Statement accounts or Retained Earnings accounts in the 'Trial Balance' app, it is recommended to limit the reporting period to a single fiscal year.
2. It is often more beneficial to use the app 'Display G/L account balances' [F0707A] to view account balances instead, particularly for retained earnings accounts. 

F0707A, Display G/L account balances, trial balance, retained earnings, balance, bcf, balance carry forward, opening balance, period, fiscal year

KBA , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , FI-GL-GL-D-2CL , Reporting/Analysis/Display (Public Cloud) , Problem