...
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.
...
...
Available
...
| View file | ||
|---|---|---|
|
...
CSV
...
Available
...
| View file | ||
|---|---|---|
|
...
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 |
ExciseDuty20 | 8.5 | This is the qty field X rate of duty | |||
CustomsRateCommodity Code | 20The value of which has been used for the calculation of duty (rate is per hectolitre) | ||||
CustomsDuty20 | 8.5 | This is the qty field X rate of duty / 100 | |||
InbondValue | 20 | Product Cost + Insurance + Freight + Vat Val Adjustment | VATAmount | 20 | The This is not 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.
...
vat however it is used in the calculation which is as follows : InbondValue +
| ||
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 % |