SAP Knowledge Base Article - Public

2063883 - Balance of Petty Cash Inconsistent from Ending Balance in Report Trial Balance

Symptom

You find that balance of petty cash and the value of field Ending Balance Company Currency in report Trial Balance is inconsistent.

Environment

SAP Business ByDesign

Reproducing the Issue

Balance of petty cash can be found in following steps:

  1. Go to Liquidity Management work center, Master Data view and Petty Cash subview.
  2. The balance amount of the petty cash account can be seen.

To check the balance in Trial Balance:

  1. Go to General Ledger work center and Report view.
  2. Select report Trial Balance.
  3. Input Company, Set of Book and G/L Account of the petty cash account.
  4. Select Accounting Period as Year to Date.
  5. The report should be run and it will be found that the amount shown in the field Ending Balance Company Currency is different from the balance in the petty cash account.

Cause

There are several payments, the payment allocations of which are in status of In Preparation.

Such payments are not included in report Trial Balance. But it is considered in Petty Cash account.

Resolution

There are two options to solve this issue:

  • To reverse those payments.
  • To edit the payment allocations, make corrections and post them.

Keywords

Balance, Petty Cash, Ending Balance, inconsistent, Trial Balance, Report. , KBA , AP-PAY , Payment Processing , How To

Product

SAP Business ByDesign all versions