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

VAT reconciliation report

Good afternoon,

 

Please see attached the Xero reconciliation report for VAT. This one isn’t perfect because the client didn’t always filed through Xero but it shows the periods and then how it works back to the TB balance – does Quickbooks produce a report similar?

 

If QuickBooks doesn’t produce the reconciliation, what we just need is the VAT on debtors and the VAT on creditors – is there anything that you could suggest?

 

Thanks

 

Ryan

1 REPLY 1
MaryLandT
Moderator

VAT reconciliation report

Hello there, @Ebbage,

 

I appreciate you for providing a screenshot of your concern.

 

Right now, we're unable to provide a report that is similar to your screenshot. The reconciliation report in QuickBooks Online lists your reconciled bank and credit card accounts.

 

What you need to do is view different reports, like VAT 101 that have the same details, then manually transfer them to an Excel file.

VATreports.PNG

 

You can also go to the Taxes from the left menu, then go to the Payments tab. You'll be able to view your VAT payments and click View to see the data from there.
payments.PNG

 

Let me know if there's anything else you need and I'll get back to you.

Need to get in touch?

Contact us