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
- Go to Tax Management work center
- Select VAT Return view
- Search for Tax Return ID
- 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
- Go to the Tax Management work center.
- Go to the Reports view.
- Search for the report: All Vat/Sales Tax items.
- Enter selection parameters as below
- Company: As per the VAT Return or VAT Return Run which created VAT return
- 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.
- Click Go
- Move the Tax Amount Overridden field from Not Currently Shown to Rows
- Click Show Settings -> Key Figures
- Add Difference and Internal Tax Amount from Available to Selected
- Click Ok
- Go to Edit Filter
- Filter for the below parameters
- Tax amount overridden: X
- Due Category: 2 (Receivables)
- 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 case 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
Toal Difference Amount, Tax Return, Value, Amount , KBA , SRD-FIN-TAX , Tax Management , How To