About QB Community

Hello,oscaradi.

I'll help you get this sorted out. 

It's possible that the tax feature was not set up. This is why you were not prompted to select VAT on the previous invoices you've recorded. 

Let's set up your VAT by following these steps:

1. On the left panel, click Tax or VAT.
2. Click the Set up VAT button.
3. Select the Start of VAT period, Filing frequency, and Reporting method.
4. Click Next and then OK.

Please see this sample screenshot for a visual reference:

Once done, open each invoice that do not have VAT. Then, make sure to select Exclusive of Tax or Inclusive of Tax from the Amounts are drop-down. This way, you can see the VAT column and select the rate. Here's a sample screenshot:

After the steps, you can run the Invoice List report. Customize the report to add the Tax amount column, and then Export it to Excel. 

I'm adding these articles for reference:

• How do I set up sales GST/VAT rates and use them on forms? (International QBO)
• Export reports, lists, and other data from QuickBooks Online

You're always welcome to post here if you have questions or other concerns with QuickBooks Online in the future. Have a great day!