Preparing your named cell data

 

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.

 

 

 

 

BACK TO SECTION CONTENTS