Symptom
You have generated your quarterly VAT return, however the Total tax receivable amount in the tax return differs from total receivable tax amount in Reported VAT / Sales Tax Items report.
Environment
SAP Business ByDesign.
Reproducing the Issue
- Go to Tax Management work center.
- Go to VAT Returns view.
- Open the reported VAT return.
- Go to Tax Returns tab.
- Click Export -> To Microsoft Excel.
- Open the exported excel file.
- Filter the content to show only the 'Receivable' tax.
- Sum the Tax Amount of all Receivable entries.
- Note down the amount.
- Open the report Reported VAT / Sales Tax Items.
- Give all the relevant selection parameters to include data from this tax return ID in the report.
- Filter by 'Receivable' tax and sum up the total receivable amount.
You noticed that the Total Receivable Amount from the Tax Return differs from the total receivable amount shown in the report for the same Tax Return ID.
Cause
This happens due to non-deductible items being considered in the run. The total tax amount you see in Tax Return tab is always aggregated one.
Resolution
If you want to see the deductible amounts follow the following path.
- Open the return in Tax Return Tab.
- Navigate to Details.
- Go to personalisation mode and check the field Deductible Tax Amount.
This enables the field in the Details screen so that you know whether the tax amount is deductible or non-deductible.
Alternatevely, if there are too much data in the VAT Return and you are unable to check the details for each entry, you can check the same via Reported VAT / Sales Tax Items or Reported VAT / Sales Tax Items reports. Through these reports, you're able to pull the Deductible Tax Amount for the entries.
Keywords
Italy. Tax Return. Tax Management. , KBA , SRD-FIN-GLO-TAX , GLO - Tax Declaration , How To