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.
For simplicity we provide a single Duty Rate calculation which contains both the customs duty and the excise duty amount on the same record.
Where you are using the system for En Primeur (Advanced Purchase) and the goods you are clearing have a preference/quota for the customs duty making the duty 0.00 then you should setup an additional duty rate, otherwise the duty and vat invoice will calculate customs duty should you land the stock as customs duty NOT paid
e.g. 333 → 333P - Set the customs duty rate to be 0.00
Any products fitting the category of “having a preference of 0.00” can then be added to this duty rate which will stop unnecessary calculations of customs duty.
As of Jan 2024 all wine goods from the EU have a preference so they fit this category and could be setup using the 333P duty rate.
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.
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