cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 3

Quickbooks Pro 2016 Desktop - VAT 100 and VAT Detail Reports

Could anyone (please) possibly explain why the VAT 100 Report puts the "Balance" [see attachment - e.g. 1,663.87 of the VAT Detail Report],  into the Box 4 - VAT reclaimed on purchases, whereas I belive it should really be the "Paid Amount" [see attachment - e.g. 793.70 of the VAT Detail Report].

 

This happens each quarterly report where the 'VAT Detail Report' shows in the "Paid Amount Column" what I belive to be the actual YET the VAT 100 Report shows the "Balance Column" which I think is being accumulated throught the year.

 

Thanks for any help to resolve.

Solved
Best answer June 18, 2020

Accepted Solutions
Highlighted
Level 3

Quickbooks Pro 2016 Desktop - VAT 100 and VAT Detail Reports

Hello,

 

Thank you all for your assistance - such disparity between versions of QB Desktop.  Nonetheless, I've found work-around solution through Excel prior submitting to HMRC.

 

You can close out this ticket now ¦<)

 

Best regards,

Nigel

View solution in original post

8 REPLIES 8
Highlighted
QuickBooks Team

Quickbooks Pro 2016 Desktop - VAT 100 and VAT Detail Reports

Thanks for the screenshots, @nayoung.


Let me share some information about VAT reclaimed on purchases. The amount shown in this field are reclaimable amounts and should be reclaimed by including the figure in your VAT return. Thus, disclosing the value within box 4.

 

For more details about this, you can refer to the HMRC website.

 

Additionally, you can also check this article that can guide you in generating a report to show the data you need and save its current settings. This way, you won't have to customise the report again to show the information you need.

Let me know if there's anything else you need help with your QuickBooks Desktop (QBDT) software. I'll be around to help you anytime. Take care and stay healthy.

Highlighted
Level 3

Quickbooks Pro 2016 Desktop - VAT 100 and VAT Detail Reports

Hello JasroV,


Thank you for your quick response.

 

I've looked carefully to both:

The HMRC website. concerns the VAT System and MTD.  It does not relate to my question.

 

Could you please explain why the VAT 100 Report puts the "Balance" [see attachment - e.g. 1,663.87 of the VAT Detail Report], into the Box 4 - VAT reclaimed on purchases, whereas I belive it should really be the "Paid Amount" [see attachment - e.g. 793.70 of the VAT Detail Report].

 

 

 

Highlighted
QuickBooks Team

Quickbooks Pro 2016 Desktop - VAT 100 and VAT Detail Reports

Hello Nayoung, 

 

Having looked into this with our desktop team, what they are saying is it is showing 1663.7 instead of 793 because there is an open balance amount of 870 from the previous period that has not been cleared by the look of it.

 

We would recommend that you speak to the desktop help team on the phone the number is 0808 168 9535 to go through that though and we also recommend that you also take a backup before you do anything.

 

Can you confirm that the 870 figure is from the last qtr and should have been zeroed off then this is a visual error and can be resolved by deleting the VAT journal. re-filing the previous qtr as an internal filing if it was sent to HMRC and then it should zero off.

 

Highlighted
Level 3

Quickbooks Pro 2016 Desktop - VAT 100 and VAT Detail Reports

Hello,

 

I just phoned 0808 168 9535 who said they can't help me because:

1) I don't have a customer number for my product QB Pro 2016 Desktop, as I didn't buy it directly from quickbooks but from a retailer.

2) QB Pro 2016 Desktop is no longer supported by Quickbooks.

 

Yes, I confirm that the 870 figure is from the last qtr (and should have been zeroed off then this is a visual error and can be resolved by deleting the VAT journal. re-filing the previous qtr as an internal filing if it was sent to HMRC and then it should zero off).  PLEASE HOW DO I ACCESS THE VAT JOURNAL

Highlighted
QuickBooks Team

Quickbooks Pro 2016 Desktop - VAT 100 and VAT Detail Reports

Hello Nayoung, 

 

To find the Journal you will need to go to the "Supplier" tab and search for HMRC VAT supplier.

 

As you can see here there will be some journals with the name VATUK0001, 0002 etc

 

image.png

 

 

These are the filings. If you delete the most recent one it will effectively unfile it on your desktop. You will need to restart your Quickbooks before you mark it as filed but if it already been submitted to HMRC you will have to select the option to "FILE VAT" instead of the "FILE VAT MTD" option as when you file this way it will give them the option to mark it as filed internally. Looking into this more you should have no problem as 2016 isn't MTD compatible so it will just be for your records as it won't send to HMRC anyways. 

 

If you have any further queries please reach back out to us we will be happy to assist you. 

Highlighted
Level 3

Quickbooks Pro 2016 Desktop - VAT 100 and VAT Detail Reports

In the VAT 100 Report, for both the Boxes 6 (Total net value of sales) and Box 7 (Total net value of purchases) I have "Carry over balances" from previous quarters.  How can I remove the 'carry over amounts' please.

If my 1st Quarterlythe "actual" Sales = £5,000 and Purchases = £2,000,

The VAT 100 Report states in Box 6 = 5,000 and Box 7 = 2,000.

 

If my 2nd Quarter "actual" Sales = £12,000 and Purchaes = £5,400.

The VAT 100 Report states in Box 6 = 17,000 and Box 7 = 7,400, INSTEAD OF Box 6 = 12,000 and Box 7 = 5,400.

Highlighted
QuickBooks Team

Quickbooks Pro 2016 Desktop - VAT 100 and VAT Detail Reports

Hello Nayoung, 

 

If you did the delete the journal, closed Quickbooks down, and then re-opened it and re-ran it should have gotten rid of them amounts from showing on this return.  

 

You could take a back up of this and download the free 30-day trial of 2020 and then upgrade the backup file and then you'll be able to phone desktop support. (You may need to purchase support package) and then they should be able to look and see what the issue is. once this is done you could then do the same thing on your own file. The problem is with it being so old the account you have, it could be caused by problems that were fixed in updates to newer versions.

Highlighted
Level 3

Quickbooks Pro 2016 Desktop - VAT 100 and VAT Detail Reports

Hello,

 

Thank you all for your assistance - such disparity between versions of QB Desktop.  Nonetheless, I've found work-around solution through Excel prior submitting to HMRC.

 

You can close out this ticket now ¦<)

 

Best regards,

Nigel

View solution in original post