You will now need to assign the
named cell titles to your input data cells on your VAT summary
sheet, for each of the required data values.
To assign the named cell
titles to your input data cells, click on the cell
that you want to name, select the Formulas tab
and choose the Define Name option. This will open the new name
dialog box. Click
into the Name box
and enter the Named cell
title that you want to assign to the cell, then click
OK. Repeat this process for
each of your input cells as follows:
CELL DATA
VALUE |
NAMED CELL TITLE TO BE ASSIGNED |
VAT entity name |
MTDVATEntityName |
Period from date |
MTDVATPeriodFrom |
Period to date |
MTDVATPeriodTo |
VAT registration number |
MTDVATRegNumber |
Box 1 value |
MTDVATBox1 |
Box 2 value |
MTDVATBox2 |
Box 3 value |
MTDVATBox3 |
Box 4 value |
MTDVATBox4 |
Box 5 value |
MTDVATBox5 |
Box 6 value |
MTDVATBox6 |
Box 7 value |
MTDVATBox7 |
Box 8 value |
MTDVATBox8 |
Box
9 value |
MTDVATBox9 |
Once you have mapped all
of your named cell titles to their corresponding cell values,
Save your calculation workbook. |
