Populating the template

 

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:

  1. 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.

  2. 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.

 

  1. 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.

  1. 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.

 

 

 

 

BACK TO SECTION CONTENTS