When generating the Country Tax Report and Standard Tax Report for the same reporting period, the total values may not match if certain transactions are excluded from the Country Tax Report. This can occur when the transaction does not meet the filters defined in the applicable Tax Return Setup.
The transactions and amounts shown on the Country Tax Report - United Kingdom are based on the Tax Return Setup. To review the setup, navigate to Setup > Tax Reporting > Tax Returns > look for Periodic VAT return - VAT 100 > click View.
On the Set Up Tax Return: United Kingdom - Periodic VAT return - VAT 100 page, the filters determine which transactions are posted to each tax return box.
For example, when reviewing Box 4, the first line of the filter includes Tax Item Types, and the selected types are Goods and Services only.
If a transaction, such as INVXXX, is reviewed and the associated item is opened by navigating to its item record > Tax tab, the Tax Item Type may be blank. Because the Tax Item Type is not populated, the transaction is not included in the Country Tax Report - United Kingdom.
To resolve the mismatch, edit the item and populate the appropriate Tax Item Type, such as Goods or Services. After the Tax Item Type is added and saved, the related transaction should be included in the Country Tax Report - United Kingdom, provided it meets the tax return filter criteria.