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 to resolve this issue and ensure the digital link column is updated correctly.''
1. Ensure that the MTD VAT template is saved on your device's local storage (not on a network drive). Storing the template on your local drive helps avoid issues with file access and permissions.
2. To resolve the issue, you need to add the file location as a trusted location in Excel. This allows the application to correctly validate the links in the template.
3. Open the VAT template file in Excel.
4. Click on "File" option located at the top left corner of Excel.
5. From the menu, choose "Options" at the bottom left.
6. In the Excel Options window, click on "Trust Center" in the left-hand menu. Next, click on "Trust Center Settings".
7. Then select "Trusted Locations".
8. In the Trusted Locations section, click on "Add new location".
9. Copy the file path where your VAT template is stored (e.g., C:\Users\YourName\Documents\MTD VAT Template.xlsx) and paste it into the location box.
10. Click OK to add the location as trusted.
11. While in the Trust Center settings, ensure that macros are enabled for the template to function correctly. You can do this by clicking on Macro Settings and selecting Enable all macros (ensure you trust the source of the file before enabling macros).
12. Once you’ve added the location as trusted and enabled macros, close the VAT template and then reopen it.
13. After reopening the file, check the "Digital Link" column again. It should now show True, indicating that the link has been successfully validated.
14. If the Digital Link column still shows False after following these steps, please contact our support team for further assistance.
Once the issue is resolved and the digital link shows True, you can proceed with completing and submitting the VAT return. If you encounter any other challenges or need further assistance, don’t hesitate to reach out to our support team at mtd@datatracks.co.uk.
Related Articles
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 ...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 ...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 ...Create Entity
An entity refers to an organisation or company that is registered for VAT. Creating an entity is a crucial step in setting up the MTD VAT Return application to manage VAT filings effectively. Both administrators and users with the appropriate ...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 ...