You
now need to digitally map your VAT Return figures from your VAT
calculation data into the 9
boxes on your AlphaBridge template as follows:
To begin, open your VAT calculation
spreadsheet.
If
you have copied the AlphaBridge template into your VAT
calculation workbook, you will be able to move between
tabs when mapping the 9 boxes.
If
you have not copied the template into your workbook, you
will need to move between your two files and you may find
it easier to set up your Excel view so that you can see
both files, side by side.
Click into your
AlphaBridge template.
Note: Depending on your Excel
settings, you may need to click on the Enable
Editing button and the Enable
content button, in order to be able to populate the template
with your data.
Map the figures
required for the 9 boxes
as follows:
Box 1: |
In
the AlphaBridge template, click in Box
1 and type the =
sign. Then click into your VAT calculation
spreadsheet, click on the value
required to populate Box 1 and press the Enter
key. |
Box 2: |
Click
in Box 2 and
type the = sign.
Then click into your VAT calculation spreadsheet,
click on the value
required to populate Box 2 and press the Enter
key. |
Box 3: |
Will
be automatically
calculated based on the values entered in Boxes
1 and 2. |
Box
4: |
Click
in Box 4 and
type the = sign.
Then click into your VAT calculation spreadsheet,
click on the value
required to populate Box 4 and press the Enter
key. |
Box
5: |
Will
be automatically
calculated based on the value entered in Box
4. |
Box
6: |
Click
in Box 6 and
type the = sign.
Then click into your VAT calculation spreadsheet,
click on the value
required to populate Box 6 and press the Enter
key. |
Box
7: |
Click
in Box 7 and
type the = sign.
Then click into your VAT calculation spreadsheet,
click on the value
required to populate Box 7 and press the Enter
key. |
Box
8: |
Click
in Box 8 and
type the = sign.
Then click into your VAT calculation spreadsheet,
click on the value
required to populate Box 8 and press the Enter
key. |
Box 9: |
Click
in Box 9 and
type the = sign.
Then click into your VAT calculation spreadsheet,
click on the value
required to populate Box 9 and press the Enter
key. |
Review your data
to ensure that it is correct and then save
a copy of the template for future reference.
Important note: If you
have copied the AlphaBridge template into another workbook, you
must ensure that the workbook is saved as a macro-enabled file
type, such as Excel Macro-Enabled
Workbook.
|