2620 CSV Output

Field Name

Length

Comments

W5No

10

The W5 number submitted to HMRC for the unique transaction, this would normally appear on your statement which is send from HMRC.   The payment of duties is split between acquisition VAT and deferred VAT so each will be allocated a separate W5 number.

CustomerCode

8

DefermentCustomer

8

SiteCode

2

This is the warehouse keepers site code to identify the site, and approval number which is being used for the generation of the duty and vat submission. A separate submission will be made for each site approval.

TaxCode

3

The 3 digit tax code for the goods, see HMRC lists for further details and descriptions about tax codes.

Date

10

The date of the transaction, and will be the date the picking has been confirmed.

ProductCode

30

ProductDescription

50

RotationNumber

10

Will be 10 digits the standard length

RotationLineNo

4

Is the line number for the rotation, and will only be completed if there is a line number associated with the movement of the stocks

SinglesPerCase

10

Number of singles in each unit

SingleSize

10

The single size, when this is bottles of wine for example the standard size would be 0.75 litres

DocRef

30

Your unique reference for this movement.

OrderType

5

There are various movement types recorded for all movements, these are unique and assist in the correlation of why payments have been made, please see the section below detailing different stock movement types.

SO Code Lists | B Customs Warehouse Order Codes (HD2)

Cases

6

The number of cases within the calculation

Singles

6

The number of single items over and above the cases  within the calculation

Qty

10

The quantity on which excise duty is paid, this could be weight, litres of alcohol, value, litres of liquid and is dependent on the tax code requirements

ExciseDuty

8.5

This is the qty field X rate of duty

Commodity Code

20

CustomsDuty

8.5

This is the qty field X rate of duty / 100

InbondValue

20

Product Cost + Insurance + Freight + Vat Val Adjustment

This is not the value for vat however it is used in the calculation which is as follows :

InbondValue +
ExciseDuty +
CustomsDuty (on this transaction) +
CustomsDuty (prev paid at the warehouse - see below)

VATAmount

20

VAT Amount

Based on value for vat x vat rate at the time of the excise movement.

DP PO Ref

12

Delivery Point purchase order reference (good for duty deferred orders)

ABV

3.3

ABV Strength %