Commodity Codes

Commodity codes are the WTO code for a product and are used throughout the world for imports and exports.

We utilise a simplified approach for this within the system however you are able to use the full codes if you so wish. They are used for reporting only within Vision Commerce.

To create a Commodity Code you will need to have set up your Product Type Codes

It is your responsibility to ensure your Commodity Codes are set up correctly and that Products are assigned the correct Code

A number of pre-loaded commodity codes will exist on any new system and you can add to this yourself, just be careful as the code can not be altered afterwards.

Duty Elements

This form enables you to maintain duties applicable to your products.

Method of Calculation

We utilise specified routing and calculation methods some of which are specified by the government departments responsible for the collection of duties, it is not always a simple calculation when you have rounding and truncation to provide within the calculations.

If you change the method of calculation it applies to Previous, Current, and New Duty Rates.

Rate / LOL

Calculation Basis : Litres of Liquid (LOL) X rate per litre of liquid

The stock information held for LOL is per case also calculated by taking the singles per case (SPC) X single size (SS)

Rate / LOA

Calculation Basis : Litres of Alcohol (LOA) X rate per litre of alcohol

LOA per case is derived from LOA * (Stength ABV / 100)
e.g. 9litre case which is 12.5% would be 9 * (12.5/100) = 1.125 litres of alcohol per case and if this was a 12 bottle case this is 0.09375 per bottle

Custom calculation use 5 decimals when calculating and then a formula of truncation when presenting the total once everything is summed together.

Tax Type Code

This refers to the code field on the form, where we always specify that you should use the HMRC code in the system, until 1 August 2023 the UK HMRC codes were all 4xx and will change to 3xx on that date.

Pre 1st August 2023 tax codes

Tax Type Code	Tax Type Description	Tax Type Unit of Measure
407	Beer made in UK >60,000 hectolitres per annum	Hectolitre % Alcohol InProduct To Nearest 0.1%
411	Sparkling Wine	hectolitres
411	Sparkling Wine	litres
412	Sparkling wine	hectolitres
412	Sparkling Wine	litres
413	Still Wine	hectolitres
413	Still Wine	litres
415	Still or sparkling wine	hectolitres
415	Still or Sparkling Wine	litres
419	Still or sparkling wine	litres
421	Sparking Made Wine	hectolitres
421	Sparkling Made Wine	litres
422	Sparkling made-wine	hectolitres
422	Sparkling Made Wine	litres
423	Still made wine	hectolitres
423	Still Made Wine	litres
425	Still or sparkling made-wine	hectolitres
425	Still or Sparkling Made Wine	litres
429	Still or sparkling made wine	litres
433	Low alcohol wine,made-wine, cider/perry mixed drinks	hectolitres
435	Low alcohol wine, made-wine, cider/perry mixed drinks	hectolitres
438	Spirits based Ready To Drink (RTD)	litres of alcohol at 20 degrees Celsius
440	Beer made in UK >5,000 and <60,000 hectolitres per annum	Hectolitre % Alcohol InProduct To Nearest 0.1%
441	Imported Beer >5,000 and <60,000 hectolitres per annum	Hectolitre % Alcohol InProduct To Nearest 0.1%
442	Beer made in UK <5,000 hectolitres per annum	Hectolitre % Alcohol InProduct To Nearest 0.1%
443	Imported Beer <5,000 hectolitres per annum	Hectolitre % Alcohol InProduct To Nearest 0.1%
444	UK produced beer exceeding1.2%not exceeding 2.8%	Hectolitre % Alcohol InProduct To Nearest 0.1%
445	UK produced beer exceeding 7.5% HSBD	Hectolitre % Alcohol InProduct To Nearest 0.1%
446	Imported Beer exceeding 1.2% not exceeding 2.8%	Hectolitre % Alcohol InProduct To Nearest 0.1%
447	Imported Beer exceeding 7.5% HSBD	Hectolitre % Alcohol InProduct To Nearest 0.1%
451	Spirits other than UK produced whisky	litres of alcohol at 20 degrees Celsius
461	UK produced malt whisky	litres of alcohol at 20 degrees Celsius
462	UK produced grain whisky	litres of alcohol at 20 degrees Celsius
463	UK produced blended whisky	litres of alcohol at 20 degrees Celsius
473	Imported beer >60,000 hectolitres per annum	Hectolitre % Alcohol InProduct To Nearest 0.1%
481	Still cider and perry: exceeding 1.2% - less than 6.9% abv	hectolitres
481	Still Cider & Perry	litres
483	Still cider and perry: exceeding 7.5% - less than 8.5% abv	hectolitres
485	Cider/Perry Sparkling made in UK or imported exceeding 5.5% but less than 8.5% (hectolitre)	hectolitres
487	Still cider and perry: at least 6.9% - not exceeding 7.5% abv	hectolitres
611	cigarettes	monetary
611	cigarettes	000's
615	cigars	kg's
619	handrolling tobacco	kg's
623	other smoking tobacco	kg's
627	chewing tobacco	kg's
633	Tobacco for Heating	kg's
B00	Value Added Tax	monetary

Current and Previous Sections

This section simply shows the current and previous rates you charged for this specific tax code.

Add New

When you have a new rate to enter, ensure you specify the date, enter the values in both the excise and customs field, even if one has not changed you need to enter both and then apply this by pressing the save button.

Additional Notes

HMRC publish rates in LOA, LOL, HLOA, and HLOL
- In general, the wine rate is published in HLOL so please remember, your calculation needs to change this to LOL.
- You will have to enter a Customs Duty Rate in addition to an Excise Duty Rate, this cannot be left as zeros.
- The use of this is then controlled by the Customs Duty Paid Flag on the Purchase Order entry as shown in more detail on the Purchase Order Tab page.
Excise Duty Rate in either LOL or LOA – this is the UK Duty
Customs Duty Rate in either LOL or LOA – this is the EU Duty
See the HMRC Website pages regarding Duty Rates:
https://www.gov.uk/government/publications/uk-trade-tariff-excise-duties-reliefs-drawbacks-and-allowances/uk-trade-tariff-excise-duties-reliefs-drawbacks-and-allowances