eSubmitter (workbook)

Workbook version of “MTDfB VAT eSubmitter”

The workbook version of “MTDfB VAT eSubmitter” has been developed as an Excel bridge solution that is compliant with MTDfB for VAT. It has been designed to be simple and straight forward to use. Moreover it can be integrated into your current processes without much disruption.

The basic workflow is as follows:

1. Make a copy of “VAT eForm” worksheet into your VAT workings' spreadsheet. The eForm is included within “MTDfB VAT eSubmitter” workbook which also offers a useful “Copy” function. 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 such as your VAT registration number, company name and the period of your VAT return. Then link (i.e. using a formula) your 9 VAT boxes 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, open “MTDfB VAT eSubmitter” workbook.

4. Go through the 4 steps of our Wizard.

5. A PDF printout of the HMRC receipt acknowledgement will finally be produced for your recordkeeping. This is a simple screenshot of the 4 steps shown above.

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 between Live and Test mode” button 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. By default Excel will prevent macros from running from untrusted workbook. If so you should see a yellow warning bar just below your ribbon. Simply click “Enable Content” button as shown below.

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.