SAP Knowledge Base Article - Public

3217898 - Difference between the Data of Tax Return and Its XML in the Output for VAT Return for Italy

Symptom

You compare the data in the tax return and its generated xml, you found differences.

You expect them to be the same.

Environment

SAP Business ByDesign.

Reproducing the Issue

To check the data in the Excel:

  1. Go to Tax Mangement Work Center.
  2. Go to VAT Returns View.
  3. Find and open Return AA(AA is the ID of the return).
  4. Go to Tab Tax Return.
  5. Download the data in the table.

In the exported excel:

The tax base amount for payables is BBB(BBB is the total amount).

The tax base amount for receivables is CCC(CCC is the total amount).

The tax amount for payables is DDD(DDD is the total amount).

The tax amount for receivables is EEE(DDD is the total amount).

To check the data in the XML:

  1. Go to Tax Mangement Work Center.
  2. Go to VAT Returns View.
  3. Find and open Return AA(AA is the ID of the return).
  4. Go to Tab Attachment.
  5. Download and open the XML.

You see that:

The tax base amount for payables is HHH(HHH is the total amount).

The tax base amount for receivables is III(III is the total amount).

The tax amount for payables is JJJ(JJJ is the total amount).

The tax amount for receivables is KKK(KKK is the total amount).

Differences exist for the amounts in the excel and xml.

Cause

For Italy, it is not mandatory as per the law that tax amount in the tax return screen and amounts in the file should match. While generating the return we are considering reverse charge base and tax amounts but at the time of file generation it is not expected that we need to consider the tax base amounts that is the reason there is a difference of amounts in both file and return.

Resolution

If you need to verify the data in the VAT Return, you can download the data from the Tab Tax Return and submit it to the tax authority.

Keywords

vat return. tax return. excel. xml. difference. Italy. , KBA , SRD-FIN-GLO-TAX , GLO - Tax Declaration , Problem

Product

SAP Business ByDesign 2022