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.

• Customise reports in QuickBooks Desktop
• Create, access and modify memorised reports

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.

Hello JasroV,

Thank you for your quick response.

I've looked carefully to both:

• Customise reports in QuickBooks Desktop
• Create, access and modify memorised reports
  and (unless I missed something), neither mentions anything concerning VAT Reports - which I find peculiar.

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

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.

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

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

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. 

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.

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.

Hi, I have a different issue with these reports in Quickbooks desktop 2016. When I post an individual 0% sale the details are posted correctly in the reports. However when I run the Vat detail report at the end of a period SOME appear on line 10 of the vat detail report Net Purchases figure. Not all invoices go this way, but last period 150 did.

All other detail is correct. Below is an extract of a report showing some of the erroneous transactions. If I post an individual transaction, posting works correctly.

Hello Gavin18, 

Welcome to the Community page, 

So some go into 'line 10' but some don't, could you please try checking the Transaction Journals for each to see why one is correct and one isn't. Top left of the invoice click 'reports' then transaction journal. Could you send us some screenshots of one that is posting correctly and one you believe is posting incorrectly so we can take a look into this for yo more.  

Hi, there is no discernable difference.I have attached two screenshots of two entries that are behaving differently.

I think it might be a bug in quickbooks. More than one data file is affected and when I enter a transaction today there is no issue.. However there is an issue with 20 consecutive transactions from March 1st to march 10th

If I create a duplicate of a problem transaction, it is posted correctly. However when I delete the problem transaction, it is immediately replaced in the report by the next equivalent transaction from my parent list, ie the report listing of erroneous transactions does not get shorter. Wierd! 

I'll help you fix this, @Gavin18.

When you see reports are listing erroneous transactions that post with negative values, it's best to utilize the verify and rebuild feature in QuickBooks Desktop. Also, ensure to create a back up along the process so that you can restore the file in case of data loss.

First, let's verify the data to see common data issues:

1. Choose Window then Close All.
2. Verify Data. Choose File then Utilities. Select Verify Data. If you see:

• • "QuickBooks detected no problems with your data," no further action is needed.
  • A specific error message, there may already be an article for it. Try searching for it in our QuickBooks Desktop support site for specific instructions.
  • "Your data has lost integrity," indicates there is data damage in the file. Continue to the steps below to Rebuild Data to correct the problem.

Once done, let's rebuild the data so that QuickBooks will self-fix. You can reference this article and check the steps in the Rebuild data section: Verify and Rebuild Data in QuickBooks Desktop. You can verify and rebuild as many as until the error/s are self-resolve by QuickBooks.

Then you can test and run the VAT Detail report to review the changes.

I've added a future reference in case you met errors and data losses in QuickBooks Desktop: Fix data damage on your QuickBooks Desktop company file.

Please update me on how it goes with the data troubleshooting steps. I'll make sure to get back to you. Have a safe day ahead.

HI, I have tried verify and rebuild. No progress.

Hello Gavin18, If you could call in so we can do a screen share with you on this number 08081689535 and our care team will have a look at the reports to get this resolved.

Emma,

I rang the number and the people were not helpful. They simply tried to refer me to my original third party vendor. The problem seems to be a quickbooks one as the rebuild did not generate any errors that would make a difference.

Hello Gavin18, Are you not registered as a user of the desktop product? They should certainly be able to do a screen share if you are named on the account? The difficulty we have here is we can not view and test the data on the forum.

Emma, I registerd online anyway, but they say they cannot access details because the vendor was a quickbooks agent. I dont understand this. Quickbooks is the software supplier ultimately. Maybe you can push some of the right buttons? There is anomalies in line 9 of the vat detail report in another company file here also in the vat detail report.

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

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.

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

Thanks for getting back in here, @VALD1.

Aside from the steps provided by my colleague above, you can also find the VAT 100 report by going to Taxes, clicking on the arrow next to Submit Return, and selecting View Summary. 

If the report isn't showing on your end, we can perform some troubleshooting steps to fix this. There are times when the browser is full of frequently accessed page resources, which causes some errors or unusual responses. Let's start accessing your account using a different or private browser. You can use either of these shortcut keys:

• Google Chrome: Ctrl + Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Microsoft Edge: Ctrl + Shift + P
• Safari: Command + Shift + N

Once the option to select the report is available, go back to your regular browser and clear its cache. This is done to speed up the process the next time you do a transaction in QuickBooks Online. Also, an alternative way is to use other compatible browsers.

I've also attached some articles you can refer to for your future guidance and detailed steps in managing your VAT settings and reports:

• VAT exceptions and reports in QuickBooks Online
• Set up and edit VAT settings, codes and rates

Feel free to leave a comment below if you have any other questions about generating the VAT 100 report in QuickBooks. I'm always here to help. Wishing you and your business continued success.