SAP Knowledge Base Article - Public

3433754 - Tax Amount in Tax Box Code 81 Different From Tax Amount Calculated by Business ByDesign (Belgium)

Symptom

You run VAT Return for country/region Belgium.

You notice that the Tax Amount in Tax Box Code 81 is different from the sum of the tax amount calculated on the source documents by Business ByDesign.
For example:
-Tax Amount in Tax Box Code 81 is 28,750.31 EUR (28,750.31 EUR stands for AAA EUR).
-Tax Amount calculated by the system is 6,637.47 EUR (6,637.47 EUR stands for BBB EUR).

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Tax Management work center.
  2. Go to the Tax Returns view.
  3. Go to the VAT Returns subview.
  4. Select the VAT ID: XXX (XXX stands for the VAT Return ID).
  5. Select View.
  6. Select the Tax Return tab.
  7. Select Tax Box Code 81-Incoming trans-domestic purch goods.

The Amount shown is AAA EUR.

  1. Select Details box.
  2. Calculate the sum of the Tax Amount.

The sum of Tax Amount is BBB EUR.

  1. Select Export > To Microsoft Excel.
  2. Calculate the total of Tax Amount on the Excel file.

The sum of Tax Amount is BBB EUR (Same Tax Amount as in ByD).

Cause

  • In case of a purchase transaction posted with a tax code with a non-deductible part of VAT (Tax Code 011 - Domestic purchase of goods, standard rate, non-deductible), you must report in box 81 the tax base amount of the transaction and the non-deductible part of VAT.

You have a net invoice entry XYZ (XYZ stands for the invoice ID) with tax code 011.
-Tax rate is 21%
-Tax Net Base Amount is 792.00 EUR.
-Tax Amount is 166.34 EUR.
The amount reported in tax box code 81 for this invoice is the sum of the Tax Net Base Amount plus the Tax Amount (792.00 EUR + 166.34 EUR).
In Business ByDesign, the Details of the tax box code  81 shows only the Tax Amount 166.34 EUR.

  • On the Tax Details, invoice XYZ appears twice because you need to have 2 lines, so that from one line the system can take the base amount and from the other line it can take the non-deductible part of VAT. This way, both amounts can be added into the appropriate box in the tax return.

Resolution

This is the correct and expected system behavior.

Keywords

Tax Box Code 81, VAT Return, Tax Code 011 - Domestic purchase of goods, standard rate, non-deductible, Belgium. , KBA , SRD-FIN-GLO-TAX , GLO - Tax Declaration , Problem

Product

SAP Business ByDesign all versions