Skip to main content
K
koups
July 15, 2023
Question

VAT report

  • July 15, 2023
  • 1 reply
  • 0 views

I am looking to create a report that gives me the transactions with VAT and transactions without VAT over a period of time- I need a total for each of these. This is not the VAT 100 report. Could anyone give advice please as to what report I need- ideally one report would be great!

1 reply

Adrian_A
Adrian_A
July 15, 2023

I know how you can review the transactions with and without vat in a single report, koups.

 

The option to pull up a report that shows the entries with and without vat isn't available in QuickBooks Online. I have a workaround, though. You can run the Transaction Detail by Tax Code and No VAT transactions report, then export them into an Excel file to have a single spreadsheet.

 

Here's how:

 

  1. Click the Reports tab.
  2. Enter and select the report name you want to pull up first.
  3. Filter the Report period.
  4. Click the Export button.
  5. Select Export to Excel.
  6. Repeat the same steps for the other report.

 

I'd also suggest sending Feedback to our developer's team. You can do so by clicking the Gear icon and then selecting Feedback.

 

I'm also adding this article for your reference in managing your VAT codes in QBO: QuickBooks VAT codes. 

 

I'm all ears if you have any follow-up questions about VAT in QBO. Keep me posted by leaving a reply below.

Terms & ConditionsAccessibility statement