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:
- Go to Reports on the left panel.
- Enter VAT Detail report in the search box.
- Set the accounting method to a Cash basis.
- Then, Run report.
![q.PNG q.PNG](https://quickbooks.intuit.com/learn-support/image/serverpage/image-id/48596iD1107C42D43597BB/image-size/large?v=v2&px=999)
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:
- Click the small gear icon.
- From there, select the tax amount, net amount, and VAT code.
- Click the Customize button at the upper-right corner.
- Click the Filter section and put a check-mark to A/R.
- Select Paid.
- Then, Run report.
![qq.PNG qq.PNG](https://quickbooks.intuit.com/learn-support/image/serverpage/image-id/48597i57ED7E3B3821CA95/image-size/large?v=v2&px=999)
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!