Skip to main content
arkvalleyinfo
Feb 7, 2019 3:19 AM UTC
Solved

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

Original commenter did not share additional details
Graceman
GracemanAnswer
Feb 7, 2019 3:19 AM UTC

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 in thread

7 replies

Graceman
GracemanAnswer
Feb 7, 2019 3:19 AM UTC

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
Aug 9, 2020 8:50 PM UTC

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
Aug 9, 2020 11:10 PM UTC

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! 

 

JackS
JackS
Mar 2, 2021 2:01 PM UTC

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

Terms & ConditionsAccessibility statement