Exporting a United Kingdom VAT Return to Excel

Note:

This topic is for NetSuite accounts that use the Tax Reports (International) page to generate the United Kingdom VAT100 Return. If you are using the Country Tax Report page, see Making Tax Digital.

The Making Tax Digital for VAT feature also allows you to export the United Kingdom VAT100 Return to an Excel file (.xls).

Companies with business records outside of NetSuite can use this feature to export VAT records from NetSuite and consolidate the VAT100 Return in another spreadsheet. For more information on submitting a consolidated VAT Return, see Submitting an MTD VAT Return in a CSV File.

Note:

Make sure to use an MTD API-enabled software in consolidating your VAT100 Return before submitting to HMRC.

To export a United Kingdom VAT100 Return to Excel:

1. Go to Reports > VAT/GST > Tax Reports (International).

2. If you are using a OneWorld account, select the United Kingdom VAT-registered subsidiary.

3. In the Country Form field, select United Kingdom.

4. Choose the tax period and click Refresh to generate the report.

5. Click Export to XLS to download the report in an Excel file.

Related Topics:

• Sending of MTD Anti-Fraud Headers
• Making Tax Digital for VAT Overview and Setup
• Submitting MTD VAT Returns to HMRC
• Submitting an MTD VAT Return in a CSV File
• Viewing Previously Submitted MTD VAT Returns
• Handling MTD VAT Return Submission Errors
• Viewing the MTD VAT Return Submission History

General Notices