How to Embed CHM MTD Bridge into your own Spreadsheet

If you wish to embed the Excel MTD VAT Bridging Tool into your own spreadsheet, you will need to open both the CHM MTD VAT Bridge and the spreadsheet you wish to embed the filing tool in.

Steps to embed the Bridging Tool:

  1. Open the Bridging Tool.
  2. Right click on the sheet tab (VAT-BRIDGE) and then select 'Move or Copy' from the menu that appears:
    user guide image

  3. Tick 'Create a copy':
    Open the 'To book' dropdown and select your accounts workbook.
    In the 'Before sheet' list, choose where to locate the embeded sheet.
    Click 'OK'.

    Note: If your workbook is not in the 'To book' list, you may need to close your workbook and then from within the Bridging Tool Excel go to File > Open and re-open your workbook.
    user guide image

  4. The bridging tool will now be embedded into your spreadsheet, repeat these steps if you wish to embed more sheets for additional VAT periods.
  5. You will now need to digitally link the Bridging Tool cells using the '=' and 'Enter' method in the User Guide.
  6. If you have embedded one of our macro enabled (.xlsm) sheets, you will need to save your workbook as a macro enabled file (*.xlsm), otherwise Excel will not allow our 'File My ITSA Return' button to function.
Back to User Guide