3736077 - Balance differs from Display line items in General Ledger when comparing periods in Balance sheet/Income statement app - SAP S/4HANA Cloud Public

Balance differs from Line item totals in Display line items in General Ledger during drilldown when comparing periods. 

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

For example as below: 

SAP S/4HANA Cloud Public Edition

1. Open the “Balance Sheet/Income Statement” app.
2. Select a G/L account and choose a fiscal period and a comparison period.
3. Observe that the period or comparison balance in the report is zero or differs from expectation.
4. Drill down to “Display Line Items in General Ledger” from the report.
5. Observe that postings exist and the summed line item amounts differ from the balance shown in the report.

• The drilldown from Balance Sheet/Income Statement to line items does not carry the hierarchy node (debit/credit side) context; the line items app fetches all relevant postings for the selected timeframe and filters.
• Line items do not include technical balance carry-forward (opening balance) items, while balance reports may include them, leading to different totals.

A Balance sheet is aligned to Asset and Liabilities:

• Asset: show DEBIT amount
• Liabilities: show CREDIT amount

• At the end of period 1 (period balance column) there is a credit amount, which is why ASSET shows 0,00€ and LIABILITIES 1.494.622,69€. 
• At the end of period 2 (comparison balance column) there is a debit amount left, which is why ASSET shows now 11.760.580,89€ and LIABILITIES 0,00€.

When navigating to the line items for the comparison balance column, it does not matter when clicking on the 11.760.580,89€ entry from ASSET or the 0,00€ entry from LIABILITIES — it will appear same line items, as balance sheet node context is not known there. 

All line items contributing to this time frame and the filters are fetched in the line items app. That is why the sum in the line items app can only match either the ASSET or LIABILITIES number, depending on whether more remains on the debit or credit side. Additionally, the amount will not match at all if an opening balance contributes to the overall number.

To review list of dedicated period debit or credit amount line items, switch to the G/L Account Balance app first.

• KBA: Note 3336589 - Difference between G/L account balance and line item totals: Solution approach and FAQs
• Help portal: Balance Sheet/Income Statement app documentation
• SAP post: Community Q&A: balance on account using Balance Sheet / Income Statement

balance sheet, income statement, comparison balance, line items, drilldown mismatch, opening balance, carry-forward, debit credit split, hierarchy context, gl account balances, period comparison, totals differ, reporting apps, by design, financial reporting , KBA , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , Problem