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

VAT100 report is missing most of output and input transactions. HELP!!

My first VAT reporting period is coming up and I am making sure all the transactions that need to be included are there but to my horror a large percentage of both Output & Input transaction (& their VAT amount, where appropriate) are missing. My VAT Return will therefore be wrong?

 

Need an expert help ASAP.

Solved
Best answer May 04, 2020

Accepted Solutions
Hamid_Khan
Level 3

VAT100 report is missing most of output and input transactions. HELP!!

Thanks for your suggesting to use online help desk. My personal experience with has been quite unremarkable so I decided to spend time looking at where the problem may lie and have resolved it.

Thanks

 

View solution in original post

9 REPLIES 9
GeorgiaC
QuickBooks Team

VAT100 report is missing most of output and input transactions. HELP!!

Hi Hamid, 

 

Thanks for reaching us here! 

 

Can I confirm if you are using the Cash-based or Standard VAT scheme? You can check which you have this set to by going to Taxes > Edit VAT > Edit settings. 


If you have this set to cash then only transactions that are marked as paid within your open return period will be accounted for. 

 

Hamid_Khan
Level 3

VAT100 report is missing most of output and input transactions. HELP!!

Hi,

 

Just checked & it was set as "standard".

Hamid_Khan
Level 3

VAT100 report is missing most of output and input transactions. HELP!!

In a way it looks like it is only counting "cash" and not Card payments, both sales & purchases!!

AlexV
QuickBooks Team

VAT100 report is missing most of output and input transactions. HELP!!

Hello there, Hamid_Khan.

 

Thanks for checking the VAT settings.

 

We also need to make sure that we've selected the correct accounting method when you pull up the VAT 100 Report. Choose Cash to include only the money you’ve paid or received. While the Accrual include open invoices and bills. You'll want to check this article for your reference: Choose between cash and accrual accounting methods in reports.

 

Aside from that, make sure that we have set the correct reporting period. This will filter the data showing in the report.vat 100.PNG

I've included this link as your reference about customising reports in QuickBooks Online.

 

I'll be here if you need more help. Have a great day

Hamid_Khan
Level 3

VAT100 report is missing most of output and input transactions. HELP!!

Good Morning AlexV,

 

Just checked both the settings (Cash/Accrual and Date Range). Both set as you suggested and no change, I'm afraid. It must be the way I have entered the transactions I suppose. 

 

Can you do a screen share with me?

SarahannC
Moderator

VAT100 report is missing most of output and input transactions. HELP!!

How are you, Hamid_Khan?

 

I appreciate you for considering the steps provided by my colleague above. It's a good thing to do a screen sharing to further investigate, and be able to identify what's causing the missing transactions. The Community place is an open forum where everyone can see our conversation from time to time.
 

As much as I wanted to do it with you, we will need to get in touch with one of our specialists. They have enough and appropriate tools to use for investigating this situation. Here are the steps on how to connect with them:

 

  1. Go to the Help menu and click Contact us.
  2. Let them know in the description box that you need in sorting out the missing transactions in the report.
  3. Click Let's talk, then select between Start messaging or Get a callback.
  4. Due to COVID-19, we have limited support and reduced our support hours too.

 

Please let us know how it goes by replying to this thread. I'm right here together with my colleagues to assist you further. I hope you're doing well. Keep safe!

Hamid_Khan
Level 3

VAT100 report is missing most of output and input transactions. HELP!!

Thanks for your suggesting to use online help desk. My personal experience with has been quite unremarkable so I decided to spend time looking at where the problem may lie and have resolved it.

Thanks

 

GeorgiaC
QuickBooks Team

VAT100 report is missing most of output and input transactions. HELP!!

Pleased to hear you've resolved this Hamid, and we hope your experience with us with our care team is more positive next time.

 

Thanks 

Hamid_Khan
Level 3

VAT100 report is missing most of output and input transactions. HELP!!

NOT REALLY- THEY ARE ALL NOVICES ALTHOUGH THEY DO THEIR BEST BUT I'M AFRAID THAT'S NOT GOOD ENOUGH!

Need to get in touch?

Contact us