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

Is there a report that shows you the VAT on outstanding debtors and creditors

 
Solved
Best answer February 07, 2019

Accepted Solutions
Gordon
Level 4

Is there a report that shows you the VAT on outstanding debtors and creditors

If you mean you want to see what vat liability is attached to old unpaid invoices or bills, then set the vat 100 report to accrual and trim the dates to all or for what ever period you want.

You would not have outstanding vat if you run accrual accounting for Vat. Only for current unfiled period which the vat 100 reports.

View solution in original post

7 REPLIES 7
Gordon
Level 4

Is there a report that shows you the VAT on outstanding debtors and creditors

If you mean you want to see what vat liability is attached to old unpaid invoices or bills, then set the vat 100 report to accrual and trim the dates to all or for what ever period you want.

You would not have outstanding vat if you run accrual accounting for Vat. Only for current unfiled period which the vat 100 reports.

RosieSteel
Level 1

Is there a report that shows you the VAT on outstanding debtors and creditors

I do monthly management accounts that are for prior periods & I do year end accounts. How do I run reports that show the VAT outstanding on Debtors & Creditors for custom periods as some of my clients are on cash accounting? I see the reports that you have suggested but these are just for current. If I run these now with past dates no data shows on the reports.

jamespaul
Moderator

Is there a report that shows you the VAT on outstanding debtors and creditors

Hello, RosieSteel.

 

I'm here to make sure you'll be able to get the outstanding VAT data for your debtors and creditors. 

 

You can change the VAT 100 report's accounting method to Accrual. This shows both the cash and accrual data within a specific period. Here's how:

 

  1. In the VAT 100 report, choose Accrual under Accounting method.
  2. Choose a specific period under Report period.
  3. Hit Run report

 

 

Also, drill down the report by clicking the amounts. They will show you the list of transactions with VAT. 

 

Other VAT-related reports are also available:

 

 

Do you also need help filing your VAT returns? The full guide can be found here: Submit a VAT return in QuickBooks Online. If you need assistance with other things in QuickBooks Online, you can browse for our articles here

 

I'm more than glad to offer future assistance to you in the future. Simply go back to this thread and add some details regarding the issue in QuickBooks Online. Have a jolly good week ahead! 

 

tim888
Level 2

Is there a report that shows you the VAT on outstanding debtors and creditors

I don't think you've answered the question Rosie posted.

 

I believe that the answer is "no" you don't have a report which shows the VAT element of Debtors or Creditors.

RosieSteel
Level 1

Is there a report that shows you the VAT on outstanding debtors and creditors

This is true - they had to take this question to their technical team who confirmed that they don't have a report that shows it. Crazy isn't it?! 

tim888
Level 2

Is there a report that shows you the VAT on outstanding debtors and creditors

I don't think the "helpful" responders realise how answering a different question just makes the frustration worse, and wastes everyone's time. Just be honest, if there isn't a report.

 

I think there is a work around. If you go to Invoicing -> Sales Transactions, then filter on Open invoices you can see the VAT element. You'd have to do this exercise on the 1st day of the following month (before any new bank transactions have been applied) and perhaps cross check the total debtor balance.

 

I missed this month, so I'm going through line by line identifying those debtors with something other than 20% VAT.

 

I think the same method will work on Creditors too looking in the Expenses section. 

JackS
Moderator

Is there a report that shows you the VAT on outstanding debtors and creditors

Hi there, for your information, we now have the ability to add the outstanding VAT to the aging reports in QuickBooks by customising the report and adding the column called 'Outstanding VAT'. 

Need to get in touch?

Contact us