cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
nayoung
Level 3

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?

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.

How can I changre the setting son the VAT 100 Report?
5 REPLIES 5
EmmaM
QuickBooks Team

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

nayoung
Level 3

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?

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!

JamesC
QuickBooks Team

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,

 

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.

 

 

nayoung
Level 3

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?

Hi James,

 

That works.  Thanks so much for your assistance.

MirriamM
Moderator

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?

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!

Need to get in touch?

Contact us