I'm using a bridging software VAT filer to submit quarterly VAT return to HMRC.
The present VAT 100 Report does not have required details of Company name, VAT Number, VAT Period Start
and End Dates.
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
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!
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.
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!