Skip to main content
N
nayoung
June 8, 2020
Solved

Quickbooks Pro 2016 Desktop - VAT 100 and VAT Detail Reports

  • June 8, 2020
  • 2 replies
  • 0 views

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.

Best answer by nayoung

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.


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

2 replies

JasroV
JasroV
June 8, 2020

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.

N
nayoungAuthor
June 9, 2020

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].

 

 

 

A
Ashleigh1
June 9, 2020

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.

 

V
VALD1
February 7, 2023

Does this report VAT100 exist in the quickbook online.  Or any report similar to this.  Need it urgently.  Thanks

MaryLandT
MaryLandT
February 7, 2023

Thank you for joining this thread, VALD1.

 

The VAT 100 Report is available in QuickBooks Online. It's called the VAT Agency Report which shows the summary information for each box of the VAT return. You can use this statement when you file returns in QuickBooks Online Plus and complete the submission to HMRC.

 

Here's how to run the report.

 

  1. Go to Business overview and select Reports.
  2. From the Standard tab, go down to the Manage VAT section, then click VAT 100 Report.
  3. Click it to open the report.

 

Another way to run the report is by going to the Taxes menu. Please browse this article to learn about pulling up the statement: VAT 100 Report.

 

To help you keep accurate records of the tax you collect and pay, make sure to set up VAT correctly in QuickBooks. This article will guide you through the process: Get started with VAT.

 

The information I've shared above should route you to the report you're looking for. Stay in touch with me if there are other reports you want to use or check. Just leave a comment below and I'll get back to you.

V
VALD1
February 7, 2023

Thank you.  But I'm not seeing this option.  Maybe I have to upgrade my quickbooks.

Terms & ConditionsAccessibility statement