1857472 - Opening Balance for Profit & Loss Account Shows as 0.00 Without Balance Carryforward Conducted

You are using the Trial Balance report on a monthly base to validate balance sheet G/L Account balances against profit and loss (P&L) accounts to decide on adjustment postings. After that you expect ending balances in the Trial Balance to tally. The approach works for all periods of the fiscal year so far. However, you notice that in the first period of the new fiscal year you do not see an opening balance for the relevant P&L account. This cannot be explained by transactions as recorded in the G/L Account - Line Items report for the relevant periods since a balance carryforward has not been conducted yet for the relevant fiscal year.

For example:
Transactions and balances of a balance sheet account (for example, deferred cost of goods sold) are compared and cleared against a P&L adjustment account. The column Opening Balance Company Currency for the P&L account shows a value of 0.00.

SAP Business ByDesign

1. Go to General Ledger work center.
2. Navigate to Reports view and List.
3. Select the report Trial Balance with the relevant parameters including the first period of the fiscal year.
4. Enter the relevant G/L accounts (for example, deferred cost of goods sold and P&L adjustment account) and run the report.
5. Compare the values in the column Opening Balance Company Currency.

P&L accounts are usually cleared during the year end procedure. This is considered in the Trial Balance even if the Balance Carryforward Run has not been performed yet. Since it is technically incorrect to assume an opening balance in the first period of the new fiscal year, a Balance Carryforward is anticipated and notionally conducted when employing the Trial Balance for this month.

When conducting comparison and clearing scenarios, an opening balance for a P&L account cannot be assumed for the first period of a fiscal year. As a workaround the last fiscal year's ending balance can be used alternatively for calculation purposes. Another option would be the usage of a balance sheet account with continued balances.

opening balance company currency; trial balance; ending balance company currency; balance carryforward; bcf , KBA , balance carryforward , trial balance , opening balance , SRD-FIN-COR , Cost & Revenue , How To