In QB 2016 Pro desktop, can Company name, VAT Number, VAT Period Start and End Dates be displayed in the VAT 100 Summary Report and thus all be exported to Excel?

Hello Nayoung

Thanks for contacting the Community

Currently the only things that can be displayed that you mentioned is the VAT period on the VAT 100 report for the 2016 pro Desktop product

Thanks

Emma

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!

Hello Nayoung,

Are you looking to submit this as an excel sheet through a bridging tool for MTD?

You may be able to get all of the data in the current period, using a VAT DETAIL report, and exporting this to excel, and adding in the required columns for this information.

Effectively, Company name, VAT number, VAT Period start and end dates can be added easily, as they are not going to change(?); whereas the data that generates the box figures will be available in a detail report.

Hi James,

That works.  Thanks so much for your assistance.

It's good to hear from you again, nayoung,

I am happy to know that your concern is now resolved. If there's anything else you need help with concerning your QuickBooks Desktop account, please feel free to visit us again.

For future reference, you can check out our Community Help article: https://quickbooks.intuit.com/community/Help-articles/ct-p/help-articles-uk?label=QuickBooks%20Deskt....

Take care always and I'm wishing you continued success! Have a great day!