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.

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:

• VAT Summary Report
• VAT Detail Report

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! 

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.

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?! 

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. 

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'.