Exporting VAT Return data
Before submitting your VAT return we suggest you export the date to .csv file (which can be opened by excel) to check that you are happy it is correct.
The option to export VAT return data can be found in the menu bar along the top of the Edit VAT Return window:
The .csv file includes the following data:
- Our Ref
- Type (whether purchase or sale)
- Sub Type
- Comments – Customer name – followed by Order or purchase comments
- Reconcile (False or True)
- VAT Box No
The following VAT boxes appear on your VAT return:
- Box 1- VAT due on sales and other outputs
- Box 2 -VAT due on EC acquisitions
- Box 3 - Total VAT Due (the sum of boxes 1+2 generated by system)
- Box 4 – VAT reclaimed on purchases and other inputs
- Box 5 – NET VAT to be paid to HMRC, or be reclaimed by you (difference between boxes 3 & 4 system generated)
- Box 6 – Total value of Sales ex VAT
- Box 7 – Total value of purchases ex VAT
- Box 8 – Total value of supplies to other to other EC states ex VAT
- Box 9 – Total value of acquisitions from other EC sates ex VAT
The data exported in the .csv file is displayed via which VAT box it appears in – so an order might show two or more times on the .csv file as shown below:
In the scenario above you can see that order no 109494-1 on the first line shows £16.67 in the VAT column and VAT Box 1.
This means that the VAT element which is £16.67 is being recorded in VAT box 1 - VAT due on sales and other outputs.
In the scenario above you can see that order no 109494-1 on the second line shows £83.33 in the NET column and VAT Box 6.
This means that the NET price which is £83.33 is being recorded in VAT box 6 - Total value of Sales ex VAT.