MTD VAT template

When working on a VAT return, you’ll need to complete a VAT template with specific details and formulas. This guide will walk you through the process of entering data, linking cells to the VAT summary, and uploading the completed template back into the application. Follow the steps below to ensure that your VAT return is correctly prepared and ready for submission.

      1. Begin by entering the VAT Registration Number (VRN) for the entity. This is a mandatory field for the VAT return.

      2. Next, enter the VAT period in the format YYYY-MM-DD. Ensure the period corresponds to the correct time frame for the return you are filing.

      3. Link the appropriate cells with the formula from the computed VAT summary Excel file. This will automatically populate the relevant figures for the return based on the values entered in previous boxes.

      4. Box 3 and Box 5 are automatically calculated based on the values populated in the previous boxes. These fields will update dynamically once the linked data is entered correctly.

      5. Make sure that the values in Boxes 6, 7, 8, and 9 are entered without decimal points or pence. Only whole numbers should be used in these fields.

      6. Check the Digital Link Column : This column that indicates whether the cells are digitally linked should be checked to ensure that the data has been correctly connected to the appropriate fields.

This column will not function properly if the sheet is moved to a different workbook. Ensure the sheet remains in the original workbook for the digital links to work correctly.

      7. You can move the VAT return sheet into their current Excel workbook for convenience. Once the sheet is correctly placed, you can upload the file, and the 9-box return information will automatically update in the application.

      8. The sheet name should always be ‘VAT Return’ to maintain compatibility with the application. Additionally, make sure the layout follows the exact pattern of the VAT template downloaded from the application for seamless integration when uploading your own VAT template.

If you need assistance with any part of the process, or if you encounter any issues, please feel free to contact our support team at mtd@datatracks.co.uk.

• Related Articles

• Login into MTD

  Accessing the MTD VAT return application is a straightforward process. To log into the MTD application, follow the provided steps below. Navigate to the MTD application login page using the following URL: https://mtdvat.datatracks.co.uk/ On the login ...

• Actions on Return

  Once you have created a VAT return, you can begin working on it by uploading, validating, and submitting the VAT template. The process involves several key steps to ensure that the VAT return is accurate and ready for submission to HMRC. Follow the ...

• False indication in VAT template

  If you've filled in the VAT template correctly and linked the necessary data, but the "Check the Digital Link" column still shows a False indication instead of True. This can occur due to the file's location or macro settings. Follow the steps below ...

• Create Return

  Once you have successfully authorized the MTD VAT Return application with HMRC, you can begin creating and submitting VAT returns for the selected entity or entities. The process is straightforward and allows you to easily check reporting obligations ...

• Authorize with HMRC

  In order for the MTD VAT Return application to interact with HMRC on your behalf, you must grant the necessary authorization. This allows the application to submit VAT returns digitally. The authorization process is simple and only needs to be ...

• Popular Articles

• Sign in to the Rainbow application

  You can log in to the Rainbow application with the credentials (registered email address and password) shared by us. To access the login page, use the following URL: rainbow.datatracks.com Enter your registered email address and password. Click on ...

• Create entity

  An "Entity" is a term used to describe a company that's required to create and submit periodic reports to regulatory authorities in iXBRL format. It's important to note that a single firm can have multiple entities under its umbrella. To uniquely ...

• Create user

  A "User" refers to a specifically identified individual who plays a role in preparing, reviewing, and filing documents. Follow the provided steps below to create a user. Admin >> User >> Add >> Submit Hover the mouse over the “Admin” menu at the top ...

• Edit user

  In case you would like to modify the user details, you can change them by following the provided steps below. Admin >> User >> Edit >> Submit. 1. Hover the mouse over the “Admin” menu at the top right of your screen then select "User" to access and ...

• Create user role

  A "user role" is a defined set of permissions and privileges assigned to a user within the application. These roles are created to determine what actions a user can perform, what information they can access, and what functions they can execute within ...

• Recent Articles

• Audit Trail

  The Audit Trail feature allows administrators to track and monitor activities performed by users within the application. This section is can access only by the Admin. Click on the "Audit Trail" section in the application to access the activity log. ...

• Edit user

  In the MTD VAT application, you can easily update a user’s details, including their name, role, and permissions. You also have the option to assign an entity or revoke authorisation if needed. Follow the steps below to edit user details effectively. ...

• License Renewal

  If your MTD VAT application licence has expired, there is no need to worry. Renewing your licence is a straightforward process that ensures uninterrupted access to your services. Follow the steps below. Steps to Upgrade or Renew Your Licence 1. ...

• Status Forbidden

  While creating an MTD VAT return, you may encounter a "Forbidden" status. This typically occurs due to incorrect login credentials or authorisation issues with HMRC. To resolve this, ensure that you are using the correct credentials assigned to the ...

• Status is Unauthorized

  While creating an MTD VAT return, you may receive a "Unauthorised" status. This typically occurs when HMRC’s authorisation (OAuth token) has expired, preventing the application from successfully interacting with HMRC. To resolve this issue, you need ...