Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Notes

Overview

The excise & vat summary report is produced following the running of the day end routine.  The csv report lists all transactions which will be included on the warrant

...

PDF

...

Available

...

View file
name7.pdf

...

CSV

...

Available

...

.

...

...

XML

...

Not Available

File Name Convention

SiteCode_CustomerCode_ExcsVAT_datetime

Limitations

*It should be noted that due to the HMRC method of calculation that the summing of the value fields will NOT match the total of the warrant.  In order to calculate this you need to add up each duty tax code to provide a total for a tax code and this is then truncated to 2 decimal places, then each tax code is added together to provide the total for the warrant.

Field Names & Content

...

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.

...

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

...

ExciseRate

...

20

...

The value of which has been used for the calculation of duty

...

ExciseDuty

...

20

...

This is the qty field X rate of duty

...

CustomsRate

...

20

...

The value of which has been used for the calculation of duty (rate is per hectolitre)

...

CustomsDuty

...

20

...

This is the qty field X rate of duty / 100

...

InbondValue

...

20

...

Product Cost + Insurance + Freight + Vat Val Adjustment

...

VATAmount

...

20

...

The value for VAT, when this is acquisition vat then it will be marked “ACQ VAT” otherwise a figure will be shown.

Stock Movement Types

HO          Home Orders, where duty is paid

CD          Customs Duty only payment where the transaction only pays customs duty

OE          European underbond movement

OU          UK underbond movement

EX           Export Movement to a destimation outside of the EC

LS            A Loss in store where duty would be paid on stocks being lost whilst in store

AD          A loss which is authorized by HMRC where goods can be destroyed with no duty payment

DU          Diplomatic Use for the goods.

...

Last Updates

We will only show entries highlighting changes which are less than 2 years old

Date

Change

 

 

 

 

Example Output

PDF

View file
name7.pdf

CSV

View file
name7.csv

XML

Not available

2620 XML Specifications

Not currently available