Preparing your files for upload and fixing errors

AlphaVAT File Upload

Before you begin uploading your files, you need to ensure that they have been formatted in the correct way, so that AlphaVAT can use the data to perform your VAT calculations.

Data requirements

Data must be saved in a standard comma-separated values (.csv) file format.  A .csv file stores tabular data in plain text.

 

The first row of the file must contain the column headings used within the file.  This is required for the data mapping process.

 

All subsequent cells must be data records and not further headings, sub-totals or totals. Each record must be on a separate row.

 

All data, including white space, is considered part of the value, and could cause warnings and/or errors within the calculation.

 

Note: Blank columns and rows will be removed if followed by subsequent data.

 

For more information see the following AlphaVAT help pages:

 

 

AlphaBridge File Upload

To use this feature too upload your Excel file, you will need to prepare your VAT Return summary data, ensure that it contains all the required information and assign the correct named cell titles.

Data required in your VAT summary sheet

  1. Open up your calculation workbook and click into your current VAT Return summary. 

  2. Your VAT Return summary must contain the following information:

 

 

  • VAT entity name

  • Period from date

  • Period to date

  • VAT registration number

  • Box 1 amount

  • Box 2 amount

  • Box 3 amount

  • Box 4 amount

  • Box 5 amount

  • Box 6 amount

  • Box 7 amount

  • Box 8 amount

  • Box 9 amount

 

 

 

You should also check that the cells containing the values for boxes 1 to 5 have been formatted as a number with two decimal places.  For more information see the following AlphaBridge help pages: