

There should be no other data in the file.

Or ten entries (when the VAT number is present as the first entry). So we expect either nine entries in the file (no VAT number), In this layout, the VAT number may be present as the first entry. Or, to keep it really simple, you could have just the data, and nothing else. With optional lines of text above and below the data. Your spreadsheet tab can have three columns of data as shown below, We accept various data layouts as shown below. We compute these and override your values as HMRC have strict rules for them. In any case, you MUST check BOX3 and BOX5 after upload. (negative entries are permitted on a VAT return but are not normally required). This box is used to claim back tax and is normally declared as a positive number, WARNING: Beware with negative entries in your file, particularly BOX4. We recommend you have a separate tab which contains the VAT return data. Professional accounting software packages should also allow you to export data to CSV. You will be able to export the data to a plain text file or CSV format. If you manage your VAT data using spreadsheet software (for example, Microsoft Excel, Apple Mac Numbers, LibreOffice or OpenOffice), Your file should be a plain text file or in CSV format.ĬSV stands for Comma Separated Variables, and is essentially a plain text file in which data is separated by commas.
