SAP Knowledge Base Article - Public

2296604 - Error: Gross amount balance not equal to zero

Symptom

You are uploading Manual Tax Entries via MS Excel and you can see the error message: Gross amount balance not equal to zero.

NOTE: The error appears once you click 'Save data to' in Excel sheet.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Tax Management work center.
  2. Go to the Manual Tax Entries view and click VAT Entries subview.
  3. Click New -> Tax Entry from Microsoft Excel.
  4. You have downloaded the excel template and maintained data in the excel sheet.
  5. Now you have clicked 'Save data to' option in excel sheet to upload Tax Entries in SAP ByDesign system.
  6. Here, you can see the error message: Gross amount balance not equal to zero.

Cause

Here, system checks on following two points while uploading the Manual Tax Entries in SAP Business ByDesign system:

  1. When you mention/enter the tax code in the excel sheet, then the Tax Amount must be calculated according to the Tax Rate maintained in the system. Additionally, if Tax Amount is '0.00', then also you have to mention '0.00'. Please ensure that the Tax Amount is calculated according to the Tax Rate maintained in the system.
  2. Gross amount in the excel sheet must be Zero.
    Debit Amount + Tax Amount =Credit Amount + Tax Amount = Gross Amount = Zero.

Resolution

This is standard system behavior.

Keywords

upload manual tax entries; excel; gross amount balance; zero; 0 , KBA , zero , gross amount balance not equal to zero , SRD-FIN-TAX , Tax Management , How To

Product

SAP Business ByDesign all versions