2134790 - Total Difference Amount In Tax Return

SAP Knowledge Base Article - Public

2134790 - Total Difference Amount In Tax Return

Symptom

You generate the tax return and in the overview of the tax return, you find the Total Difference Amount shows a value. You would like to know why this difference amount is displayed? How it is calculated? Is there anything wrong in the system?

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Tax Management work center
  2. Select VAT Return view
  3. Search for Tax Return ID
  4. Click View

In the Overview tab you find the field Total Difference Amount. This field is showing the Value. You would like to know how this is calculated and what are the implications of the same.

Cause

While creating the invoice /documents, a user has manually changed the tax amounts or tax code and posted documents with tax amounts different from tax amounts calculated by the system. Hence there will be a difference between Calculated Tax and Applicable Tax (Posted tax).

Total Difference = Internal tax amount (Calculated Tax Amount) - Applicable tax amount (Posted Tax amount)

Resolution

  1. Go to Tax Management work center
  2. Reports view
  3. Search for the report: All Vat/Sales Tax items.
  4. Enter selection parameters as below
    1. Company: As per the VAT Return or VAT Return Run which created VAT return
    2. Tax due date: As per the Tax return or if there exist return with overlapping time frame then modify the selection criteria accordingly. For example: Tax return XXX which shows difference executed for period 01.01.2014 to 31.12.2014. However there exist tax return YYY which is for 01.01.2014 to 30.06.2014. In this case, execute the report with the tax due date as 01.07.2014 to 31.12.2014.
  5. Click Go
  6. Move the Tax Amount Overridden field from Not Currently Shown to Rows
  7. Click Show Settings -> Key Figures
  8. Add Difference and Internal Tax Amount from Available to Selected
  9. Click Ok
  10. Go to Edit Filter
  11. Filter for the below parameters
    1. Tax amount overridden: X
    2. Due Category: 2 (Receivables)
  12. Click Go

You can check Result row for the Difference column. This should match with the Total Difference Amount in the Tax Return screen.
This return will also provide the details on the Source Document IDs and its type along with the System calculated tax (Column: Internal Tax Amount) and Posted tax (Column: Applicable Tax Amount).

Similar approaches apply to investigate differences in reported tax amounts also for localizations where the explicit field Total Difference Amount is not featured.

If after checking the report, you found that discrepancy still cannot be plausibly explained - Please report an incident to SAP.

Please note that, Total difference Amount is displayed only to indicate that there is a difference between system calculated tax and the actual tax posted. However Total Tax Amount is showing the correct values as per the Posted tax. you can proceed further and report/submit the tax return to authority.

Keywords

KBA , SRD-FIN-TAX , Tax Management , How To

Product

SAP Business ByDesign all versions