In order to fulfil VAT MTD filing requirements to HMRC I need to generate an Excel Worksheet (which would be my Source File) that contains:

* Company Name

* VAT Number.

* VAT Period Start Date

* VAT Period End Date

PLUS all the data in currently generated VAT 100 Report: Box 1 through to Box 9.

What can I do please? Surely there are some settings in QB 2016 Pro that can be changed to achieve this?

This is turning into a disaster!