Down load last years' invoices to excel including net, VAT and gross amounts

Hello there, Leets.

You can run a Transaction Detail by Tax Code report in QuickBooks Online to show the list of your last year's sales invoices displaying the Net amount, VAT amount, and Gross amount column. You can export it to Excel and I'm here to guide you.

Here's how:

1. On the left menu, go to Reports and search for Transaction Detail by Tax Code.
2. Click the Customise button.
3. Open the Filter section and select Invoice and Expense (Choose as many as you prefer) as the Transaction Type.

    

    
   
4. Click Run Report.
5. Click the Gear icon on the top-right of the report preview page and click Show more.
6. Select only the following columns to display:
   1. VAT Amount
   2. Net Amount
   3. Gross Total
7. Click the Share button beside the Gear icon and select Export to Excel.

In the 6th step, you can select any columns you prefer to show other than those listed above.

After customising the report, you can consider memorising it to save and access it easily in the future.

The Community page is always open for any type of your concerns. Please don't hesitate to reply if you need additional assistance. I'd gladly help you anytime.