Tax table population
The following table is an example of a typical tax code table for the UK (Country Code = GB).
When a percentage value is set to 999, this means that the entry can be used for any tax rate. This is only available if the tax code information for the corresponding organization is configured so that the Any Rate setting is selected on the Settings > Invoice Processing > Capture Profiles > Tax Settings > Tax Code Information tab.
Country |
TaxCode |
VendorID |
ShipTo |
Ship From |
Service |
Material Group |
Material No |
Percentage |
---|---|---|---|---|---|---|---|---|
GB |
V0 |
GB |
GB |
0 |
||||
GB |
V1 |
GB |
GB |
17.5 |
||||
GB |
V3 |
GB |
EU |
999 |
||||
GB |
V4 |
GB |
EU |
X |
999 |
|||
GB |
V6 |
GB |
GB |
8 |
||||
GB |
V9 |
GB |
GB |
15 |
||||
GB |
VF |
GB |
XX |
999 |
||||
GB |
V9 |
GB |
GB |
999 |
Using this configuration, Kofax AP Agility behaves as follows for each record.
If it is a domestic transaction, and no tax is charged, then tax code V0 is always used.
-
If it is a domestic transaction, and tax at the rate of 17.5% is charged on the invoice, then tax code V1 is always used.
-
If the goods are shipped from an EU member state country to the UK, then tax code V3 is always used.
-
If the invoice is from an EU member state vendor and the service is performed in the UK, then tax code V4 is always used.
-
If it is a domestic transaction, and tax at the rate of 8% was charged on the invoice, then tax code V6 is always used.
-
If it is a domestic transaction, and tax at the rate of 15% was charged on the invoice, then tax code V9 is always used.
-
If the invoice is from a vendor outside of the EU, and the goods are shipped to the UK, then tax code VF is always used.
-
If no specific item tax percentage is determined from the invoice, but it is a domestic transaction, then tax code V9 is always used.
Step 8 represents the default tax code for a combination of ship-to and ship-from countries. The most common non-zero tax code must be set against this record.
If an additional business requirement involves a new tax code (VS) that must be used in instances where a non-EU member state vendor submitted an invoice for a service provided outside the EU, and where tax was charged at 0%, then add the following entry to the tax table.
Country |
TaxCode |
VendorID |
ShipTo |
Ship From |
Service |
Material Group |
Material No |
Percentage |
---|---|---|---|---|---|---|---|---|
GB |
VS |
XX |
XX |
X |
0 |
Equally, if a requirement arises whereby a different tax code (DS) must be used in all instances involving a service carried out domestically irrespective of whether tax is charged or not, the following entry must be added to the tax table.
Country |
TaxCode |
VendorID |
ShipTo |
Ship From |
Service |
Material Group |
Material No |
Percentage |
---|---|---|---|---|---|---|---|---|
GB |
DS |
GB |
GB |
X |
999 |