Skip to main content
julie-woodhouse
Oct 23, 2019 11:29 AM UTC
Solved

Can QB generate a report showing outstanding VAT on debtors? Our Client is on cash basis for VAT. I need the report that will show the VAT for the unpaid amount

Original commenter did not share additional details
JackS
JackSAnswer
Mar 2, 2021 2:02 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'. 

View in thread

11 replies

payment after leaving
Oct 23, 2019 11:57 AM UTC

Hi julie-woodhouse

 

You can run a Transaction detail by Account report, select the small icon to the right hand side of the print and export icon, select show more, select tax amount, net amount and VAT code, select customise, select Filter, select the A/R Paid box, it will move to the top of the filter queue then use the drop down menu to the right of A/R Paid and change to Unpaid, select run report, change the report date to All Dates, run report.

payment after leaving
Oct 23, 2019 11:59 AM UTC

Hi julie-woodhouse

 

We forgot to include that when you are in the filter option select distribution account and use the drop down menu and select debtors.

ManagementAccountant
Aug 11, 2020 12:28 PM UTC

Can this customised report be backdated to show what was unpaid at a certain date (when client was moved from cash to standard, for instance)?

Ashleigh1
Aug 11, 2020 2:03 PM UTC

Hello ManagementAccountant, 

 

Thank you for posting on this thread, 

 

At the top of the report, you will see the section for the date, there you will be able to change it to it just run the report for a certain date range you want to view. 

 

So if you change the report period to custom then next to that put the date from and too you want to look at then click run report. 

 

This will just show you the report between the date range you put in. 

JackS
JackSAnswer
Mar 2, 2021 2:02 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'. 

aflgroupbookkeep
Apr 20, 2021 4:11 PM UTC

Please could you explain how to do so as I cannot see any options under Customise on AR summary?

Kristine Mae
Kristine Mae
Apr 20, 2021 5:22 PM UTC

Let me explain how it works, Aflgroupbookkeep.

 

You're unable to add it to the summary reports. You can only add the Outstanding VAT column to the ageing detail reports. Here's how:

  1. Click Reports.
  2. Enter Accounts receivable ageing detail in the Find report by name field.
  3. Click Customise.
  4. Go to Rows/Columns, then click Change columns.
  5. Tick the Outstanding VAT box. then click Run report.

Feel free to check this article to help you more with customising: Customise reports in QuickBooks Online.

 

Don't hesitate to let us know if you have other concerns. We'll be right here to help you. Take care!

    Terms & ConditionsAccessibility statement