UK Submit VAT Return via CSV

To use UK Submit VAT Return via CSV feature, read the following topics:

• UK Submit VAT Return via CSV Overview

• Prerequisites for using UK Submit VAT Return via CSV feature

• UK Submit VAT Return via CSV Custom Role

• Creating UK VAT Return via CSV Report

UK Submit VAT Return via CSV Overview

UK Submit VAT Return via CSV is a feature that enables you to import a custom VAT100 Return report in CSV file format to NetSuite and subsequently submit the report to Her Majesty’s Revenue and Customs (HMRC) using Making Tax Digital (MTD) connection.

The purpose of the UK Submit VAT Return via CSV feature is a possibility to import VAT100 Return report to NetSuite for customers that are not able to use the standard VAT100 return due to certain scenarios not currently supported by NetSuite, such as:

• the subsidiary’s base currency is not GBP

• specific adjustments due to non-deductible expenses of VAT regimes or VAT calculated based on the margin

• sales via alternative nexuses (distance selling) that need to be added to the VAT return offline

• group reporting and reports with high volumes

Prerequisites for using UK Submit VAT Return via CSV feature

Note:

This feature is for NetSuite OneWorld accounts that use Tax Reporting Framework SuiteApp.

Before using the UK Submit VAT Return via CSV feature, your account administrator must enable several features and preferences in your NetSuite account.

• NetSuite OneWorld account – UK Submit VAT Return via CSV feature is supported on NetSuite OneWorld accounts only. If you use NetSuite OneWorld, you can associate an account with one or more subsidiaries.

• Tax Reporting Framework – A required SuiteApp. To use UK Submit VAT Return via CSV feature, you must first install the Tax Reporting Framework SuiteApp. This SuiteApp provides the permissions, setup options, and tax reporting features to country tax reports. To install, see Installing Tax Reporting Framework

• United Kingdom Localization SuiteApp – A required SuiteApp. To use UK Submit VAT Return via CSV feature, you must first install the United Kingdom Localization SuiteApp. This SuiteApp delivers templates so that United Kingdom tax reports can be generated and submitted digitally to Her Majesty’s Revenue and Customs (HMRC). To install, see Installing the United Kingdom Localization SuiteApp

For more information about installing SuiteApps, see Installing a Bundle.

UK Submit VAT Return via CSV Custom Role

UK Submit VAT Return via CSV feature has a form of a Suitelet and is executed by a custom created internal role – UK Submit VAT Return via CSV (internal). This role is given minimal necessary permissions and its purpose is to operate the UK Submit VAT Return via CSV Suitelet page. The role operates the feature automatically, no setting up is required. To see the details of the role, go to Setup > User/Roles > Manage Roles

Note:

UK Submit VAT Return via CSV (internal) role is not to be modified, deleted or inactivated as it was created for purposes of this feature only.

The UK Submit VAT Return via CSV feature is automatically available for all roles in your NetSuite account. If you wish to limit access to the feature for certain roles, follow instructions below:

Limiting access for UK Submit VAT Return via CSV:

1. Go to Customizations > Scripting > Script Deployments

2. Find UK Submit VAT Return via CSV deployment record and click Edit.

3. In the Audience tab, select the roles you want to give access to by clicking on the roles’ names while holding CTRL key.

Creating UK VAT Return via CSV Report

With the UK Submit VAT Return via CSV feature, you can upload a custom VAT100 report from CSV file to NetSuite and submit United Kingdom VAT100 Return directly to HMRC’s Making Tax Digital (MTD) system. To learn your VAT Return deadline, check the HMRC VAT Returns

Generating UK Submit VAT Return via CSV:

1. Go to Reports > Tax > UK Submit VAT Return via CSV.

2. Select Subsidiary from the drop-down list.

   Note:

   The drop-down list contains only the subsidiaries that you have permission to view. Note that only subsidiaries having the United Kingdom as their nexus country are available and their tax registration numbers must be populated. To populate the tax registration numbers, go to Setup > Company > Subsidiaries > Tax Registrations

3. Select Nexus from the drop-down list.

   Note:

   The drop-down list only contains the nexuses available for the currently selected subsidiary. By default, the nexus field shows the first nexus available for selected subsidiary.

4. Click on Download Template to download the excel file.

5. Open the template and populate the Final VAT Return tab with your VAT Return data. Inserted data is being validated against a set of criteria:

   • User Preferences – Number format, date format and CSV delimiter must match the format set in your User Preferences

   • Values – Populate the fields VRN, Start Date and End Date; populate the boxes 1, 2, 4, 6, 7, 8 and 9 with the custom created formula based on calculation from imported sheets, if the amounts in the boxes have no values, enter zero.

   • File Size – The file size can not exceed 1 MB.

   • Tax Registration Number – VAT Registration Number (VRN) must match selected subsidiary’s Tax Registration Number for selected nexus.

   For more information, click on the Instructions tab.

   Note:

   When inserting your data, you must retain digital links to provide better traceability for audit purposes as per the requirement of HMRC. For more information about digital links, see 4.2.1.Digital Links

6. When completed, save the Final VAT Return tab in CSV format in your computer.

7. Click on Choose File button to upload the file to the Suitelet.

8. Click on the Generate button to start validation.

9. If the uploaded file is invalid, the system displays an error message. Follow the guidelines in the error message and then try again.

10. If the validation is successful, the system will display confirmation message and you will be automatically redirected to Country Tax Reports page. Your report is listed on top of the processed reports list.

    For unsuccessful validation, you will see an error banner with more error details.

11. On the Country Tax Reports page, you can review your imported report under name UK VAT Return via CSV and submit it to HMRC using Making Tax Digital (MTD) connection.

12. You can export the report in either PDF or Excel formats using the Export buttons.

Related Topics

• Periodic VAT return – VAT100
• Making Tax Digital
• Making Tax Digital: Submission Errors in Tax Reporting Framework
• Electronic Tax Filing in Tax Reporting Framework
• Customizing Localized Tax Returns
• Setting Up Country Tax Reporting Preferences
• Generating Localized Country Tax Reports
• Viewing a Generated Country Tax Report
• Making Adjustments on a Country Tax Report
• Exporting a Country Tax Report
• Country Tax Reports in Tax Reporting Framework
• Tax Reporting Framework Error Codes
• Known Limitations of Tax Reporting Framework
• Installing Tax Reporting Framework
• Roles and Permissions in Tax Reporting Framework
• Making Tax Digital: Fraud Prevention Headers for Tax Reporting Framework

General Notices