Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
January 11, 2022
Question

Reporting showing VAT and non-VAT

  • January 11, 2022
  • 2 replies
  • 6 views

Hello, I need to generate a report that shows transactions over a period of time but grouped with the ones with VAT added (20%) together and those without VAT together so we can see the totals of each group (VAT and no VAT). Is there a report that I can run to show this? I dont want to run the VAT 100 report. 

 

Thanks

2 replies

Level 5
January 11, 2022

Hello there, lkoups.

 

Thank you for reaching out to us here in the Community. I'm here to help you run a report with and no VAT transactions in QuickBooks Online.

 

Here's how to open VAT transactions:
 

  1. Go to Reports.
  2. In the search box, enter VAT Detail Report and then click it.
  3. Hit the report period and desired date range.
  4. Choose Run report.

    On the othere 

To show both reports in one, you can export a report to excel.

 

  1. Go to Reports.
  2. Choose No VAT transactions report.
  3. Click Run report.


Lastly, I've got you this helpful article in case you need some ideas about how you can save your customized report: Memorise reports in QuickBooks Online.

Let me know if you have other questions about running VAT transaction report. I'm always around to assist you.

New Member
July 10, 2026

how do i enter vat when entering expenses

QuickBooks Team
July 10, 2026

Have you set up VAT in QuickBooks Online yet? If not, you'll need to do that first before you can add tax to your transactions.

 

Once that's done, you can add your expenses. Just make sure to select either Exclusive of Tax or Inclusive of Tax under the Amounts are dropdown menu so the system calculates the VAT.

 

Reply below if you need anything else. We're here to help!