SAP Knowledge Base Article - Public

2138853 - Report Financial Statements Creates Balances on the Assets and Liabilities Side of the Financial Statement

Symptom

You run the report Financial Statements and in accordance with the settings in work center Business Configuration you expect one accumulated balance for Cash Account XXX, either on the Assets Side or on the Liabilities Side.
Instead you see a balance on the Assets- as well as on the Liabilities side of the report.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Open General Ledger work center
  2. Go to Reports - List and select the report Financial Statements
  3. Enter all relevant parameters and click on Go
  4. You see that for Cash Account XXX a balance is shown on the Assets side as well as on the Liabilities side of the Financial Statement

 

Check the settings in Work Center Business Configuration:

  1. Open Business Configuration work center and select Activity Charts of Accounts, Financial Reporting Structures, Account Determination
  2. Click on Edit Financial Reporting Structures
  3. Select the relevant Reporting Structure and choose Edit - Expand All
  4. Cash Account XXX has been correctly assigned to the Asset Side as Show Only - Debit Balance
  5. Cash Account XXX has been correctly assigned to the Liability Side as Show Only - Credit Balance

The settings in Work Center Business Configuration are correct.

Cause

You created a manual posting to Cash Account XXX using the Journal Entry Type:00047 - Manual Posting - Journal Entry Voucher with the Screen Variant: 601 - Journal Entry Voucher.
Since there is no option to address a bank account the document is posted to the General Ledger and not to the Cash Subledger while other documents related to Cash Account XXX have been posted to the Cash Subledger.
Hence the system considers the accounts as two different Subledger Accounts (Cash Account and Account without Subledger).
The aggregation is done seperately and consequently the balances for Cash Account XXX are not accumulated, but shown on the Assets and Liabilities side in the Financial Statement.

This can be double-checked as follows:

  1. Open General Ledger Work Center
  2. Go to Reports - Lists and select the report Trial Balance
  3. Add all necessary parameters and click on Go
  4. Move Subledger Account Type from Not Currently Shown to Rows
  5. You can see the postings to a Subledger which have been created for Cash Account XXX   

Resolution

Reverse the Journal Entry Voucher:

  1. Open General Ledger work center
  2. Go to Journal Entries
  3. Select the relevant Journal Entry Voucher and click on Reverse

Create a new Journal Entry Voucher which will post to the Cash Subledger:

  1. Open General Ledger Work Center
  2. Go to Journal Entries
  3. Click on New -Journal Entry
  4. Select 00083-Manual Entry for Cash in the field Journal Entry Type
  5. Select 636-Manual Write-Up/Write-Down for Cash as Screen Variant
  6. Enter the relevant Bank in the first row
  7. Fill in all the necessary details and confirm with Post

If you run the report Financial Statements afterwards the posting is either shown on the Assets or Liabilities side of the report according to the balance of Cash Account XXX.

Keywords

KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions