Skip to main content
J
julie-woodhouse
October 23, 2019
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

  • October 23, 2019
  • 4 replies
  • 0 views
Original commenter did not share additional details
Best answer by JackS

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

4 replies

P
payment after leaving
October 23, 2019

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.

P
payment after leaving
October 23, 2019

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.

M
ManagementAccountant
August 11, 2020

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

A
Ashleigh1
August 11, 2020

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
March 2, 2021

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

A
aflgroupbookkeep
April 20, 2021

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

Kristine Mae
Kristine Mae
April 20, 2021

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