SAP Knowledge Base Article - Public

2655241 - Total Tax Amount in VAT Return is Greater Than Manually Calculated Tax For That Return

Symptom

  • You have submitted a VAT Tax Return.
  • As a confirmation, you manually calculate the Total Amount tax by adding together all the values under Tax Amount column in the Tax Return tab.
  • You notice that the amount shown under Total Tax Amount field in the Overview tab, is greater than the value you have manually calculated above.

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 VAT Returns subview.
  4. Find VAT Return ID XX and open it.
  5. Open the Overview tab.
  6. Take note of the value shown under Total Tax Amount field.
  7. Open the Tax Return tab.
  8. Click the Export button.
  9. Select To Microsoft Excel option.
  10. Save the document in your device.
  11. Open the saved Excel file and sum the column called Tax Amount.
    Note: The value shown under Total Tax Amount field in the Overview tab of the VAT Return is greater than the value you have manually calculated.

    (XX represents the Tax ID number)
     

Cause

  • The Total Tax Amount value shown in the Overview tab field of the VAT Tax Return shows the sum of all items taken into consideration for the relevant VAT Tax Return Run.
  • The manually put together Total Amount tax takes into consideration only the values that have been submitted to the Tax Authories.
  • The relevant VAT Tax Return Run contains several Warning messages that have been ignored. The invoices with Warning messages are not submitted to the Tax Authories.

Resolution

In order for the Total Tax Amount and the manually calculated Total Amount to match, you need to correct the items affected by Warning messages in the relevant VAT Tax Return Run.

Keywords

Total, Amount, Tax, Return, Authorities, Tax Management, Run, Warning, VAT , KBA , SRD-FIN-TAX , Tax Management , Problem

Product

SAP Business ByDesign all versions