Excel Bridging Tool: 1 User

Code: XLVATi-PT-001

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

Businesses and Agents alike can authorise up to a maximum of just one government gateway ID using this workbook.

The government gateway ID that successfully authorises access to a MTD account 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.


  1. Enter your MTD for VAT details. These include:
    • your government gategway ID (maximum of 1)
    • 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.

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.


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


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

£0.00 £10.00
Earn 0 reward points