Excel Bridging Tool: Open

Code: XLVATi-PT-100

This workbook uses HMRC's production APIs to access a user's MTD for VAT account.

Businesses and Agents alike can authorise any number of government gateway IDs using this workbook. There is no maximum limit.

All government gateway IDs that successfully authorise access to MTD accounts will be stored for subsequent use within the workbook.

Any number of Company / Client names and VRNs can be entered and stored within this workbook to promote continuity and simplification.

Functionality:

  1. Enter your MTD for VAT details. These include:
    • your government gategway ID 
    • your associated password
    • your Company Name
    • your VRN
  2. Grant authority for the workbook to access your MTD for VAT account (once every 18 months)
  3. View your obligations, liabilities and payments
  4. Select a VAT period to submit or retrieve from your obligations
  5. Use Excel formula to link your VAT Return to your underlying transactions and / or workings
  6. Submit your VAT Return
  7. Retrieve your fulfilled VAT Return
  8. Create a PDF copy of your submitted VAT Return
  9. View the events log

Set Up:

After downloading the bridging tool, you will need to grant authority for the workbook to access your MTD for VAT account. You will need your government gateway ID and associated password to hand in order to complete this authority. Here's a quick video on what 'granting authority' looks like. This video shows how to use the default browser - Internet Explorer.

The Internet Explorer option automatically brings the authorisation code back into the tool for the user. I've updated this version so users can also grant authority using other browsers like Microsoft Edge, Mozilla Firefox and Google Chrome. However, these browsers cannot be automated to the same extent - so I have configured the tool to allow the user to copy the authorisation code from HMRC displayed in these browsers back into the tool to complete the set up.

Tip: It's a good idea to make sure you have completed your MTD registration before you use the bridging tool. If your MTD registration is incomplete, HMRC will allow you to grant authority to the bridging tool but will not allow you to access your MTD VAT account. This means that even though you will have granted authority, you will not be able to do things like view your Obligations or submit your VAT returns.

Switching Bridging Tool:

If you need to switch your bridging tool, all you need to do is grant authority to your new bridging tool as described above.

Download:

Upon purchase you will be sent a confirmation email. Included within this email will be your personal download URL. You will be able to download your bridging tool from this URL.

Support:

If you have any questions, either pre or post purchase, please do ask.


£0.00 £10.00
Earn 0 reward points