Skip to main content
Ebbage
Ebbage
August 27, 2019
Question

VAT reconciliation report

  • August 27, 2019
  • 1 reply
  • 0 views

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

MaryLandT
MaryLandT
August 27, 2019

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.

 

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.

 

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

Terms & ConditionsAccessibility statement