- Mark as New
- Bookmark
- Subscribe
- Highlight
- Report Inappropriate Content
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! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Highlight
- Report Inappropriate Content
VAT
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.
- Mark as New
- Bookmark
- Subscribe
- Highlight
- Report Inappropriate Content
VAT
Hi,
Just checked & it was set as "standard".
- Mark as New
- Bookmark
- Subscribe
- Highlight
- Report Inappropriate Content
VAT
In a way it looks like it is only counting "cash" and not Card payments, both sales & purchases!!
- Mark as New
- Bookmark
- Subscribe
- Highlight
- Report Inappropriate Content
VAT
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.
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
- Mark as New
- Bookmark
- Subscribe
- Highlight
- Report Inappropriate Content
VAT
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?
- Mark as New
- Bookmark
- Subscribe
- Highlight
- Report Inappropriate Content
VAT
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:
- Go to the Help menu and click Contact us.
- Let them know in the description box that you need in sorting out the missing transactions in the report.
- Click Let's talk, then select between Start messaging or Get a callback.
- 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!
- Mark as New
- Bookmark
- Subscribe
- Highlight
- Report Inappropriate Content
VAT
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
- Mark as New
- Bookmark
- Subscribe
- Highlight
- Report Inappropriate Content
VAT
NOT REALLY- THEY ARE ALL NOVICES ALTHOUGH THEY DO THEIR BEST BUT I'M AFRAID THAT'S NOT GOOD ENOUGH!