As part of the sales tax validation, you compare the actual posted tax amounts with the calculated tax amounts in the case of debit taxation. The calculation is based on the assessment basis (BMG) in conjunction with the recorded tax key.
A reported difference is not necessarily an error. Perhaps an otherwise correct posting does not correspond to the scheme of the validation. In this respect, the aim is not to obtain a validation without differences - it must only be ensured that the difference can be explained. Small differences in the cent range are common anyway (and are generally due to rounding).
Example: Due to a traffic accident caused by your own fault, your fully comprehensive company car is repaired. You receive an invoice from the garage that only requests VAT.
You post the input tax account directly to the vendor. Although the posting is correct, you see a difference. However, there is nothing to correct.
Due to the link to the tax key, only tax accounts that are listed as input tax or sales tax accounts in the tax matrix are listed. This is particularly relevant for accounts in the input tax area that you occasionally post to directly (e.g. VAT deductible in the following year).
The date range (1) is freely selectable so that you can limit a date restriction to a difference.
Hide empty lines (2) prevents the display of tax account lines without movement.
Show direct tax postings (3) also lists postings without a tax key.
Validation of a tax key
The highlighted line for the key "V19" (input tax 19%) reads as follows:
The indicator 66 is the corresponding indicator in the advance return for tax on sales/purchases, followed by the tax account assigned in the tax matrix with a description and the tax percentage rate assigned in the tax matrix.
In the "Turnover" column, the amounts of the booking lines are netted with V19 in the period. This assessment basis is then multiplied by the tax rate and output in the "Tax calculated" column.
In the "Tax posted" column, all amounts of the tax account in the period that were generated by the tax key of the line are netted.
The last column shows the difference between "Tax calculated" and "Tax posted".
The difference shown here is clearly too high and should be checked. The best way to do this is to first narrow down the data using the calendar.
The drill-down in the "Tax calculated" field is helpful; the journal is filtered accordingly in the lines with a tax key.
You can recognise a posting that was made with tax code V19, but the tax amount is set to 1570 instead of 1576. This results in a difference for line 1576 with V19.
This difference does not necessarily have to be corrected, as the allocation of the "Input tax" account (1570) is analogous to "Input tax 19%" (1576) in the advance return for sales tax.