Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?

Reports and Accounting

Reports and Accounting

  • 2,289 Topics
  • 4,574 Replies
2289 Topics
debi-fry
 Reports and Accounting
jackie5
 Reports and Accounting
Josh Rainford
 Reports and Accounting
Reconciling VAT on Cash basis

I am looking for a report that will allow me to see what VAT is attached to my debtors and creditors as at the year end.  I have tried the customise reports and filtering by A/R Paid and A/P Paid, but that only reflects whether they have been paid as at today's date or not.  I basically want to run my Aged debtors report and be able to select a VAT column. My client has various VAT rates on both purchases and sales so not as straight forward as just applying 20% VAT.  There doesn't appear to be a way of reconciling the VAT account when preparing the year end accounts from QuickBooks Online when a client is on cash accounting for VAT.  I know there is a VAT reconciliation feature on Xero which allows you to reconcile the VAT at any given date allowing you to prove a VAT balance. Is there nothing similar in QuickBooks Online? Any help would be much appreciated. Regards, Josh

211
sazzad-hossain
 Reports and Accounting
Marky
 Reports and Accounting
Jen3
 Reports and Accounting
dunav
 Reports and Accounting
accounts233
 Reports and Accounting
accounts232
 Reports and Accounting
geoff50k
 Reports and Accounting
123geds
 Reports and Accounting
Mick6
 Reports and Accounting
fusionphotograph
 Reports and Accounting
eastmanchesterau
 Reports and Accounting
alison-finn
 Reports and Accounting
Valerie69
 Reports and Accounting
anne_king
 Reports and Accounting
invoices2
 Reports and Accounting
sandra23
 Reports and Accounting
siobhan5
 Reports and Accounting
chris142
 Reports and Accounting
btaylor4
 Reports and Accounting
antony3
 Reports and Accounting
Mike_Messenger
 Reports and Accounting
lewis7
 Reports and Accounting
Show more activity
Start a discussion
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement