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

Filing VAT - the VAT 100 report has included last quarters figures as well, including the payment made. How can I adjust these figures to exclude last quarters filed figures

Customer is cash accounting.  Filing has not been a problem before but this quarter the VAT 100 report has included last quarters figures, if I subtract these (including the payment made) I get the correct figure for this quarter.  How do I adjust these figures to file MTD VAT?

Solved
Best answer January 07, 2020

Accepted Solutions
Dags
Level 1

Filing VAT - the VAT 100 report has included last quarters figures as well, including the payment made. How can I adjust these figures to exclude last quarters filed figures

Thank you so much, I followed your instructions and it has worked a treat, my current VAT 100 is correct and I am now in a position to file it with HMRC.

Again, my heartfelt thanks!

Dags

View solution in original post

2 REPLIES 2
Ashleigh1
QuickBooks Team

Filing VAT - the VAT 100 report has included last quarters figures as well, including the payment made. How can I adjust these figures to exclude last quarters filed figures

Hi Dags, 

 

Thanks for reaching out to us on the Community page,

 

Can you go into the supplier center, check if the journal from the last return is under the hmrc supplier. If it is delete and  re run  the period and do a paper filing in QuickBooks Desktop. If it is not there check the prior return to see if the vat 100 report and detailed report are on their from the last quarter, to find this click ob vat tool bar at the top and go down to prior returns.  If it is there the filed return, you need to a filing for the same period but extend it to the first of the month. for example if it is (1st Jan to 31st then file it on the 1st Feb.) However if you have transactions that are on the 1st you will have to move the date to the 2nd as it will file any transactions you had on the first. 

 

Let us know how you get on. 

Dags
Level 1

Filing VAT - the VAT 100 report has included last quarters figures as well, including the payment made. How can I adjust these figures to exclude last quarters filed figures

Thank you so much, I followed your instructions and it has worked a treat, my current VAT 100 is correct and I am now in a position to file it with HMRC.

Again, my heartfelt thanks!

Dags

Need to get in touch?

Contact us