Tax table population
The following table is an example of a typical tax code table for the UK (Country Code = GB).
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, the system behaves as follows for each record.
-
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 |