eSubmitter Add-In

The basic workflow is as follows:

1. Click “Insert MTDfB VAT eForm” button from the ribbon tab to add a copy of “VAT eForm” worksheet into your VAT workings' spreadsheet. You can have more than one “VAT eForm” worksheet in your workbook. This is particularly useful if you use the same workbook during the year. Simply give a meaningful name to each “VAT eForm” worksheet.

2. Enter basic information in the eForm: your VAT registration number, HMRC Login ID and the period of your VAT return. Then link (i.e. using a formula) your 7 VAT boxes (box 1, 2, 4, 6, 7, 8 and 9) from your workings into the eForm placeholders. You should not type in any actual values into the 9 boxes as the “link” is an HMRC’s requirement. If you are using the same spreadsheet for all your VAT returns, then Step 1 & 2 won’t have to be repeated for each VAT submission. This is generally the case when you "Copy+Paste" last quarter workbook to create the new quarter VAT return workbook.

3. When ready to submit your VAT return, click “Submit VAT Return” button located in the ribbon tab. When completed, the Submission receipt acknowledgement box will be populated with HMRC response for your recordkeeping. An example is shown below.

Download and evaluate our Excel bridge solution

“MTDfB VAT eSubmitter” has been recognised by HMRC and it is listed on their website. You can run “MTDfB VAT eSubmitter” in test mode. The program lets you create a test user on HMRC's sandbox server which will allow you to submit one of your VAT returns in the HMRC testing environment. Simply click “Switch to Test Mode” button located in the ribbon tab to create this test user and follow the normal steps to submit a VAT return. When signing into HMRC please enter the test user's credential instead of your own.

Click here to download the latest version of MTDfB VAT eSubmitter.

Requirement: a working internet connection, Windows 7 or above, Excel 2013 or later and Macros must be enabled.

Version 1.23 update include:

• Resolve issues with a recent Windows Edge update. In some cases HMRC response to grant access was not transferred successfully to MTDfB VAT eSubmitter by Edge.

Installation

1. Download “MTDfB VAT eSubmitter” Add-In.

2. Go to Excel Add-ins manager located in Excel Options.

3. Browse and select “MTDfB VAT eSubmitter” Add-In.