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

Hello, I haven't received all payments fro sale yet and already should pay VAT. How to adjust my report to allow only paid sales to go for VAT report?

 
1 REPLY 1
SarahannC
Moderator

Hello, I haven't received all payments fro sale yet and already should pay VAT. How to adjust my report to allow only paid sales to go for VAT report?

Hi there, Svarog Firepro ltd.

 

Let me share some information about running a VAT report that only shows paid sales.

 

First, let me confirm the accounting method you used for your VAT return. Is it for Cash basis or Accrual? If it’s a Cash basis, paid sales will automatically populate in the VAT Detail report. Here’s how:

 

  1. Go to Reports on the left panel.
  2. Enter  VAT Detail report in the search box.
  3. Set the accounting method to a Cash basis.
  4. Then, Run report.

q.PNG

 

On the other hand, for the Accrual method, the report generates paid and unpaid sales. With that, we’re unable to adjust the report to show only the paid sales. 

 

You may want to try running the Transaction Detail by Account report in QuickBooks. Then, filter the report to A/R and set the status to Paid. Here are the things that you might want to include on this report:

 

  1. Click the small gear icon.
  2. From there, select the tax amount, net amount, and VAT code.
  3. Click the Customize button at the upper-right corner.
  4. Click the Filter section and put a check-mark to A/R
  5. Select Paid.
  6. Then, Run report.

qq.PNG

 

If you want to save what you've customised, you can check this article for further instructions on how to do it: Memorise reports in QuickBooks Online.

 

Please know that you can always go back here if you have more something to ask about QuickBooks reports. I'll help you with that. Take care!

Need to get in touch?

Contact us