1. Country-Specific Features
  2. United Kingdom Help Topics
  3. United Kingdom-specific SuiteApps
  4. United Kingdom Localization
  5. United Kingdom Tax Reporting Framework
  6. UK Submit VAT Return via CSV
  7. Creating UK VAT Return via CSV Report

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'll be automatically redirected to Country Tax Reports page. Your report is listed on top of the processed reports list.

    For unsuccessful validation, you'll 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.

General Notices